APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';

1: PACKAGE BODY CSM_PARTY_SITE_EVENT_PKG AS
2: /* $Header: csmeptsb.pls 120.2 2011/01/10 10:37:02 saradhak ship $ */
3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');

Line 12: procedure insert_party_sites_acc (p_party_site_id hz_party_sites.party_site_id%type,

8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
10: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
11:
12: procedure insert_party_sites_acc (p_party_site_id hz_party_sites.party_site_id%type,
13: p_party_id hz_parties.party_id%type,
14: p_user_id fnd_user.user_id%type)
15: is
16: l_sysdate date;

Line 56: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type)

52: l_party_id hz_parties.party_id%type;
53: l_err_msg VARCHAR2(4000);
54: l_ret_status VARCHAR2(4000);
55:
56: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type)
57: is
58: select party_id
59: from hz_party_sites
60: where party_site_id = p_party_site_id;

Line 59: from hz_party_sites

55:
56: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type)
57: is
58: select party_id
59: from hz_party_sites
60: where party_site_id = p_party_site_id;
61:
62: BEGIN
63: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 112: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type, c_user_id NUMBER)

108: l_party_id hz_parties.party_id%type;
109: l_err_msg VARCHAR2(4000);
110: l_ret_status VARCHAR2(4000);
111:
112: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type, c_user_id NUMBER)
113: is
114: select party_id
115: FROM hz_party_sites ps
116: WHERE party_site_id = p_party_site_id

Line 115: FROM hz_party_sites ps

111:
112: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type, c_user_id NUMBER)
113: is
114: select party_id
115: FROM hz_party_sites ps
116: WHERE party_site_id = p_party_site_id
117: AND NOT EXISTS
118: ( SELECT 1
119: FROM CSM_INCIDENTS_ALL_ACC acc,

Line 178: CURSOR l_party_site_acc_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)

174: l_sqlerrmsg VARCHAR2(4000);
175: l_error_msg VARCHAR2(4000);
176: l_return_status VARCHAR2(2000);
177:
178: CURSOR l_party_site_acc_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
179: IS
180: SELECT acc.access_id, acc.user_id
181: FROM csm_party_sites_acc acc
182: WHERE party_site_id = p_party_site_id;

Line 218: l_location_id hz_party_sites.location_id%TYPE;

214: l_sqlerrmsg VARCHAR2(4000);
215: l_error_msg VARCHAR2(4000);
216: l_return_status VARCHAR2(2000);
217:
218: l_location_id hz_party_sites.location_id%TYPE;
219:
220: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)
221: IS
222: SELECT acc.access_id,

Line 220: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)

216: l_return_status VARCHAR2(2000);
217:
218: l_location_id hz_party_sites.location_id%TYPE;
219:
220: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)
221: IS
222: SELECT acc.access_id,
223: acc.user_id
224: FROM hz_party_sites ps,

Line 224: FROM hz_party_sites ps,

220: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)
221: IS
222: SELECT acc.access_id,
223: acc.user_id
224: FROM hz_party_sites ps,
225: csm_party_sites_acc acc
226: WHERE ps.location_id = p_location_id
227: AND acc.party_site_id = ps.party_site_id;
228:

Line 271: l_party_site_id hz_party_sites.party_site_id%TYPE;

267: l_sqlerrmsg VARCHAR2(4000);
268: l_error_msg VARCHAR2(4000);
269: l_return_status VARCHAR2(2000);
270:
271: l_party_site_id hz_party_sites.party_site_id%TYPE;
272:
273: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
274: IS
275: SELECT access_id, user_id

Line 273: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)

269: l_return_status VARCHAR2(2000);
270:
271: l_party_site_id hz_party_sites.party_site_id%TYPE;
272:
273: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
274: IS
275: SELECT access_id, user_id
276: FROM csm_party_sites_acc
277: WHERE party_site_id = p_party_site_id;