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 JL_BR_AP_COLLECTION_DOCS

Line 69: jl_br_ap_collection_docs jlbl,

65: /* Invoice number AND Due date */
66: SELECT apps.invoice_id, apps.payment_num
67: INTO invoice_id_s, payment_num_s
68: FROM ap_payment_schedules_ALL apps,
69: jl_br_ap_collection_docs jlbl,
70: ap_invoices_ALL apinv
71: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
72: apps.org_id = jlbl.org_id AND --bug 14615620
73: apps.org_id = apinv.org_id AND --bug 14615620

Line 92: jl_br_ap_collection_docs jlbl,

88: /* Supplier Site AND Supplier Name */
89: SELECT apps.invoice_id, apps.payment_num
90: INTO invoice_id_s, payment_num_s
91: FROM ap_payment_schedules_ALL apps,
92: jl_br_ap_collection_docs jlbl,
93: ap_invoices_ALL apinv
94: /* Bug # 635847 / 659227
95: ,
96: po_vendor_sites povs

Line 122: jl_br_ap_collection_docs jlbl,

118: BEGIN
119: SELECT apps.invoice_id, apps.payment_num
120: INTO invoice_id_s, payment_num_s
121: FROM ap_payment_schedules_ALL apps,
122: jl_br_ap_collection_docs jlbl,
123: ap_invoices_ALL apinv
124: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
125: apps.org_id = jlbl.org_id AND --bug 14615620
126: apps.org_id = apinv.org_id AND --bug 14615620

Line 147: jl_br_ap_collection_docs jlbl,

143: IF x_selected = 'N' THEN
144: SELECT apps.invoice_id, apps.payment_num
145: INTO invoice_id_s, payment_num_s
146: FROM ap_payment_schedules_ALL apps,
147: jl_br_ap_collection_docs jlbl,
148: ap_invoices_ALL apinv
149: /* Bug # 635847 / 659227
150: ,
151: po_vendor_sites povs

Line 179: jl_br_ap_collection_docs jlbl,

175: END IF;
176: SELECT apps.invoice_id, apps.payment_num
177: INTO invoice_id_s, payment_num_s
178: FROM ap_payment_schedules_ALL apps,
179: jl_br_ap_collection_docs jlbl,
180: ap_invoices_ALL apinv
181: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
182: apps.org_id = jlbl.org_id AND --bug 14615620
183: apps.org_id = apinv.org_id AND --bug 14615620

Line 204: jl_br_ap_collection_docs jlbl,

200: /* Invoice Number 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: ,
208: po_vendor_sites povs

Line 234: jl_br_ap_collection_docs jlbl,

230: /* Invoice number AND Gross Amount AND Due Date */
231: SELECT apps.invoice_id, apps.payment_num
232: INTO invoice_id_s, payment_num_s
233: FROM ap_payment_schedules_ALL apps,
234: jl_br_ap_collection_docs jlbl,
235: ap_invoices_ALL apinv
236: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
237: apps.org_id = jlbl.org_id AND --bug 14615620
238: apps.org_id = apinv.org_id AND --bug 14615620

Line 260: jl_br_ap_collection_docs jlbl,

256: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
257: SELECT apps.invoice_id, apps.payment_num
258: INTO invoice_id_s, payment_num_s
259: FROM ap_payment_schedules_ALL apps,
260: jl_br_ap_collection_docs jlbl,
261: ap_invoices_ALL apinv
262: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
263: apps.org_id = jlbl.org_id AND --bug 14615620
264: apps.org_id = apinv.org_id AND --bug 14615620

Line 288: jl_br_ap_collection_docs jlbl,

