APPS.CSM_PARTY_EVENT_PKG dependencies on CSM_PARTIES_ACC

Line 5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';

1: PACKAGE BODY CSM_PARTY_EVENT_PKG AS
2: /* $Header: csmeptyb.pls 120.1 2005/07/25 00:18:48 trajasek noship $ */
3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_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_PARTIES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';

Line 6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';

2: /* $Header: csmeptyb.pls 120.1 2005/07/25 00:18:48 trajasek noship $ */
3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
6: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_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_PARTIES');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
10:

Line 29: INSERT INTO csm_parties_acc (party_id,

25: l_sysdate date;
26: BEGIN
27: l_sysdate := SYSDATE;
28:
29: INSERT INTO csm_parties_acc (party_id,
30: user_id,
31: created_by,
32: creation_date,
33: last_updated_by,

Line 46: csm_parties_acc_s.nextval,

42: l_sysdate,
43: fnd_global.user_id,
44: l_sysdate,
45: fnd_global.login_id,
46: csm_parties_acc_s.nextval,
47: 1
48: )
49: RETURNING access_id INTO x_access_id;
50:

Line 116: CURSOR l_check_party_ref(l_party_id csm_parties_acc.party_id%TYPE,

112: l_ret_status VARCHAR2(4000);
113: l_ref_exists NUMBER := 0 ;
114:
115: /** Check ref for given party and user*/
116: CURSOR l_check_party_ref(l_party_id csm_parties_acc.party_id%TYPE,
117: l_user_id csm_parties_acc.user_id%TYPE) IS
118: SELECT 1
119: FROM csm_parties_acc a,
120: cs_incidents_all_b b,

Line 117: l_user_id csm_parties_acc.user_id%TYPE) IS

113: l_ref_exists NUMBER := 0 ;
114:
115: /** Check ref for given party and user*/
116: CURSOR l_check_party_ref(l_party_id csm_parties_acc.party_id%TYPE,
117: l_user_id csm_parties_acc.user_id%TYPE) IS
118: SELECT 1
119: FROM csm_parties_acc a,
120: cs_incidents_all_b b,
121: csm_incidents_all_acc c

Line 119: FROM csm_parties_acc a,

115: /** Check ref for given party and user*/
116: CURSOR l_check_party_ref(l_party_id csm_parties_acc.party_id%TYPE,
117: l_user_id csm_parties_acc.user_id%TYPE) IS
118: SELECT 1
119: FROM csm_parties_acc a,
120: cs_incidents_all_b b,
121: csm_incidents_all_acc c
122: WHERE a.party_id = l_party_id
123: AND a.user_id = l_user_id

Line 197: FROM csm_parties_acc

193:
194: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)
195: IS
196: SELECT access_id, user_id
197: FROM csm_parties_acc
198: WHERE party_id = p_party_id;
199:
200: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)
201: IS