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_ACC_PKG

Line 7: g_publication_item_name0 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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:
11: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';

Line 8: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');

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:
11: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
12: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';

Line 15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

11: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
12: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
13: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
14: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';

Line 16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');

12: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
13: g_pk1_name1 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
14: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';

Line 21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:
24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';

Line 22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');

18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:
24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';

Line 27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

23:
24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
29:
30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';

Line 28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');

24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
29:
30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';
32: g_pk1_name4 CONSTANT VARCHAR2(30) := 'CONTACT_POINT_ID';

Line 33: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

29:
30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';
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';

Line 34: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CONTACT_POINTS');

30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC';
31: g_acc_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_HZ_CONTACT_POINTS_ACC_S';
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';

Line 39: g_publication_item_name5 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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:
42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';

Line 40: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');*/

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:
42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';
44: g_pk1_name6 CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';

Line 45: g_publication_item_name6 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

41:
42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';
44: g_pk1_name6 CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
45: g_publication_item_name6 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
47:
48: g_acc_table_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
49: g_acc_sequence_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';

Line 46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';
44: g_pk1_name6 CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
45: g_publication_item_name6 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
47:
48: g_acc_table_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
49: g_acc_sequence_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
50: g_pk1_name7 CONSTANT VARCHAR2(30) := 'COUNTER_ID';

Line 51: g_publication_item_name7 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

47:
48: g_acc_table_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
49: g_acc_sequence_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
50: g_pk1_name7 CONSTANT VARCHAR2(30) := 'COUNTER_ID';
51: g_publication_item_name7 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
52: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');
53:
54: g_acc_table_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
55: g_acc_sequence_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';

Line 52: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');

48: g_acc_table_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
49: g_acc_sequence_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
50: g_pk1_name7 CONSTANT VARCHAR2(30) := 'COUNTER_ID';
51: g_publication_item_name7 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
52: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');
53:
54: g_acc_table_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
55: g_acc_sequence_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
56: g_pk1_name8 CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';

Line 58: g_publication_item_name8 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

54: g_acc_table_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
55: g_acc_sequence_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
56: g_pk1_name8 CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
57: g_pk2_name8 CONSTANT VARCHAR2(30) := 'COUNTER_ID';
58: g_publication_item_name8 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
59: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
60:
61:
62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';

Line 59: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');

55: g_acc_sequence_name8 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
56: g_pk1_name8 CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
57: g_pk2_name8 CONSTANT VARCHAR2(30) := 'COUNTER_ID';
58: g_publication_item_name8 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
59: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
60:
61:
62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
63: g_acc_sequence_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';

Line 65: g_publication_item_name9 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

61:
62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
63: g_acc_sequence_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
64: g_pk1_name9 CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
65: g_publication_item_name9 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
66: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');
67:
68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';

Line 66: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');

62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
63: g_acc_sequence_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
64: g_pk1_name9 CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
65: g_publication_item_name9 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
66: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');
67:
68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
70: g_pk1_name10 CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';

Line 71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

67:
68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
70: g_pk1_name10 CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');
73:
74: g_acc_table_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC';
75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';

Line 72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');

68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
70: g_pk1_name10 CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');
73:
74: g_acc_table_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC';
75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';
76: g_pk1_name11 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';

Line 78: g_publication_item_name11 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

