APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on AP_INVOICES_ALL

Line 197: l_invoice_num ap_invoices_all.invoice_num%TYPE;

193: l_non_emp boolean; -- If Other Than Employee
194: l_inv_str VARCHAR2(30);
195: l_module_name VARCHAR2(200) := g_module_name || 'SUPPLIER_TYPE';
196: l_message VARCHAR2(1000);
197: l_invoice_num ap_invoices_all.invoice_num%TYPE;
198:
199:
200: BEGIN
201: x_error_code := g_SUCCESS;

Line 941: ap_invoices_all aia,

937: asup.vendor_type_lookup_code
938: INTO l_payment_reason_code,
939: l_vendor_type_lookup_code
940: FROM IBY_DOCS_PAYABLE_ALL idpa, -- added all
941: ap_invoices_all aia,
942: ap_suppliers asup
943: WHERE idpa.payment_id=p_payment_id
944: AND idpa.calling_app_doc_unique_ref2 = p_invoice_id
945: AND aia.invoice_id = p_invoice_id

Line 1433: FROM ap_invoices_all

1429: CURSOR get_pay_alone_flag_csr(p_invoice_id NUMBER)
1430: IS
1431: SELECT exclusive_payment_flag,
1432: invoice_num
1433: FROM ap_invoices_all
1434: WHERE
1435: invoice_id = p_invoice_id;
1436:
1437: l_pay_alone_flag VARCHAR2(1);

Line 1438: l_invoice_num ap_invoices_all.invoice_num%TYPE;

1434: WHERE
1435: invoice_id = p_invoice_id;
1436:
1437: l_pay_alone_flag VARCHAR2(1);
1438: l_invoice_num ap_invoices_all.invoice_num%TYPE;
1439: l_message VARCHAR2(1000);
1440: l_module_name VARCHAR2(200) := g_module_name || 'PAY_ALONE_OPTION';
1441:
1442: BEGIN

Line 1449: FETCH get_pay_alone_flag_csr into l_pay_alone_flag, l_invoice_num; -- Getting Pay ALone Flag From AP_INVOICES_ALL using invoice_id

1445: l_message := 'Validating Pay Alone Option, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id ;
1446: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1447:
1448: OPEN get_pay_alone_flag_csr(p_invoice_id);
1449: FETCH get_pay_alone_flag_csr into l_pay_alone_flag, l_invoice_num; -- Getting Pay ALone Flag From AP_INVOICES_ALL using invoice_id
1450: CLOSE get_pay_alone_flag_csr;
1451:
1452: IF (l_pay_alone_flag IS NULL ) or ( UPPER(l_pay_alone_flag) ='N') THEN
1453: x_error_mesg := 'Invoices for this payment format must be have the Pay Alone flag checked on the invoice ' || l_invoice_num || '.';

Line 1581: l_invoice_num ap_invoices_all.invoice_num%TYPE;

1577: )IS
1578:
1579: l_message VARCHAR2(1000);
1580: l_module_name VARCHAR2(200) := g_module_name || 'ACCOUNT_TYPE';
1581: l_invoice_num ap_invoices_all.invoice_num%TYPE;
1582:
1583: BEGIN
1584:
1585: x_error_code := g_SUCCESS;

Line 1592: from ap_invoices_all

1588: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1589:
1590: select invoice_num
1591: into l_invoice_num
1592: from ap_invoices_all
1593: where invoice_id = p_invoice_id;
1594:
1595:
1596: -- Valid values for bank account type are "CHECKINGS" - Checking account; "SAVINGS" - Savings account.