[Home] [Help]
100: l_check_id number;
101:
102: cursor checks_to_assign_vouchers is
103: select check_id
104: from ap_checks_all
105: where completed_pmts_group_id = p_completed_pmts_group_id
106: and org_id = p_current_org_id;
107:
108:
124: loop
125: fetch checks_to_assign_vouchers into l_check_id;
126: exit when checks_to_assign_vouchers%notfound;
127:
128: update ap_checks_all
129: set check_voucher_num = l_next_voucher_number
130: where check_id = l_check_id;
131:
132: l_next_voucher_number := l_next_voucher_number + 1;
160:
161: CURSOR C_INTEREST_INVOICES IS
162: SELECT i.invoice_id
163: FROM ap_invoice_payments_all aip,
164: ap_checks_all c,
165: ap_invoices_all i,
166: ap_invoice_relationships ir
167: WHERE c.check_id = p_check_id
168: AND c.check_id = aip.check_id
246: select ac.check_id,
247: ac.payment_document_id,
248: ac.payment_method_code,
249: ac.ce_bank_acct_use_id
250: from ap_checks_all ac,
251: iby_payment_profiles ipp
252: where completed_pmts_group_id = p_completed_pmts_group_id
253: and ipp.payment_profile_id = ac.payment_profile_id
254: and ac.org_id = p_current_org_id;
460: return;
461:
462: elsif l_return_code = 0 then
463:
464: update ap_checks_all
465: set doc_sequence_id = l_dbseqid,
466: doc_sequence_value = l_seqval,
467: doc_category_code = l_doc_category_code
468: where check_id = l_check_id;
686: l_perform_awt_flag varchar2(1);
687: l_set_of_books_id number;
688: l_interest_invoice_count number;
689: l_checkrun_id number;
690: l_checkrun_name ap_checks_all.checkrun_name%type;
691: l_exchange_rate_type varchar2(30);
692: l_transfer_priority varchar2(25);
693: l_check_date date;
694: l_current_org_id number;
756: -- Added for Payment Request
757: CURSOR c_subscribed_payments IS
758: SELECT Distinct AC.Check_ID,
759: APR.Reg_Application_ID
760: FROM AP_Checks_All AC,
761: AP_Invoice_Payments_All AIP,
762: AP_Invoices_All AI,
763: AP_Product_Registrations APR
764: WHERE AC.Checkrun_Name = l_checkrun_name
1505:
1506: END if; --if auto_calculate_interest_flag = 'Y'
1507:
1508:
1509: /*bug8224330, transported the insert into ap_checks_all here, after the insertion of interest invoices related data
1510: into ap tables*/
1511:
1512: l_debug_info := 'insert into ap_checks_all';
1513: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1508:
1509: /*bug8224330, transported the insert into ap_checks_all here, after the insertion of interest invoices related data
1510: into ap tables*/
1511:
1512: l_debug_info := 'insert into ap_checks_all';
1513: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1515: END IF;
1516:
1514: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1515: END IF;
1516:
1517:
1518: INSERT INTO ap_checks_all
1519: (CHECK_ID,
1520: -- Bug 6845440 commented below field
1521: -- BANK_ACCOUNT_ID,
1522: CE_BANK_ACCT_USE_ID,
2128: ap_selected_invoices_all SI,
2129: fnd_currencies FORE,
2130: ap_payment_schedules_all PS,
2131: ap_invoices_all AI,
2132: ap_checks_all ac,
2133: ap_supplier_sites_all aps, -- bug 7673570
2134: ce_bank_acct_uses_all ceu,
2135: ce_gl_accounts_ccid cegl,
2136: XLA_EVENTS_INT_GT xeg
2805: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2806: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2807: END IF;
2808:
2809: update ap_checks_all
2810: set status_lookup_code = 'STOP INITIATED',
2811: stopped_date= p_stopped_date, -- Bug 6957071
2812: stopped_by= p_stopped_by -- Bug 6957071
2813: where payment_id = p_payment_id;
2844: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2845: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2846: END IF;
2847:
2848: update ap_checks_all
2849: set status_lookup_code = 'NEGOTIABLE',
2850: stopped_date=null, -- Bug 6957071
2851: stopped_by=null -- Bug 6957071
2852: where payment_id = p_payment_id;