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_SCHEDULES_ITEMS dependencies on PN_SCHEDULES_ITEMS

Line 1: PACKAGE BODY pn_schedules_items AS

1: PACKAGE BODY pn_schedules_items AS
2: -- $Header: PNSCHITB.pls 120.98.12020000.3 2013/03/03 06:24:14 smahapat ship $
3:
4: -------------------------------------------------------------------------------
5: -- This is the MAIN procedure in this Package.

Line 972: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);

968: pnp_debug_pkg.log('p_sch_day : '||p_sch_day); /* 9231686 */
969:
970: IF norm_st_dt_rec_tbl(p_sch_day) is not null /* 9231686 */
971: THEN
972: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);
973: pn_schedules_items.g_norm_dt_avl := 'Y';
974: ELSE
975: pn_schedules_items.g_norm_dt_avl := NULL;
976:

Line 973: pn_schedules_items.g_norm_dt_avl := 'Y';

969:
970: IF norm_st_dt_rec_tbl(p_sch_day) is not null /* 9231686 */
971: THEN
972: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);
973: pn_schedules_items.g_norm_dt_avl := 'Y';
974: ELSE
975: pn_schedules_items.g_norm_dt_avl := NULL;
976:
977: END IF;

Line 975: pn_schedules_items.g_norm_dt_avl := NULL;

971: THEN
972: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);
973: pn_schedules_items.g_norm_dt_avl := 'Y';
974: ELSE
975: pn_schedules_items.g_norm_dt_avl := NULL;
976:
977: END IF;
978:
979:

Line 980: pnp_debug_pkg.log('gvbl : '||pn_schedules_items.g_norm_dt_avl);

976:
977: END IF;
978:
979:
980: pnp_debug_pkg.log('gvbl : '||pn_schedules_items.g_norm_dt_avl);
981:
982: If pn_schedules_items.g_norm_dt_avl is NULL THEN
983:
984: /* If Retro is enabled - we need correct p_norm_start_date to be passed to

Line 982: If pn_schedules_items.g_norm_dt_avl is NULL THEN

978:
979:
980: pnp_debug_pkg.log('gvbl : '||pn_schedules_items.g_norm_dt_avl);
981:
982: If pn_schedules_items.g_norm_dt_avl is NULL THEN
983:
984: /* If Retro is enabled - we need correct p_norm_start_date to be passed to
985: PN_NORM_RENORM_PKG.NORMALIZE_RENORMALIZE procedure. AMT-RETRO */
986: IF NOT PNP_UTIL_FUNC.RETRO_ENABLED THEN

Line 1003: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl: '||pn_schedules_items.g_norm_dt_avl);

999:
1000: norm_st_dt_rec_tbl(p_sch_day) := p_norm_str_dt;
1001:
1002: else
1003: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl: '||pn_schedules_items.g_norm_dt_avl);
1004: p_norm_str_dt := norm_st_dt_rec_tbl(p_sch_day);
1005: pnp_debug_pkg.log('l_first_draft_sch: '||p_norm_str_dt);
1006:
1007: END IF; /* 9231686 */

Line 4302: and schedule_date >= pn_schedules_items.FIRST_DAY(l_norm_str_dt)

4298: WHERE ppi.payment_term_id = p_payment_term_id
4299: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
4300: AND pps.payment_schedule_id = ppi.payment_schedule_id
4301: AND pps.payment_status_lookup_code <> 'DRAFT'
4302: and schedule_date >= pn_schedules_items.FIRST_DAY(l_norm_str_dt)
4303: and schedule_date <= (SELECT lease_termination_date
4304: FROM pn_lease_details_all
4305: WHERE lease_id = p_lease_id);
4306:

Line 4813: l_schd_date1 := pn_schedules_items.get_schedule_date

