eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 3: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';

1: PACKAGE BODY CSM_CUSTOMER_ACCOUNT_EVENT_PKG AS
2: /* $Header: csmecatb.pls 120.2.12020000.2 2013/04/09 06:23:47 saradhak ship $ */
3: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';
5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';

Line 4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';

1: PACKAGE BODY CSM_CUSTOMER_ACCOUNT_EVENT_PKG AS
2: /* $Header: csmecatb.pls 120.2.12020000.2 2013/04/09 06:23:47 saradhak ship $ */
3: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';
5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;

1: PACKAGE BODY CSM_CUSTOMER_ACCOUNT_EVENT_PKG AS
2: /* $Header: csmecatb.pls 120.2.12020000.2 2013/04/09 06:23:47 saradhak ship $ */
3: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';
5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

Line 7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';

3: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';
5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
10:
11:

Line 9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
10:
11:
12: TYPE l_num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
13:

Line 34: select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, hcas.cust_acct_site_id,ps.user_id

30: AND ps.user_id=acc.user_id));
31:
32: CURSOR c_ins_cur
33: IS
34: select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, hcas.cust_acct_site_id,ps.user_id
35: from hz_cust_acct_sites_all hcas,CSM_PARTY_SITES_ACC ps
36: WHERE ps.PARTY_SITE_ID=hcas.party_site_id
37: AND hcas.status='A'
38: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu

Line 135: OPEN c_ins_cur FOR select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, p_user_id,hcas.cust_acct_site_id

131: BEGIN
132:
133: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);
134:
135: OPEN c_ins_cur FOR select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, p_user_id,hcas.cust_acct_site_id
136: from hz_cust_acct_sites_all hcas
137: where hcas.party_site_id = p_party_site_id
138: AND hcas.status='A' --download only active ones
139: And ORG_ID=p_org_id

Line 184: FROM HZ_CUST_ACCOUNTS hzc

180: --CURSOR declarations
181: CURSOR c_cust_accnt_ins(c_party_id NUMBER , c_user_id NUMBER)
182: IS
183: SELECT hzc.CUST_ACCOUNT_ID
184: FROM HZ_CUST_ACCOUNTS hzc
185: WHERE hzc.PARTY_ID = c_party_id
186: AND NOT EXISTS
187: (
188: SELECT 1

Line 189: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc

185: WHERE hzc.PARTY_ID = c_party_id
186: AND NOT EXISTS
187: (
188: SELECT 1
189: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc
190: WHERE acc.USER_ID = c_user_id
191: AND acc.CUST_ACCOUNT_ID = hzc.CUST_ACCOUNT_ID
192: );
193:

Line 238: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc

234: --CURSOR declarations
235: CURSOR c_cust_accnt_upd(c_last_run_date DATE)
236: IS
237: SELECT acc.access_id,acc.user_id
238: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
239: WHERE hzc.cust_account_id = acc.cust_account_id
240: AND hzc.LAST_UPDATE_DATE > c_last_run_date;
241:
242: --cursor to get last run date from jtm_con_request_data

Line 251: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;

247: WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
248: AND procedure_name = 'CUST_ACCOUNTS_UPD';
249:
250: --variable declarations
251: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
252: l_sqlerrno varchar2(20);
253: l_sqlerrmsg varchar2(2000);
254: l_markdirty BOOLEAN;
255: l_accessid_lst asg_download.access_list;

Line 280: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc

276: COMMIT;
277: END LOOP;
278:
279: FOR rec in (SELECT DISTINCT PARTY_ID,USER_ID --any new accounts added ?
280: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
281: WHERE hzc.cust_account_id = acc.cust_account_id
282: AND EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS hzc2
283: WHERE hzc2.PARTY_ID = hzc.PARTY_ID
284: AND NOT EXISTS (SELECT 1 FROM CSM_HZ_CUST_ACCOUNTS_ACC acc2

Line 282: AND EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS hzc2

278:
279: FOR rec in (SELECT DISTINCT PARTY_ID,USER_ID --any new accounts added ?
280: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
281: WHERE hzc.cust_account_id = acc.cust_account_id
282: AND EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS hzc2
283: WHERE hzc2.PARTY_ID = hzc.PARTY_ID
284: AND NOT EXISTS (SELECT 1 FROM CSM_HZ_CUST_ACCOUNTS_ACC acc2
285: WHERE acc2.USER_ID = acc.USER_ID
286: AND acc2.CUST_ACCOUNT_ID = hzc2.CUST_ACCOUNT_ID )))

Line 284: AND NOT EXISTS (SELECT 1 FROM CSM_HZ_CUST_ACCOUNTS_ACC acc2

280: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
281: WHERE hzc.cust_account_id = acc.cust_account_id
282: AND EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS hzc2
283: WHERE hzc2.PARTY_ID = hzc.PARTY_ID
284: AND NOT EXISTS (SELECT 1 FROM CSM_HZ_CUST_ACCOUNTS_ACC acc2
285: WHERE acc2.USER_ID = acc.USER_ID
286: AND acc2.CUST_ACCOUNT_ID = hzc2.CUST_ACCOUNT_ID )))
287: LOOP
288: CUST_ACCOUNTS_INS(rec.PARTY_ID,rec.USER_ID);

Line 328: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc

324: --CURSOR declarations
325: CURSOR c_cust_accnt_del(c_party_id NUMBER , c_user_id NUMBER)
326: IS
327: SELECT acc.CUST_ACCOUNT_ID,acc.access_id
328: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc
329: WHERE acc.USER_ID = c_user_id
330: AND NOT EXISTS
331: (
332: SELECT 1

Line 339: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;

335: AND acc.party_ID = c_party_id
336: );
337:
338: --variable declarations
339: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
340: l_sqlerrno varchar2(20);
341: l_sqlerrmsg varchar2(2000);
342: p_message VARCHAR(3000);
343: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;

Line 343: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;

339: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
340: l_sqlerrno varchar2(20);
341: l_sqlerrmsg varchar2(2000);
342: p_message VARCHAR(3000);
343: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;
344: l_markdirty BOOLEAN;
345: BEGIN
346:
347: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCOUNTS_DEL',FND_LOG.LEVEL_EXCEPTION);