APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_ABATEMENTS_PKG

Line 9061: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);

9057: l_min_var_abt_id := abtmt_exists_rec.var_abatement_id;
9058: l_min_pmt_term_id := abtmt_exists_rec.payment_term_id;
9059:
9060: --pnp_debug_pkg.log('prior to update');
9061: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9062: update pn_var_abatements_all
9063: set var_rent_inv_id = l_fst_inv_id
9064: where var_abatement_id = l_min_var_abt_id;
9065:

Line 9104: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9100:
9101: l_row_id := NULL;
9102: l_var_abmt_id :=NULL;
9103:
9104: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9105: X_ROWID => l_row_id,
9106: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9107: X_VAR_RENT_ID => p_var_rent_id,
9108: X_VAR_RENT_INV_ID => l_inv_id,

Line 9279: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9275: IF l_abt_exists <> 'Y' THEN
9276: l_row_id := NULL;
9277: l_var_abmt_id :=NULL;
9278:
9279: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9280: X_ROWID => l_row_id,
9281: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9282: X_VAR_RENT_ID => p_var_rent_id,
9283: X_VAR_RENT_INV_ID => l_last_inv_id,

Line 9432: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);

9428: l_min_var_abt_id:= abtmt_exists_rec.var_abatement_id;
9429: l_min_pmt_term_id:= abtmt_exists_rec.payment_term_id;
9430: --pnp_debug_pkg.log('prior to update');
9431:
9432: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9433: UPDATE pn_var_abatements_all
9434: SET var_rent_inv_id=l_inv_id
9435: WHERE var_abatement_id = l_min_var_abt_id;
9436:

Line 9459: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9455: IF (l_pmt_term_id = l_abtmt_term_id) THEN
9456: l_row_id := NULL;
9457: l_var_abmt_id :=NULL;
9458:
9459: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9460: X_ROWID => l_row_id,
9461: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9462: X_VAR_RENT_ID => p_var_rent_id,
9463: X_VAR_RENT_INV_ID => l_inv_id,

Line 9594: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9590: IF l_abtmt_exists = 'N' THEN
9591:
9592: l_row_id := NULL;
9593: l_var_abmt_id :=NULL;
9594: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9595: X_ROWID => l_row_id,
9596: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9597: X_VAR_RENT_ID => p_var_rent_id,
9598: X_VAR_RENT_INV_ID => l_inv_id,

Line 9724: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9720:
9721: l_row_id := NULL;
9722: l_var_abmt_id :=NULL;
9723:
9724: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9725: X_ROWID => l_row_id,
9726: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9727: X_VAR_RENT_ID => p_var_rent_id,
9728: X_VAR_RENT_INV_ID => l_inv_id,