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 969: ap_inv_selection_criteria_all aisc,

965: (trunc(aps.due_date) + nvl(ipm.maturity_date_offset_days,0)) due_date -- Bug 5357689
966: --Bug 543942 added NVL in the above scenario
967: from ap_selected_invoices_all asi,
968: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
969: ap_inv_selection_criteria_all aisc,
970: ap_payment_schedules_all aps,
971: fv_tpp_assignments_v fv, --5017076
972: iby_payment_methods_vl ipm -- Bug 5357689
973: where asi.invoice_id = ai.invoice_id

Line 1073: from ap_inv_selection_criteria_all

1069:
1070: --5007819
1071: select nvl(zero_amounts_allowed,'N')
1072: into l_maximize_credits_flag
1073: from ap_inv_selection_criteria_all
1074: where checkrun_id = p_checkrun_id;
1075:
1076: l_debug_info := 'group all documents';
1077: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1377: from dual;
1378:
1379:
1380:
1381: l_debug_info := 'insert into ap_inv_selection_criteria_all';
1382: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1383: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1384: END IF;
1385:

Line 1386: insert into ap_inv_selection_criteria_all(

1382: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1383: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
1384: END IF;
1385:
1386: insert into ap_inv_selection_criteria_all(
1387: check_date,
1388: pay_thru_date,
1389: hi_payment_priority,
1390: low_payment_priority,

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

2469: END IF;
2470:
2471:
2472:
2473: ---if this is a repeating request call a procedure to insert into ap_inv_selection_criteria_all
2474: --the hld says to validate the parameters, but this should probably be done
2475: --in the value sets or setup for the pay process request
2476:
2477:

Line 2613: FROM ap_inv_selection_criteria_all

2609: l_ATTRIBUTE12,
2610: l_ATTRIBUTE13,
2611: l_ATTRIBUTE14,
2612: l_ATTRIBUTE15
2613: FROM ap_inv_selection_criteria_all
2614: WHERE checkrun_id = l_checkrun_id
2615: AND status = 'UNSTARTED';
2616:
2617: EXCEPTION

Line 2624: UPDATE ap_inv_selection_criteria_all

2620: raise SELECTION_FAILURE;
2621: END;
2622:
2623:
2624: UPDATE ap_inv_selection_criteria_all
2625: set status = 'SELECTING',
2626: -- Bug 7492768 We need to reset the inv_awt_exists_flag which indicates if the
2627: -- check run contains invoice that has awt.
2628: inv_awt_exists_flag = 'N'

Line 3714: from ap_inv_selection_criteria_all

3710: inv_awt_exists_flag
3711: into l_doc_rejection_level_code,
3712: l_pay_rejection_level_code,
3713: l_inv_awt_exists_flag
3714: from ap_inv_selection_criteria_all
3715: where checkrun_id = l_checkrun_id;
3716:
3717: IF NVL(l_inv_awt_exists_flag, 'N') = 'Y' THEN
3718: l_doc_rejection_level_code := 'REQUEST';

Line 3801: update ap_inv_selection_criteria_all

3797: --need to pause the request if payables options requires exchange rates
3798: --and none were found or we are using 'user'exchange rate type
3799:
3800: if l_missing_rates_count > 0 then
3801: update ap_inv_selection_criteria_all
3802: set status = 'MISSING RATES'
3803: where checkrun_id = l_checkrun_id;
3804:
3805: if l_batch_exchange_rate_type = 'User' then

Line 3864: update ap_inv_selection_criteria_all

3860:
3861:
3862: if l_count_inv_selected = 0 then
3863:
3864: update ap_inv_selection_criteria_all
3865: set status = 'CANCELLED NO PAYMENTS'
3866: where checkrun_id = l_checkrun_id;
3867:
3868: commit;

Line 3924: update ap_inv_selection_criteria_all

3920:
3921:
3922:
3923:
3924: update ap_inv_selection_criteria_all
3925: set status = decode(l_payables_review_settings,'Y','REVIEW','SELECTED')
3926: where status = 'SELECTING'
3927: and checkrun_id = l_checkrun_id;
3928:

Line 3966: from ap_inv_selection_criteria_all

3962: chr(0));
3963:
3964: select status
3965: into l_batch_status
3966: from ap_inv_selection_criteria_all
3967: where checkrun_id = l_checkrun_id;
3968:
3969: if l_batch_status = 'SELECTED' and l_payables_review_settings <> 'Y' then
3970:

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

4048: p_checkrun_id in varchar2,
4049: p_submit_to_iby in varchar2 default 'N') is
4050:
4051: l_debug_info varchar2(2000);
4052: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;-- bug# 6643035
4053: l_check_date date;
4054: l_bank_account_id number; --4710933
4055: l_payment_profile_id number;
4056: l_req_id number;

Line 4203: FROM ap_inv_selection_criteria_all

4199: l_ATTRIBUTE13,
4200: l_ATTRIBUTE14,
4201: l_ATTRIBUTE15
4202: /*bug 7519277*/
4203: FROM ap_inv_selection_criteria_all
4204: WHERE checkrun_id = p_checkrun_id;
4205:
4206:
4207:

Line 4250: update ap_inv_selection_criteria_all

4246: where checkrun_id = p_checkrun_id;
4247:
4248: -- Bug 7492768 We need to reset the inv_awt_exists_flag which indicates if the
4249: -- check run contains invoice that has awt.
4250: update ap_inv_selection_criteria_all
4251: set inv_awt_exists_flag = 'N'
4252: where checkrun_id = p_checkrun_id;
4253:
4254:

Line 4282: FROM ap_inv_selection_criteria_all

4278: select decode(nvl(inv_awt_exists_flag, 'N'), 'Y', 'REQUEST', document_rejection_level_code) document_rejection_level_code,
4279: decode(nvl(inv_awt_exists_flag, 'N'), 'Y', 'REQUEST', payment_rejection_level_code) payment_rejection_level_code
4280: into l_doc_rejection_level_code,
4281: l_pay_rejection_level_code
4282: FROM ap_inv_selection_criteria_all
4283: WHERE checkrun_id = p_checkrun_id;
4284: -- Bug 7492768 End
4285:
4286: --regroup

Line 4362: update ap_inv_selection_criteria_all

4358:
4359:
4360: if l_missing_rates_count > 0 then
4361:
4362: update ap_inv_selection_criteria_all
4363: set status = 'MISSING RATES'
4364: where checkrun_id = p_checkrun_id;
4365:
4366: if l_batch_exchange_rate_type = 'User' then

Line 4444: from ap_inv_selection_criteria_all

4440:
4441:
4442: select status
4443: into l_batch_status
4444: from ap_inv_selection_criteria_all
4445: where checkrun_id = p_checkrun_id;
4446:
4447:
4448:

Line 4453: update ap_inv_selection_criteria_all

4449:
4450:
4451: if p_submit_to_iby = 'Y' and l_batch_status = 'CALCULATING' then
4452:
4453: update ap_inv_selection_criteria_all
4454: set status = 'SELECTED'
4455: where checkrun_id = p_checkrun_id;
4456:
4457: SELECT lower(iso_language),iso_territory

Line 4532: update ap_inv_selection_criteria_all

4528: chr(0));
4529: --4676790
4530: elsif p_submit_to_iby = 'N' and l_batch_status = 'CALCULATING' then
4531:
4532: update ap_inv_selection_criteria_all
4533: set status = 'REVIEW'
4534: where checkrun_id = p_checkrun_id;
4535:
4536: end if;

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

4563: p_checkrun_id in varchar2) is
4564:
4565: l_debug_info varchar2(2000);
4566: l_current_calling_sequence varchar2(2000);
4567: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;-- bug# 6643035
4568: l_psr_id number;
4569: l_return_status varchar2(1);
4570:
4571: begin

Line 4577: from ap_inv_selection_criteria_all

4573: l_current_calling_sequence := 'ap_autoselect_pkg.cancel_batch';
4574:
4575: select checkrun_name
4576: into l_checkrun_name
4577: from ap_inv_selection_criteria_all
4578: where checkrun_id = p_checkrun_id;
4579:
4580:
4581: begin

Line 4601: update ap_inv_selection_criteria_all

4597: l_return_status);
4598:
4599: else
4600:
4601: update ap_inv_selection_criteria_all
4602: set status = 'CANCELING'
4603: where checkrun_id = p_checkrun_id;
4604:
4605: commit;

Line 4638: update ap_inv_selection_criteria_all

4634: update ap_payment_schedules_all
4635: set checkrun_id = null
4636: where checkrun_id = p_checkrun_id;
4637:
4638: update ap_inv_selection_criteria_all
4639: set status = 'CANCELED' --seeded with one L
4640: where checkrun_id = p_checkrun_id;
4641:
4642: end if;

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

4670:
4671: begin
4672:
4673: l_current_calling_sequence := 'ap_autoselect_pkg.selection_criteria_report';
4674: l_debug_info:= 'select from ap_inv_selection_criteria_all';
4675:
4676: fnd_file.put_line(fnd_file.output, '');
4677:
4678: l_qryCtx := DBMS_XMLGEN.newContext(

Line 4686: from ap_inv_selection_criteria_all aisc,

4682: aisc.zero_invoices_allowed, ab.batch_name,
4683: vndr.meaning supplier_type, hz.party_name,
4684: iby.payment_method_name, rate.displayed_field document_exchange_rate_type,
4685: apt.template_name
4686: from ap_inv_selection_criteria_all aisc,
4687: ap_batches_all ab,
4688: iby_payment_methods_vl iby,
4689: fnd_lookups vndr,
4690: hz_parties hz,