74: g_acc_table_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC';
75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';
76: g_pk1_name11 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
77: g_pk2_name11 CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
78: g_publication_item_name11 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
79: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_RELATIONSHIPS');
80:
81: PROCEDURE REFRESH_ACC ( x_return_status OUT NOCOPY VARCHAR2,
82: x_error_message OUT NOCOPY VARCHAR2

Line 79: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_RELATIONSHIPS');

75: g_acc_sequence_name11 CONSTANT VARCHAR2(30) := 'CSM_HZ_RELATIONSHIPS_ACC_S';
76: g_pk1_name11 CONSTANT VARCHAR2(30) := 'RELATIONSHIP_ID';
77: g_pk2_name11 CONSTANT VARCHAR2(30) := 'DIRECTIONAL_FLAG';
78: g_publication_item_name11 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
79: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_RELATIONSHIPS');
80:
81: PROCEDURE REFRESH_ACC ( x_return_status OUT NOCOPY VARCHAR2,
82: x_error_message OUT NOCOPY VARCHAR2
83: )

Line 610: --call the CSM_ACC_PKG to delete the record from csm_hz_cust_accounts_acc table

606: IF l_cust_acct_id_tbl.COUNT > 0 THEN
607:
608: FOR i IN l_cust_acct_id_tbl.FIRST..l_cust_acct_id_tbl.LAST LOOP
609:
610: --call the CSM_ACC_PKG to delete the record from csm_hz_cust_accounts_acc table
611:
612: CSM_ACC_PKG.Delete_Acc
613: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name6
614: ,P_ACC_TABLE_NAME => g_acc_table_name6

Line 612: CSM_ACC_PKG.Delete_Acc

608: FOR i IN l_cust_acct_id_tbl.FIRST..l_cust_acct_id_tbl.LAST LOOP
609:
610: --call the CSM_ACC_PKG to delete the record from csm_hz_cust_accounts_acc table
611:
612: CSM_ACC_PKG.Delete_Acc
613: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name6
614: ,P_ACC_TABLE_NAME => g_acc_table_name6
615: ,P_PK1_NAME => g_pk1_name6
616: ,P_PK1_NUM_VALUE => l_cust_acct_id_tbl(i)

Line 675: --call the CSM_ACC_PKG to delete the record from csm_sr_contacts_acc table

671: IF l_contacts_id_tbl.COUNT > 0 THEN
672:
673: FOR i IN l_contacts_id_tbl.FIRST..l_contacts_id_tbl.LAST LOOP
674:
675: --call the CSM_ACC_PKG to delete the record from csm_sr_contacts_acc table
676:
677: CSM_ACC_PKG.Delete_Acc
678: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
679: ,P_ACC_TABLE_NAME => g_acc_table_name4

Line 677: CSM_ACC_PKG.Delete_Acc

673: FOR i IN l_contacts_id_tbl.FIRST..l_contacts_id_tbl.LAST LOOP
674:
675: --call the CSM_ACC_PKG to delete the record from csm_sr_contacts_acc table
676:
677: CSM_ACC_PKG.Delete_Acc
678: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
679: ,P_ACC_TABLE_NAME => g_acc_table_name4
680: ,P_PK1_NAME => g_pk1_name4
681: ,P_PK1_NUM_VALUE => l_contacts_id_tbl(i)

Line 685: --call the CSM_ACC_PKG to delete the record from csm_hz_relationships_acc table

681: ,P_PK1_NUM_VALUE => l_contacts_id_tbl(i)
682: ,P_USER_ID => l_user_id_tbl(i)
683: );
684:
685: --call the CSM_ACC_PKG to delete the record from csm_hz_relationships_acc table
686:
687: CSM_ACC_PKG.Delete_Acc
688: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name11
689: ,P_ACC_TABLE_NAME => g_acc_table_name11

Line 687: CSM_ACC_PKG.Delete_Acc

683: );
684:
685: --call the CSM_ACC_PKG to delete the record from csm_hz_relationships_acc table
686:
687: CSM_ACC_PKG.Delete_Acc
688: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name11
689: ,P_ACC_TABLE_NAME => g_acc_table_name11
690: ,P_PK1_NAME => g_pk1_name11
691: ,P_PK1_NUM_VALUE => l_relationship_id_tbl(i)

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 707: CSM_ACC_PKG.Delete_Acc

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
710: ,P_PK1_NAME => g_pk1_name0
711: ,P_PK1_NUM_VALUE => l_party_id_tbl(i)

Line 715: CSM_ACC_PKG.Delete_Acc

711: ,P_PK1_NUM_VALUE => l_party_id_tbl(i)
712: ,P_USER_ID => l_user_id_tbl(i)
713: );
714:
715: CSM_ACC_PKG.Delete_Acc
716: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name0
717: ,P_ACC_TABLE_NAME => g_acc_table_name0
718: ,P_PK1_NAME => g_pk1_name0
719: ,P_PK1_NUM_VALUE => l_subject_id_tbl(i)

Line 771: --call the CSM_ACC_PKG to delete the record from csm_item_instances_acc table

767: IF l_instance_id_tbl.COUNT > 0 THEN
768:
769: FOR i IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST LOOP
770:
771: --call the CSM_ACC_PKG to delete the record from csm_item_instances_acc table
772:
773: CSM_ACC_PKG.Delete_Acc
774: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
775: ,P_ACC_TABLE_NAME => g_acc_table_name3

