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.39 2011/12/26 07:04:59 rgokavar ship $ */
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 2297: PROCEDURE update_location_search(p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,

2293: | HISTORY |
2294: | 15-Mar-2004 Ramesh Ch Created |
2295: *----------------------------------------------------------------------------*/
2296:
2297: PROCEDURE update_location_search(p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2298: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
2299: )
2300: IS
2301: Cursor c_locations(p_location_id NUMBER) IS

Line 2298: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE

2294: | 15-Mar-2004 Ramesh Ch Created |
2295: *----------------------------------------------------------------------------*/
2296:
2297: PROCEDURE update_location_search(p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2298: p_new_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
2299: )
2300: IS
2301: Cursor c_locations(p_location_id NUMBER) IS
2302: SELECT ac.CUST_ACCT_SITE_ID

Line 2472: END HZ_LOCATION_V2PUB;

2468: END IF;
2469:
2470: END check_obsolete_columns;
2471:
2472: END HZ_LOCATION_V2PUB;