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
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
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
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
2436: END IF;
2437:
2438: END check_obsolete_columns;
2439:
2440: END HZ_LOCATION_V2PUB;