4809: FOR base_terms_to_extend_rec IN get_main_lease_terms_to_expand(l_old_lease_end_date) LOOP
4810:
4811: l_payment_term_rec := base_terms_to_extend_rec;
4812:
4813: l_schd_date1 := pn_schedules_items.get_schedule_date
4814: ( p_lease_id => p_lease_id,
4815: p_day => l_payment_term_rec.schedule_day,
4816: p_start_date => l_lease_ext_end_date + 1,
4817: p_end_date => l_lease_term_date,

Line 4818: p_freq => pn_schedules_items.get_frequency(l_payment_term_rec.frequency_code)

4814: ( p_lease_id => p_lease_id,
4815: p_day => l_payment_term_rec.schedule_day,
4816: p_start_date => l_lease_ext_end_date + 1,
4817: p_end_date => l_lease_term_date,
4818: p_freq => pn_schedules_items.get_frequency(l_payment_term_rec.frequency_code)
4819: );
4820: l_schd_day := TO_NUMBER(TO_CHAR(l_schd_date1,'DD'));
4821:
4822: IF NVL(l_payment_term_rec.index_norm_flag,'N') = 'Y' AND l_payment_term_rec.parent_term_id IS NOT NULL

Line 4844: pn_schedules_items.Insert_Payment_Term

4840: l_payment_term_rec.index_norm_flag := NULL;
4841: l_payment_term_rec.lease_change_id := l_lease_change_id;
4842: l_payment_term_rec.status := 'DRAFT';
4843:
4844: pn_schedules_items.Insert_Payment_Term
4845: ( p_payment_term_rec => l_payment_term_rec,
4846: x_return_status => x_return_status,
4847: x_return_message => x_return_message );
4848:

Line 4857: pn_schedules_items.Insert_Payment_Term

4853: l_payment_term_rec.end_date := l_lease_term_date;
4854: l_payment_term_rec.lease_change_id := l_lease_change_id;
4855: l_payment_term_rec.status := 'DRAFT';
4856:
4857: pn_schedules_items.Insert_Payment_Term
4858: ( p_payment_term_rec => l_payment_term_rec,
4859: x_return_status => x_return_status,
4860: x_return_message => x_return_message );
4861:

Line 5081: pn_schedules_items.g_norm_dt_avl := NULL; /* 9231686 */

5077: WHERE payment_term_id = l_payment_term_rec.payment_term_id and normalize='Y';
5078:
5079: end if;
5080:
5081: pn_schedules_items.g_norm_dt_avl := NULL; /* 9231686 */
5082: pnp_debug_pkg.log('EXPANSION -End- (-)');
5083:
5084: END expansion;
5085:

Line 6431: pn_schedules_items.Insert_Payment_Term (

6427: l_payment_term_rec.status := 'DRAFT';
6428:
6429: pnp_debug_pkg.log('CREATE_PAYMENT_TERM - payment term_id '||l_payment_term_rec.payment_Term_id);
6430:
6431: pn_schedules_items.Insert_Payment_Term (
6432: p_payment_term_rec => l_payment_term_rec,
6433: x_return_status => x_return_status,
6434: x_return_message => x_return_message);
6435:

Line 7536: and schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date)

7532: WHERE ppi.payment_term_id = p_payment_term_id
7533: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
7534: AND pps.payment_schedule_id = ppi.payment_schedule_id
7535: AND pps.payment_status_lookup_code <> 'DRAFT'
7536: and schedule_date >= pn_schedules_items.FIRST_DAY(l_amd_comn_date)
7537: and schedule_date <= (SELECT lease_termination_date from
7538: pn_lease_details_all where lease_id = p_lease_id ); /* 7149537 */
7539:
7540: BEGIN

Line 7582: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);

7578:
7579:
7580: IF norm_st_dt_rec_tbl(l_sch_dy) is not null
7581: THEN
7582: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);
7583: pn_schedules_items.g_norm_dt_avl := 'Y';
7584: ELSE
7585: pn_schedules_items.g_norm_dt_avl := NULL;
7586:

Line 7583: pn_schedules_items.g_norm_dt_avl := 'Y';

