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;
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;
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:
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
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
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;
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
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: