APPS.OTA_ADD_TRAINING_SS dependencies on HR_API

Line 905: ,hr_api_transaction_steps hrtrns

901: From
902: wf_item_activity_statuses process
903: ,wf_item_attribute_values attribute2
904: ,wf_process_activities activity
905: ,hr_api_transaction_steps hrtrns
906: Where
907: activity.activity_name = p_processname
908: and activity.process_item_type = p_item_type
909: and activity.activity_item_type = p_item_type

Line 969: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

965: l_transaction_mode VARCHAR2(10);
966: l_from VARCHAR2(20);
967: l_tran_submitted VARCHAR2(1);
968:
969: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
970: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
971: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
972:
973:

Line 970: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

966: l_from VARCHAR2(20);
967: l_tran_submitted VARCHAR2(1);
968:
969: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
970: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
971: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
972:
973:
974:

Line 971: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

967: l_tran_submitted VARCHAR2(1);
968:
969: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
970: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
971: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
972:
973:
974:
975: BEGIN

Line 1078: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

1074: l_some_warning NUMBER := 0;
1075: l_from VARCHAR2(100);
1076: l_message VARCHAR2(1000) := NULL;
1077:
1078: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1079: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1080: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1081: BEGIN
1082:

Line 1079: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

1075: l_from VARCHAR2(100);
1076: l_message VARCHAR2(1000) := NULL;
1077:
1078: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1079: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1080: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1081: BEGIN
1082:
1083:

Line 1080: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

1076: l_message VARCHAR2(1000) := NULL;
1077:
1078: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1079: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1080: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1081: BEGIN
1082:
1083:
1084: hr_transaction_api.get_transaction_step_info

Line 1324: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;

1320: l_some_warning NUMBER := 0;
1321: l_from VARCHAR2(100);
1322: l_message VARCHAR2(1000) := NULL;
1323:
1324: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1325: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1326: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1327: l_approval_reg_flag wf_lookups.lookup_code%type;
1328:

Line 1325: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

1321: l_from VARCHAR2(100);
1322: l_message VARCHAR2(1000) := NULL;
1323:
1324: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1325: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1326: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1327: l_approval_reg_flag wf_lookups.lookup_code%type;
1328:
1329: BEGIN

Line 1326: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;

1322: l_message VARCHAR2(1000) := NULL;
1323:
1324: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1325: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;
1326: l_activity_id HR_API_TRANSACTION_STEPS.ACTIVITY_ID%TYPE;
1327: l_approval_reg_flag wf_lookups.lookup_code%type;
1328:
1329: BEGIN
1330:

Line 2641: ,hr_api_transaction_steps hrtrns

2637: From
2638: wf_item_activity_statuses process
2639: ,wf_item_attribute_values attribute2
2640: ,wf_process_activities activity
2641: ,hr_api_transaction_steps hrtrns
2642: Where
2643: activity.activity_name = 'OTA_ADDTRNG_JSP_PRC'
2644: and activity.process_item_type = 'HRSSA'
2645: and activity.activity_item_type = 'HRSSA'