APPS.FV_SF224_TRANSACTIONS dependencies on AP_INVOICES_ALL

Line 33: g_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

29: g_sysdate DATE;
30:
31: g_payment_type_flag ap_checks_all.PAYMENT_TYPE_FLAG%TYPE;
32: g_check_void_date DATE;
33: g_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
34:
35: sob NUMBER;
36: error_code NUMBER;
37: error_buf VARCHAR2(2000);

Line 1984: ap_invoices_all ai,

1980: gl_code_combinations gcc,
1981: fv_report_definitions frd,
1982: fv_fund_parameters ffp,
1983: fv_treasury_symbols fts,
1984: ap_invoices_all ai,
1985: ap_invoice_distributions_all aid,
1986: ap_invoice_payments_all aip,
1987: ap_payment_hist_dists aphd,
1988: gl_import_references glir,

Line 2098: ap_invoices_all ai,

2094: gl_code_combinations gcc,
2095: fv_report_definitions frd,
2096: fv_fund_parameters ffp,
2097: fv_treasury_symbols fts,
2098: ap_invoices_all ai,
2099: ap_invoice_distributions_all aid,
2100: ap_invoice_payments_all aip,
2101: gl_import_references glir,
2102: xla_ae_headers xah,

Line 2190: ap_invoices_all ai,

2186: gl_code_combinations gcc,
2187: fv_report_definitions frd,
2188: fv_fund_parameters ffp,
2189: fv_treasury_symbols fts,
2190: ap_invoices_all ai,
2191: ap_invoice_distributions_all aid,
2192: ap_invoice_payments_all aip,
2193: gl_import_references glir,
2194: xla_ae_headers xah,

Line 3307: FROM ap_invoices_all

3303: -- get the document number
3304: BEGIN
3305: SELECT invoice_num
3306: INTO l_document_number
3307: FROM ap_invoices_all
3308: WHERE invoice_id = TO_NUMBER(l_reference_2);
3309: EXCEPTION WHEN NO_DATA_FOUND THEN
3310: SELECT SUBSTR(name,1,50)
3311: INTO l_document_number

Line 3325: FROM ap_invoices_all

3321: ELSE
3322: BEGIN
3323: SELECT 'Y', invoice_type_lookup_code
3324: INTO l_exists, g_invoice_type_lookup_code
3325: FROM ap_invoices_all
3326: WHERE invoice_id = to_number(l_REFERENCE_2) ;
3327: EXCEPTION
3328: when no_data_found then
3329: x_name := 'Invalid Invoice Id - ' || l_reference_2 ;

Line 3578: from AP_INVOICES_ALL

3574: Else
3575: Begin
3576: select 'Y'
3577: into l_exists
3578: from AP_INVOICES_ALL
3579: Where invoice_id = to_number(l_reference_4);
3580: Exception
3581: when no_data_found then
3582: x_name := 'Invalid Invoice Id - ' || l_reference_4 ;

Line 4090: ap_invoices_all api

4086: l_vendor_id,
4087: l_inv_amount,
4088: l_check_date
4089: FROM ap_checks_all apc,
4090: ap_invoices_all api
4091: WHERE api.invoice_id = NVL(l_reference, 0)
4092: AND apc.check_id = to_number(l_reference_3)
4093: AND l_payables_ia_paygroup = api.pay_group_lookup_code
4094: AND (apc.payment_method_lookup_code = 'CLEARING'

Line 4167: ap_invoices_all api

4163: apc.void_date
4164: INTO l_accomplish_date,
4165: l_void_date
4166: FROM ap_checks_all apc,
4167: ap_invoices_all api
4168: WHERE api.invoice_id = Nvl(l_reference, 0)
4169: AND apc.check_id = nvl(l_reference_3,0);
4170: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4171: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4325: FROM ap_invoices_all

4321: END IF;
4322: -- invoice_id
4323: SELECT invoice_date
4324: INTO l_invoice_date
4325: FROM ap_invoices_all
4326: WHERE Invoice_id = to_number (nvl(l_reference_4,'0')) ;
4327: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INVOICE DATE IS '||
4329: TO_CHAR(l_invoice_date, 'MM/DD/YYYY'));

Line 5337: l_parent_invoice_id ap_invoices_all.invoice_id%TYPE;

5333: RETURN DATE IS
5334: l_obligation_date DATE;
5335: l_module_name VARCHAR2(100);
5336: l_po_dist_id ap_invoice_distributions_all.po_distribution_id%TYPE;
5337: l_parent_invoice_id ap_invoices_all.invoice_id%TYPE;
5338: BEGIN
5339: l_module_name := g_module_name || 'get_void_check_obligation_date';
5340: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5341: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Start of get_void_check_obligation_date') ;

Line 5371: FROM ap_invoices_all

5367: END IF;
5368: ELSIF l_parent_invoice_id <> 0 THEN
5369: SELECT INVOICE_DATE
5370: INTO l_obligation_date
5371: FROM ap_invoices_all
5372: WHERE invoice_id = l_parent_invoice_id;
5373: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5375: 'Obligation Date is Parent Invoice Date => ' || l_obligation_date);

Line 5380: FROM ap_invoices_all

5376: END IF;
5377: ELSE
5378: SELECT INVOICE_DATE
5379: INTO l_obligation_date
5380: FROM ap_invoices_all
5381: WHERE invoice_id = p_invoice_id;
5382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5383: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5384: 'Obligation Date is Invoice Date => ' || l_obligation_date);

Line 5583: FROM ap_invoices_all

5579: DECODE(apid.parent_invoice_id,
5580: NULL,
5581: NULL,
5582: (SELECT invoice_date
5583: FROM ap_invoices_all
5584: WHERE invoice_id = apid.parent_invoice_id)),
5585: (SELECT NVL(gl_encumbered_date,creation_date)
5586: FROM po_distributions
5587: WHERE po_distribution_id = apid.po_distribution_id))

Line 5595: FROM ap_invoices_all

5591: DECODE(apid.parent_invoice_id,
5592: NULL,
5593: NULL,
5594: (SELECT invoice_num
5595: FROM ap_invoices_all
5596: WHERE invoice_id = apid.parent_invoice_id)),
5597: (SELECT segment1
5598: FROM po_headers
5599: WHERE po_header_id = (SELECT po_header_id

Line 5606: ap_invoices_all api,

5602: obligation_number
5603: FROM
5604: ap_checks_all apc,
5605: ap_invoice_payments_all apip,
5606: ap_invoices_all api,
5607: ap_invoice_distributions_all apid
5608: WHERE apip.set_of_books_id = l_set_of_books_id
5609: AND apip.set_of_books_id = api.set_of_books_id
5610: AND api.set_of_books_id = apid.set_of_books_id