APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_ABATEMENTS_PKG

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

9002: l_min_var_abt_id := abtmt_exists_rec.var_abatement_id;
9003: l_min_pmt_term_id := abtmt_exists_rec.payment_term_id;
9004:
9005: --pnp_debug_pkg.log('prior to update');
9006: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9007: update pn_var_abatements_all
9008: set var_rent_inv_id = l_fst_inv_id
9009: where var_abatement_id = l_min_var_abt_id;
9010:

Line 9049: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9045:
9046: l_row_id := NULL;
9047: l_var_abmt_id :=NULL;
9048:
9049: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9050: X_ROWID => l_row_id,
9051: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9052: X_VAR_RENT_ID => p_var_rent_id,
9053: X_VAR_RENT_INV_ID => l_inv_id,

Line 9224: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9220: IF l_abt_exists <> 'Y' THEN
9221: l_row_id := NULL;
9222: l_var_abmt_id :=NULL;
9223:
9224: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9225: X_ROWID => l_row_id,
9226: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9227: X_VAR_RENT_ID => p_var_rent_id,
9228: X_VAR_RENT_INV_ID => l_last_inv_id,

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

9373: l_min_var_abt_id:= abtmt_exists_rec.var_abatement_id;
9374: l_min_pmt_term_id:= abtmt_exists_rec.payment_term_id;
9375: --pnp_debug_pkg.log('prior to update');
9376:
9377: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9378: UPDATE pn_var_abatements_all
9379: SET var_rent_inv_id=l_inv_id
9380: WHERE var_abatement_id = l_min_var_abt_id;
9381:

Line 9404: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9400: IF (l_pmt_term_id = l_abtmt_term_id) THEN
9401: l_row_id := NULL;
9402: l_var_abmt_id :=NULL;
9403:
9404: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9405: X_ROWID => l_row_id,
9406: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9407: X_VAR_RENT_ID => p_var_rent_id,
9408: X_VAR_RENT_INV_ID => l_inv_id,

Line 9539: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9535: IF l_abtmt_exists = 'N' THEN
9536:
9537: l_row_id := NULL;
9538: l_var_abmt_id :=NULL;
9539: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9540: X_ROWID => l_row_id,
9541: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9542: X_VAR_RENT_ID => p_var_rent_id,
9543: X_VAR_RENT_INV_ID => l_inv_id,

Line 9669: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

9665:
9666: l_row_id := NULL;
9667: l_var_abmt_id :=NULL;
9668:
9669: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
9670: X_ROWID => l_row_id,
9671: X_VAR_ABATEMENT_ID => l_var_abmt_id,
9672: X_VAR_RENT_ID => p_var_rent_id,
9673: X_VAR_RENT_INV_ID => l_inv_id,