APPS.CSL_HZ_PARTIES_ACC_PKG dependencies on HZ_PARTIES

Line 1: PACKAGE BODY CSL_HZ_PARTIES_ACC_PKG AS

1: PACKAGE BODY CSL_HZ_PARTIES_ACC_PKG AS
2: /* $Header: cslpaacb.pls 120.1 2005/08/31 02:56:49 utekumal noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTIES_ACC';

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

1: PACKAGE BODY CSL_HZ_PARTIES_ACC_PKG AS
2: /* $Header: cslpaacb.pls 120.1 2005/08/31 02:56:49 utekumal noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTIES_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_PARTIES');
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'PARTY_ID';

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTIES_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_PARTIES');
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'PARTY_ID';
10: g_debug_level NUMBER;
11:

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

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_HZ_PARTIES_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_PARTIES');
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'PARTY_ID';
10: g_debug_level NUMBER;
11:
12: /**

Line 20: FROM HZ_PARTIES

16: RETURN BOOLEAN
17: IS
18: CURSOR c_party( b_party_id NUMBER ) IS
19: SELECT party_id -- Fix for Sql Performance
20: FROM HZ_PARTIES
21: WHERE PARTY_ID = b_party_id;
22: r_party c_party%ROWTYPE;
23: BEGIN
24: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 564: WF_CORE.CONTEXT('CSL_HZ_PARTIES_ACC_PKG', 'UPDATE_PARTY_WFSUB', p_event.getEventName(), p_subscription_guid);

560: RETURN 'SUCCESS';
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: WF_CORE.CONTEXT('CSL_HZ_PARTIES_ACC_PKG', 'UPDATE_PARTY_WFSUB', p_event.getEventName(), p_subscription_guid);
565: WF_EVENT.setErrorInfo(p_event, 'ERROR');
566: RETURN 'ERROR';
567: END UPDATE_PARTY_WFSUB;
568: END CSL_HZ_PARTIES_ACC_PKG;

Line 568: END CSL_HZ_PARTIES_ACC_PKG;

564: WF_CORE.CONTEXT('CSL_HZ_PARTIES_ACC_PKG', 'UPDATE_PARTY_WFSUB', p_event.getEventName(), p_subscription_guid);
565: WF_EVENT.setErrorInfo(p_event, 'ERROR');
566: RETURN 'ERROR';
567: END UPDATE_PARTY_WFSUB;
568: END CSL_HZ_PARTIES_ACC_PKG;