Line 773: CSM_ACC_PKG.Delete_Acc

769: FOR i IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST LOOP
770:
771: --call the CSM_ACC_PKG to delete the record from csm_item_instances_acc table
772:
773: CSM_ACC_PKG.Delete_Acc
774: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
775: ,P_ACC_TABLE_NAME => g_acc_table_name3
776: ,P_PK1_NAME => g_pk1_name3
777: ,P_PK1_NUM_VALUE => l_instance_id_tbl(i)

Line 824: --call the CSM_ACC_PKG to delete from csm_counters_acc table

820: IF l_counter_id_tbl.COUNT > 0 THEN
821:
822: FOR i IN l_counter_id_tbl.FIRST..l_counter_id_tbl.LAST LOOP
823:
824: --call the CSM_ACC_PKG to delete from csm_counters_acc table
825:
826: CSM_ACC_PKG.Delete_Acc
827: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name7
828: ,P_ACC_TABLE_NAME => g_acc_table_name7

Line 826: CSM_ACC_PKG.Delete_Acc

822: FOR i IN l_counter_id_tbl.FIRST..l_counter_id_tbl.LAST LOOP
823:
824: --call the CSM_ACC_PKG to delete from csm_counters_acc table
825:
826: CSM_ACC_PKG.Delete_Acc
827: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name7
828: ,P_ACC_TABLE_NAME => g_acc_table_name7
829: ,P_PK1_NAME => g_pk1_name7
830: ,P_PK1_NUM_VALUE => l_counter_id_tbl(i)

Line 876: --call the CSM_ACC_PKG to delete from csm_counter_values_acc table

872: IF l_counter_value_id_tbl.COUNT > 0 THEN
873:
874: FOR i IN l_counter_value_id_tbl.FIRST..l_counter_value_id_tbl.LAST LOOP
875:
876: --call the CSM_ACC_PKG to delete from csm_counter_values_acc table
877:
878: CSM_ACC_PKG.Delete_Acc
879: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name8
880: ,P_ACC_TABLE_NAME => g_acc_table_name8

Line 878: CSM_ACC_PKG.Delete_Acc

874: FOR i IN l_counter_value_id_tbl.FIRST..l_counter_value_id_tbl.LAST LOOP
875:
876: --call the CSM_ACC_PKG to delete from csm_counter_values_acc table
877:
878: CSM_ACC_PKG.Delete_Acc
879: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name8
880: ,P_ACC_TABLE_NAME => g_acc_table_name8
881: ,P_PK1_NAME => g_pk1_name8
882: ,P_PK1_NUM_VALUE => l_counter_value_id_tbl(i)

Line 922: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROPERTIES_ACC table

918: IF l_counter_prp_id_tbl.COUNT > 0 THEN
919:
920: FOR i IN l_counter_prp_id_tbl.FIRST..l_counter_prp_id_tbl.LAST LOOP
921:
922: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROPERTIES_ACC table
923:
924: CSM_ACC_PKG.Delete_Acc
925: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
926: ,P_ACC_TABLE_NAME => g_acc_table_name9

Line 924: CSM_ACC_PKG.Delete_Acc

920: FOR i IN l_counter_prp_id_tbl.FIRST..l_counter_prp_id_tbl.LAST LOOP
921:
922: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROPERTIES_ACC table
923:
924: CSM_ACC_PKG.Delete_Acc
925: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
926: ,P_ACC_TABLE_NAME => g_acc_table_name9
927: ,P_PK1_NAME => g_pk1_name9
928: ,P_PK1_NUM_VALUE => l_counter_prp_id_tbl(i)

Line 968: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROP_VALUES_ACC table

964: IF l_counter_prop_val_tbl.COUNT > 0 THEN
965:
966: FOR i IN l_counter_prop_val_tbl.FIRST..l_counter_prop_val_tbl.LAST LOOP
967:
968: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROP_VALUES_ACC table
969:
970: CSM_ACC_PKG.Delete_Acc
971: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
972: ,P_ACC_TABLE_NAME => g_acc_table_name9

Line 970: CSM_ACC_PKG.Delete_Acc

