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_ITEMS

Line 53: -- 28-NOV-05 pikhar o replaced pn_payment_items with _all table

49: -- HISTORY :
50: --
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,

Line 54: -- 08-DEC-06 acprakas o Bug5389144. Added code to modify Record History columns of pn_payment_items

50: --
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,

Line 83: FROM pn_payment_items_all

79: ,actual_amount
80: ,currency_code
81: ,due_date
82: ,rate
83: FROM pn_payment_items_all
84: WHERE payment_schedule_id = p_schedule_id
85: AND payment_item_type_lookup_code = 'CASH';
86:
87: CURSOR norm_cursor( p_term_id IN NUMBER

Line 93: FROM pn_payment_items_all pi

89: SELECT pi.payment_item_id
90: ,pi.accounted_amount
91: ,pi.actual_amount
92: ,pi.currency_code
93: FROM pn_payment_items_all pi
94: ,pn_payment_items_all pi1
95: WHERE pi.payment_schedule_id = p_schedule_id
96: AND pi.payment_term_id = p_term_id
97: AND pi.payment_item_type_lookup_code = 'NORMALIZED'

Line 94: ,pn_payment_items_all pi1

90: ,pi.accounted_amount
91: ,pi.actual_amount
92: ,pi.currency_code
93: FROM pn_payment_items_all pi
94: ,pn_payment_items_all pi1
95: WHERE pi.payment_schedule_id = p_schedule_id
96: AND pi.payment_term_id = p_term_id
97: AND pi.payment_item_type_lookup_code = 'NORMALIZED'
98: AND pi1.payment_schedule_id = pi.payment_schedule_id

Line 192: UPDATE pn_payment_items

188: END IF;
189:
190: IF (NVL(payment_item_rec.accounted_amount,0) <> NVL(l_accounted_amt,0)) THEN
191:
192: UPDATE pn_payment_items
193: SET accounted_amount = l_accounted_amt,
194: accounted_date = l_accounted_date,
195: last_update_date = SYSDATE, --Bug#5389144
196: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144

Line 206: UPDATE pn_payment_items

202: IF l_exists_norm THEN
203:
204: IF (NVL(l_norm_accounted_amount,0) <> NVL(l_accounted_amt_norm,0)) THEN
205:
206: UPDATE pn_payment_items
207: SET accounted_amount = l_accounted_amt_norm,
208: accounted_date = l_accounted_date,
209: RATE = payment_item_rec.RATE,
210: CURRENCY_CODE = payment_item_rec.currency_code,

Line 247: -- 08-DEC-06 acprakas o Bug5389144. Added code to modify Record History columns of pn_payment_items

243: -- 28-Nov-05 pikhar o Passed org_id in pn_mo_chace_utils.get_profile_value
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

Line 299: FROM pn_payment_items_all item

295: AND ploc.location_code >= NVL(p_location_from_code, ploc.location_code)
296: AND ploc.location_code <= NVL(p_location_to_code, ploc.location_code)
297: AND EXISTS
298: (SELECT NULL
299: FROM pn_payment_items_all item
300: WHERE item.payment_schedule_id = pps.payment_schedule_id
301: AND item.due_date BETWEEN NVL(p_trx_from_date, item.due_date)
302: AND NVL(p_trx_to_date, item.due_date)
303: )

Line 332: FROM pn_payment_items_all item

328: AND pld.lease_id = pps.lease_id
329: AND pld.responsible_user = NVL(p_responsible_user, pld.responsible_user)
330: AND EXISTS
331: (SELECT NULL
332: FROM pn_payment_items_all item
333: WHERE item.payment_schedule_id = pps.payment_schedule_id
334: AND item.due_date BETWEEN NVL(p_trx_from_date, item.due_date)
335: AND NVL(p_trx_to_date, item.due_date)
336: )

Line 356: pn_payment_items_all ppi

352: SELECT 'Y'
353: FROM DUAL
354: WHERE EXISTS (SELECT NULL
355: FROM pn_payment_terms_all ppt,
356: pn_payment_items_all ppi
357: WHERE ppi.payment_term_id = ppt.payment_term_id
358: AND ppi.payment_schedule_id = p_schedule_id
359: AND (ppt.customer_id IS NULL
360: OR ppt.customer_site_use_id IS NULL

Line 379: pn_payment_items_all ppi

375: SELECT 'Y'
376: FROM dual
377: WHERE EXISTS (SELECT NULL
378: FROM pn_payment_terms_all ppt,
379: pn_payment_items_all ppi
380: WHERE ppi.payment_term_id = ppt.payment_term_id
381: AND ppi.payment_schedule_id = p_schedule_id
382: AND (ppt.vendor_id IS NULL OR
383: ppt.vendor_site_id Is NULL

Line 397: FROM pn_payment_items_all ppi

393: CURSOR check_act_amt (p_schedule_id IN NUMBER) IS
394: SELECT 'Y'
395: FROM dual
396: WHERE EXISTS(SELECT NULL
397: FROM pn_payment_items_all ppi
398: WHERE ppi.payment_schedule_id = p_schedule_id
399: AND ppi.actual_amount IS NULL);
400:
401: -------------------------------------------------------------------------------

Line 447: l_payment_item_id PN_PAYMENT_ITEMS_ALL.payment_item_id%TYPE;

443: l_curr_exists BOOLEAN;
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;

Line 731: UPDATE PN_PAYMENT_ITEMS

727:
728: ELSE
729:
730: /* Update the export flags in the items */
731: UPDATE PN_PAYMENT_ITEMS
732: SET export_to_ap_flag = DECODE(l_lease_class_code,
733: 'DIRECT','Y',
734: NULL),
735: export_to_ar_flag = DECODE(l_lease_class_code,

Line 891: FROM pn_payment_items_all item

887: AND ploc.location_id = pt.location_id
888: AND ploc.location_code >= NVL(p_location_from_code, ploc.location_code)
889: AND ploc.location_code <= NVL(p_location_to_code, ploc.location_code)
890: AND EXISTS(SELECT NULL
891: FROM pn_payment_items_all item
892: WHERE item.payment_schedule_id = pps.payment_schedule_id
893: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
894: AND NVL(p_trx_to_date,item.due_date))
895: AND NOT EXISTS (SELECT NULL

Line 896: FROM pn_payment_items_all pi

892: WHERE item.payment_schedule_id = pps.payment_schedule_id
893: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
894: AND NVL(p_trx_to_date,item.due_date))
895: AND NOT EXISTS (SELECT NULL
896: FROM pn_payment_items_all pi
897: WHERE pi.payment_schedule_id = pps.payment_schedule_id
898: AND (pi.TRANSFERRED_TO_AP_FLAG = 'Y' OR
899: pi.TRANSFERRED_TO_AR_FLAG = 'Y')
900: )

Line 921: FROM pn_payment_items_all item

917: AND pl.lease_num <= NVL(p_lease_to_number, pl.lease_num)
918: AND pld.lease_id = pps.lease_id
919: AND pld.responsible_user = NVL(p_responsible_user, pld.responsible_user)
920: AND EXISTS (SELECT NULL
921: FROM pn_payment_items_all item
922: WHERE item.payment_schedule_id = pps.payment_schedule_id
923: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
924: AND NVL(p_trx_to_date,item.due_date))
925: AND NOT EXISTS (SELECT NULL

Line 926: FROM pn_payment_items_all pi

922: WHERE item.payment_schedule_id = pps.payment_schedule_id
923: AND item.due_date BETWEEN NVL(p_trx_from_date,item.due_date)
924: AND NVL(p_trx_to_date,item.due_date))
925: AND NOT EXISTS (SELECT NULL
926: FROM pn_payment_items_all pi
927: WHERE pi.payment_schedule_id = pps.payment_schedule_id
928: AND (pi.TRANSFERRED_TO_AP_FLAG = 'Y' OR
929: pi.TRANSFERRED_TO_AR_FLAG = 'Y')
930: )

Line 994: UPDATE PN_PAYMENT_ITEMS

990: /* Increment the schedules total */
991: l_sch_unapp := l_sch_unapp + 1;
992:
993: /* Update the export flags in the items to NULL */
994: UPDATE PN_PAYMENT_ITEMS
995: SET export_to_ap_flag = NULL,
996: export_to_ar_flag = NULL
997: WHERE payment_item_type_lookup_code = 'CASH'
998: AND payment_schedule_id = l_payment_schedule_id;