7579:
7580: IF norm_st_dt_rec_tbl(l_sch_dy) is not null
7581: THEN
7582: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);
7583: pn_schedules_items.g_norm_dt_avl := 'Y';
7584: ELSE
7585: pn_schedules_items.g_norm_dt_avl := NULL;
7586:
7587: END IF;

Line 7585: pn_schedules_items.g_norm_dt_avl := NULL;

7581: THEN
7582: pnp_debug_pkg.log('pn_schedules_items.g_norm_dt_avl : '||pn_schedules_items.g_norm_dt_avl);
7583: pn_schedules_items.g_norm_dt_avl := 'Y';
7584: ELSE
7585: pn_schedules_items.g_norm_dt_avl := NULL;
7586:
7587: END IF;
7588:
7589:

Line 7594: ELSIF pn_schedules_items.g_norm_dt_avl IS NULL THEN /* 9231686 */

7590: --asahoo modified to set ammendment commencement date as Normalization Start Date
7591: IF (p_lease_context in ('CON','EXP','CONTERM')) THEN -- Bug 14284343
7592: l_nrm_st_dt := l_amd_comn_date;
7593:
7594: ELSIF pn_schedules_items.g_norm_dt_avl IS NULL THEN /* 9231686 */
7595: SELECT NVL(First_Day(MIN(pps.schedule_date)),l_amd_comn_date)
7596: into l_nrm_st_dt
7597: FROM pn_payment_schedules_all pps
7598: WHERE pps.lease_id = p_lease_id

Line 7794: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(NVL(l_amd_comn_date,l_norm_str_dt)) /* 7149537 */

7790: SELECT count(*) into l_count
7791: FROM pn_payment_schedules_all pps,
7792: pn_payment_items_all ppi
7793: WHERE pps.lease_id = p_lease_id
7794: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(NVL(l_amd_comn_date,l_norm_str_dt)) /* 7149537 */
7795: AND LAST_DAY(g_new_lea_term_dt)
7796: AND pps.payment_status_lookup_code in ( 'DRAFT', 'ON_HOLD' )
7797: AND TO_CHAR(pps.schedule_date,'DD') = pay_term_con_cur.schedule_day
7798: AND ppi.PAYMENT_SCHEDULE_ID(+) = pps.PAYMENT_SCHEDULE_ID

Line 8145: pn_schedules_items.g_norm_dt_avl := NULL; /* 9231686 */

8141: ,p_new_lea_term_dt => p_new_lea_term_dt
8142: );
8143: END IF;
8144:
8145: pn_schedules_items.g_norm_dt_avl := NULL; /* 9231686 */
8146: pnp_debug_pkg.log('MINI RETRO CONTRACTION of MAIN Lease -End- (-)');
8147:
8148: EXCEPTION
8149: WHEN OTHERS THEN RAISE ;

Line 8282: pnp_debug_pkg.log('pn_schedules_items.schedule_items +Start+ (+)');

8278: FOR i in 1..28 LOOP
8279: norm_st_dt_rec_tbl(i) := NULL;
8280: END LOOP;
8281:
8282: pnp_debug_pkg.log('pn_schedules_items.schedule_items +Start+ (+)');
8283: pnp_debug_pkg.log('Lease_ID : '||TO_CHAR(g_lease_id));
8284: pnp_debug_pkg.log('Lease Context: '||p_lease_context
8285: ||', Called From: '||p_called_from);
8286:

Line 8615: pnp_debug_pkg.log('pn_schedules_items.schedule_items -End- (-)');

8611: END IF;
8612:
8613: pnp_debug_pkg.log('');
8614: pnp_debug_pkg.log('');
8615: pnp_debug_pkg.log('pn_schedules_items.schedule_items -End- (-)');
8616:
8617: EXCEPTION
8618: WHEN RETRO_NOT_ENABLED_EXCEPTION THEN
8619: fnd_message.set_name ('PN', 'PN_RETRO_NOT_ENABLED');

Line 8636: END pn_schedules_items;

8632:
8633:
8634:
8635:
8636: END pn_schedules_items;