APPS.PN_VAR_RENT_INV_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 69: FROM PN_VAR_RENT_INV_ALL

65: X_TRUE_UP_EXP_CODE IN VARCHAR2
66: ) IS
67: CURSOR C IS
68: SELECT ROWID
69: FROM PN_VAR_RENT_INV_ALL
70: WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID;
71:
72: CURSOR org_cur IS
73: SELECT org_id

Line 105: INSERT INTO PN_VAR_RENT_INV_ALL (

101: END IF;
102:
103: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(l_org_id),4);
104:
105: INSERT INTO PN_VAR_RENT_INV_ALL (
106: VAR_RENT_INV_ID,
107: ADJUST_NUM,
108: INVOICE_DATE,
109: FOR_PER_RENT,

Line 285: FROM PN_VAR_RENT_INV_ALL

281: X_ATTRIBUTE15 IN VARCHAR2
282: ) IS
283: CURSOR c1 IS
284: SELECT *
285: FROM PN_VAR_RENT_INV_ALL
286: WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID
287: FOR UPDATE OF VAR_RENT_INV_ID nowait;
288:
289: tlINfo c1%ROWTYPE;

Line 637: UPDATE PN_VAR_RENT_INV_ALL SET

633: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.UPDATE_ROW (+)');
634:
635: l_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(),4);
636:
637: UPDATE PN_VAR_RENT_INV_ALL SET
638: ADJUST_NUM = X_ADJUST_NUM,
639: INVOICE_DATE = X_INVOICE_DATE,
640: FOR_PER_RENT = ROUND(X_FOR_PER_RENT, l_precision),
641: TOT_ACT_VOL = ROUND(X_TOT_ACT_VOL, l_precision),

Line 702: DELETE FROM PN_VAR_RENT_INV_ALL

698: BEGIN
699:
700: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.DELETE_ROW (+)');
701:
702: DELETE FROM PN_VAR_RENT_INV_ALL
703: WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID;
704:
705: IF (SQL%NOTFOUND) THEN
706: RAISE NO_DATA_FOUND;