APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on CSM_BUS_PROCESS_TXNS_ACC

Line 18: Refreshes the CSM_BUS_PROCESS_TXNS_ACC table by comparing with the

14: g_all_palm_res_list asg_download.user_list;
15:
16:
17: /**
18: Refreshes the CSM_BUS_PROCESS_TXNS_ACC table by comparing with the
19: backend table for deletes, updates and inserts.
20: Refreshes for all the users
21: Also adds corresponding entries in to SDQ
22: */

Line 45: FROM CSM_BUS_PROCESS_TXNS_ACC acc

41:
42: CURSOR l_deletes_cur
43: IS
44: SELECT acc.access_id
45: FROM CSM_BUS_PROCESS_TXNS_ACC acc
46: WHERE NOT EXISTS
47: (SELECT bpt.BUSINESS_PROCESS_ID
48: FROM CS_BUS_PROCESS_TXNS bpt,
49: CS_BUSINESS_PROCESSES bpr

Line 62: l_max_update_date CSM_BUS_PROCESS_TXNS_ACC.LAST_UPDATE_DATE%TYPE;

58:
59: l_mark_dirty boolean;
60: l_bpr_last_update_date CS_BUSINESS_PROCESSES.LAST_UPDATE_DATE%TYPE;
61: l_bpt_last_update_date CS_BUS_PROCESS_TXNS.LAST_UPDATE_DATE%TYPE;
62: l_max_update_date CSM_BUS_PROCESS_TXNS_ACC.LAST_UPDATE_DATE%TYPE;
63:
64: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
65: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
66: l_transaction_type_id CS_BUS_PROCESS_TXNS.TRANSACTION_TYPE_ID%TYPE;

Line 64: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;

60: l_bpr_last_update_date CS_BUSINESS_PROCESSES.LAST_UPDATE_DATE%TYPE;
61: l_bpt_last_update_date CS_BUS_PROCESS_TXNS.LAST_UPDATE_DATE%TYPE;
62: l_max_update_date CSM_BUS_PROCESS_TXNS_ACC.LAST_UPDATE_DATE%TYPE;
63:
64: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
65: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
66: l_transaction_type_id CS_BUS_PROCESS_TXNS.TRANSACTION_TYPE_ID%TYPE;
67: l_run_date DATE;
68:

Line 100: DELETE FROM CSM_BUS_PROCESS_TXNS_ACC

96: SYSDATE);
97: END LOOP;
98:
99: --remove from ACC
100: DELETE FROM CSM_BUS_PROCESS_TXNS_ACC
101: WHERE ACCESS_ID = l_access_id;
102:
103: END LOOP;
104:

Line 114: CSM_BUS_PROCESS_TXNS_ACC acc

110: l_dsql :=
111: 'SELECT acc.access_id, bpt.last_update_date, bpr.last_update_date
112: FROM CS_BUS_PROCESS_TXNS bpt,
113: CS_BUSINESS_PROCESSES bpr,
114: CSM_BUS_PROCESS_TXNS_ACC acc
115: WHERE bpr.business_process_id = bpt.business_process_id
116: AND bpt.transaction_type_id = acc.transaction_type_id
117: AND bpt.business_process_id = acc.business_process_id
118: AND (bpt.last_update_date > :1

Line 150: UPDATE CSM_BUS_PROCESS_TXNS_ACC

146: l_max_update_date := l_bpr_last_update_date;
147: END IF;
148:
149: --update ACC
150: UPDATE CSM_BUS_PROCESS_TXNS_ACC
151: SET LAST_UPDATE_DATE = l_run_date -- l_max_update_date
152: WHERE ACCESS_ID = l_access_id;
153:
154: END LOOP;

Line 169: FROM CSM_BUS_PROCESS_TXNS_ACC acc

165: WHERE bpr.business_process_id = bpt.business_process_id
166: AND bpr.field_service_flag = ''Y''
167: AND NOT EXISTS
168: (SELECT access_id
169: FROM CSM_BUS_PROCESS_TXNS_ACC acc
170: WHERE bpt.transaction_type_id = acc.transaction_type_id
171: AND bpt.business_process_id = acc.business_process_id )';
172:
173:

Line 211: INSERT INTO CSM_BUS_PROCESS_TXNS_ACC (ACCESS_ID, BUSINESS_PROCESS_ID,

207: l_max_update_date := l_bpr_last_update_date;
208: END IF;
209:
210: --insert into
211: INSERT INTO CSM_BUS_PROCESS_TXNS_ACC (ACCESS_ID, BUSINESS_PROCESS_ID,
212: TRANSACTION_TYPE_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
213: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
214: VALUES (l_access_id, l_business_process_id,
215: l_transaction_type_id, fnd_global.user_id, sysdate, fnd_global.user_id,