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 342: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);

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

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

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

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

343: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
344: l_ps_rec.GLOBAL_ATTRIBUTE12 := 'FORMATTED'; --bug 12606008
345: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
346: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
347: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
348: exception
349: when others then
350: null;
351: end;

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

542: SET event_id =l_event_id
543: WHERE occurrence_id = l_occurrence_id;
544: -- End SLA Uptake - Bug#4301543
545:
546: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
547: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
548: l_ps_rec.GLOBAL_ATTRIBUTE12 := 'FORMATTED'; --bug 12606008
549: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
550: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';

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

543: WHERE occurrence_id = l_occurrence_id;
544: -- End SLA Uptake - Bug#4301543
545:
546: arp_ps_pkg.fetch_p(CURSOR_PS.PAYMENT_SCHEDULE_ID, l_ps_rec);
547: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
548: l_ps_rec.GLOBAL_ATTRIBUTE12 := 'FORMATTED'; --bug 12606008
549: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
550: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
551: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);

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

547: arp_ps_pkg.lock_p(CURSOR_PS.PAYMENT_SCHEDULE_ID);
548: l_ps_rec.GLOBAL_ATTRIBUTE12 := 'FORMATTED'; --bug 12606008
549: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'Y';
550: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'BANK';
551: arp_ps_pkg.update_p(l_ps_rec, CURSOR_PS.PAYMENT_SCHEDULE_ID);
552:
553: /* Update status to FORMATTED and update bank accounts */
554: update JL_BR_AR_COLLECTION_DOCS_ALL
555: set DOCUMENT_STATUS = 'FORMATTED',

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

720: INTO l_ps_id
721: FROM jl_br_ar_collection_docs
722: WHERE document_id = TMP.DOCUMENT_ID;
723:
724: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
725: arp_ps_pkg.lock_p(l_ps_id);
726: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'REGISTRY';
727: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
728:

Line 725: arp_ps_pkg.lock_p(l_ps_id);

721: FROM jl_br_ar_collection_docs
722: WHERE document_id = TMP.DOCUMENT_ID;
723:
724: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
725: arp_ps_pkg.lock_p(l_ps_id);
726: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'REGISTRY';
727: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
728:
729: /* Following elsif added for Bug 865082 */

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

723:
724: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
725: arp_ps_pkg.lock_p(l_ps_id);
726: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'REGISTRY';
727: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
728:
729: /* Following elsif added for Bug 865082 */
730: elsif TMP.STD_OCCURRENCE_CODE = 'WRITE_OFF_REQUISITION' then
731: /* UPDATE ar_payment_schedules

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

743: INTO l_ps_id
744: FROM jl_br_ar_collection_docs
745: WHERE document_id = TMP.DOCUMENT_ID;
746:
747: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
748: arp_ps_pkg.lock_p(l_ps_id);
749: l_ps_rec.GLOBAL_ATTRIBUTE12 := NULL; --bug 12606008
750: l_ps_rec.selected_for_receipt_batch_id := NULL;
751: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'MANUAL_RECEIPT';

Line 748: arp_ps_pkg.lock_p(l_ps_id);

744: FROM jl_br_ar_collection_docs
745: WHERE document_id = TMP.DOCUMENT_ID;
746:
747: arp_ps_pkg.fetch_p(l_ps_id, l_ps_rec);
748: arp_ps_pkg.lock_p(l_ps_id);
749: l_ps_rec.GLOBAL_ATTRIBUTE12 := NULL; --bug 12606008
750: l_ps_rec.selected_for_receipt_batch_id := NULL;
751: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'MANUAL_RECEIPT';
752: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'N';

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

749: l_ps_rec.GLOBAL_ATTRIBUTE12 := NULL; --bug 12606008
750: l_ps_rec.selected_for_receipt_batch_id := NULL;
751: l_ps_rec.GLOBAL_ATTRIBUTE9 := 'MANUAL_RECEIPT';
752: l_ps_rec.GLOBAL_ATTRIBUTE11 := 'N';
753: arp_ps_pkg.update_p(l_ps_rec, l_ps_id);
754:
755: end if;
756: end loop;
757: select B.SELECTION_CONTROL_ID,