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.40.12010000.11 2009/02/20 14:06:39 acprakas ship $
3:
4: -------------------------------------------------------------------------------
5: -- This is the MAIN procedure in this Package.

Line 4008: l_schd_date1 := pn_schedules_items.get_schedule_date

4004: FOR base_terms_to_extend_rec IN get_main_lease_terms_to_expand(l_old_lease_end_date) LOOP
4005:
4006: l_payment_term_rec := base_terms_to_extend_rec;
4007:
4008: l_schd_date1 := pn_schedules_items.get_schedule_date
4009: ( p_lease_id => p_lease_id,
4010: p_day => l_payment_term_rec.schedule_day,
4011: p_start_date => l_lease_ext_end_date + 1,
4012: p_end_date => l_lease_term_date,

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

4009: ( p_lease_id => p_lease_id,
4010: p_day => l_payment_term_rec.schedule_day,
4011: p_start_date => l_lease_ext_end_date + 1,
4012: p_end_date => l_lease_term_date,
4013: p_freq => pn_schedules_items.get_frequency(l_payment_term_rec.frequency_code)
4014: );
4015: l_schd_day := TO_NUMBER(TO_CHAR(l_schd_date1,'DD'));
4016:
4017: IF NVL(l_payment_term_rec.index_norm_flag,'N') = 'Y' AND l_payment_term_rec.parent_term_id IS NOT NULL

Line 4039: pn_schedules_items.Insert_Payment_Term

4035: l_payment_term_rec.index_norm_flag := NULL;
4036: l_payment_term_rec.lease_change_id := l_lease_change_id;
4037: l_payment_term_rec.status := 'DRAFT';
4038:
4039: pn_schedules_items.Insert_Payment_Term
4040: ( p_payment_term_rec => l_payment_term_rec,
4041: x_return_status => x_return_status,
4042: x_return_message => x_return_message );
4043:

Line 4052: pn_schedules_items.Insert_Payment_Term

4048: l_payment_term_rec.end_date := l_lease_term_date;
4049: l_payment_term_rec.lease_change_id := l_lease_change_id;
4050: l_payment_term_rec.status := 'DRAFT';
4051:
4052: pn_schedules_items.Insert_Payment_Term
4053: ( p_payment_term_rec => l_payment_term_rec,
4054: x_return_status => x_return_status,
4055: x_return_message => x_return_message );
4056:

Line 5452: pn_schedules_items.Insert_Payment_Term (

5448: l_payment_term_rec.status := 'DRAFT';
5449:
5450: pnp_debug_pkg.log('CREATE_PAYMENT_TERM - payment term_id '||l_payment_term_rec.payment_Term_id);
5451:
5452: pn_schedules_items.Insert_Payment_Term (
5453: p_payment_term_rec => l_payment_term_rec,
5454: x_return_status => x_return_status,
5455: x_return_message => x_return_message);
5456:

Line 6681: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(l_norm_str_dt)

6677: SELECT count(*) into l_count
6678: FROM pn_payment_schedules_all pps,
6679: pn_payment_items_all ppi
6680: WHERE pps.lease_id = p_lease_id
6681: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(l_norm_str_dt)
6682: AND LAST_DAY(g_new_lea_term_dt)
6683: AND pps.payment_status_lookup_code in ( 'DRAFT', 'ON_HOLD' )
6684: AND TO_CHAR(pps.schedule_date,'DD') = pay_term_con_cur.schedule_day
6685: AND ppi.PAYMENT_SCHEDULE_ID(+) = pps.PAYMENT_SCHEDULE_ID

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

7083: BEGIN
7084:
7085: g_lease_id := p_lease_id;
7086:
7087: pnp_debug_pkg.log('pn_schedules_items.schedule_items +Start+ (+)');
7088: pnp_debug_pkg.log('Lease_ID : '||TO_CHAR(g_lease_id));
7089: pnp_debug_pkg.log('Lease Context: '||p_lease_context
7090: ||', Called From: '||p_called_from);
7091:

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

7408: END IF;
7409:
7410: pnp_debug_pkg.log('');
7411: pnp_debug_pkg.log('');
7412: pnp_debug_pkg.log('pn_schedules_items.schedule_items -End- (-)');
7413:
7414: EXCEPTION
7415: WHEN RETRO_NOT_ENABLED_EXCEPTION THEN
7416: fnd_message.set_name ('PN', 'PN_RETRO_NOT_ENABLED');

Line 7433: END pn_schedules_items;

7429:
7430:
7431:
7432:
7433: END pn_schedules_items;