DBA Data[Home] [Help]

APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_UPG_TRX_PKG

Line 1: PACKAGE BODY PN_VAR_UPG_TRX_PKG AS

1: PACKAGE BODY PN_VAR_UPG_TRX_PKG AS
2: -- $Header: PNUPGTRB.pls 120.0 2011/10/10 10:20:08 acprakas noship $
3:
4: --------------------------------------------------------------------------------
5: --

Line 103: PN_VAR_UPG_TRX_PKG.process_vr_upgrade

99:
100: IF p_property_code IS NOT NULL OR p_property_name IS NOT NULL THEN
101:
102: FOR rec IN csr_get_vrent_wprop LOOP
103: PN_VAR_UPG_TRX_PKG.process_vr_upgrade
104: ( p_var_rent_id => rec.var_rent_id);
105: END LOOP;
106:
107: ELSIF p_location_code_from IS NOT NULL or p_location_code_to IS NOT NULL THEN

Line 110: PN_VAR_UPG_TRX_PKG.process_vr_upgrade

106:
107: ELSIF p_location_code_from IS NOT NULL or p_location_code_to IS NOT NULL THEN
108:
109: FOR rec IN csr_get_vrent_wloc LOOP
110: PN_VAR_UPG_TRX_PKG.process_vr_upgrade
111: ( p_var_rent_id => rec.var_rent_id);
112: END LOOP;
113:
114: ELSE

Line 117: PN_VAR_UPG_TRX_PKG.process_vr_upgrade

113:
114: ELSE
115:
116: FOR rec IN csr_get_vrent_woloc LOOP
117: PN_VAR_UPG_TRX_PKG.process_vr_upgrade
118: ( p_var_rent_id => rec.var_rent_id);
119: END LOOP;
120:
121: END IF;

Line 225: END PN_VAR_UPG_TRX_PKG;

221: WHEN OTHERS THEN
222: raise_application_error ('-20001','Error ' || to_char(sqlcode)||' error message '||SQLERRM);
223: END process_vr_upgrade;
224:
225: END PN_VAR_UPG_TRX_PKG;
226: