[Home] [Help]
46: ppt.currency_code,
47: ppt.rate,
48: ppt.index_period_id,
49: ppt.norm_start_date
50: FROM pn_payment_terms_all ppt
51: WHERE ppt.lease_id = p_lease_id
52: AND ppt.var_rent_inv_id IS NULL
53: AND ppt.period_billrec_id IS NULL
54: AND EXISTS (SELECT NULL
76: ppt.currency_code,
77: ppt.rate,
78: ppt.index_period_id,
79: ppt.norm_start_date
80: FROM pn_payment_terms_all ppt
81: WHERE ppt.lease_id = p_lease_id
82: AND ppt.index_period_id IS NOT NULL
83: AND ppt.status = 'APPROVED'
84: AND ppt.index_term_indicator NOT IN ('BACKBILL','ATLEAST-BACKBILL')
117: ppt.currency_code,
118: ppt.rate,
119: ppt.norm_start_date,
120: ppt.norm_end_date
121: FROM pn_payment_terms_all ppt
122: WHERE ppt.lease_id = p_lease_id
123: AND ppt.payment_term_id = p_payment_term_id
124: AND EXISTS (SELECT NULL
125: FROM pn_payment_items_all ppi
163: ppt.currency_code,
164: ppt.rate,
165: ppt.index_period_id,
166: ppt.norm_start_date
167: FROM pn_payment_terms_all ppt
168: WHERE ppt.lease_id = p_lease_id
169: AND NVL(ppt.normalize,'N') = 'Y'
170: AND NVL(ppt.status,'APPROVED') = 'APPROVED'
171: AND EXISTS (SELECT NULL
205: ppt.currency_code,
206: ppt.rate,
207: ppt.index_period_id,
208: ppt.norm_start_date
209: FROM pn_payment_terms_all ppt
210: WHERE ppt.lease_id = p_lease_id
211: AND ppt.var_rent_inv_id IS NULL
212: AND ppt.period_billrec_id IS NULL
213: AND (NVL(ppt.normalize,'N') = 'Y' AND NVL(ppt.norm_end_date, ppt.end_date) > p_cutoff_date) /* 6699877 */
236: ppt.currency_code,
237: ppt.rate,
238: ppt.index_period_id,
239: ppt.norm_start_date
240: FROM pn_payment_terms_all ppt
241: WHERE ppt.lease_id = p_lease_id
242: AND ppt.index_period_id IS NOT NULL
243: AND ppt.status = 'APPROVED'
244: AND ppt.index_term_indicator NOT IN ('BACKBILL','ATLEAST-BACKBILL')
286: ppt.rate,
287: ppt.norm_start_date,
288: plc.change_type_lookup_code,
289: plc.change_commencement_date
290: FROM pn_payment_terms_all ppt,
291: pn_lease_changes_all plc
292: WHERE ppt.lease_id = p_lease_id
293: AND ppt.lease_change_id = plc.lease_change_id
294: AND ppt.index_period_id IS NULL
331: ppt.set_of_books_id,
332: ppt.currency_code,
333: ppt.rate,
334: ppt.norm_start_date
335: FROM pn_payment_terms_all ppt
336: WHERE ppt.payment_term_id = p_term_id
337: AND NOT EXISTS (SELECT NULL
338: FROM pn_payment_items_all ppi
339: WHERE ppt.lease_id = p_lease_id
370: ppt.set_of_books_id,
371: ppt.currency_code,
372: ppt.rate,
373: ppt.norm_start_date
374: FROM pn_payment_terms_all ppt
375: WHERE lease_id = p_lease_id
376: AND ppt.index_period_id IS NULL
377: AND ppt.var_rent_inv_id IS NULL
378: AND ppt.period_billrec_id IS NULL
413: ppt.currency_code,
414: ppt.rate,
415: ppt.norm_start_date,
416: ppt.norm_end_date
417: FROM pn_payment_terms_all ppt
418: WHERE ppt.lease_id = p_lease_id
419: AND ppt.changed_flag = 'Y'
420: AND EXISTS (SELECT NULL
421: FROM pn_payment_items_all ppi
1531: l_actual_amount pn_payment_items.actual_amount%TYPE;
1532:
1533: CURSOR org_cur IS
1534: SELECT org_id
1535: FROM pn_payment_terms_all
1536: WHERE payment_term_id = p_term_id;
1537:
1538: CURSOR get_calc_date_recur_bb ( p_term_id IN NUMBER) IS
1539: SELECT recur_bb_calc_date
1536: WHERE payment_term_id = p_term_id;
1537:
1538: CURSOR get_calc_date_recur_bb ( p_term_id IN NUMBER) IS
1539: SELECT recur_bb_calc_date
1540: FROM pn_payment_terms_all
1541: WHERE payment_term_id = p_term_id
1542: AND recur_bb_calc_date IS NOT NULL;
1543:
1544: CURSOR get_inv_grp_rule IS
1542: AND recur_bb_calc_date IS NOT NULL;
1543:
1544: CURSOR get_inv_grp_rule IS
1545: SELECT grouping_rule_id
1546: FROM pn_payment_terms_all
1547: WHERE payment_term_id = p_term_id;
1548:
1549: l_org_id NUMBER;
1550: l_sch_dt DATE := p_sch_dt;
1740: l_org_id NUMBER;
1741:
1742: CURSOR get_org_id(l_term_id NUMBER) IS
1743: SELECT org_id
1744: FROM pn_payment_terms_all
1745: WHERE payment_term_id = l_term_id;
1746:
1747: l_due_date DATE;
1748:
1747: l_due_date DATE;
1748:
1749: CURSOR get_calc_date_recur_bb ( p_term_id IN NUMBER) IS
1750: SELECT recur_bb_calc_date
1751: FROM pn_payment_terms_all
1752: WHERE payment_term_id = p_term_id
1753: AND recur_bb_calc_date IS NOT NULL ;
1754:
1755: CURSOR get_inv_grp_rule IS
1753: AND recur_bb_calc_date IS NOT NULL ;
1754:
1755: CURSOR get_inv_grp_rule IS
1756: SELECT grouping_rule_id
1757: FROM pn_payment_terms_all
1758: WHERE payment_term_id = p_term_id;
1759:
1760: l_inv_grp_rule NUMBER := NULL;
1761:
2162:
2163: END IF;
2164:
2165: -- Added for BUG#2590872
2166: UPDATE pn_payment_terms_all
2167: SET event_type_code = p_lease_context
2168: WHERE normalize ='Y'
2169: AND payment_term_id = p_term_id;
2170:
2705: l_ext_precision NUMBER;
2706: l_min_acct_unit NUMBER;
2707:
2708: CURSOR currency_cur IS
2709: SELECT currency_code FROM pn_payment_terms_all WHERE payment_term_id = p_term_id;
2710:
2711: BEGIN
2712:
2713: pnp_debug_pkg.log('update_cash_item +Start+ (+)');
2796: end_date,
2797: actual_amount,
2798: estimated_amount,
2799: frequency_code
2800: FROM pn_payment_terms_all
2801: WHERE lease_id = g_lease_id
2802: AND end_date = p_new_lease_term_date
2803: AND frequency_code <> 'OT';
2804:
2886: -- 07-FEB-2002 Satish Tripathi o Added variable l_norm_str_dt to capture Normalize Start
2887: -- Date, if the term is added through AMEND.
2888: -- 26-MAR-2002 Satish Tripathi o Added variable l_sch_str_dt to correctly point the
2889: -- Schedule-Start-Date for NON MONTHLY Payment Term.
2890: -- 10-DEC-2002 graghuna o Modified to update pn_payment_terms_all.norm_end_date
2891: -- for Month-to-Month Re-Normalization issue. --MTM-I
2892: -- 16-OCT-2003 Satish Tripathi o Fix for BUG# 3201091. Conditionally pass lease_context
2893: -- depending on change_type_lookup_code of a particular term.
2894: -- Pass new parameter p_amd_comm_dt to get_sch_info and
2995:
2996: END IF;
2997:
2998: IF add_main_cur.normalize = 'Y' THEN
2999: UPDATE pn_payment_terms_all
3000: SET norm_start_date = NVL(l_norm_str_dt, p_new_lea_comm_dt),
3001: norm_end_date = g_new_lea_term_dt
3002: WHERE payment_term_id = add_main_cur.payment_term_id;
3003: END IF;
3277: -- 07-FEB-2002 Satish Tripathi o Added variable l_norm_str_dt to capture Normalize Start
3278: -- Date, if term was added through AMEND and pass it to
3279: -- routine CREATE_NORMALIZE_ITEMS.
3280: -- 10-DEC-2002 graghuna o Modified to get and pass p_active_lease_change_id to
3281: -- cursor and update pn_payment_terms_all.norm_end_date
3282: -- for Month-to-Month Re-Normalization issue. --MTM-I
3283: -- 16-OCT-2003 Satish Tripathi o Fix for BUG# 3201091. Pass new parameter p_lease_change_id
3284: -- to create_normalize_items.
3285: -- 03-DEC-2003 Satish Tripathi o Call Contract_Tenancies to early terminate tenancies only
3332: WHERE lease_id = p_lease_id
3333: AND schedule_date > p_new_lea_term_dt
3334: AND payment_status_lookup_code = 'DRAFT')
3335: AND payment_term_id NOT IN (SELECT payment_term_id
3336: FROM pn_payment_terms_all
3337: WHERE lease_id = p_lease_id
3338: AND var_rent_inv_id IS NOT NULL);
3339:
3340: /* Delete payment schedules for the lease which are in draft status
3351: WHERE pitm.payment_schedule_id = psch.payment_schedule_id);
3352:
3353: DELETE pn_payment_items_all
3354: WHERE payment_term_id IN (SELECT payment_term_id
3355: FROM pn_payment_terms_all
3356: WHERE start_date > p_new_lea_term_dt
3357: AND lease_id = p_lease_id)
3358: AND payment_term_id NOT IN (SELECT payment_term_id
3359: FROM pn_payment_terms_all
3355: FROM pn_payment_terms_all
3356: WHERE start_date > p_new_lea_term_dt
3357: AND lease_id = p_lease_id)
3358: AND payment_term_id NOT IN (SELECT payment_term_id
3359: FROM pn_payment_terms_all
3360: WHERE lease_id = p_lease_id
3361: AND var_rent_inv_id IS NOT NULL);
3362:
3363: /* Delete payment terms for the lease which have term start date
3364: greater than lease termination date. */
3365:
3366: pnp_debug_pkg.log('CON - MAIN - Deleting Payment Terms');
3367:
3368: DELETE pn_payment_terms_all
3369: WHERE lease_id = p_lease_id
3370: AND start_date > p_new_lea_term_dt
3371: AND var_rent_inv_id IS NULL;
3372:
3374: lease termination date. */
3375:
3376: pnp_debug_pkg.log('CON - MAIN - Updating end date of Payment Terms');
3377:
3378: UPDATE pn_payment_terms_all
3379: SET end_date = p_new_lea_term_dt,
3380: last_update_date = SYSDATE,
3381: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3382: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3455:
3456: pnp_debug_pkg.log('CON - MAIN - Renormalization done for Term : '
3457: ||TO_CHAR(con_cur.payment_term_id));
3458:
3459: UPDATE pn_payment_terms_all
3460: SET norm_end_date = g_new_lea_term_dt
3461: WHERE payment_term_id = con_cur.payment_term_id;
3462:
3463: END LOOP;
3631: greater than lease termination date. */
3632:
3633: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Deleting Payment Terms');
3634:
3635: DELETE pn_payment_terms_all term
3636: WHERE lease_id = p_lease_id
3637: AND start_date > p_new_lea_term_dt
3638: AND index_period_id IS NULL
3639: AND NOT EXISTS(SELECT 1
3648:
3649: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Updating end date of Payment Terms');
3650:
3651: FOR i IN 1 .. l_item_end_dt_tbl.COUNT LOOP
3652: UPDATE pn_payment_terms_all
3653: SET end_date = l_item_end_dt_tbl(i).item_end_dt,
3654: last_update_date = SYSDATE,
3655: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
3656: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
3702:
3703: pnp_debug_pkg.log('CONTRACTION_BY_ITM_END_DT - MAIN - Renormalization done for Term : '
3704: ||TO_CHAR(con_cur.payment_term_id));
3705:
3706: UPDATE pn_payment_terms_all
3707: SET norm_end_date = p_new_lea_term_dt
3708: WHERE payment_term_id = con_cur.payment_term_id;
3709:
3710: END LOOP;
3748: -- Date, if term was added through AMEND.
3749: -- 26-MAR-2002 Satish Tripathi o Added variable l_sch_str_dt to correctly point the
3750: -- Schedule-Start-Date for NON MONTHLY Payment Term.
3751: -- 10-DEC-2002 graghuna o Modified to get and pass p_active_lease_change_id to
3752: -- cursor and update pn_payment_terms_all.norm_end_date
3753: -- for Month-to-Month Re-Normalization issue. --MTM-I
3754: -- 16-OCT-2003 Satish Tripathi o Fix for BUG# 3201091. Pass new parameter p_lease_change_id
3755: -- to process_term.
3756: -- 24-MAR-2004 Satish Tripathi o Fixed for BUG# 3295405. If norm_start_date is null
3783: l_active_lease_change_id pn_lease_details.lease_change_id%TYPE;
3784: l_cutoff_date DATE;
3785: l_ext_dt DATE;
3786: l_old_lease_end_date DATE;
3787: l_payment_term_rec pn_payment_terms_all%ROWTYPE;
3788: x_return_status VARCHAR2(100);
3789: x_return_message VARCHAR2(100);
3790: l_lease_change_id NUMBER;
3791: l_lease_status_old VARCHAR2(30);
3824: AND pld.lease_id = p_lease_id;
3825:
3826: CURSOR get_main_lease_terms_to_expand( p_old_lease_end_date DATE) IS
3827: SELECT *
3828: FROM pn_payment_terms_all
3829: WHERE lease_id = p_lease_id
3830: AND end_date = p_old_lease_end_date
3831: AND index_period_id IS NULL
3832: AND var_rent_inv_id IS NULL
3973: p_index_prd_id => con_cur.index_period_id,
3974: p_norm_str_dt => l_norm_str_dt,
3975: p_lease_change_id => con_cur.lease_change_id);
3976:
3977: UPDATE pn_payment_terms_all
3978: SET norm_end_date = g_new_lea_term_dt
3979: WHERE payment_term_id = con_cur.payment_term_id;
3980:
3981: pnp_debug_pkg.log('EXPANSION - processed term '||TO_CHAR(con_cur.payment_term_id));
4055: x_return_message => x_return_message );
4056:
4057: ELSE
4058:
4059: UPDATE pn_payment_terms_all
4060: SET end_date = l_lease_term_date,
4061: lease_change_id = l_lease_change_id,
4062: last_update_date = SYSDATE,
4063: last_updated_by = fnd_global.user_id,
4091: p_new_end_date => g_new_lea_term_dt,
4092: x_return_status => x_return_status,
4093: x_return_message => x_return_message);
4094:
4095: UPDATE pn_payment_terms_all
4096: SET end_date = g_new_lea_term_dt
4097: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
4098: -- Added For Bug#7184211
4099: IF NVL(l_payment_term_rec.normalize,'N') = 'Y' THEN
4202: -- 07-FEB-2002 Satish Tripathi o Added variable l_norm_str_dt to capture Normalize Start
4203: -- Date, if term was added through AMEND.
4204: -- 26-MAR-2002 Satish Tripathi o Added variable l_sch_str_dt to correctly point the
4205: -- Schedule-Start-Date for NON MONTHLY Payment Term.
4206: -- 10-DEC-2002 graghuna o Modified to update pn_payment_terms_all.norm_end_date
4207: -- for Month-to-Month Re-Normalization issue. --MTM-I
4208: -- 16-OCT-2003 Satish Tripathi o Fix for BUG# 3201091. Pass new parameter p_lease_change_id
4209: -- to process_term.
4210: -- 20-NOV-2006 Hareesha o MTM Uptake - Added handling for creating schedules and items
4250: ppt.set_of_books_id,
4251: ppt.currency_code,
4252: ppt.rate,
4253: ppt.norm_start_date
4254: FROM pn_payment_terms_all ppt
4255: WHERE lease_id = p_lease_id
4256: AND ppt.index_period_id IS NULL
4257: AND ppt.var_rent_inv_id IS NULL
4258: AND ppt.period_billrec_id IS NULL
4389: p_norm_str_dt => l_norm_str_dt,
4390: p_lease_change_id => abs_cur.lease_change_id);
4391:
4392: IF abs_cur.normalize = 'Y' THEN
4393: UPDATE pn_payment_terms_all
4394: SET norm_start_date = NVL(l_norm_str_dt, p_new_lea_comm_dt),
4395: norm_end_date = g_new_lea_term_dt
4396: WHERE payment_term_id = abs_cur.payment_term_id;
4397: END IF;
4505: p_norm_str_dt => l_norm_str_dt,
4506: p_lease_change_id => add_ind_var_cur.lease_change_id);
4507:
4508: IF add_ind_var_cur.normalize = 'Y' THEN
4509: UPDATE pn_payment_terms_all
4510: SET norm_start_date = l_norm_str_dt,
4511: norm_end_date = g_new_lea_term_dt
4512: WHERE payment_term_id = add_ind_var_cur.payment_term_id;
4513: END IF;
4752: END IF;
4753:
4754: END IF;
4755:
4756: UPDATE pn_payment_terms_all
4757: SET changed_flag = 'N'
4758: WHERE payment_term_id = pay_term_con_cur.payment_term_id;
4759:
4760: END LOOP;
4928: -- while insertion.
4929: -- 03-APR-07 Prabhakar o Bug #5958872. Added the two parameters area and
4930: -- area_type_code in the call to inser_row handler.
4931: -------------------------------------------------------------------------------
4932: PROCEDURE Insert_Payment_Term (p_payment_term_rec IN OUT NOCOPY pn_payment_terms_all%ROWTYPE,
4933: x_return_status OUT NOCOPY VARCHAR2,
4934: x_return_message OUT NOCOPY VARCHAR2)
4935: IS
4936:
5115: -- 27-NOV-06 Hareesha o MTM Uptake - Passed payment_term_id parameter to
5116: -- create_schedules.
5117: --------------------------------------------------------------------------------
5118:
5119: PROCEDURE Extend_Payment_Term (p_payment_term_rec IN pn_payment_terms_all%ROWTYPE,
5120: p_new_lea_comm_dt IN DATE,
5121: p_new_lea_term_dt IN DATE,
5122: p_mths IN NUMBER,
5123: p_new_start_date IN DATE ,
5136: l_sch_end_dt DATE;
5137: l_norm_st_dt DATE;
5138: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
5139: l_pymnt_st_lkp_cd pn_payment_schedules.payment_status_lookup_code%TYPE;
5140: l_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5141: l_act_amt pn_payment_terms_all.actual_amount%TYPE;
5142: l_cash_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5143: l_cash_act_amt pn_payment_terms_all.actual_amount%TYPE;
5144: l_rec_found BOOLEAN := FALSE;
5137: l_norm_st_dt DATE;
5138: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
5139: l_pymnt_st_lkp_cd pn_payment_schedules.payment_status_lookup_code%TYPE;
5140: l_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5141: l_act_amt pn_payment_terms_all.actual_amount%TYPE;
5142: l_cash_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5143: l_cash_act_amt pn_payment_terms_all.actual_amount%TYPE;
5144: l_rec_found BOOLEAN := FALSE;
5145: l_sch_day VARCHAR2(240);
5138: l_sch_id pn_payment_schedules.payment_schedule_id%TYPE;
5139: l_pymnt_st_lkp_cd pn_payment_schedules.payment_status_lookup_code%TYPE;
5140: l_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5141: l_act_amt pn_payment_terms_all.actual_amount%TYPE;
5142: l_cash_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5143: l_cash_act_amt pn_payment_terms_all.actual_amount%TYPE;
5144: l_rec_found BOOLEAN := FALSE;
5145: l_sch_day VARCHAR2(240);
5146: l_exist_amount NUMBER;
5139: l_pymnt_st_lkp_cd pn_payment_schedules.payment_status_lookup_code%TYPE;
5140: l_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5141: l_act_amt pn_payment_terms_all.actual_amount%TYPE;
5142: l_cash_est_amt pn_payment_terms_all.estimated_amount%TYPE;
5143: l_cash_act_amt pn_payment_terms_all.actual_amount%TYPE;
5144: l_rec_found BOOLEAN := FALSE;
5145: l_sch_day VARCHAR2(240);
5146: l_exist_amount NUMBER;
5147:
5400: -- to process_term.
5401: -- 16-OCT-06 Hareesha o Populate index_norm_flag and parent_term_id while
5402: -- creating not-normalized terms for rollover period.
5403: -------------------------------------------------------------------------------
5404: PROCEDURE Create_Payment_Term (p_payment_term_rec IN pn_payment_terms_all%ROWTYPE,
5405: p_lease_end_date IN DATE,
5406: p_term_start_date IN DATE,
5407: p_term_end_date IN DATE,
5408: p_new_lea_term_dt IN DATE,
5417: l_new_term_start_date DATE := NULL;
5418: l_schedule_date DATE := NULL;
5419: l_sch_id NUMBER := NULL;
5420: l_curr_payment_term_id NUMBER := NULL;
5421: l_payment_term_rec pn_payment_terms_all%ROWTYPE;
5422: l_pro_sch_dt pn_payment_schedules.schedule_date%TYPE;
5423: l_no_sch NUMBER;
5424: l_freq NUMBER;
5425: l_counter NUMBER;
5555: IS
5556:
5557: CURSOR payment_terms_cursor (p_date DATE) IS
5558: SELECT *
5559: FROM pn_payment_terms_all
5560: WHERE lease_id = p_lease_id
5561: AND frequency_code <> 'OT'
5562: AND index_period_id IS NULL
5563: AND end_date = p_date;
5585: l_schd_date DATE := NULL;
5586: l_schd_day NUMBER := NULL;
5587: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
5588: l_rollover_mode VARCHAR2(30) := NULL;
5589: l_freq_code pn_payment_terms_all.frequency_code%TYPE;
5590: l_freq NUMBER;
5591: l_no_of_sch NUMBER;
5592: l_last_sch_date DATE;
5593: l_duration_in_months NUMBER;
5653: x_return_message => x_return_message);
5654:
5655: pnp_debug_pkg.log('ROLLOVER - Update end date of payment term..');
5656:
5657: UPDATE pn_payment_terms_all
5658: SET end_date = p_lease_end_date,
5659: lease_status = 'MTM'
5660: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
5661:
5745: x_return_status => x_return_status,
5746: x_return_message => x_return_message);
5747:
5748: pnp_debug_pkg.log('ROLLOVER - Update end date of payment term..');
5749: UPDATE pn_payment_terms_all
5750: SET end_date = p_lease_end_date,
5751: lease_status = 'MTM'
5752: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
5753: END IF;
5975: SUM(DECODE(ppi.payment_item_type_lookup_code, 'NORMALIZED',
5976: NVL(ppi.actual_amount,0), 0)) norm_amt
5977: FROM pn_payment_items_all ppi,
5978: pn_payment_schedules_all pps,
5979: pn_payment_terms_all ppt
5980: WHERE ppt.lease_id = g_lease_id
5981: AND ppt.lease_id = pps.lease_id
5982: AND pps.payment_schedule_id = ppi.payment_schedule_id
5983: AND ppt.payment_term_id = ppi.payment_term_id
6104: SELECT agr.rec_agreement_name
6105: ,agr.rec_agreement_num
6106: FROM pn_rec_agreements_all agr
6107: ,pn_rec_agr_lines_all line
6108: ,pn_payment_terms_all term
6109: WHERE agr.lease_id = g_lease_id
6110: AND agr.rec_agreement_id = line.rec_agreement_id
6111: AND term.payment_term_id = p_term_id
6112: AND line.purpose = term.payment_purpose_code
6170: SELECT pvr.rent_num
6171: FROM pn_var_rents_all pvr
6172: ,pn_var_rent_inv_all pvri
6173: ,pn_var_abatements_all pva
6174: ,pn_payment_terms_all ppt
6175: WHERE ppt.payment_term_id = p_term_id
6176: AND pva.payment_term_id = ppt.payment_term_id
6177: AND pvri.var_rent_inv_id = pva.var_rent_inv_id
6178: AND pvri.invoice_date BETWEEN ppt.start_date
6239: l_act_amount NUMBER;
6240:
6241: CURSOR currency_cur IS
6242: SELECT currency_code
6243: FROM pn_payment_terms_all
6244: WHERE payment_term_id = p_payment_term_id;
6245:
6246: BEGIN
6247: pnp_debug_pkg.log('UPDATE TERMS +Start+ (+)');
6261: l_act_amount := TO_NUMBER(NULL);
6262: END IF;
6263:
6264: /* Updates the term with new term start/end date */
6265: UPDATE pn_payment_terms_all
6266: SET start_date = NVL(p_new_lea_term_start_dt, start_date),
6267: end_date = p_new_lea_term_end_dt,
6268: actual_amount = NVL(l_act_amount, actual_amount),
6269: last_update_date = SYSDATE,
6303: l_adj_amount NUMBER;
6304:
6305: CURSOR currency_cur IS
6306: SELECT currency_code
6307: FROM pn_payment_terms_all
6308: WHERE payment_term_id = p_term_id;
6309:
6310: BEGIN
6311: pnp_debug_pkg.log('update_cash_item +Start+ (-)');
6441: DELETE pn_payment_items_all
6442: WHERE payment_term_id = p_payment_term_id;
6443:
6444: pnp_debug_pkg.log('Deleting term ....'||p_payment_term_id);
6445: DELETE pn_payment_terms_all
6446: WHERE payment_term_id = p_payment_term_id;
6447:
6448:
6449: pnp_debug_pkg.log('Delete term End (-)');
6475: -- before renormalizing the terms.
6476: -- 04-APR-06 piagrawa o Bug#5107134 - modified delete statement to include
6477: -- status 'ON_HOLD'
6478: -- 02-JAN-09 acprakas o Bug#7016892. Modified code to update changed_flag
6479: -- of pn_payment_terms_all only when lease context is
6480: -- CONTERM.
6481: --------------------------------------------------------------------------------
6482:
6483: PROCEDURE contract_pay_term_mini_retro (p_lease_id NUMBER,
6723:
6724: END IF; /* IF p_normalize = 'Y' */
6725:
6726: IF p_lease_context = 'CONTERM' THEN
6727: UPDATE pn_payment_terms_all
6728: SET changed_flag = 'N'
6729: WHERE payment_term_id = pay_term_con_cur.payment_term_id;
6730: END IF;
6731:
7034:
7035: CURSOR terms_cur (p1_lease_id IN NUMBER)
7036: IS
7037: SELECT UPDATE_NBP_FLAG
7038: FROM PN_PAYMENT_TERMS_ALL
7039: WHERE lease_id = p1_lease_id
7040: FOR UPDATE NOWAIT;
7041:
7042: CURSOR bkhd_exists_cur
7357:
7358:
7359: END LOOP;
7360:
7361: UPDATE pn_payment_terms_all
7362: SET UPDATE_NBP_FLAG = NULL
7363: WHERE lease_id = p_lease_id;
7364:
7365: