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_MASS_APPR_PKG dependencies on PN_PAYMENT_SCHEDULES

Line 55: -- and pn_payment_schedules with correct values.

51: -- 30-SEP-04 kkhegde o Created
52: -- 11-OCT-05 pikhar o ensure l_accounted_date does not have a timestamp.
53: -- 28-NOV-05 pikhar o replaced pn_payment_items with _all table
54: -- 08-DEC-06 acprakas o Bug5389144. Added code to modify Record History columns of pn_payment_items
55: -- and pn_payment_schedules with correct values.
56: --------------------------------------------------------------------------------
57: PROCEDURE update_accounted_amount (p_schedule_id IN NUMBER,
58: p_functional_curr IN VARCHAR2,
59: p_conversion_type IN VARCHAR2,

Line 248: -- and pn_payment_schedules with correct values.

244: -- 28-Nov-05 pikhar o replaced tables with _ALL tables
245: -- 01-DEC-05 pikhar o passed org_id in pnp_util_func.get_default_gl_period
246: -- and pnp_util_func.check_conversion_type
247: -- 08-DEC-06 acprakas o Bug5389144. Added code to modify Record History columns of pn_payment_items
248: -- and pn_payment_schedules with correct values.
249: --------------------------------------------------------------------------------
250: PROCEDURE approve( errbuf OUT NOCOPY VARCHAR2
251: ,retcode OUT NOCOPY VARCHAR2
252: ,p_schedule_from_date IN DATE

Line 279: FROM pn_payment_schedules_all pps,

275: pl.lease_class_code s_lease_class_code,
276: pl.lease_id s_lease_id,
277: pl.lease_num s_lease_number,
278: pl.name s_lease_name
279: FROM pn_payment_schedules_all pps,
280: pn_leases pl,
281: pn_lease_details_all pld,
282: pn_tenancies_all pt,
283: pn_locations_all ploc

Line 318: FROM pn_payment_schedules_all pps,

314: pl.lease_class_code s_lease_class_code,
315: pl.lease_id s_lease_id,
316: pl.lease_num s_lease_number,
317: pl.name s_lease_name
318: FROM pn_payment_schedules_all pps,
319: pn_leases pl,
320: pn_lease_details_all pld
321: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
322: AND NVL(p_schedule_to_date, pps.schedule_date)

Line 448: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;

444: l_sched_failed BOOLEAN;
445:
446: /* variables to store the values selected in the main cursor */
447: l_payment_item_id PN_PAYMENT_ITEMS_ALL.payment_item_id%TYPE;
448: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;
449: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
450: l_lease_class_code PN_LEASES_ALL.lease_class_code%TYPE;
451: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;

Line 449: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

445:
446: /* variables to store the values selected in the main cursor */
447: l_payment_item_id PN_PAYMENT_ITEMS_ALL.payment_item_id%TYPE;
448: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;
449: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
450: l_lease_class_code PN_LEASES_ALL.lease_class_code%TYPE;
451: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
452: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
453: l_lease_number PN_LEASES_ALL.lease_num%TYPE;

Line 746: UPDATE PN_PAYMENT_SCHEDULES

742: WHERE payment_item_type_lookup_code = 'CASH'
743: AND payment_schedule_id = l_payment_schedule_id;
744:
745: /* Approve the schedule */
746: UPDATE PN_PAYMENT_SCHEDULES
747: SET payment_status_lookup_code = 'APPROVED',
748: approved_by_user_id = fnd_profile.value('USER_ID'),
749: approval_date = SYSDATE,
750: period_name = l_period_name,

Line 872: FROM pn_payment_schedules_all pps,

868: SELECT DISTINCT
869: pps.payment_schedule_id s_payment_schedule_id,
870: pps.schedule_date s_schedule_date,
871: pl.lease_id s_lease_id
872: FROM pn_payment_schedules_all pps,
873: pn_leases pl,
874: pn_lease_details_all pld,
875: pn_tenancies_all pt,
876: pn_locations_all ploc

Line 908: FROM pn_payment_schedules_all pps,

904: SELECT DISTINCT
905: pps.payment_schedule_id s_payment_schedule_id,
906: pps.schedule_date s_schedule_date,
907: pl.lease_id s_lease_id
908: FROM pn_payment_schedules_all pps,
909: pn_leases pl,
910: pn_lease_details_all pld
911: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
912: AND NVL(p_schedule_to_date, pps.schedule_date)

Line 937: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;

933: /* counters */
934: l_sch_unapp NUMBER;
935:
936: /* variables */
937: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;
938: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
939: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
940:
941: BEGIN

Line 938: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;

934: l_sch_unapp NUMBER;
935:
936: /* variables */
937: l_payment_schedule_id PN_PAYMENT_SCHEDULES_ALL.payment_schedule_id%TYPE;
938: l_payment_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
939: l_lease_id PN_LEASES_ALL.lease_id%TYPE;
940:
941: BEGIN
942:

Line 1001: UPDATE PN_PAYMENT_SCHEDULES

997: WHERE payment_item_type_lookup_code = 'CASH'
998: AND payment_schedule_id = l_payment_schedule_id;
999:
1000: /* Approve the schedule */
1001: UPDATE PN_PAYMENT_SCHEDULES
1002: SET payment_status_lookup_code = 'DRAFT',
1003: approved_by_user_id = NULL,
1004: approval_date = NULL,
1005: period_name = NULL