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_PARTY_DATA_EVENT_PKG dependencies on CSM_PARTIES_ACC

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

1: PACKAGE BODY CSM_PARTY_DATA_EVENT_PKG AS
2: /* $Header: csmepdab.pls 120.13 2008/06/12 12:51:22 trajasek noship $ */
3:
4: g_table_name0 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name0 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
6: g_acc_sequence_name0 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
7: g_publication_item_name0 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');
9: g_pk1_name0 CONSTANT VARCHAR2(30) := 'PARTY_ID';

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

2: /* $Header: csmepdab.pls 120.13 2008/06/12 12:51:22 trajasek noship $ */
3:
4: g_table_name0 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name0 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
6: g_acc_sequence_name0 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
7: g_publication_item_name0 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');
9: g_pk1_name0 CONSTANT VARCHAR2(30) := 'PARTY_ID';
10:

Line 36: /*g_acc_table_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';

32: g_pk1_name4 CONSTANT VARCHAR2(30) := 'CONTACT_POINT_ID';
33: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');
35:
36: /*g_acc_table_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
37: g_acc_sequence_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
38: g_pk1_name5 CONSTANT VARCHAR2(30) := 'PARTY_ID';
39: g_publication_item_name5 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
40: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');*/

Line 37: g_acc_sequence_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';

33: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');
35:
36: /*g_acc_table_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';
37: g_acc_sequence_name5 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC_S';
38: g_pk1_name5 CONSTANT VARCHAR2(30) := 'PARTY_ID';
39: g_publication_item_name5 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
40: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');*/
41:

Line 88: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;

84: IS
85:
86: --variable declarations
87:
88: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;
89: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
90: TYPE l_party_site_id_tbl_type IS TABLE OF csm_party_sites_acc.party_site_id%TYPE INDEX BY BINARY_INTEGER;
91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;
92: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;

Line 89: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;

85:
86: --variable declarations
87:
88: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;
89: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
90: TYPE l_party_site_id_tbl_type IS TABLE OF csm_party_sites_acc.party_site_id%TYPE INDEX BY BINARY_INTEGER;
91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;
92: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
93: TYPE l_contacts_id_tbl_type IS TABLE OF csm_sr_contacts_acc.sr_contact_point_id%TYPE INDEX BY BINARY_INTEGER;

Line 145: FROM csm_parties_acc cpa

141: FROM csm_party_assignment tcpa
142: WHERE tcpa.party_site_id IN (-1,-2)
143: AND tcpa.deleted_flag = 'N'
144: AND NOT EXISTS ( SELECT 1
145: FROM csm_parties_acc cpa
146: WHERE cpa.party_id = tcpa.party_id
147: AND cpa.user_id = tcpa.user_id
148: );
149:

Line 384: FROM csm_parties_acc cpa

380: FROM csm_party_assignment tcpa
381: WHERE tcpa.party_site_id IN (-1,-2)
382: AND tcpa.deleted_flag = 'Y'
383: AND EXISTS ( SELECT 1
384: FROM csm_parties_acc cpa
385: WHERE cpa.party_id = tcpa.party_id
386: AND cpa.user_id = tcpa.user_id
387: );
388:

Line 705: --call the CSM_ACC_PKG to delete the record from csm_parties_acc table

701: COMMIT;
702:
703: FOR i IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
704:
705: --call the CSM_ACC_PKG to delete the record from csm_parties_acc table
706:
707: CSM_ACC_PKG.Delete_Acc
708: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
709: ,P_ACC_TABLE_NAME => g_acc_table_name0

Line 1038: --call the CSM_ACC_PKG to delete the record from csm_parties_acc table

1034: ,P_PK2_NUM_VALUE => l_party_id_tbl(i)
1035: ,P_USER_ID => l_user_id_tbl(i)
1036: );
1037:
1038: --call the CSM_ACC_PKG to delete the record from csm_parties_acc table
1039:
1040: CSM_ACC_PKG.Delete_Acc
1041: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
1042: ,P_ACC_TABLE_NAME => g_acc_table_name0

Line 1102: --call the CSM_ACC_PKG to delete the record from csm_parties_acc table

1098: IF l_party_id_tbl.COUNT > 0 THEN
1099:
1100: FOR i IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
1101:
1102: --call the CSM_ACC_PKG to delete the record from csm_parties_acc table
1103:
1104: CSM_ACC_PKG.Delete_Acc
1105: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
1106: ,P_ACC_TABLE_NAME => g_acc_table_name0

Line 1150: --call the CSM_ACC_PKG to insert into csm_parties_acc table

1146: IF l_party_id_tbl.COUNT > 0 THEN
1147:
1148: FOR i IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
1149:
1150: --call the CSM_ACC_PKG to insert into csm_parties_acc table
1151:
1152: CSM_ACC_PKG.Insert_Acc
1153: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
1154: ,P_ACC_TABLE_NAME => g_acc_table_name0

Line 1223: --call the CSM_ACC_PKG to insert into csm_parties_acc table

1219: ,P_PK2_NUM_VALUE => l_party_id_tbl(i)
1220: ,P_USER_ID => l_user_id_tbl(i)
1221: );
1222:
1223: --call the CSM_ACC_PKG to insert into csm_parties_acc table
1224:
1225: CSM_ACC_PKG.Insert_Acc
1226: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
1227: ,P_ACC_TABLE_NAME => g_acc_table_name0

Line 1625: --call the CSM_ACC_PKG to insert object id into csm_parties_acc table

1621: COMMIT;
1622:
1623: FOR i IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
1624:
1625: --call the CSM_ACC_PKG to insert object id into csm_parties_acc table
1626: CSM_ACC_PKG.Insert_Acc
1627: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
1628: ,P_ACC_TABLE_NAME => g_acc_table_name0
1629: ,P_SEQ_NAME => g_acc_sequence_name0

Line 1635: --call the CSM_ACC_PKG to insert Subject id into csm_parties_acc table

1631: ,P_PK1_NUM_VALUE => l_party_id_tbl(i)
1632: ,P_USER_ID => l_user_id_tbl(i)
1633: );
1634:
1635: --call the CSM_ACC_PKG to insert Subject id into csm_parties_acc table
1636: CSM_ACC_PKG.Insert_Acc
1637: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
1638: ,P_ACC_TABLE_NAME => g_acc_table_name0
1639: ,P_SEQ_NAME => g_acc_sequence_name0