APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on AP_INVOICES_ALL

Line 199: l_invoice_num ap_invoices_all.invoice_num%TYPE;

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

Line 1449: l_invoice_num ap_invoices_all.invoice_num%TYPE;

1445: AND calling_app_id=200
1446: AND UPPER(payment_function) IN ('PAYABLES_DISB','EMPLOYEE_EXP');
1447:
1448: l_pay_alone_flag VARCHAR2(1);
1449: l_invoice_num ap_invoices_all.invoice_num%TYPE;
1450: l_message VARCHAR2(1000);
1451: l_module_name VARCHAR2(200) := g_module_name || 'PAY_ALONE_OPTION';
1452:
1453: BEGIN

Line 1460: 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

1456: l_message := 'Validating Pay Alone Option, Parameters: p_format_name = ' || p_format_name || ', p_invoice_id = ' || p_invoice_id ;
1457: log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_message);
1458:
1459: OPEN get_pay_alone_flag_csr(p_invoice_id, p_payment_id);
1460: 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
1461: CLOSE get_pay_alone_flag_csr;
1462:
1463: IF (l_pay_alone_flag IS NULL ) or ( UPPER(l_pay_alone_flag) ='N') THEN
1464: x_error_mesg := 'Invoices for this payment format must be have the Pay Alone flag checked on the invoice ' || l_invoice_num || '.';

Line 1593: l_invoice_num ap_invoices_all.invoice_num%TYPE;

1589: )IS
1590:
1591: l_message VARCHAR2(1000);
1592: l_module_name VARCHAR2(200) := g_module_name || 'ACCOUNT_TYPE';
1593: l_invoice_num ap_invoices_all.invoice_num%TYPE;
1594:
1595: BEGIN
1596:
1597: x_error_code := g_SUCCESS;