284: /* Invoice number AND Gross Amount AND Due Date AND Supplier Name */
285: SELECT apps.invoice_id, apps.payment_num
286: INTO invoice_id_s, payment_num_s
287: FROM ap_payment_schedules_ALL apps,
288: jl_br_ap_collection_docs jlbl,
289: ap_invoices_ALL apinv
290: /* Bug # 635847 / 659227
291: ,
292: po_vendor_sites povs

Line 322: jl_br_ap_collection_docs jlbl,

318: /* AND Supplier Name */
319: SELECT apps.invoice_id, apps.payment_num
320: INTO invoice_id_s, payment_num_s
321: FROM ap_payment_schedules_ALL apps,
322: jl_br_ap_collection_docs jlbl,
323: ap_invoices_ALL apinv
324: /* Bug # 635847 / 659227
325: ,
326: po_vendor_sites povs

Line 359: jl_br_ap_collection_docs jlbl,

355: BEGIN
356: SELECT apps.invoice_id, apps.payment_num
357: INTO invoice_id_s, payment_num_s
358: FROM ap_payment_schedules_ALL apps,
359: jl_br_ap_collection_docs jlbl,
360: ap_invoices_ALL apinv
361: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
362: apps.org_id = jlbl.org_id AND --bug 14615620
363: apps.org_id = apinv.org_id AND --bug 14615620

Line 388: jl_br_ap_collection_docs jlbl,

384: IF x_selected = 'N' THEN
385: SELECT apps.invoice_id, apps.payment_num
386: INTO invoice_id_s, payment_num_s
387: FROM ap_payment_schedules_ALL apps,
388: jl_br_ap_collection_docs jlbl,
389: ap_invoices_ALL apinv
390: /* Bug # 635847 / 659227
391: ,
392: po_vendor_sites povs

Line 424: jl_br_ap_collection_docs jlbl,

420: BEGIN
421: SELECT apps.invoice_id, apps.payment_num
422: INTO invoice_id_s, payment_num_s
423: FROM ap_payment_schedules_ALL apps,
424: jl_br_ap_collection_docs jlbl,
425: ap_invoices_ALL apinv
426: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
427: apps.org_id = jlbl.org_id AND --bug 14615620
428: apps.org_id = apinv.org_id AND --bug 14615620

Line 449: jl_br_ap_collection_docs jlbl,

445: IF x_selected = 'N' THEN
446: SELECT apps.invoice_id, apps.payment_num
447: INTO invoice_id_s, payment_num_s
448: FROM ap_payment_schedules_ALL apps,
449: jl_br_ap_collection_docs jlbl,
450: ap_invoices_ALL apinv
451: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
452: apps.org_id = jlbl.org_id AND --bug 14615620
453: apps.org_id = apinv.org_id AND --bug 14615620

Line 480: jl_br_ap_collection_docs jlbl,

476: /* Gross Amount AND Due Date AND Supplier Site */
477: SELECT apps.invoice_id, apps.payment_num
478: INTO invoice_id_s, payment_num_s
479: FROM ap_payment_schedules_ALL apps,
480: jl_br_ap_collection_docs jlbl,
481: ap_invoices_ALL apinv
482: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
483: apps.org_id = jlbl.org_id AND --bug 14615620
484: apps.org_id = apinv.org_id AND --bug 14615620

Line 506: jl_br_ap_collection_docs jlbl,

502: /* Gross Amount AND Due Date AND Supplier Name */
503: SELECT apps.invoice_id, apps.payment_num
504: INTO invoice_id_s, payment_num_s
505: FROM ap_payment_schedules_ALL apps,
506: jl_br_ap_collection_docs jlbl,
507: ap_invoices_ALL apinv
508: /* Bug # 635847 / 659227
509: ,
510: po_vendor_sites povs

Line 546: UPDATE jl_br_ap_collection_docs

542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
543: END IF;
544: END;
545: IF x_selected = 'Y' THEN /* Create the link with two tables */
546: UPDATE jl_br_ap_collection_docs
547: SET invoice_id = invoice_id_s,
548: payment_num = payment_num_s
549: WHERE bank_collection_id = bank_collection_id_e;
550: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 551: l_log_msg := 'Updated jl_br_ap_collection_docs invoice_id ' ||

547: SET invoice_id = invoice_id_s,
548: payment_num = payment_num_s
549: WHERE bank_collection_id = bank_collection_id_e;
550: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
551: l_log_msg := 'Updated jl_br_ap_collection_docs invoice_id ' ||
552: invoice_id_s || ' payment_num' || payment_num_s;
553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
554: END IF;
555:

Line 633: UPDATE jl_br_ap_collection_docs

629: l_log_msg := 'updated hold flag to N in ap_payment_schedules';
630: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
631: END IF;
632:
633: UPDATE jl_br_ap_collection_docs
634: SET hold_flag = 'N'
635: WHERE bank_collection_id = bank_collection_id_e;
636: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
637: l_log_msg := 'updated hold flag to N in jl_br_ap_collection_docs';

Line 637: l_log_msg := 'updated hold flag to N in jl_br_ap_collection_docs';

633: UPDATE jl_br_ap_collection_docs
634: SET hold_flag = 'N'
635: WHERE bank_collection_id = bank_collection_id_e;
636: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
637: l_log_msg := 'updated hold flag to N in jl_br_ap_collection_docs';
638: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
639: END IF;
640:
641: ELSE /* If not associated, hold the collection document */

Line 642: UPDATE jl_br_ap_collection_docs

638: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
639: END IF;
640:
641: ELSE /* If not associated, hold the collection document */
642: UPDATE jl_br_ap_collection_docs
643: SET hold_flag = 'Y'
644: WHERE bank_collection_id = bank_collection_id_e;
645: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
646: l_log_msg := 'associate_flag_s is N updated hold_flag to Y in jl_br_ap_collection_docs';

Line 646: l_log_msg := 'associate_flag_s is N updated hold_flag to Y in jl_br_ap_collection_docs';

642: UPDATE jl_br_ap_collection_docs
643: SET hold_flag = 'Y'
644: WHERE bank_collection_id = bank_collection_id_e;
645: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
646: l_log_msg := 'associate_flag_s is N updated hold_flag to Y in jl_br_ap_collection_docs';
647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
648: END IF;
649:
650: END IF;

Line 652: UPDATE jl_br_ap_collection_docs

648: END IF;
649:
650: END IF;
651: ELSE /* If association is not enabled, hold the collection document */
652: UPDATE jl_br_ap_collection_docs
653: SET hold_flag = 'Y'
654: WHERE bank_collection_id = bank_collection_id_e;
655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
656: l_log_msg := 'x_enable_association is N update hold flag to Y in jl_br_ap_collection_docs';

Line 656: l_log_msg := 'x_enable_association is N update hold flag to Y in jl_br_ap_collection_docs';

652: UPDATE jl_br_ap_collection_docs
653: SET hold_flag = 'Y'
654: WHERE bank_collection_id = bank_collection_id_e;
655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
656: l_log_msg := 'x_enable_association is N update hold flag to Y in jl_br_ap_collection_docs';
657: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
658: END IF;
659:
660: END IF;

Line 662: UPDATE jl_br_ap_collection_docs

658: END IF;
659:
660: END IF;
661: ELSE /* If bank collection is not enabled, release the collection document*/
662: UPDATE jl_br_ap_collection_docs
663: SET hold_flag = 'N'
664: WHERE bank_collection_id = bank_collection_id_e;
665:
666: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 667: l_log_msg := 'x_enable_bank_coll is N update hold flag to N in jl_br_ap_collection_docs';

663: SET hold_flag = 'N'
664: WHERE bank_collection_id = bank_collection_id_e;
665:
666: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
667: l_log_msg := 'x_enable_bank_coll is N update hold flag to N in jl_br_ap_collection_docs';
668: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
669: END IF;
670:
671: END IF;

Line 731: jl_br_ap_collection_docs_ALL jlbl,

727: /* Invoice number AND Due date */
728: SELECT bank_collection_id
729: INTO bank_collection_id_s
730: FROM ap_payment_schedules apps,
731: jl_br_ap_collection_docs_ALL jlbl,
732: ap_invoices_ALL apinv
733: WHERE apps.invoice_id = invoice_id_e AND
734: apps.payment_num = payment_num_e AND
735: apps.org_id = jlbl.org_id AND --bug 14615620

Line 754: jl_br_ap_collection_docs_ALL jlbl,

750: /* Supplier Site and Supplier Name */
751: SELECT bank_collection_id
752: INTO bank_collection_id_s
753: FROM ap_payment_schedules apps,
754: jl_br_ap_collection_docs_ALL jlbl,
755: ap_invoices_ALL apinv
756: /* Bug # 635847 / 659227
757: ,
758: po_vendor_sites povs

Line 784: jl_br_ap_collection_docs_ALL jlbl,

780: BEGIN
781: SELECT bank_collection_id
782: INTO bank_collection_id_s
783: FROM ap_payment_schedules apps,
784: jl_br_ap_collection_docs_ALL jlbl,
785: ap_invoices_ALL apinv
786: WHERE apps.invoice_id = invoice_id_e AND
787: apps.payment_num = payment_num_e AND
788: apps.org_id = jlbl.org_id AND --bug 14615620

Line 809: jl_br_ap_collection_docs_ALL jlbl,

805: IF x_selected = 'N' THEN
806: SELECT bank_collection_id
807: INTO bank_collection_id_s
808: FROM ap_payment_schedules apps,
809: jl_br_ap_collection_docs_ALL jlbl,
810: ap_invoices_ALL apinv
811: /* Bug # 635847 / 659227
812: ,
813: po_vendor_sites povs

Line 841: jl_br_ap_collection_docs_ALL jlbl,

837: /* Invoice Number AND Due date AND Supplier Site */
838: SELECT bank_collection_id
839: INTO bank_collection_id_s
840: FROM ap_payment_schedules apps,
841: jl_br_ap_collection_docs_ALL jlbl,
842: ap_invoices_ALL apinv
843: WHERE apps.invoice_id = invoice_id_e AND
844: apps.payment_num = payment_num_e AND
845: apps.org_id = jlbl.org_id AND --bug 14615620

Line 866: jl_br_ap_collection_docs_ALL jlbl,

862: /* Invoice Number AND Due date AND Supplier Name */
863: SELECT bank_collection_id
864: INTO bank_collection_id_s
865: FROM ap_payment_schedules apps,
866: jl_br_ap_collection_docs_ALL jlbl,
867: ap_invoices_ALL apinv
868: /* Bug # 635847 / 659227
869: ,
870: po_vendor_sites povs

Line 896: jl_br_ap_collection_docs_ALL jlbl,

892: /* Invoice number AND Gross Amount AND Due Date */
893: SELECT bank_collection_id
894: INTO bank_collection_id_s
895: FROM ap_payment_schedules apps,
896: jl_br_ap_collection_docs_ALL jlbl,
897: ap_invoices_ALL apinv
898: WHERE apps.invoice_id = invoice_id_e AND
899: apps.payment_num = payment_num_e AND
900: apps.org_id = jlbl.org_id AND --bug 14615620

Line 922: jl_br_ap_collection_docs_ALL jlbl,

918: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
919: SELECT bank_collection_id
920: INTO bank_collection_id_s
921: FROM ap_payment_schedules apps,
922: jl_br_ap_collection_docs_ALL jlbl,
923: ap_invoices_ALL apinv
924: WHERE apps.invoice_id = invoice_id_e AND
925: apps.payment_num = payment_num_e AND
926: apps.org_id = jlbl.org_id AND --bug 14615620

Line 950: jl_br_ap_collection_docs_ALL jlbl,

