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 2006/07/27 11:05:40 trajasek noship $ */
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 2006/07/27 11:05:40 trajasek noship $ */
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 2006/07/27 11:05:40 trajasek noship $ */
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: --PROCEDURE IMPLEMENTATION DETAILS

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: --PROCEDURE IMPLEMENTATION DETAILS
12: --This procedure will insert account id into the access table only for the party
13: --which is passed to this procedure and which is not already present in the CUST ACcount Access table

Line 22: FROM HZ_CUST_ACCOUNTS hzc

18: --CURSOR declarations
19: CURSOR c_cust_accnt_ins(c_party_id NUMBER , c_user_id NUMBER)
20: IS
21: SELECT hzc.CUST_ACCOUNT_ID
22: FROM HZ_CUST_ACCOUNTS hzc
23: WHERE hzc.PARTY_ID = c_party_id
24: AND NOT EXISTS
25: (
26: SELECT 1

Line 27: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc

23: WHERE hzc.PARTY_ID = c_party_id
24: AND NOT EXISTS
25: (
26: SELECT 1
27: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc
28: WHERE acc.USER_ID = c_user_id
29: AND acc.CUST_ACCOUNT_ID = hzc.CUST_ACCOUNT_ID
30: );
31:

Line 78: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc

74: --CURSOR declarations
75: CURSOR c_cust_accnt_upd(c_last_run_date DATE)
76: IS
77: SELECT acc.access_id,acc.user_id
78: FROM HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
79: WHERE hzc.cust_account_id = acc.cust_account_id
80: AND hzc.LAST_UPDATE_DATE > c_last_run_date;
81:
82: --cursor to get last run date from jtm_con_request_data

Line 91: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;

87: WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
88: AND procedure_name = 'CUST_ACCOUNTS_UPD';
89:
90: --variable declarations
91: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
92: l_sqlerrno varchar2(20);
93: l_sqlerrmsg varchar2(2000);
94: l_markdirty BOOLEAN;
95: l_accessid_lst asg_download.access_list;

Line 159: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc

155: --CURSOR declarations
156: CURSOR c_cust_accnt_del(c_party_id NUMBER , c_user_id NUMBER)
157: IS
158: SELECT acc.CUST_ACCOUNT_ID,acc.access_id
159: FROM CSM_HZ_CUST_ACCOUNTS_ACC acc
160: WHERE acc.USER_ID = c_user_id
161: AND NOT EXISTS
162: (
163: SELECT 1

Line 170: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;

166: AND acc.party_ID = c_party_id
167: );
168:
169: --variable declarations
170: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
171: l_sqlerrno varchar2(20);
172: l_sqlerrmsg varchar2(2000);
173: p_message VARCHAR(3000);
174: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;

Line 174: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;

170: l_cst_account_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
171: l_sqlerrno varchar2(20);
172: l_sqlerrmsg varchar2(2000);
173: p_message VARCHAR(3000);
174: l_access_id CSM_HZ_CUST_ACCOUNTS_ACC.ACCESS_ID%TYPE;
175: l_markdirty BOOLEAN;
176: BEGIN
177:
178: 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);