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 68: FROM ap_payment_schedules_ALL apps,

64: END IF;
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

Line 91: FROM ap_payment_schedules_ALL apps,

87: END IF;
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: ,

Line 121: FROM ap_payment_schedules_ALL apps,

117: /* Supplier Site OR Supplier Name */
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

Line 146: FROM ap_payment_schedules_ALL apps,

142: END;
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: ,

Line 178: FROM ap_payment_schedules_ALL apps,

174: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
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

Line 203: FROM ap_payment_schedules_ALL apps,

199: END IF;
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: ,

Line 233: FROM ap_payment_schedules_ALL apps,

229: END IF;
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

Line 259: FROM ap_payment_schedules_ALL apps,

255: END IF;
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

Line 287: FROM ap_payment_schedules_ALL apps,

283: END IF;
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: ,

Line 321: FROM ap_payment_schedules_ALL apps,

317: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
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: ,

Line 358: FROM ap_payment_schedules_ALL apps,

354: /* AND Supplier Name */
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

Line 387: FROM ap_payment_schedules_ALL apps,

383: END;
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: ,

Line 423: FROM ap_payment_schedules_ALL apps,

419: /* Invoice number OR Gross Amount AND Due Date AND Supplier Site */
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

Line 448: FROM ap_payment_schedules_ALL apps,

444: END;
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

Line 479: FROM ap_payment_schedules_ALL apps,

475: END IF;
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

Line 505: FROM ap_payment_schedules_ALL apps,

501: END IF;
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: ,

Line 557: UPDATE ap_payment_schedules

553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
554: END IF;
555:
556: -- Bug Number 659227 / R11 Patch / May 98 (Copying Y to GA8)
557: UPDATE ap_payment_schedules
558: SET global_attribute11 = bank_collection_id_e,
559: global_attribute8 = 'Y'
560: WHERE invoice_id = invoice_id_s
561: AND payment_num = payment_num_s;

Line 563: l_log_msg := 'Updated ap_payment_schedules global_attribute11 ' || bank_collection_id_e;

559: global_attribute8 = 'Y'
560: WHERE invoice_id = invoice_id_s
561: AND payment_num = payment_num_s;
562: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
563: l_log_msg := 'Updated ap_payment_schedules global_attribute11 ' || bank_collection_id_e;
564: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
565: END IF;
566: associate_flag_s := 'Y';
567: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 624: UPDATE ap_payment_schedules

620: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
621: l_log_msg := 'associate_flag_s is Y';
622: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
623: END IF;
624: UPDATE ap_payment_schedules
625: SET hold_flag = 'N'
626: WHERE invoice_id = invoice_id_s
627: AND payment_num = payment_num_s;
628: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 629: l_log_msg := 'updated hold flag to N in ap_payment_schedules';

625: SET hold_flag = 'N'
626: WHERE invoice_id = invoice_id_s
627: AND payment_num = payment_num_s;
628: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
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

Line 689: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;

685: associate_flag_s IN OUT NOCOPY VARCHAR2 )
686: IS
687: x_enable_bank_coll ap_system_parameters.global_attribute1%TYPE;
688: x_enable_association ap_system_parameters.global_attribute2%TYPE;
689: x_payment_status_flag ap_payment_schedules.payment_status_flag%TYPE;
690: -- Logging Infra:
691: l_procedure_name CONSTANT VARCHAR2(30) := 'jl_br_ap_associate_trade_note';
692: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
693: -- Logging Infra:

Line 730: FROM ap_payment_schedules apps,

726: END IF;
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

Line 753: FROM ap_payment_schedules apps,

749: END IF;
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: ,

Line 783: FROM ap_payment_schedules apps,

779: /* Supplier Site OR Supplier Name */
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

Line 808: FROM ap_payment_schedules apps,

804: END;
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: ,

Line 840: FROM ap_payment_schedules apps,

836: END IF;
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

Line 865: FROM ap_payment_schedules apps,

861: END IF;
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: ,

Line 895: FROM ap_payment_schedules apps,

891: END IF;
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

Line 921: FROM ap_payment_schedules apps,

917: END IF;
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

Line 949: FROM ap_payment_schedules apps,

945: END IF;
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: ,

Line 983: FROM ap_payment_schedules apps,

979: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
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: ,

Line 1020: FROM ap_payment_schedules apps,