946: /* Invoice number AND Gross Amount AND Due Date AND Supplier Name */
947: SELECT bank_collection_id
948: INTO bank_collection_id_s
949: FROM ap_payment_schedules apps,
950: jl_br_ap_collection_docs_ALL jlbl,
951: ap_invoices_ALL apinv
952: /* Bug # 635847 / 659227
953: ,
954: po_vendor_sites povs

Line 984: jl_br_ap_collection_docs_ALL jlbl,

980: /* AND Supplier Name */
981: SELECT bank_collection_id
982: INTO bank_collection_id_s
983: FROM ap_payment_schedules apps,
984: jl_br_ap_collection_docs_ALL jlbl,
985: ap_invoices_ALL apinv
986: /* Bug # 635847 / 659227
987: ,
988: po_vendor_sites povs

Line 1021: jl_br_ap_collection_docs_ALL jlbl,

1017: BEGIN
1018: SELECT bank_collection_id
1019: INTO bank_collection_id_s
1020: FROM ap_payment_schedules apps,
1021: jl_br_ap_collection_docs_ALL jlbl,
1022: ap_invoices_ALL apinv
1023: WHERE apps.invoice_id = invoice_id_e AND
1024: apps.payment_num = payment_num_e AND
1025: apps.org_id = jlbl.org_id AND --bug 14615620

Line 1050: jl_br_ap_collection_docs_ALL jlbl,

1046: IF x_selected = 'N' THEN
1047: SELECT bank_collection_id
1048: INTO bank_collection_id_s
1049: FROM ap_payment_schedules apps,
1050: jl_br_ap_collection_docs_ALL jlbl,
1051: ap_invoices_ALL apinv
1052: /* Bug # 635847 / 659227
1053: ,
1054: po_vendor_sites povs

Line 1086: jl_br_ap_collection_docs_ALL jlbl,

1082: BEGIN
1083: SELECT bank_collection_id
1084: INTO bank_collection_id_s
1085: FROM ap_payment_schedules apps,
1086: jl_br_ap_collection_docs_ALL jlbl,
1087: ap_invoices_ALL apinv
1088: WHERE apps.invoice_id = invoice_id_e AND
1089: apps.payment_num = payment_num_e AND
1090: apps.org_id = jlbl.org_id AND --bug 14615620

Line 1111: jl_br_ap_collection_docs_ALL jlbl,

1107: IF x_selected = 'N' THEN
1108: SELECT bank_collection_id
1109: INTO bank_collection_id_s
1110: FROM ap_payment_schedules apps,
1111: jl_br_ap_collection_docs_ALL jlbl,
1112: ap_invoices_ALL apinv
1113: WHERE apps.invoice_id = invoice_id_e AND
1114: apps.payment_num = payment_num_e AND
1115: apps.org_id = jlbl.org_id AND --bug 14615620

Line 1142: jl_br_ap_collection_docs_ALL jlbl,

1138: /* Gross Amount AND Due Date AND Supplier Site */
1139: SELECT bank_collection_id
1140: INTO bank_collection_id_s
1141: FROM ap_payment_schedules apps,
1142: jl_br_ap_collection_docs_ALL jlbl,
1143: ap_invoices_ALL apinv
1144: WHERE apps.invoice_id = invoice_id_e AND
1145: apps.payment_num = payment_num_e AND
1146: apps.org_id = jlbl.org_id AND --bug 14615620

Line 1168: jl_br_ap_collection_docs_ALL jlbl,

1164: /* Gross Amount AND Due Date AND Supplier Name */
1165: SELECT bank_collection_id
1166: INTO bank_collection_id_s
1167: FROM ap_payment_schedules apps,
1168: jl_br_ap_collection_docs_ALL jlbl,
1169: ap_invoices_ALL apinv
1170: /* Bug # 635847 / 659227
1171: ,
1172: po_vendor_sites povs

Line 1210: UPDATE jl_br_ap_collection_docs

1206: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1207: l_log_msg := 'Updated ap_payment_schedules global_attribute11 ' || bank_collection_id_s;
1208: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1209: END IF;
1210: UPDATE jl_br_ap_collection_docs
1211: SET invoice_id = invoice_id_e,
1212: payment_num = payment_num_e
1213: WHERE bank_collection_id = bank_collection_id_s;
1214: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1291: UPDATE jl_br_ap_collection_docs

1287: SET hold_flag = 'N'
1288: WHERE invoice_id = invoice_id_e
1289: AND payment_num = payment_num_e;
1290:
1291: UPDATE jl_br_ap_collection_docs
1292: SET hold_flag = 'N'
1293: WHERE bank_collection_id = bank_collection_id_s;
1294: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1295: l_log_msg := 'Updated hold to N in ar_payment_schedules, jl_br_ap_collection_docs';

Line 1295: l_log_msg := 'Updated hold to N in ar_payment_schedules, jl_br_ap_collection_docs';

1291: UPDATE jl_br_ap_collection_docs
1292: SET hold_flag = 'N'
1293: WHERE bank_collection_id = bank_collection_id_s;
1294: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1295: l_log_msg := 'Updated hold to N in ar_payment_schedules, jl_br_ap_collection_docs';
1296: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1297: END IF;
1298:
1299: ELSE /* If not associated and payment schedule not paid */