966: FOR i IN l_counter_prop_val_tbl.FIRST..l_counter_prop_val_tbl.LAST LOOP
967:
968: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROP_VALUES_ACC table
969:
970: CSM_ACC_PKG.Delete_Acc
971: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
972: ,P_ACC_TABLE_NAME => g_acc_table_name9
973: ,P_PK1_NAME => g_pk1_name9
974: ,P_PK1_NUM_VALUE => l_counter_prop_val_tbl(i)

Line 1026: --call the CSM_ACC_PKG to delete the record from csm_party_sites_acc table

1022: IF l_party_site_id_tbl.COUNT > 0 THEN
1023:
1024: FOR i IN l_party_site_id_tbl.FIRST..l_party_site_id_tbl.LAST LOOP
1025:
1026: --call the CSM_ACC_PKG to delete the record from csm_party_sites_acc table
1027:
1028: CSM_ACC_PKG.Delete_Acc
1029: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1030: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 1028: CSM_ACC_PKG.Delete_Acc

1024: FOR i IN l_party_site_id_tbl.FIRST..l_party_site_id_tbl.LAST LOOP
1025:
1026: --call the CSM_ACC_PKG to delete the record from csm_party_sites_acc table
1027:
1028: CSM_ACC_PKG.Delete_Acc
1029: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1030: ,P_ACC_TABLE_NAME => g_acc_table_name1
1031: ,P_PK1_NAME => g_pk1_name1
1032: ,P_PK1_NUM_VALUE => l_party_site_id_tbl(i)

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 1040: CSM_ACC_PKG.Delete_Acc

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
1043: ,P_PK1_NAME => g_pk1_name0
1044: ,P_PK1_NUM_VALUE => l_party_id_tbl(i)

Line 1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table

1052: COMMIT;
1053:
1054: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1055:
1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table
1057:
1058: CSM_ACC_PKG.Delete_Acc
1059: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1060: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 1058: CSM_ACC_PKG.Delete_Acc

1054: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1055:
1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table
1057:
1058: CSM_ACC_PKG.Delete_Acc
1059: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1060: ,P_ACC_TABLE_NAME => g_acc_table_name2
1061: ,P_PK1_NAME => g_pk1_name2
1062: ,P_PK1_NUM_VALUE => l_location_id_tbl(i)

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 1104: CSM_ACC_PKG.Delete_Acc

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
1107: ,P_PK1_NAME => g_pk1_name0
1108: ,P_PK1_NUM_VALUE => l_party_id_tbl(i)

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 1152: CSM_ACC_PKG.Insert_Acc

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
1155: ,P_SEQ_NAME => g_acc_sequence_name0
1156: ,P_PK1_NAME => g_pk1_name0

Line 1210: --call the CSM_ACC_PKG to insert into csm_party_sites_acc table

1206: IF l_party_site_id_tbl.COUNT > 0 THEN
1207:
1208: FOR i IN l_party_site_id_tbl.FIRST..l_party_site_id_tbl.LAST LOOP
1209:
1210: --call the CSM_ACC_PKG to insert into csm_party_sites_acc table
1211:
1212: CSM_ACC_PKG.Insert_Acc
1213: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1214: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 1212: CSM_ACC_PKG.Insert_Acc

1208: FOR i IN l_party_site_id_tbl.FIRST..l_party_site_id_tbl.LAST LOOP
1209:
1210: --call the CSM_ACC_PKG to insert into csm_party_sites_acc table
1211:
1212: CSM_ACC_PKG.Insert_Acc
1213: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1214: ,P_ACC_TABLE_NAME => g_acc_table_name1
1215: ,P_SEQ_NAME => g_acc_sequence_name1
1216: ,P_PK1_NAME => g_pk1_name1

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 1225: CSM_ACC_PKG.Insert_Acc

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
1228: ,P_SEQ_NAME => g_acc_sequence_name0
1229: ,P_PK1_NAME => g_pk1_name0

Line 1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table

1236: COMMIT;
1237:
1238: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1239:
1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table
1241:
1242: CSM_ACC_PKG.Insert_Acc
1243: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1244: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 1242: CSM_ACC_PKG.Insert_Acc

1238: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1239:
1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table
1241:
1242: CSM_ACC_PKG.Insert_Acc
1243: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1244: ,P_ACC_TABLE_NAME => g_acc_table_name2
1245: ,P_SEQ_NAME => g_acc_sequence_name2
1246: ,P_USER_ID => l_user_id_tbl(i)

Line 1305: --call the CSM_ACC_PKG to insert into csm_item_instances_acc table

1301: IF l_instance_id_tbl.COUNT > 0 THEN
1302:
1303: FOR i IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST LOOP
1304:
1305: --call the CSM_ACC_PKG to insert into csm_item_instances_acc table
1306:
1307: CSM_ACC_PKG.Insert_Acc
1308: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
1309: ,P_ACC_TABLE_NAME => g_acc_table_name3

Line 1307: CSM_ACC_PKG.Insert_Acc

1303: FOR i IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST LOOP
1304:
1305: --call the CSM_ACC_PKG to insert into csm_item_instances_acc table
1306:
1307: CSM_ACC_PKG.Insert_Acc
1308: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
1309: ,P_ACC_TABLE_NAME => g_acc_table_name3
1310: ,P_SEQ_NAME => g_acc_sequence_name3
1311: ,P_PK1_NAME => g_pk1_name3

Line 1369: --call the CSM_ACC_PKG to insert into csm_counters_acc table

1365: IF l_counter_id_tbl.COUNT > 0 THEN
1366:
1367: FOR i IN l_counter_id_tbl.FIRST..l_counter_id_tbl.LAST LOOP
1368:
1369: --call the CSM_ACC_PKG to insert into csm_counters_acc table
1370:
1371: CSM_ACC_PKG.Insert_Acc
1372: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name7
1373: ,P_ACC_TABLE_NAME => g_acc_table_name7

Line 1371: CSM_ACC_PKG.Insert_Acc

1367: FOR i IN l_counter_id_tbl.FIRST..l_counter_id_tbl.LAST LOOP
1368:
1369: --call the CSM_ACC_PKG to insert into csm_counters_acc table
1370:
1371: CSM_ACC_PKG.Insert_Acc
1372: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name7
1373: ,P_ACC_TABLE_NAME => g_acc_table_name7
1374: ,P_SEQ_NAME => g_acc_sequence_name7
1375: ,P_PK1_NAME => g_pk1_name7

Line 1422: --call the CSM_ACC_PKG to insert into csm_counter_values_acc table

1418: IF l_counter_value_id_tbl.COUNT > 0 THEN
1419:
1420: FOR i IN l_counter_value_id_tbl.FIRST..l_counter_value_id_tbl.LAST LOOP
1421:
1422: --call the CSM_ACC_PKG to insert into csm_counter_values_acc table
1423:
1424: CSM_ACC_PKG.Insert_Acc
1425: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name8
1426: ,P_ACC_TABLE_NAME => g_acc_table_name8

Line 1424: CSM_ACC_PKG.Insert_Acc

1420: FOR i IN l_counter_value_id_tbl.FIRST..l_counter_value_id_tbl.LAST LOOP
1421:
1422: --call the CSM_ACC_PKG to insert into csm_counter_values_acc table
1423:
1424: CSM_ACC_PKG.Insert_Acc
1425: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name8
1426: ,P_ACC_TABLE_NAME => g_acc_table_name8
1427: ,P_SEQ_NAME => g_acc_sequence_name8
1428: ,P_PK1_NAME => g_pk1_name8

Line 1471: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROPERTIES_ACC table

1467: IF l_counter_prp_id_tbl.COUNT > 0 THEN
1468:
1469: FOR i IN l_counter_prp_id_tbl.FIRST..l_counter_prp_id_tbl.LAST LOOP
1470:
1471: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROPERTIES_ACC table
1472:
1473: CSM_ACC_PKG.Insert_Acc
1474: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
1475: ,P_ACC_TABLE_NAME => g_acc_table_name9

Line 1473: CSM_ACC_PKG.Insert_Acc

1469: FOR i IN l_counter_prp_id_tbl.FIRST..l_counter_prp_id_tbl.LAST LOOP
1470:
1471: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROPERTIES_ACC table
1472:
1473: CSM_ACC_PKG.Insert_Acc
1474: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
1475: ,P_ACC_TABLE_NAME => g_acc_table_name9
1476: ,P_SEQ_NAME => g_acc_sequence_name9
1477: ,P_PK1_NAME => g_pk1_name9

Line 1518: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROP_VALUES_ACC table

