APPS.CSM_CURRENCY_EVENT_PKG dependencies on CSM_CURRENCIES_ACC

Line 46: csm_currencies_acc acc

42: IS
43: SELECT acc.access_id, curr.currency_code, curr_tl.language
44: FROM fnd_currencies curr,
45: fnd_currencies_tl curr_tl,
46: csm_currencies_acc acc
47: WHERE curr.currency_code = curr_tl.currency_code
48: AND curr.currency_code = acc.currency_code
49: AND ((SYSDATE not BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate))
50: OR curr.enabled_flag <> 'Y')

Line 56: select csm_currencies_acc_s.NEXTVAL from dual;

52: OR (curr_tl.creation_date < p_last_upd_date AND curr_tl.last_update_date > p_last_upd_date)
53: );
54:
55: CURSOR l_access_id_csr IS
56: select csm_currencies_acc_s.NEXTVAL from dual;
57:
58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;

Line 64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;

60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;
64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;
65: l_tl_omfs_palm_resource_list asg_download.user_list;
66: l_single_access_id_list asg_download.access_list;
67: --a null list
68: l_null_access_list asg_download.access_list;

Line 110: DELETE FROM CSM_CURRENCIES_ACC

106: SYSDATE);
107: END IF;
108:
109: --remove from ACC
110: DELETE FROM CSM_CURRENCIES_ACC
111: WHERE ACCESS_ID = l_access_id;
112:
113: END LOOP;
114:

Line 122: from csm_currencies_acc acc,

118: /******* UPDATES **********/
119: --generate sql for updates
120: l_dsql :=
121: 'select acc.access_id, curr_tl.language, curr.last_update_date, curr_tl.last_update_date
122: from csm_currencies_acc acc,
123: fnd_currencies curr,
124: fnd_currencies_tl curr_tl
125: where acc.currency_code = curr.currency_code
126: and curr_tl.currency_code = curr.currency_code

Line 188: FROM CSM_CURRENCIES_ACC acc

184: WHERE SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
185: AND curr.enabled_flag = ''Y''
186: AND NOT EXISTS
187: (SELECT 1
188: FROM CSM_CURRENCIES_ACC acc
189: WHERE acc.currency_code = curr.currency_code
190: )';
191:
192: --open the cursor

Line 200: -- select csm_currencies_acc_s.NEXTVAL into l_access_id from dual;

196: FETCH l_inserts_cur INTO l_currency_code, l_curr_last_update_date;
197: EXIT WHEN l_inserts_cur%NOTFOUND;
198:
199: --generate access_id
200: -- select csm_currencies_acc_s.NEXTVAL into l_access_id from dual;
201: OPEN l_access_id_csr;
202: FETCH l_access_id_csr INTO l_access_id;
203: CLOSE l_access_id_csr;
204: --mark dirty the SDQ for all users

Line 212: INSERT INTO csm_currencies_acc(currency_code, access_id, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

208: ASG_DOWNLOAD.INS, sysdate);
209: END LOOP;
210:
211: --insert into
212: INSERT INTO csm_currencies_acc(currency_code, access_id, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
213: LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
214: VALUES (l_currency_code, l_access_id, fnd_global.user_id, sysdate, fnd_global.user_id,
215: l_curr_last_update_date, fnd_global.login_id);
216: