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.44.12020000.2 2013/04/12 07:04:36 rgokavar ship $ */
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 3060: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

3056: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3057: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3058: l_debug_prefix VARCHAR2(30) := '';
3059: /* Bug Fix: 4515314 */
3060: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
3061: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;
3062: l_msg_count number;
3063: l_msg_data varchar2(2000);
3064:

Line 3088: HZ_PARTY_SITE_V2PUB.update_party_site_use

3084: fetch c_active_use into l_party_site_use_id,l_object_version_number;
3085: exit when c_active_use%notfound;
3086: l_party_site_use_rec.party_site_use_id := l_party_site_use_id;
3087: l_party_site_use_rec.status := 'I';
3088: HZ_PARTY_SITE_V2PUB.update_party_site_use
3089: (p_init_msg_list => FND_API.G_TRUE,
3090: p_party_site_use_rec => l_party_site_use_rec,
3091: p_object_version_number => l_object_version_number,
3092: x_return_status => x_return_status,

Line 3491: END HZ_PARTY_SITE_V2PUB;

3487: END IF;
3488:
3489: END check_obsolete_columns;
3490:
3491: END HZ_PARTY_SITE_V2PUB;