APPS.HR_TRANS_HISTORY_API dependencies on HR_API

Line 151: FROM pqh_ss_approval_history ah, HR_API_TRANSACTIONS tx

147: ,ah.CREATION_DATE
148: ,ah.LAST_UPDATE_DATE
149: ,ah.LAST_UPDATED_BY
150: ,ah.LAST_UPDATE_LOGIN
151: FROM pqh_ss_approval_history ah, HR_API_TRANSACTIONS tx
152: WHERE TRANSACTION_ID = TRANSACTION_HISTORY_ID
153: AND TRANSACTION_HISTORY_ID = P_TRANSACTION_ID;
154:
155: -- Note: Heena - Can we use only PQH_SS_APPROVAL_HISTORY ?

Line 174: -- from PQH_SS_APPROVAL_HISTORY and HR_API_TRANSACTIONS

170: FETCH getMaxOldSeq INTO l_seq_id;
171: CLOSE getMaxOldSeq;
172: IF (l_seq_id IS NOT NULL) THEN
173: -- populate PQH_SS_TRANS_STATE_HISTORY
174: -- from PQH_SS_APPROVAL_HISTORY and HR_API_TRANSACTIONS
175: NULL;
176: OPEN populateStateTable;
177: FETCH populateStateTable BULK COLLECT INTO
178: stateTbl.TRANSACTION_HISTORY_ID

Line 588: INSERT INTO HR_API_TRANSACTION_STEPS

584:
585: l_cnt := TxStepTbl.STEP_HISTORY_ID.count;
586:
587: FOR i in 1.. l_cnt LOOP
588: INSERT INTO HR_API_TRANSACTION_STEPS
589: (
590: TRANSACTION_STEP_ID
591: ,TRANSACTION_ID
592: ,API_NAME

Line 771: INSERT INTO hr_api_transaction_values

767: CLOSE cur_trans_value;
768:
769: l_cnt := TxValueTbl.transaction_value_id.count;
770: For i in 1.. l_cnt Loop
771: INSERT INTO hr_api_transaction_values
772: (
773: TRANSACTION_VALUE_ID
774: ,TRANSACTION_STEP_ID
775: ,DATATYPE

Line 914: UPDATE HR_API_TRANSACTIONS

910: hr_utility.set_location('Entering: '|| l_proc,5);
911: l_seq_id := getTransStateSequence(P_TRANSACTION_ID => P_TRANSACTION_ID);
912:
913: -- Copy Transaction details from history.
914: UPDATE HR_API_TRANSACTIONS
915: SET (
916: STATUS
917: ,TRANSACTION_STATE
918: ,TRANSACTION_EFFECTIVE_DATE

Line 974: DELETE HR_API_TRANSACTION_VALUES

970: -- end special handling
971:
972:
973: -- DELETE Steps and Values First.
974: DELETE HR_API_TRANSACTION_VALUES
975: WHERE TRANSACTION_STEP_ID in
976: ( SELECT TRANSACTION_STEP_ID
977: FROM HR_API_TRANSACTION_STEPS
978: WHERE TRANSACTION_ID = P_TRANSACTION_ID);

Line 977: FROM HR_API_TRANSACTION_STEPS

973: -- DELETE Steps and Values First.
974: DELETE HR_API_TRANSACTION_VALUES
975: WHERE TRANSACTION_STEP_ID in
976: ( SELECT TRANSACTION_STEP_ID
977: FROM HR_API_TRANSACTION_STEPS
978: WHERE TRANSACTION_ID = P_TRANSACTION_ID);
979:
980: DELETE HR_API_TRANSACTION_STEPS
981: WHERE TRANSACTION_ID = P_TRANSACTION_ID;

Line 980: DELETE HR_API_TRANSACTION_STEPS

976: ( SELECT TRANSACTION_STEP_ID
977: FROM HR_API_TRANSACTION_STEPS
978: WHERE TRANSACTION_ID = P_TRANSACTION_ID);
979:
980: DELETE HR_API_TRANSACTION_STEPS
981: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
982:
983: -- Copy Steps from history to transaction tables.
984: RevertTransSteps

Line 1091: ,P_USER_COMMENT IN VARCHAR2 default hr_api.g_varchar2

1087: ,P_APPROVAL_HISTORY_ID IN OUT NOCOPY NUMBER
1088: ,P_NOTIFICATION_ID IN NUMBER
1089: ,P_ACTION IN VARCHAR2
1090: ,P_USER_NAME IN VARCHAR2
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;

Line 1100: FROM HR_API_TRANSACTIONS

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
1101: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
1102:
1103: l_row cur_trans_details%RowType;
1104: Begin

Line 1364: from hr_api_transaction_values

1360: creation_date ,
1361: last_update_date ,
1362: last_updated_by ,
1363: last_update_login
1364: from hr_api_transaction_values
1365: where transaction_step_id = P_TRANSACTION_STEP_ID;
1366:
1367: l_cnt integer;
1368: l_proc constant varchar2(100) := g_package || ' SaveTransValueHisroty';

Line 1495: FROM hr_api_transaction_steps

1491: ,INFORMATION27
1492: ,INFORMATION28
1493: ,INFORMATION29
1494: ,INFORMATION30
1495: FROM hr_api_transaction_steps
1496: WHERE TRANSACTION_ID = P_TRANSACTION_ID;
1497:
1498: l_cnt integer;
1499: l_proc constant varchar2(100) := g_package || 'SaveTransStepHisroty';

Line 1735: FROM hr_api_transactions t, pqh_ss_transaction_history pt

1731: ,t.PARENT_TRANSACTION_ID
1732: ,t.RELAUNCH_FUNCTION
1733: ,t.TRANSACTION_DOCUMENT
1734: ,pt.transaction_history_id
1735: FROM hr_api_transactions t, pqh_ss_transaction_history pt
1736: WHERE transaction_id = P_TRANSACTION_ID
1737: AND t.transaction_id = pt.transaction_history_ID (+);
1738:
1739: l_trans_details_row cur_trans_details%ROWTYPE;