DBA Data[Home] [Help]

APPS.UMX_REG_SERVICES_PKG dependencies on WF_EVENTS

Line 394: l_ntf_guid_raw WF_EVENTS.guid%type;

390: f_ludate date; -- entity update date in file
391: db_luby number; -- entity owner in db
392: db_ludate date; -- entity update date in db
393:
394: l_ntf_guid_raw WF_EVENTS.guid%type;
395: l_BUS_LOGIC_guid_raw WF_EVENTS.guid%type;
396: l_event_name WF_EVENTS.name%type;
397: l_wf_role_name wf_local_roles.name%type;
398: l_reg_function_id fnd_form_functions.function_id%type;

Line 395: l_BUS_LOGIC_guid_raw WF_EVENTS.guid%type;

391: db_luby number; -- entity owner in db
392: db_ludate date; -- entity update date in db
393:
394: l_ntf_guid_raw WF_EVENTS.guid%type;
395: l_BUS_LOGIC_guid_raw WF_EVENTS.guid%type;
396: l_event_name WF_EVENTS.name%type;
397: l_wf_role_name wf_local_roles.name%type;
398: l_reg_function_id fnd_form_functions.function_id%type;
399: l_transaction_type_id AME_TRANSACTION_TYPES_V.transaction_type_id%type;

Line 396: l_event_name WF_EVENTS.name%type;

392: db_ludate date; -- entity update date in db
393:
394: l_ntf_guid_raw WF_EVENTS.guid%type;
395: l_BUS_LOGIC_guid_raw WF_EVENTS.guid%type;
396: l_event_name WF_EVENTS.name%type;
397: l_wf_role_name wf_local_roles.name%type;
398: l_reg_function_id fnd_form_functions.function_id%type;
399: l_transaction_type_id AME_TRANSACTION_TYPES_V.transaction_type_id%type;
400:

Line 415: from wf_events

411: where name = X_WF_ROLE_NAME;
412:
413: CURSOR eventName(x_guid_raw in RAW) is
414: select name
415: from wf_events
416: where guid = HEXTORAW(x_guid_raw);
417:
418: CURSOR ame is
419: select ame.TRANSACTION_TYPE_ID, fa.APPLICATION_ID

Line 671: select guid from wf_events

667:
668: ) IS
669:
670: cursor get_notification_guid is
671: select guid from wf_events
672: where name = X_WF_NOTIFICATION_EVENT_NAME;
673:
674: cursor get_bus_guid is
675: select guid from wf_events

Line 675: select guid from wf_events

671: select guid from wf_events
672: where name = X_WF_NOTIFICATION_EVENT_NAME;
673:
674: cursor get_bus_guid is
675: select guid from wf_events
676: where name = X_WF_BUS_LOGIC_EVENT_NAME;
677:
678: l_wf_notification_guid wf_events.guid%type;
679: l_wf_bus_logic_event_guid wf_events.guid%type;

Line 678: l_wf_notification_guid wf_events.guid%type;

674: cursor get_bus_guid is
675: select guid from wf_events
676: where name = X_WF_BUS_LOGIC_EVENT_NAME;
677:
678: l_wf_notification_guid wf_events.guid%type;
679: l_wf_bus_logic_event_guid wf_events.guid%type;
680:
681:
682: begin

Line 679: l_wf_bus_logic_event_guid wf_events.guid%type;

675: select guid from wf_events
676: where name = X_WF_BUS_LOGIC_EVENT_NAME;
677:
678: l_wf_notification_guid wf_events.guid%type;
679: l_wf_bus_logic_event_guid wf_events.guid%type;
680:
681:
682: begin
683: