APPS.CSL_HZ_PARTY_SITES_ACC_PKG dependencies on HZ_PARTY_SITES

Line 1: PACKAGE BODY CSL_HZ_PARTY_SITES_ACC_PKG AS

1: PACKAGE BODY CSL_HZ_PARTY_SITES_ACC_PKG AS
2: /* $Header: cslpsacb.pls 120.0 2005/05/24 18:18:39 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTY_SITES_ACC';

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTY_SITES_ACC';

1: PACKAGE BODY CSL_HZ_PARTY_SITES_ACC_PKG AS
2: /* $Header: cslpsacb.pls 120.0 2005/05/24 18:18:39 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTY_SITES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_PARTY_SITES');
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_PARTY_SITES');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTY_SITES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_PARTY_SITES');
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
10: g_debug_level NUMBER;
11:

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTY_SITES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_PARTY_SITES');
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
10: g_debug_level NUMBER;
11:
12: PROCEDURE INSERT_PARTY_SITE( p_party_site_id IN NUMBER

Line 17: FROM HZ_PARTY_SITES

13: , p_resource_id IN NUMBER )
14: IS
15: CURSOR c_party_site( b_party_site_id NUMBER ) IS
16: SELECT *
17: FROM HZ_PARTY_SITES
18: WHERE party_site_id = b_party_site_id;
19:
20: r_party_site c_party_site%ROWTYPE;
21:

Line 127: FROM HZ_PARTY_SITES

123: , p_resource_id IN NUMBER )
124: IS
125: CURSOR c_party_site( b_party_site_id NUMBER ) IS
126: SELECT *
127: FROM HZ_PARTY_SITES
128: WHERE party_site_id = b_party_site_id;
129:
130: r_party_site c_party_site%ROWTYPE;
131:

Line 175: FROM HZ_PARTY_SITES

171: , p_resource_id IN NUMBER )
172: IS
173: CURSOR c_party_site( b_party_site_id NUMBER ) IS
174: SELECT *
175: FROM HZ_PARTY_SITES
176: WHERE party_site_id = b_party_site_id;
177:
178: r_party_site c_party_site%ROWTYPE;
179:

Line 250: END CSL_HZ_PARTY_SITES_ACC_PKG;

246: END IF;
247:
248: END CHANGE_PARTY_SITE;
249:
250: END CSL_HZ_PARTY_SITES_ACC_PKG;