APPS.PN_VAR_ABATEMENTS_PKG dependencies on PN_VAR_ABATEMENTS_ALL

Line 31: FROM PN_VAR_ABATEMENTS_ALL

27: ) IS
28:
29: CURSOR var_abatements IS
30: SELECT ROWID
31: FROM PN_VAR_ABATEMENTS_ALL
32: WHERE VAR_ABATEMENT_ID = X_VAR_ABATEMENT_ID;
33:
34: CURSOR org_cur IS
35: SELECT org_id

Line 64: INSERT INTO PN_VAR_ABATEMENTS_ALL

60: INTO X_VAR_ABATEMENT_ID
61: FROM dual;
62: END IF;
63:
64: INSERT INTO PN_VAR_ABATEMENTS_ALL
65: ( VAR_RENT_ID,
66: VAR_ABATEMENT_ID,
67: VAR_RENT_INV_ID,
68: PAYMENT_TERM_ID,

Line 122: FROM PN_VAR_ABATEMENTS_ALL

118: ) IS
119:
120: CURSOR c1 IS
121: SELECT *
122: FROM PN_VAR_ABATEMENTS_ALL
123: WHERE VAR_RENT_ID = X_VAR_RENT_ID AND
124: VAR_RENT_INV_ID = X_VAR_RENT_INV_ID AND
125: PAYMENT_TERM_ID = X_PAYMENT_TERM_ID
126: FOR UPDATE OF VAR_ABATEMENT_ID NOWAIT;

Line 184: UPDATE PN_VAR_ABATEMENTS_ALL SET

180: BEGIN
181:
182: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (+)');
183:
184: UPDATE PN_VAR_ABATEMENTS_ALL SET
185: VAR_RENT_ID = X_VAR_RENT_ID,
186: VAR_RENT_INV_ID = X_VAR_RENT_INV_ID,
187: PAYMENT_TERM_ID = X_PAYMENT_TERM_ID,
188: INCLUDE_TERM = X_INCLUDE_TERM,

Line 224: DELETE FROM PN_VAR_ABATEMENTS_ALL

220: BEGIN
221:
222: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (+)');
223:
224: DELETE FROM PN_VAR_ABATEMENTS_ALL
225: WHERE VAR_RENT_ID = X_VAR_RENT_ID
226: AND VAR_RENT_INV_ID = X_VAR_RENT_INV_ID
227: AND PAYMENT_TERM_ID = X_PAYMENT_TERM_ID;
228:

Line 315: WHERE exists ( select null from pn_var_abatements_all

311: p_pmt_term_id IN NUMBER)
312: IS
313: SELECT 'y'
314: FROM dual
315: WHERE exists ( select null from pn_var_abatements_all
316: where var_rent_id=p_var_rentId AND
317: var_rent_inv_id=p_var_rent_inv_id AND
318: payment_term_id=p_pmt_term_id);
319:

Line 354: FROM pn_var_abatements_all

350: IS
351: -- Get the details of
352: CURSOR get_update_cur(p_var_rentId IN NUMBER,p_var_rent_inv_id IN NUMBER) IS
353: SELECT *
354: FROM pn_var_abatements_all
355: WHERE var_rent_id= p_var_rentId
356: AND var_rent_inv_id = p_var_rent_inv_id
357: AND update_flag = 'Y';
358: BEGIN

Line 463: FROM pn_var_abatements_all

459: CURSOR check_abtmt_terms_inv(p_inv_id IN NUMBER,p_term_id IN NUMBER) IS
460: SELECT 'x' abatement_exists
461: FROM dual
462: WHERE EXISTS (SELECT payment_term_id
463: FROM pn_var_abatements_all
464: WHERE var_rent_inv_id=p_inv_id
465: AND payment_term_id=p_term_id);
466:
467: -- Get all abatement terms for an invoice with update_flag='Y'

Line 470: FROM pn_var_abatements_all pva

466:
467: -- Get all abatement terms for an invoice with update_flag='Y'
468: CURSOR get_upd_terms(p_var_rentId IN NUMBER,p_var_rent_inv_id IN NUMBER) IS
469: SELECT payment_term_id,include_term,include_increases
470: FROM pn_var_abatements_all pva
471: WHERE pva.var_rent_id= p_var_rentId
472: AND pva.var_rent_inv_id = p_var_rent_inv_id
473: AND update_flag = 'Y';
474:

Line 611: FROM pn_var_abatements_all

607: -- Get the details of
608: CURSOR incl_term_cur(p_payment_term_id IN NUMBER,p_var_rent_inv_id IN NUMBER,
609: p_var_rent_id IN NUMBER) IS
610: SELECT include_term
611: FROM pn_var_abatements_all
612: WHERE var_rent_id=p_var_rent_id
613: AND payment_term_id=p_payment_term_id
614: AND var_rent_inv_id=p_var_rent_inv_id;
615:

Line 654: FROM pn_var_abatements_all

650: -- Get the details of
651: CURSOR incl_increases_cur(p_payment_term_id IN NUMBER,p_var_rent_inv_id IN NUMBER,
652: p_var_rent_id IN NUMBER) IS
653: SELECT include_increases
654: FROM pn_var_abatements_all
655: WHERE var_rent_id=p_var_rent_id
656: AND payment_term_id=p_payment_term_id
657: AND var_rent_inv_id=p_var_rent_inv_id;
658: l_incl_incr VARCHAR2(1):='N';

Line 755: FROM pn_var_abatements_all

751: CURSOR check_abtmt_terms_inv(p_inv_id IN NUMBER,p_term_id IN NUMBER) IS
752: SELECT 'x' abatement_exists
753: FROM dual
754: WHERE exists (select payment_term_id
755: FROM pn_var_abatements_all
756: WHERE var_rent_inv_id=p_inv_id
757: AND payment_term_id=p_term_id);
758:
759: -- Get all abatement terms for an invoice with update_flag='Y'

Line 762: FROM pn_var_abatements_all pva

758:
759: -- Get all abatement terms for an invoice with update_flag='Y'
760: CURSOR get_upd_terms(p_var_rentId IN NUMBER,p_var_rent_inv_id IN NUMBER) IS
761: SELECT payment_term_id,include_term,include_increases
762: FROM pn_var_abatements_all pva
763: WHERE pva.var_rent_id= p_var_rentId
764: AND pva.var_rent_inv_id = p_var_rent_inv_id
765: AND update_flag = 'Y';
766: