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.AP_AUTOSELECT_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 1360: ap_inv_selection_criteria_all aisc,

1356: (trunc(aps.due_date) + nvl(ipm.maturity_date_offset_days,0)) due_date -- Bug 5357689
1357: --Bug 543942 added NVL in the above scenario
1358: from ap_selected_invoices_all asi,
1359: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
1360: ap_inv_selection_criteria_all aisc,
1361: ap_payment_schedules_all aps,
1362: fv_tpp_assignments_v fv, --5017076
1363: iby_payment_methods_vl ipm -- Bug 5357689
1364: where asi.invoice_id = ai.invoice_id

Line 1469: from ap_inv_selection_criteria_all

1465:
1466: --5007819
1467: select nvl(zero_amounts_allowed,'N'), payment_profile_id
1468: into l_maximize_credits_flag, l_payment_profile_id -- Added for bug 9089243
1469: from ap_inv_selection_criteria_all
1470: where checkrun_id = p_checkrun_id;
1471:
1472: -- Added for bug 9089243
1473: if (l_payment_profile_id is not null) then

Line 1978: l_debug_info := 'insert into ap_inv_selection_criteria_all';

1974: from dual;
1975:
1976:
1977:
1978: l_debug_info := 'insert into ap_inv_selection_criteria_all';
1979: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1980: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1981: END IF;
1982:

Line 1983: insert into ap_inv_selection_criteria_all(

1979: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1980: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1981: END IF;
1982:
1983: insert into ap_inv_selection_criteria_all(
1984: check_date,
1985: pay_thru_date,
1986: hi_payment_priority,
1987: low_payment_priority,

Line 2554: ---if this is a repeating request call a procedure to insert into ap_inv_selection_criteria_all

2550: END IF;
2551:
2552:
2553:
2554: ---if this is a repeating request call a procedure to insert into ap_inv_selection_criteria_all
2555: --the hld says to validate the parameters, but this should probably be done
2556: --in the value sets or setup for the pay process request
2557:
2558:

Line 2709: FROM ap_inv_selection_criteria_all

2705: l_ATTRIBUTE12,
2706: l_ATTRIBUTE13,
2707: l_ATTRIBUTE14,
2708: l_ATTRIBUTE15
2709: FROM ap_inv_selection_criteria_all
2710: WHERE checkrun_id = l_checkrun_id
2711: AND status = 'UNSTARTED';
2712:
2713: EXCEPTION

Line 2729: UPDATE ap_inv_selection_criteria_all

2725: END IF;
2726: Commented for bug#12773508 End */
2727:
2728: /* Bug 9750106 - updating check_date and pay_thru_date as done in bug6764140 */
2729: UPDATE ap_inv_selection_criteria_all
2730: set status = 'SELECTING',
2731: check_date = TRUNC(check_date),
2732: pay_thru_date = TRUNC(pay_thru_date),
2733: -- Bug 7492768 We need to reset the inv_awt_exists_flag which indicates if the

Line 4859: update ap_inv_selection_criteria_all

4855: --need to pause the request if payables options requires exchange rates
4856: --and none were found or we are using 'user'exchange rate type
4857:
4858: if l_missing_rates_count > 0 then
4859: update ap_inv_selection_criteria_all
4860: set status = 'MISSING RATES'
4861: where checkrun_id = l_checkrun_id;
4862:
4863: if l_batch_exchange_rate_type = 'User' then

Line 5045: from ap_inv_selection_criteria_all

5041: inv_awt_exists_flag
5042: into l_doc_rejection_level_code,
5043: l_pay_rejection_level_code,
5044: l_inv_awt_exists_flag
5045: from ap_inv_selection_criteria_all
5046: where checkrun_id = l_checkrun_id;
5047:
5048:
5049: --Start bug12349626

Line 5110: update ap_inv_selection_criteria_all

5106:
5107:
5108: if l_count_inv_selected = 0 then
5109:
5110: update ap_inv_selection_criteria_all
5111: set status = 'CANCELLED NO PAYMENTS'
5112: where checkrun_id = l_checkrun_id;
5113:
5114: commit;

Line 5170: update ap_inv_selection_criteria_all

5166:
5167:
5168:
5169:
5170: update ap_inv_selection_criteria_all
5171: set status = decode(l_payables_review_settings,'Y','REVIEW','SELECTED')
5172: where status = 'SELECTING'
5173: and checkrun_id = l_checkrun_id;
5174:

Line 5227: from ap_inv_selection_criteria_all

5223: chr(0));
5224:
5225: select status
5226: into l_batch_status
5227: from ap_inv_selection_criteria_all
5228: where checkrun_id = l_checkrun_id;
5229:
5230: if l_batch_status = 'SELECTED' and l_payables_review_settings <> 'Y' then
5231:

Line 5279: /* Bug 11063950 : Populated Request_id in ap_inv_selection_criteria_all */

5275: l_debug_info := 'request_id ='||to_char(l_req_id);
5276: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5277: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5278: END IF;
5279: /* Bug 11063950 : Populated Request_id in ap_inv_selection_criteria_all */
5280: update ap_inv_selection_criteria_all
5281: set request_id = l_req_id
5282: where checkrun_id = l_checkrun_id;
5283: end if;

Line 5280: update ap_inv_selection_criteria_all

5276: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5277: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
5278: END IF;
5279: /* Bug 11063950 : Populated Request_id in ap_inv_selection_criteria_all */
5280: update ap_inv_selection_criteria_all
5281: set request_id = l_req_id
5282: where checkrun_id = l_checkrun_id;
5283: end if;
5284:

Line 5316: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;-- bug# 6643035

5312: p_checkrun_id in varchar2,
5313: p_submit_to_iby in varchar2 default 'N') is
5314:
5315: l_debug_info varchar2(2000);
5316: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;-- bug# 6643035
5317: l_check_date date;
5318: l_bank_account_id number; --4710933
5319: l_payment_profile_id number;
5320: l_req_id number;

Line 5499: FROM ap_inv_selection_criteria_all

5495: l_ATTRIBUTE13,
5496: l_ATTRIBUTE14,
5497: l_ATTRIBUTE15
5498: /*bug 7519277*/
5499: FROM ap_inv_selection_criteria_all
5500: WHERE checkrun_id = p_checkrun_id;
5501:
5502:
5503:

Line 5555: update ap_inv_selection_criteria_all

5551: where checkrun_id = p_checkrun_id;
5552:
5553: -- Bug 7492768 We need to reset the inv_awt_exists_flag which indicates if the
5554: -- check run contains invoice that has awt.
5555: update ap_inv_selection_criteria_all
5556: set inv_awt_exists_flag = 'N'
5557: where checkrun_id = p_checkrun_id;
5558:
5559: --redo interest

Line 5648: update ap_inv_selection_criteria_all

5644:
5645:
5646: if l_missing_rates_count > 0 then
5647:
5648: update ap_inv_selection_criteria_all
5649: set status = 'MISSING RATES'
5650: where checkrun_id = p_checkrun_id;
5651:
5652: if l_batch_exchange_rate_type = 'User' then

Line 5795: from ap_inv_selection_criteria_all

5791: this avoids running the update on asi unless necessary */
5792:
5793: Select inv_awt_exists_flag
5794: into l_inv_awt_exists_flag
5795: from ap_inv_selection_criteria_all
5796: WHERE checkrun_id = p_checkrun_id;
5797:
5798: l_debug_info := 'Recalculate: restoring affects_rejection_level data';
5799: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5838: FROM ap_inv_selection_criteria_all

5834: decode(nvl(inv_awt_exists_flag, 'N'), 'Y', decode(payment_rejection_level_code,'REQUEST',payment_rejection_level_code,'PAYEE'), payment_rejection_level_code) payment_rejection_level_code
5835: --Bug 8746215 End
5836: into l_doc_rejection_level_code,
5837: l_pay_rejection_level_code
5838: FROM ap_inv_selection_criteria_all
5839: WHERE checkrun_id = p_checkrun_id;
5840: -- Bug 7492768 End
5841:
5842: End of bug12349626 */

Line 5918: update ap_inv_selection_criteria_all

5914:
5915:
5916: if l_missing_rates_count > 0 then
5917:
5918: update ap_inv_selection_criteria_all
5919: set status = 'MISSING RATES'
5920: where checkrun_id = p_checkrun_id;
5921:
5922: if l_batch_exchange_rate_type = 'User' then

Line 6000: from ap_inv_selection_criteria_all

5996:
5997:
5998: select status
5999: into l_batch_status
6000: from ap_inv_selection_criteria_all
6001: where checkrun_id = p_checkrun_id;
6002:
6003:
6004:

Line 6009: update ap_inv_selection_criteria_all

6005:
6006:
6007: if p_submit_to_iby = 'Y' and l_batch_status = 'CALCULATING' then
6008:
6009: update ap_inv_selection_criteria_all
6010: set status = 'SELECTED'
6011: where checkrun_id = p_checkrun_id;
6012:
6013: SELECT lower(iso_language),iso_territory

Line 6104: update ap_inv_selection_criteria_all

6100: chr(0));
6101: --4676790
6102: elsif p_submit_to_iby = 'N' and l_batch_status = 'CALCULATING' then
6103:
6104: update ap_inv_selection_criteria_all
6105: set status = 'REVIEW'
6106: where checkrun_id = p_checkrun_id;
6107:
6108: end if;

Line 6139: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;-- bug# 6643035

6135: p_checkrun_id in varchar2) is
6136:
6137: l_debug_info varchar2(2000);
6138: l_current_calling_sequence varchar2(2000);
6139: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;-- bug# 6643035
6140: l_psr_id number;
6141: l_return_status varchar2(1);
6142: l_fd_count NUMBER; /* Bug 14336393 */
6143: excp_return_success EXCEPTION;

Line 6151: from ap_inv_selection_criteria_all

6147: l_current_calling_sequence := 'ap_autoselect_pkg.cancel_batch';
6148:
6149: select checkrun_name
6150: into l_checkrun_name
6151: from ap_inv_selection_criteria_all
6152: where checkrun_id = p_checkrun_id;
6153:
6154:
6155: begin

Line 6198: update ap_inv_selection_criteria_all

6194: RAISE excp_return_success;
6195: end if;
6196: end if;
6197:
6198: update ap_inv_selection_criteria_all
6199: set status = 'CANCELING'
6200: where checkrun_id = p_checkrun_id;
6201:
6202: /* commit; Commenting out as it is not required at this stage Bug 14336393 */

Line 6235: update ap_inv_selection_criteria_all

6231: update ap_payment_schedules_all
6232: set checkrun_id = null
6233: where checkrun_id = p_checkrun_id;
6234:
6235: update ap_inv_selection_criteria_all
6236: set status = 'CANCELED' --seeded with one L
6237: where checkrun_id = p_checkrun_id;
6238:
6239: end if;

Line 6274: l_debug_info:= 'select from ap_inv_selection_criteria_all';

6270:
6271: begin
6272:
6273: l_current_calling_sequence := 'ap_autoselect_pkg.selection_criteria_report';
6274: l_debug_info:= 'select from ap_inv_selection_criteria_all';
6275:
6276: fnd_file.put_line(fnd_file.output, '');
6277:
6278: l_qryCtx := DBMS_XMLGEN.newContext(

Line 6286: from ap_inv_selection_criteria_all aisc,

6282: aisc.zero_invoices_allowed, ab.batch_name,
6283: vndr.meaning supplier_type, hz.party_name,
6284: iby.payment_method_name, rate.displayed_field document_exchange_rate_type,
6285: apt.template_name
6286: from ap_inv_selection_criteria_all aisc,
6287: ap_batches_all ab,
6288: iby_payment_methods_vl iby,
6289: fnd_lookups vndr,
6290: hz_parties hz,