1514: IF l_counter_prop_val_tbl.COUNT > 0 THEN
1515:
1516: FOR i IN l_counter_prop_val_tbl.FIRST..l_counter_prop_val_tbl.LAST LOOP
1517:
1518: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROP_VALUES_ACC table
1519:
1520: CSM_ACC_PKG.Insert_Acc
1521: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
1522: ,P_ACC_TABLE_NAME => g_acc_table_name9

Line 1520: CSM_ACC_PKG.Insert_Acc

1516: FOR i IN l_counter_prop_val_tbl.FIRST..l_counter_prop_val_tbl.LAST LOOP
1517:
1518: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROP_VALUES_ACC table
1519:
1520: CSM_ACC_PKG.Insert_Acc
1521: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
1522: ,P_ACC_TABLE_NAME => g_acc_table_name9
1523: ,P_SEQ_NAME => g_acc_sequence_name9
1524: ,P_PK1_NAME => g_pk1_name9

Line 1593: --call the CSM_ACC_PKG to insert into csm_sr_contacts_acc table

1589: IF l_contacts_id_tbl.COUNT > 0 THEN
1590:
1591: FOR i IN l_contacts_id_tbl.FIRST..l_contacts_id_tbl.LAST LOOP
1592:
1593: --call the CSM_ACC_PKG to insert into csm_sr_contacts_acc table
1594:
1595: CSM_ACC_PKG.Insert_Acc
1596: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
1597: ,P_ACC_TABLE_NAME => g_acc_table_name4

Line 1595: CSM_ACC_PKG.Insert_Acc

1591: FOR i IN l_contacts_id_tbl.FIRST..l_contacts_id_tbl.LAST LOOP
1592:
1593: --call the CSM_ACC_PKG to insert into csm_sr_contacts_acc table
1594:
1595: CSM_ACC_PKG.Insert_Acc
1596: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
1597: ,P_ACC_TABLE_NAME => g_acc_table_name4
1598: ,P_SEQ_NAME => g_acc_sequence_name4
1599: ,P_PK1_NAME => g_pk1_name4

Line 1604: --call the CSM_ACC_PKG to insert into csm_hz_relationships_acc table

1600: ,P_PK1_NUM_VALUE => l_contacts_id_tbl(i)
1601: ,P_USER_ID => l_user_id_tbl(i)
1602: );
1603:
1604: --call the CSM_ACC_PKG to insert into csm_hz_relationships_acc table
1605:
1606: CSM_ACC_PKG.Insert_Acc
1607: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name11
1608: ,P_ACC_TABLE_NAME => g_acc_table_name11

Line 1606: CSM_ACC_PKG.Insert_Acc

1602: );
1603:
1604: --call the CSM_ACC_PKG to insert into csm_hz_relationships_acc table
1605:
1606: CSM_ACC_PKG.Insert_Acc
1607: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name11
1608: ,P_ACC_TABLE_NAME => g_acc_table_name11
1609: ,P_SEQ_NAME => g_acc_sequence_name11
1610: ,P_PK1_NAME => g_pk1_name11

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 1626: CSM_ACC_PKG.Insert_Acc

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
1630: ,P_PK1_NAME => g_pk1_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

Line 1636: CSM_ACC_PKG.Insert_Acc

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
1640: ,P_PK1_NAME => g_pk1_name0

Line 1681: --call the CSM_ACC_PKG to insert the record into csm_hz_cust_accounts_acc table

1677: IF l_cust_acct_id_tbl.COUNT > 0 THEN
1678:
1679: FOR i IN l_cust_acct_id_tbl.FIRST..l_cust_acct_id_tbl.LAST LOOP
1680:
1681: --call the CSM_ACC_PKG to insert the record into csm_hz_cust_accounts_acc table
1682:
1683: CSM_ACC_PKG.Insert_Acc
1684: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name6
1685: ,P_ACC_TABLE_NAME => g_acc_table_name6

Line 1683: CSM_ACC_PKG.Insert_Acc

1679: FOR i IN l_cust_acct_id_tbl.FIRST..l_cust_acct_id_tbl.LAST LOOP
1680:
1681: --call the CSM_ACC_PKG to insert the record into csm_hz_cust_accounts_acc table
1682:
1683: CSM_ACC_PKG.Insert_Acc
1684: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name6
1685: ,P_ACC_TABLE_NAME => g_acc_table_name6
1686: ,P_SEQ_NAME => g_acc_sequence_name6
1687: ,P_PK1_NAME => g_pk1_name6