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.1 2005/07/25 00:18:18 trajasek noship $ */
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)

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)
113: is
114: select party_id
115: from hz_party_sites
116: where party_site_id = p_party_site_id;

Line 115: from hz_party_sites

111:
112: cursor l_party_sites_csr(p_party_site_id hz_party_sites.party_site_id%type)
113: is
114: select party_id
115: from hz_party_sites
116: where party_site_id = p_party_site_id;
117:
118: BEGIN
119: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

164: l_sqlerrmsg VARCHAR2(4000);
165: l_error_msg VARCHAR2(4000);
166: l_return_status VARCHAR2(2000);
167:
168: CURSOR l_party_site_acc_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
169: IS
170: SELECT acc.access_id, acc.user_id
171: FROM csm_party_sites_acc acc
172: WHERE party_site_id = p_party_site_id;

Line 208: l_location_id hz_party_sites.location_id%TYPE;

204: l_sqlerrmsg VARCHAR2(4000);
205: l_error_msg VARCHAR2(4000);
206: l_return_status VARCHAR2(2000);
207:
208: l_location_id hz_party_sites.location_id%TYPE;
209:
210: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)
211: IS
212: SELECT acc.access_id,

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

206: l_return_status VARCHAR2(2000);
207:
208: l_location_id hz_party_sites.location_id%TYPE;
209:
210: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)
211: IS
212: SELECT acc.access_id,
213: acc.user_id
214: FROM hz_party_sites ps,

Line 214: FROM hz_party_sites ps,

210: CURSOR l_party_site_csr (p_location_id hz_party_sites.location_id%TYPE)
211: IS
212: SELECT acc.access_id,
213: acc.user_id
214: FROM hz_party_sites ps,
215: csm_party_sites_acc acc
216: WHERE ps.location_id = p_location_id
217: AND acc.party_site_id = ps.party_site_id;
218:

Line 261: l_party_site_id hz_party_sites.party_site_id%TYPE;

257: l_sqlerrmsg VARCHAR2(4000);
258: l_error_msg VARCHAR2(4000);
259: l_return_status VARCHAR2(2000);
260:
261: l_party_site_id hz_party_sites.party_site_id%TYPE;
262:
263: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
264: IS
265: SELECT access_id, user_id

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

259: l_return_status VARCHAR2(2000);
260:
261: l_party_site_id hz_party_sites.party_site_id%TYPE;
262:
263: CURSOR l_party_site_csr (p_party_site_id hz_party_sites.party_site_id%TYPE)
264: IS
265: SELECT access_id, user_id
266: FROM csm_party_sites_acc
267: WHERE party_site_id = p_party_site_id;