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.2 2011/01/10 10:37:24 saradhak ship $ */
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.2 2011/01/10 10:37:24 saradhak ship $ */
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: l_count NUMBER := 0 ;
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 p
120: WHERE p.party_id = l_party_id

Line 117: l_user_id csm_parties_acc.user_id%TYPE) IS

113: l_ref_exists NUMBER := 0 ;
114: l_count NUMBER := 0 ;
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 p
120: WHERE p.party_id = l_party_id
121: AND p.user_id = l_user_id

Line 119: FROM csm_parties_acc p

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 p
120: WHERE p.party_id = l_party_id
121: AND p.user_id = l_user_id
122: AND NOT EXISTS
123: (

Line 148: CURSOR c_get_party_count(l_party_id csm_parties_acc.party_id%TYPE,

144: AND cont.PARTY_ID = p.PARTY_ID
145: AND src.sr_contact_point_id = cont.sr_contact_point_id
146: );
147:
148: CURSOR c_get_party_count(l_party_id csm_parties_acc.party_id%TYPE,
149: l_user_id csm_parties_acc.user_id%TYPE)
150: IS
151: SELECT count(*)
152: FROM csm_parties_acc

Line 149: l_user_id csm_parties_acc.user_id%TYPE)

145: AND src.sr_contact_point_id = cont.sr_contact_point_id
146: );
147:
148: CURSOR c_get_party_count(l_party_id csm_parties_acc.party_id%TYPE,
149: l_user_id csm_parties_acc.user_id%TYPE)
150: IS
151: SELECT count(*)
152: FROM csm_parties_acc
153: WHERE party_id = l_party_id

Line 152: FROM csm_parties_acc

148: CURSOR c_get_party_count(l_party_id csm_parties_acc.party_id%TYPE,
149: l_user_id csm_parties_acc.user_id%TYPE)
150: IS
151: SELECT count(*)
152: FROM csm_parties_acc
153: WHERE party_id = l_party_id
154: AND user_id = l_user_id;
155:
156: BEGIN

Line 242: FROM csm_parties_acc

238:
239: CURSOR l_parties_csr (p_party_id hz_parties.party_id%TYPE)
240: IS
241: SELECT access_id, user_id
242: FROM csm_parties_acc
243: WHERE party_id = p_party_id;
244:
245: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)
246: IS

Line 302: SELECT /*+ INDEX (p CSM_PARTIES_ACC_U1) */ p.party_id,p.USER_ID

298: IS
299: PRAGMA AUTONOMOUS_TRANSACTION;
300: CURSOR l_party_csr
301: IS
302: SELECT /*+ INDEX (p CSM_PARTIES_ACC_U1) */ p.party_id,p.USER_ID
303: FROM CSM_PARTIES_ACC p
304: WHERE NOT EXISTS
305: (
306: SELECT /*+INDEX (csi CS_INCIDENTS_U1) */ 1

Line 303: FROM CSM_PARTIES_ACC p

299: PRAGMA AUTONOMOUS_TRANSACTION;
300: CURSOR l_party_csr
301: IS
302: SELECT /*+ INDEX (p CSM_PARTIES_ACC_U1) */ p.party_id,p.USER_ID
303: FROM CSM_PARTIES_ACC p
304: WHERE NOT EXISTS
305: (
306: SELECT /*+INDEX (csi CS_INCIDENTS_U1) */ 1
307: FROM csm_incidents_all_acc acc,

Line 331: SELECT /*+ INDEX (p CSM_PARTIES_ACC_U1) */

327: AND src.sr_contact_point_id = cont.sr_contact_point_id
328: );
329:
330: CURSOR c_get_access_ID(b_party_id NUMBER,b_user_id NUMBER) IS
331: SELECT /*+ INDEX (p CSM_PARTIES_ACC_U1) */
332: P.ACCESS_ID
333: FROM CSM_PARTIES_ACC P
334: WHERE P.PARTY_ID = b_party_id
335: AND P.USER_ID = b_user_id;

Line 333: FROM CSM_PARTIES_ACC P

329:
330: CURSOR c_get_access_ID(b_party_id NUMBER,b_user_id NUMBER) IS
331: SELECT /*+ INDEX (p CSM_PARTIES_ACC_U1) */
332: P.ACCESS_ID
333: FROM CSM_PARTIES_ACC P
334: WHERE P.PARTY_ID = b_party_id
335: AND P.USER_ID = b_user_id;
336:
337: l_sqlerrno VARCHAR2(20);

Line 376: DELETE FROM CSM_PARTIES_ACC WHERE ACCESS_ID=l_accessid_tbl(I);

372: , l_userid_tbl, 'D', sysdate,true );
373:
374: -- doing PARTY delete
375: FORALL I IN 1..l_accessid_tbl.COUNT
376: DELETE FROM CSM_PARTIES_ACC WHERE ACCESS_ID=l_accessid_tbl(I);
377: -- commit after every 100 records since mark dirty takes time when more than 100
378: COMMIT;
379: EXIT WHEN l_partyid_tbl.COUNT < 100;
380: END LOOP;