Skip to main content

In Apps9 prior to upgrading to Cloud we used to use the API call Time_Pers_Diary_Result_API.New and Modify used to work. Now this is the only code I can find using the debug tool in 23r1:

DECLARE
return_array_ Time_Registration_Manager_Handling_SVC.Dialog_Result_Structure_Arr;
cursor_ SYS_REFCURSOR;
BEGIN
return_array_ := Time_Registration_Manager_Handling_SVC.Do_Report_Date_Range_With_Intervals('TIME_REGISTRATION_ATTENDANCE', 'FALSE', 'TRUE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', '10', '826', TO_DATE('2025-04-09','YYYY-MM-DD'), NULL, 'JEH', NULL, NULL, NULL, NULL, 'M', 'M', NULL, NULL, '', NULL, NULL, 'L', 'O', 'NAT_DB', NULL, NULL, '101481020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'FALSE', 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', :JobTransactionParams, NULL, TO_DATE('2025-04-09','YYYY-MM-DD'), TO_DATE('2025-04-09','YYYY-MM-DD'), 'FALSE', 'FALSE', 'FALSE', NULL, unbound## => '');
OPEN cursor_ FOR SELECT * FROM TABLE(return_array_);
NULL := cursor_;
END;


How do I debug what API calls are in this SVC so I can use it in the custom event? I tried to look in the debug tool but couldn't find it.

 

Anyone found the same problem?

​@Robert Perez you can use the SVC package directly in your event. You just need to make sure you set OData session to true.

 

Basically you’ll have your event action code something like that. I’ve used that multiple times and it works like a charm.

DECLARE

   return_array_ Time_Registration_Manager_Handling_SVC.Dialog_Result_Structure_Arr;

   ….

BEGIN

  Fnd_Session_API.Set_Property('ODP_SESSION', 'TRUE');

  return_array_ := Time_Registration_Manager_Handling_SVC.Do_Report_Date_Range_With_Intervals('TIME_REGISTRATION_ATTENDANCE', 'FALSE', 'TRUE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', 'FALSE', '10', '826', TO_DATE('2025-04-09','YYYY-MM-DD'), NULL, 'JEH', NULL, NULL, NULL, NULL, 'M', 'M', NULL, NULL, '', NULL, NULL, 'L', 'O', 'NAT_DB', NULL, NULL, '101481020', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'FALSE', 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FALSE', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', :JobTransactionParams, NULL, TO_DATE('2025-04-09','YYYY-MM-DD'), TO_DATE('2025-04-09','YYYY-MM-DD'), 'FALSE', 'FALSE', 'FALSE', NULL, unbound## => '');

  Fnd_Session_API.Set_Property('ODP_SESSION', 'FALSE');

END;

 

Reply


Terms & ConditionsCookie settings