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
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,
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
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
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
2468: END IF;
2469:
2470: END check_obsolete_columns;
2471:
2472: END HZ_LOCATION_V2PUB;