1016: /* AND Supplier Name */
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

Line 1049: FROM ap_payment_schedules apps,

1045: END;
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: ,

Line 1085: FROM ap_payment_schedules apps,

1081: /* Invoice number OR Gross Amount AND Due Date AND Supplier Site */
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

Line 1110: FROM ap_payment_schedules apps,

1106: END;
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

Line 1141: FROM ap_payment_schedules apps,

1137: END IF;
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

Line 1167: FROM ap_payment_schedules apps,

1163: END IF;
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: ,

Line 1201: UPDATE ap_payment_schedules

1197: END IF;
1198: END;
1199: IF x_selected = 'Y' THEN /* Create the link with two tables */
1200: -- Bug Number 659227 / R11 Patch / May 98 (Copying Y to GA8)
1201: UPDATE ap_payment_schedules
1202: SET global_attribute11 = bank_collection_id_s,
1203: global_attribute8 = 'Y'
1204: WHERE invoice_id = invoice_id_e AND
1205: payment_num = payment_num_e;

Line 1207: l_log_msg := 'Updated ap_payment_schedules global_attribute11 ' || bank_collection_id_s;

1203: global_attribute8 = 'Y'
1204: WHERE invoice_id = invoice_id_e AND
1205: payment_num = payment_num_e;
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,

Line 1286: UPDATE ap_payment_schedules

1282: l_log_msg := 'associate_flag_s is Y';
1283: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1284: END IF;
1285:
1286: UPDATE ap_payment_schedules
1287: SET hold_flag = 'N'
1288: WHERE invoice_id = invoice_id_e
1289: AND payment_num = payment_num_e;
1290:

Line 1307: FROM ap_payment_schedules

1303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1304: END IF;
1305: SELECT payment_status_flag
1306: INTO x_payment_status_flag
1307: FROM ap_payment_schedules
1308: WHERE invoice_id = invoice_id_e
1309: AND payment_num = payment_num_e;
1310:
1311: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1317: UPDATE ap_payment_schedules

1313: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1314: END IF;
1315:
1316: IF (x_payment_status_flag = 'N') THEN
1317: UPDATE ap_payment_schedules
1318: SET hold_flag = 'Y'
1319: WHERE invoice_id = invoice_id_e
1320: AND payment_num = payment_num_e;
1321: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1322: l_log_msg := 'x_payment_status_flag N, Updated hold_flag_s Y in ap_payment_schedules';

1318: SET hold_flag = 'Y'
1319: WHERE invoice_id = invoice_id_e
1320: AND payment_num = payment_num_e;
1321: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1322: l_log_msg := 'x_payment_status_flag N, Updated hold_flag_s Y in ap_payment_schedules';
1323: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1324: END IF;
1325: END IF;
1326: END IF;

Line 1328: UPDATE ap_payment_schedules

1324: END IF;
1325: END IF;
1326: END IF;
1327: ELSE /* If association not enabled, hold the payment schedule */
1328: UPDATE ap_payment_schedules
1329: SET hold_flag = 'Y'
1330: WHERE invoice_id = invoice_id_e
1331: AND payment_num = payment_num_e;
1332: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1333: l_log_msg := 'x_enable_association is N updated ap_payment_schedules hold flag to Y';

1329: SET hold_flag = 'Y'
1330: WHERE invoice_id = invoice_id_e
1331: AND payment_num = payment_num_e;
1332: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1333: l_log_msg := 'x_enable_association is N updated ap_payment_schedules hold flag to Y';
1334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1335: END IF;
1336:
1337: END IF;

Line 1339: UPDATE ap_payment_schedules

1335: END IF;
1336:
1337: END IF;
1338: ELSE /* If bank collection is not enabled, release the payment schedule */
1339: UPDATE ap_payment_schedules
1340: SET hold_flag = 'N'
1341: WHERE invoice_id = invoice_id_e
1342: AND payment_num = payment_num_e;
1343: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1344: l_log_msg := 'x_enable_bank_coll is N, updated ap_payment_schedules to N';

1340: SET hold_flag = 'N'
1341: WHERE invoice_id = invoice_id_e
1342: AND payment_num = payment_num_e;
1343: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1344: l_log_msg := 'x_enable_bank_coll is N, updated ap_payment_schedules to N';
1345: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1346: END IF;
1347:
1348: END IF;