DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_PARTY_SITE_V2PUB

Line 1: PACKAGE BODY HZ_PARTY_SITE_V2PUB AS

1: PACKAGE BODY HZ_PARTY_SITE_V2PUB AS
2: /*$Header: ARH2PSSB.pls 120.43 2006/07/31 23:39:52 baianand noship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITE_V2PUB';

7:
8: G_DEBUG_COUNT NUMBER := 0;
9: --G_DEBUG BOOLEAN := FALSE;
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITE_V2PUB';
12:
13: -- Bug 2197181: added for mix-n-match project.
14:
15: g_pst_mixnmatch_enabled VARCHAR2(1);

Line 3053: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

3049: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3050: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3051: l_debug_prefix VARCHAR2(30) := '';
3052: /* Bug Fix: 4515314 */
3053: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
3054: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;
3055: l_msg_count number;
3056: l_msg_data varchar2(2000);
3057:

Line 3081: HZ_PARTY_SITE_V2PUB.update_party_site_use

3077: fetch c_active_use into l_party_site_use_id,l_object_version_number;
3078: exit when c_active_use%notfound;
3079: l_party_site_use_rec.party_site_use_id := l_party_site_use_id;
3080: l_party_site_use_rec.status := 'I';
3081: HZ_PARTY_SITE_V2PUB.update_party_site_use
3082: (p_init_msg_list => FND_API.G_TRUE,
3083: p_party_site_use_rec => l_party_site_use_rec,
3084: p_object_version_number => l_object_version_number,
3085: x_return_status => x_return_status,

Line 3484: END HZ_PARTY_SITE_V2PUB;

3480: END IF;
3481:
3482: END check_obsolete_columns;
3483:
3484: END HZ_PARTY_SITE_V2PUB;