APPS.HR_TRANS_HISTORY_API dependencies on PQH_SS_TRANS_STATE_HISTORY

Line 124: FROM PQH_SS_TRANS_STATE_HISTORY

120: IS
121: -- Cursor to return MaxSeq for new transactions.
122: CURSOR getMaxSeq IS
123: SELECT MAX(APPROVAL_HISTORY_ID)
124: FROM PQH_SS_TRANS_STATE_HISTORY
125: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID;
126:
127: -- Cursor to return Max seq for old transactions.
128: CURSOR getMaxOldSeq IS

Line 173: -- populate PQH_SS_TRANS_STATE_HISTORY

169: OPEN getMaxOldSeq;
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

Line 197: Insert into pqh_ss_trans_state_history

193: ,stateTbl.LAST_UPDATE_LOGIN;
194:
195: l_cnt := stateTbl.TRANSACTION_HISTORY_ID.count;
196: FOR i in 1.. l_cnt LOOP
197: Insert into pqh_ss_trans_state_history
198: (
199: TRANSACTION_HISTORY_ID,
200: APPROVAL_HISTORY_ID,
201: CREATOR_PERSON_ID,

Line 933: FROM PQH_SS_TRANS_STATE_HISTORY

929: ,EFFECTIVE_DATE_OPTION
930: ,PARENT_TRANSACTION_ID
931: ,RELAUNCH_FUNCTION
932: ,TRANSACTION_DOCUMENT
933: FROM PQH_SS_TRANS_STATE_HISTORY
934: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
935: AND approval_history_id = l_seq_id
936: )
937: WHERE TRANSACTION_ID = P_TRANSACTION_ID

Line 938: AND exists (SELECT 1 FROM PQH_SS_TRANS_STATE_HISTORY

934: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
935: AND approval_history_id = l_seq_id
936: )
937: WHERE TRANSACTION_ID = P_TRANSACTION_ID
938: AND exists (SELECT 1 FROM PQH_SS_TRANS_STATE_HISTORY
939: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
940: AND approval_history_id = l_seq_id);
941:
942: -- special handling for old txn in progress

Line 1032: DELETE pqh_ss_trans_state_history

1028:
1029: If cur_chk_stale_data%found AND l_seq_id IS NOT NULL THEN
1030: hr_utility.set_location('Entering If: '|| l_proc,15);
1031: -- Delete State History
1032: DELETE pqh_ss_trans_state_history
1033: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1034: and approval_history_id = l_seq_id;
1035:
1036: -- Delete Routing History

Line 1740: l_seq_id PQH_SS_TRANS_STATE_HISTORY.approval_history_id%TYPE;

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;
1740: l_seq_id PQH_SS_TRANS_STATE_HISTORY.approval_history_id%TYPE;
1741: l_proc constant varchar2(100) := g_package || ' SaveTransactionHistory';
1742:
1743: Begin
1744: hr_utility.set_location('Entering: '|| l_proc,5);