APPS.HR_TRANS_HISTORY_API dependencies on PQH_SS_APPROVAL_HISTORY

Line 130: FROM PQH_SS_APPROVAL_HISTORY

126:
127: -- Cursor to return Max seq for old transactions.
128: CURSOR getMaxOldSeq IS
129: SELECT MAX(APPROVAL_HISTORY_ID)
130: FROM PQH_SS_APPROVAL_HISTORY
131: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID;
132:
133: CURSOR populateStateTable IS
134: Select

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 155: -- Note: Heena - Can we use only PQH_SS_APPROVAL_HISTORY ?

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 ?
156:
157: l_seq_id NUMBER(5) := NULL;
158: l_proc constant varchar2(100) := g_package || ' getTransStateSequence';
159: stateTbl TransStateHistTbl;

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 1014: from pqh_ss_approval_history

1010: l_proc constant varchar2(100) := g_package || ' DeleteStaleData';
1011:
1012: CURSOR cur_chk_stale_data IS
1013: select action
1014: from pqh_ss_approval_history
1015: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1016: and approval_history_id = l_seq_id
1017: and action = 'SFL';
1018:

Line 1037: DELETE pqh_ss_approval_history

1033: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1034: and approval_history_id = l_seq_id;
1035:
1036: -- Delete Routing History
1037: DELETE pqh_ss_approval_history
1038: WHERE TRANSACTION_HISTORY_ID = P_TRANSACTION_ID
1039: and approval_history_id = l_seq_id;
1040:
1041: -- TODO: Delete Value History