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 284: FROM PN_VAR_RENT_INV_ALL

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

Line 636: UPDATE PN_VAR_RENT_INV_ALL SET

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

Line 701: DELETE FROM PN_VAR_RENT_INV_ALL

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