DBA Data[Home] [Help]

APPS.HZ_LOCATION_V2PUB dependencies on HZ_LOCATION_V2PUB

Line 1: PACKAGE BODY hz_location_v2pub AS

1: PACKAGE BODY hz_location_v2pub AS
2: /*$Header: ARH2LOSB.pls 120.35 2006/07/19 23:30:25 baianand noship $ */
3:
4: --------------------------------------
5: -- declaration of private global varibles

Line 52: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

48: x_return_status OUT NOCOPY VARCHAR2
49: );
50:
51: PROCEDURE update_location_search(
52: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
53: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
54: );
55:
56: FUNCTION isModified(p_old_value IN VARCHAR2,

Line 53: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

49: );
50:
51: PROCEDURE update_location_search(
52: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
53: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
54: );
55:
56: FUNCTION isModified(p_old_value IN VARCHAR2,
57: p_new_value IN VARCHAR2

Line 2265: PROCEDURE update_location_search(p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

2261: | HISTORY |
2262: | 15-Mar-2004 Ramesh Ch Created |
2263: *----------------------------------------------------------------------------*/
2264:
2265: PROCEDURE update_location_search(p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2266: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
2267: )
2268: IS
2269: Cursor c_locations(p_location_id NUMBER) IS

Line 2266: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

2262: | 15-Mar-2004 Ramesh Ch Created |
2263: *----------------------------------------------------------------------------*/
2264:
2265: PROCEDURE update_location_search(p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2266: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
2267: )
2268: IS
2269: Cursor c_locations(p_location_id NUMBER) IS
2270: SELECT ac.CUST_ACCT_SITE_ID

Line 2440: END HZ_LOCATION_V2PUB;

2436: END IF;
2437:
2438: END check_obsolete_columns;
2439:
2440: END HZ_LOCATION_V2PUB;