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_AP_ASSOCIATE_COLLECTION dependencies on AP_PAYMENT_SCHEDULES

Line 36: FROM ap_payment_schedules_ALL apps,

32: IF (association_method_e = 'METHOD1') THEN
33: /* Invoice number AND Due date */
34: SELECT apps.invoice_id, apps.payment_num
35: INTO invoice_id_s, payment_num_s
36: FROM ap_payment_schedules_ALL apps,
37: jl_br_ap_collection_docs jlbl,
38: ap_invoices_ALL apinv
39: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
40: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 53: FROM ap_payment_schedules_ALL apps,

49: ELSIF (association_method_e = 'METHOD2') THEN
50: /* Supplier Site AND Supplier Name */
51: SELECT apps.invoice_id, apps.payment_num
52: INTO invoice_id_s, payment_num_s
53: FROM ap_payment_schedules_ALL apps,
54: jl_br_ap_collection_docs jlbl,
55: ap_invoices_ALL apinv
56: /* Bug # 635847 / 659227
57: ,

Line 77: FROM ap_payment_schedules_ALL apps,

73: /* Supplier Site OR Supplier Name */
74: BEGIN
75: SELECT apps.invoice_id, apps.payment_num
76: INTO invoice_id_s, payment_num_s
77: FROM ap_payment_schedules_ALL apps,
78: jl_br_ap_collection_docs jlbl,
79: ap_invoices_ALL apinv
80: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
81: (( apinv.vendor_site_id = jlbl.vendor_site_id AND

Line 96: FROM ap_payment_schedules_ALL apps,

92: END;
93: IF x_selected = 'N' THEN
94: SELECT apps.invoice_id, apps.payment_num
95: INTO invoice_id_s, payment_num_s
96: FROM ap_payment_schedules_ALL apps,
97: jl_br_ap_collection_docs jlbl,
98: ap_invoices_ALL apinv
99: /* Bug # 635847 / 659227
100: ,

Line 118: FROM ap_payment_schedules_ALL apps,

114: ELSIF (association_method_e = 'METHOD4') THEN
115: /* Invoice Number AND Due date AND Supplier Site */
116: SELECT apps.invoice_id, apps.payment_num
117: INTO invoice_id_s, payment_num_s
118: FROM ap_payment_schedules_ALL apps,
119: jl_br_ap_collection_docs jlbl,
120: ap_invoices_ALL apinv
121: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
122: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 137: FROM ap_payment_schedules_ALL apps,

133: ELSIF (association_method_e = 'METHOD5') THEN
134: /* Invoice Number AND Due date AND Supplier Name */
135: SELECT apps.invoice_id, apps.payment_num
136: INTO invoice_id_s, payment_num_s
137: FROM ap_payment_schedules_ALL apps,
138: jl_br_ap_collection_docs jlbl,
139: ap_invoices_ALL apinv
140: /* Bug # 635847 / 659227
141: ,

Line 161: FROM ap_payment_schedules_ALL apps,

157: ELSIF (association_method_e = 'METHOD6') THEN
158: /* Invoice number AND Gross Amount AND Due Date */
159: SELECT apps.invoice_id, apps.payment_num
160: INTO invoice_id_s, payment_num_s
161: FROM ap_payment_schedules_ALL apps,
162: jl_br_ap_collection_docs jlbl,
163: ap_invoices_ALL apinv
164: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
165: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 181: FROM ap_payment_schedules_ALL apps,

177: ELSIF (association_method_e = 'METHOD7') THEN
178: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
179: SELECT apps.invoice_id, apps.payment_num
180: INTO invoice_id_s, payment_num_s
181: FROM ap_payment_schedules_ALL apps,
182: jl_br_ap_collection_docs jlbl,
183: ap_invoices_ALL apinv
184: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
185: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 203: FROM ap_payment_schedules_ALL apps,

199: ELSIF (association_method_e = 'METHOD8') THEN
200: /* Invoice number AND Gross Amount AND Due Date AND Supplier Name */
201: SELECT apps.invoice_id, apps.payment_num
202: INTO invoice_id_s, payment_num_s
203: FROM ap_payment_schedules_ALL apps,
204: jl_br_ap_collection_docs jlbl,
205: ap_invoices_ALL apinv
206: /* Bug # 635847 / 659227
207: ,

Line 231: FROM ap_payment_schedules_ALL apps,

227: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
228: /* AND Supplier Name */
229: SELECT apps.invoice_id, apps.payment_num
230: INTO invoice_id_s, payment_num_s
231: FROM ap_payment_schedules_ALL apps,
232: jl_br_ap_collection_docs jlbl,
233: ap_invoices_ALL apinv
234: /* Bug # 635847 / 659227
235: ,

Line 262: FROM ap_payment_schedules_ALL apps,

258: /* AND Supplier Name */
259: BEGIN
260: SELECT apps.invoice_id, apps.payment_num
261: INTO invoice_id_s, payment_num_s
262: FROM ap_payment_schedules_ALL apps,
263: jl_br_ap_collection_docs jlbl,
264: ap_invoices_ALL apinv
265: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
266: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 285: FROM ap_payment_schedules_ALL apps,

281: END;
282: IF x_selected = 'N' THEN
283: SELECT apps.invoice_id, apps.payment_num
284: INTO invoice_id_s, payment_num_s
285: FROM ap_payment_schedules_ALL apps,
286: jl_br_ap_collection_docs jlbl,
287: ap_invoices_ALL apinv
288: /* Bug # 635847 / 659227
289: ,

Line 311: FROM ap_payment_schedules_ALL apps,

307: /* Invoice number OR Gross Amount AND Due Date AND Supplier Site */
308: BEGIN
309: SELECT apps.invoice_id, apps.payment_num
310: INTO invoice_id_s, payment_num_s
311: FROM ap_payment_schedules_ALL apps,
312: jl_br_ap_collection_docs jlbl,
313: ap_invoices_ALL apinv
314: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
315: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 330: FROM ap_payment_schedules_ALL apps,

326: END;
327: IF x_selected = 'N' THEN
328: SELECT apps.invoice_id, apps.payment_num
329: INTO invoice_id_s, payment_num_s
330: FROM ap_payment_schedules_ALL apps,
331: jl_br_ap_collection_docs jlbl,
332: ap_invoices_ALL apinv
333: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
334: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 351: FROM ap_payment_schedules_ALL apps,

347: ELSIF (association_method_e = 'METHOD12') THEN
348: /* Gross Amount AND Due Date AND Supplier Site */
349: SELECT apps.invoice_id, apps.payment_num
350: INTO invoice_id_s, payment_num_s
351: FROM ap_payment_schedules_ALL apps,
352: jl_br_ap_collection_docs jlbl,
353: ap_invoices_ALL apinv
354: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
355: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 371: FROM ap_payment_schedules_ALL apps,

367: ELSIF (association_method_e = 'METHOD13') THEN
368: /* Gross Amount AND Due Date AND Supplier Name */
369: SELECT apps.invoice_id, apps.payment_num
370: INTO invoice_id_s, payment_num_s
371: FROM ap_payment_schedules_ALL apps,
372: jl_br_ap_collection_docs jlbl,
373: ap_invoices_ALL apinv
374: /* Bug # 635847 / 659227
375: ,

Line 404: UPDATE ap_payment_schedules

400: payment_num = payment_num_s
401: WHERE bank_collection_id = bank_collection_id_e;
402:
403: -- Bug Number 659227 / R11 Patch / May 98 (Copying Y to GA8)
404: UPDATE ap_payment_schedules
405: SET global_attribute11 = bank_collection_id_e,
406: global_attribute8 = 'Y'
407: WHERE invoice_id = invoice_id_s
408: AND payment_num = payment_num_s;

Line 427: UPDATE ap_payment_schedules

423: IF x_enable_association = 'Y' THEN
424: associate_coll_doc( bank_collection_id_e, association_method_e,
425: invoice_id_s, payment_num_s, associate_flag_s );
426: IF associate_flag_s = 'Y' THEN /* If associated, release both*/
427: UPDATE ap_payment_schedules
428: SET hold_flag = 'N'
429: WHERE invoice_id = invoice_id_s
430: AND payment_num = payment_num_s;
431:

Line 467: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;

463: associate_flag_s IN OUT NOCOPY VARCHAR2 )
464: IS
465: x_enable_bank_coll ap_system_parameters.global_attribute1%TYPE;
466: x_enable_association ap_system_parameters.global_attribute2%TYPE;
467: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
468: /*-----------------------------------------------------------*/
469: /* ASSOCIATE_TRADE_NOTE */
470: /*-----------------------------------------------------------*/
471: PROCEDURE associate_trade_note (

Line 487: FROM ap_payment_schedules apps,

483: IF (association_method_e = 'METHOD1') THEN
484: /* Invoice number AND Due date */
485: SELECT bank_collection_id
486: INTO bank_collection_id_s
487: FROM ap_payment_schedules apps,
488: jl_br_ap_collection_docs_ALL jlbl,
489: ap_invoices_ALL apinv
490: WHERE apps.invoice_id = invoice_id_e AND
491: apps.payment_num = payment_num_e AND

Line 504: FROM ap_payment_schedules apps,

500: ELSIF (association_method_e = 'METHOD2') THEN
501: /* Supplier Site and Supplier Name */
502: SELECT bank_collection_id
503: INTO bank_collection_id_s
504: FROM ap_payment_schedules apps,
505: jl_br_ap_collection_docs_ALL jlbl,
506: ap_invoices_ALL apinv
507: /* Bug # 635847 / 659227
508: ,

Line 528: FROM ap_payment_schedules apps,

524: /* Supplier Site OR Supplier Name */
525: BEGIN
526: SELECT bank_collection_id
527: INTO bank_collection_id_s
528: FROM ap_payment_schedules apps,
529: jl_br_ap_collection_docs_ALL jlbl,
530: ap_invoices_ALL apinv
531: WHERE apps.invoice_id = invoice_id_e AND
532: apps.payment_num = payment_num_e AND

Line 547: FROM ap_payment_schedules apps,

543: END;
544: IF x_selected = 'N' THEN
545: SELECT bank_collection_id
546: INTO bank_collection_id_s
547: FROM ap_payment_schedules apps,
548: jl_br_ap_collection_docs_ALL jlbl,
549: ap_invoices_ALL apinv
550: /* Bug # 635847 / 659227
551: ,

Line 569: FROM ap_payment_schedules apps,

565: ELSIF (association_method_e = 'METHOD4') THEN
566: /* Invoice Number AND Due date AND Supplier Site */
567: SELECT bank_collection_id
568: INTO bank_collection_id_s
569: FROM ap_payment_schedules apps,
570: jl_br_ap_collection_docs_ALL jlbl,
571: ap_invoices_ALL apinv
572: WHERE apps.invoice_id = invoice_id_e AND
573: apps.payment_num = payment_num_e AND

Line 588: FROM ap_payment_schedules apps,

584: ELSIF (association_method_e = 'METHOD5') THEN
585: /* Invoice Number AND Due date AND Supplier Name */
586: SELECT bank_collection_id
587: INTO bank_collection_id_s
588: FROM ap_payment_schedules apps,
589: jl_br_ap_collection_docs_ALL jlbl,
590: ap_invoices_ALL apinv
591: /* Bug # 635847 / 659227
592: ,

Line 612: FROM ap_payment_schedules apps,

608: ELSIF (association_method_e = 'METHOD6') THEN
609: /* Invoice number AND Gross Amount AND Due Date */
610: SELECT bank_collection_id
611: INTO bank_collection_id_s
612: FROM ap_payment_schedules apps,
613: jl_br_ap_collection_docs_ALL jlbl,
614: ap_invoices_ALL apinv
615: WHERE apps.invoice_id = invoice_id_e AND
616: apps.payment_num = payment_num_e AND

Line 632: FROM ap_payment_schedules apps,

628: ELSIF (association_method_e = 'METHOD7') THEN
629: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
630: SELECT bank_collection_id
631: INTO bank_collection_id_s
632: FROM ap_payment_schedules apps,
633: jl_br_ap_collection_docs_ALL jlbl,
634: ap_invoices_ALL apinv
635: WHERE apps.invoice_id = invoice_id_e AND
636: apps.payment_num = payment_num_e AND

Line 654: FROM ap_payment_schedules apps,

650: ELSIF (association_method_e = 'METHOD8') THEN
651: /* Invoice number AND Gross Amount AND Due Date AND Supplier Name */
652: SELECT bank_collection_id
653: INTO bank_collection_id_s
654: FROM ap_payment_schedules apps,
655: jl_br_ap_collection_docs_ALL jlbl,
656: ap_invoices_ALL apinv
657: /* Bug # 635847 / 659227
658: ,

Line 682: FROM ap_payment_schedules apps,

678: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
679: /* AND Supplier Name */
680: SELECT bank_collection_id
681: INTO bank_collection_id_s
682: FROM ap_payment_schedules apps,
683: jl_br_ap_collection_docs_ALL jlbl,
684: ap_invoices_ALL apinv
685: /* Bug # 635847 / 659227
686: ,

Line 713: FROM ap_payment_schedules apps,

709: /* AND Supplier Name */
710: BEGIN
711: SELECT bank_collection_id
712: INTO bank_collection_id_s
713: FROM ap_payment_schedules apps,
714: jl_br_ap_collection_docs_ALL jlbl,
715: ap_invoices_ALL apinv
716: WHERE apps.invoice_id = invoice_id_e AND
717: apps.payment_num = payment_num_e AND

Line 736: FROM ap_payment_schedules apps,

732: END;
733: IF x_selected = 'N' THEN
734: SELECT bank_collection_id
735: INTO bank_collection_id_s
736: FROM ap_payment_schedules apps,
737: jl_br_ap_collection_docs_ALL jlbl,
738: ap_invoices_ALL apinv
739: /* Bug # 635847 / 659227
740: ,

Line 762: FROM ap_payment_schedules apps,

758: /* Invoice number OR Gross Amount AND Due Date AND Supplier Site */
759: BEGIN
760: SELECT bank_collection_id
761: INTO bank_collection_id_s
762: FROM ap_payment_schedules apps,
763: jl_br_ap_collection_docs_ALL jlbl,
764: ap_invoices_ALL apinv
765: WHERE apps.invoice_id = invoice_id_e AND
766: apps.payment_num = payment_num_e AND

Line 781: FROM ap_payment_schedules apps,

777: END;
778: IF x_selected = 'N' THEN
779: SELECT bank_collection_id
780: INTO bank_collection_id_s
781: FROM ap_payment_schedules apps,
782: jl_br_ap_collection_docs_ALL jlbl,
783: ap_invoices_ALL apinv
784: WHERE apps.invoice_id = invoice_id_e AND
785: apps.payment_num = payment_num_e AND

Line 802: FROM ap_payment_schedules apps,

798: ELSIF (association_method_e = 'METHOD12') THEN
799: /* Gross Amount AND Due Date AND Supplier Site */
800: SELECT bank_collection_id
801: INTO bank_collection_id_s
802: FROM ap_payment_schedules apps,
803: jl_br_ap_collection_docs_ALL jlbl,
804: ap_invoices_ALL apinv
805: WHERE apps.invoice_id = invoice_id_e AND
806: apps.payment_num = payment_num_e AND

Line 822: FROM ap_payment_schedules apps,

818: ELSIF (association_method_e = 'METHOD13') THEN
819: /* Gross Amount AND Due Date AND Supplier Name */
820: SELECT bank_collection_id
821: INTO bank_collection_id_s
822: FROM ap_payment_schedules apps,
823: jl_br_ap_collection_docs_ALL jlbl,
824: ap_invoices_ALL apinv
825: /* Bug # 635847 / 659227
826: ,

Line 850: UPDATE ap_payment_schedules

846: x_selected := 'N';
847: END;
848: IF x_selected = 'Y' THEN /* Create the link with two tables */
849: -- Bug Number 659227 / R11 Patch / May 98 (Copying Y to GA8)
850: UPDATE ap_payment_schedules
851: SET global_attribute11 = bank_collection_id_s,
852: global_attribute8 = 'Y'
853: WHERE invoice_id = invoice_id_e AND
854: payment_num = payment_num_e;

Line 884: UPDATE ap_payment_schedules

880: associate_flag_s );
881:
882: IF associate_flag_s = 'Y' THEN /* Se associou, */
883: /* libera os dois */
884: UPDATE ap_payment_schedules
885: SET hold_flag = 'N'
886: WHERE invoice_id = invoice_id_e
887: AND payment_num = payment_num_e;
888:

Line 897: FROM ap_payment_schedules

893: ELSE /* If not associated and payment schedule not paid */
894: /* then hold the payment schedule */
895: SELECT payment_status_flag
896: INTO x_payment_status_flag
897: FROM ap_payment_schedules
898: WHERE invoice_id = invoice_id_e
899: AND payment_num = payment_num_e;
900:
901: IF (x_payment_status_flag = 'N') THEN

Line 902: UPDATE ap_payment_schedules

898: WHERE invoice_id = invoice_id_e
899: AND payment_num = payment_num_e;
900:
901: IF (x_payment_status_flag = 'N') THEN
902: UPDATE ap_payment_schedules
903: SET hold_flag = 'Y'
904: WHERE invoice_id = invoice_id_e
905: AND payment_num = payment_num_e;
906: END IF;

Line 909: UPDATE ap_payment_schedules

905: AND payment_num = payment_num_e;
906: END IF;
907: END IF;
908: ELSE /* If association not enabled, hold the payment schedule */
909: UPDATE ap_payment_schedules
910: SET hold_flag = 'Y'
911: WHERE invoice_id = invoice_id_e
912: AND payment_num = payment_num_e;
913:

Line 916: UPDATE ap_payment_schedules

912: AND payment_num = payment_num_e;
913:
914: END IF;
915: ELSE /* If bank collection is not enabled, release the payment schedule */
916: UPDATE ap_payment_schedules
917: SET hold_flag = 'N'
918: WHERE invoice_id = invoice_id_e
919: AND payment_num = payment_num_e;
920: