Human Capital Management - EBS (MOSC)

MOSC Banner

how to get Person id and assignment id from termination business event

We have a subscription based on business event oracle.apps.per.api.ex_employee.actual_termination_emp, which calls a package.

Within the function we have the following code, but the values for person id and assignment id are blank

FUNCTION xx_process (p_subscription_guid IN RAW, p_event IN OUT wf_event_t)

   RETURN VARCHAR2

  IS   l_param_list  wf_parameter_list_t;

   l_param_name  VARCHAR2 (240);

   l_param_value  VARCHAR2 (2000);

   l_event_name  VARCHAR2 (2000);

   l_event_key   VARCHAR2 (2000);

 l_event_data  VARCHAR2 (4000);

 l_person_id NUMBER;

 l_assignment_id NUMBER;

  BEGIN

   l_param_list := p_event.getparameterlist;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center