DBA Data[Home] [Help]

APPS.HR_TRANS_HISTORY_API dependencies on WF_ROLES

Line 1095: lv_orig_system wf_roles.orig_system%type;

1091: ,P_USER_COMMENT IN VARCHAR2 default hr_api.g_varchar2
1092: )
1093: IS
1094: l_proc constant varchar2(100) := g_package || 'SaveRoutingHistory';
1095: lv_orig_system wf_roles.orig_system%type;
1096: lv_orig_system_id wf_roles.orig_system_id%type;
1097:
1098: CURSOR cur_trans_details IS
1099: SELECT ITEM_TYPE, ITEM_KEY, TRANSACTION_EFFECTIVE_DATE, EFFECTIVE_DATE_OPTION

Line 1096: lv_orig_system_id wf_roles.orig_system_id%type;

1092: )
1093: IS
1094: l_proc constant varchar2(100) := g_package || 'SaveRoutingHistory';
1095: lv_orig_system wf_roles.orig_system%type;
1096: lv_orig_system_id wf_roles.orig_system_id%type;
1097:
1098: CURSOR cur_trans_details IS
1099: SELECT ITEM_TYPE, ITEM_KEY, TRANSACTION_EFFECTIVE_DATE, EFFECTIVE_DATE_OPTION
1100: FROM HR_API_TRANSACTIONS