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.JL_BR_AR_REMIT_COLL_OCCUR dependencies on ARP_PS_PKG

Line 341: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);

337: where PAYMENT_SCHEDULE_ID = CURSOR_PS.PAYMENT_SCHEDULE_ID;
338: */
339: mo_global.set_policy_context('S',cursor_ps.org_id);
340: begin
341: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
342: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
343: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
344: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
345: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);

Line 342: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);

338: */
339: mo_global.set_policy_context('S',cursor_ps.org_id);
340: begin
341: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
342: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
343: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
344: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
345: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
346: exception

Line 345: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);

341: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
342: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
343: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
344: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
345: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
346: exception
347: when others then
348: null;
349: end;

Line 542: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);

538: SET event_id =l_event_id
539: WHERE occurrence_id = l_occurrence_id;
540: -- End SLA Uptake - Bug#4301543
541:
542: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
543: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
544: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
545: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
546: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);

Line 543: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);

539: WHERE occurrence_id = l_occurrence_id;
540: -- End SLA Uptake - Bug#4301543
541:
542: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
543: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
544: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
545: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
546: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
547:

Line 546: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);

542: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
543: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
544: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
545: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
546: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
547:
548: /* Update status to FORMATTED and update bank accounts */
549: update JL_BR_AR_COLLECTION_DOCS_ALL
550: set DOCUMENT_STATUS = 'FORMATTED',

Line 719: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);

715: INTO l_ps_id
716: FROM jl_br_ar_collection_docs
717: WHERE document_id = TMP.DOCUMENT_ID;
718:
719: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
720: arp_ps_pkg.lock_p(l_ps_id);
721: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'REGISTRY';
722: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
723:

Line 720: arp_ps_pkg.lock_p(l_ps_id);

716: FROM jl_br_ar_collection_docs
717: WHERE document_id = TMP.DOCUMENT_ID;
718:
719: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
720: arp_ps_pkg.lock_p(l_ps_id);
721: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'REGISTRY';
722: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
723:
724: /* Following elsif added for Bug 865082 */

Line 722: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);

718:
719: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
720: arp_ps_pkg.lock_p(l_ps_id);
721: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'REGISTRY';
722: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
723:
724: /* Following elsif added for Bug 865082 */
725: elsif TMP.STD_OCCURRENCE_CODE = 'WRITE_OFF_REQUISITION' then
726: /* UPDATE ar_payment_schedules

Line 742: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);

738: INTO l_ps_id
739: FROM jl_br_ar_collection_docs
740: WHERE document_id = TMP.DOCUMENT_ID;
741:
742: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
743: arp_ps_pkg.lock_p(l_ps_id);
744: l_ps_rec.selected_for_receipt_batch_id := NULL;
745: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'MANUAL_RECEIPT';
746: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'N';

Line 743: arp_ps_pkg.lock_p(l_ps_id);

739: FROM jl_br_ar_collection_docs
740: WHERE document_id = TMP.DOCUMENT_ID;
741:
742: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
743: arp_ps_pkg.lock_p(l_ps_id);
744: l_ps_rec.selected_for_receipt_batch_id := NULL;
745: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'MANUAL_RECEIPT';
746: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'N';
747: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);

Line 747: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);

743: arp_ps_pkg.lock_p(l_ps_id);
744: l_ps_rec.selected_for_receipt_batch_id := NULL;
745: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'MANUAL_RECEIPT';
746: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'N';
747: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
748:
749: end if;
750: end loop;
751: select B.SELECTION_CONTROL_ID,