eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_NORM_RENORM_PKG dependencies on PN_SCHEDULES_ITEMS

Line 143: SELECT pn_schedules_items.FIRST_DAY(change_commencement_date)

139:
140: BEGIN
141:
142: --Fix for bug#14143342
143: SELECT pn_schedules_items.FIRST_DAY(change_commencement_date)
144: INTO l_amd_comn_date
145: FROM
146: (SELECT *
147: FROM pn_lease_changes_all

Line 178: AND schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp); /* 8491119 */

174: WHERE ppi.payment_term_id = p_term_id
175: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
176: AND pps.payment_schedule_id = ppi.payment_schedule_id
177: AND pps.payment_status_lookup_code <> 'DRAFT'
178: AND schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp); /* 8491119 */
179: --AND schedule_date <= (SELECT last_day(lease_termination_date) from /* 11742270 */
180: --pn_lease_details_all where lease_id = p_lease_id );
181:
182: pnp_debug_pkg.log('l_app_amt : ' || l_app_amt);

Line 194: AND schedule_date < pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp);

190: WHERE ppi.payment_term_id = p_term_id
191: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
192: AND pps.payment_schedule_id = ppi.payment_schedule_id
193: AND pps.payment_status_lookup_code = 'DRAFT'
194: AND schedule_date < pn_schedules_items.FIRST_DAY(l_amd_comn_date_tmp);
195:
196: pnp_debug_pkg.log('l_dft_amt : ' || l_dft_amt);
197:
198: Select NVL(SUM(ppi.actual_amount),0)

Line 497: pn_schedules_items.create_cash_items

493:
494: IF l_cash_item = 0 THEN
495: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
496: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
497: pn_schedules_items.create_cash_items
498: (p_est_amt => 0,
499: p_act_amt => 0,
500: p_sch_dt => g_norm_item_tbl(i).schedule_date,
501: p_sch_id => g_norm_item_tbl(i).schedule_id,

Line 694: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt)));

690: l_partial_start_fraction := 0;
691: l_partial_end_fraction := 0;
692: l_adjustment_amount := 0;
693: l_norm_months := CEIL(MONTHS_BETWEEN(LAST_DAY(p_norm_end_dt),
694: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt)));
695: fnd_currency.get_info(p_curr_code, l_precision, l_ext_precision, l_min_acct_unit);
696:
697: FOR get_cash_rec IN get_cash_total LOOP
698: l_cash_total := get_cash_rec.total_cash_amount;

Line 954: pn_schedules_items.create_cash_items

950:
951: IF l_cash_item = 0 THEN
952: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> create $ 0 cash items(+)');
953: pnp_debug_pkg.log(' PN_NORM_RENORM_PKG.RENORMALIZE_ACROSS_ALL_DRAFT -> for schedule id : '||g_norm_item_tbl(i).schedule_id);
954: pn_schedules_items.create_cash_items
955: (p_est_amt => 0,
956: p_act_amt => 0,
957: p_sch_dt => g_norm_item_tbl(i).schedule_date,
958: p_sch_id => g_norm_item_tbl(i).schedule_id,

Line 1006: 07-feb-10 asahoo 0 Bug#13486716: Modified the cursor GET_TERM_SCHEDULES, added PN_SCHEDULES_ITEMS.FIRST_DAY for l_amd_comn_date

1002: items doesn't exists for this schedule initially.
1003: 24-AUG-08 rkartha o Bug#6829173 : Added code for handling the case where the term
1004: completely falls outside the new lease duration
1005: when early terminating.
1006: 07-feb-10 asahoo 0 Bug#13486716: Modified the cursor GET_TERM_SCHEDULES, added PN_SCHEDULES_ITEMS.FIRST_DAY for l_amd_comn_date
1007: If p_norm_str_dt and g_new_lea_term_dt have same month and year, we will pass
1008: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt) to RENORMALIZE_ACROSS_ALL_DRAFT
1009: ------------------------------------------------------------------------------*/
1010: PROCEDURE NORMALIZE_RENORMALIZE

Line 1008: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt) to RENORMALIZE_ACROSS_ALL_DRAFT

1004: completely falls outside the new lease duration
1005: when early terminating.
1006: 07-feb-10 asahoo 0 Bug#13486716: Modified the cursor GET_TERM_SCHEDULES, added PN_SCHEDULES_ITEMS.FIRST_DAY for l_amd_comn_date
1007: If p_norm_str_dt and g_new_lea_term_dt have same month and year, we will pass
1008: PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt) to RENORMALIZE_ACROSS_ALL_DRAFT
1009: ------------------------------------------------------------------------------*/
1010: PROCEDURE NORMALIZE_RENORMALIZE
1011: (p_lease_context IN VARCHAR2,
1012: p_lease_id IN NUMBER,

Line 1038: NVL(PN_SCHEDULES_ITEMS.FIRST_DAY(l_amd_comn_date),PN_SCHEDULES_ITEMS.FIRST_DAY(c_norm_str_dt)) /6838211 /

1034: FROM pn_payment_schedules_all pps,
1035: pn_payment_items_all ppi
1036: WHERE pps.lease_id = p_lease_id
1037: AND pps.schedule_date BETWEEN
1038: NVL(PN_SCHEDULES_ITEMS.FIRST_DAY(l_amd_comn_date),PN_SCHEDULES_ITEMS.FIRST_DAY(c_norm_str_dt)) /*6838211 */
1039: AND LAST_DAY(g_new_lea_term_dt) --AND LAST_DAY(p_norm_end_dt) /*Bug4956314*/
1040: AND pps.payment_status_lookup_code = 'DRAFT' /* bug 6737971 removed
1041: ON_HOLD */
1042: AND TO_CHAR(pps.schedule_date,'DD') = p_sch_day

Line 1144: lp_norm_str_dt := PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt);

1140: --Fix for bug#13486716
1141: IF (p_norm_str_dt IS NOT NULL AND g_new_lea_term_dt IS NOT NULL
1142: AND TO_CHAR(p_norm_str_dt,'MMYY') = TO_CHAR(g_new_lea_term_dt,'MMYY'))
1143: THEN
1144: lp_norm_str_dt := PN_SCHEDULES_ITEMS.FIRST_DAY(p_norm_str_dt);
1145: ELSE
1146: lp_norm_str_dt := p_norm_str_dt;
1147: END IF;
1148: