DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1237: FROM ap_invoice_lines_all

1233: PRODUCT_TABLE ,
1234: REFERENCE_KEY1 ,
1235: REFERENCE_KEY2 ,
1236: RCV_SHIPMENT_LINE_ID
1237: FROM ap_invoice_lines_all
1238: WHERE invoice_id = p_existing_ppa_inv_id
1239: AND line_source = 'PO PRICE ADJUSTMENT'
1240: AND match_type = 'PO_PRICE_ADJUSTMENT'
1241: AND line_type_lookup_code = 'RETROITEM'

Line 4060: ||'AP_INVOICE_LINES_ALL';

4056: ||P_calling_sequence;
4057:
4058: ---------------------------------------------------------------------------
4059: debug_info := 'Insert_Zero_Amt_Adjustments Step 1. Insert into '
4060: ||'AP_INVOICE_LINES_ALL';
4061: ---------------------------------------------------------------------------
4062: INSERT INTO AP_INVOICE_LINES_ALL(
4063: invoice_id,
4064: line_number,

Line 4062: INSERT INTO AP_INVOICE_LINES_ALL(

4058: ---------------------------------------------------------------------------
4059: debug_info := 'Insert_Zero_Amt_Adjustments Step 1. Insert into '
4060: ||'AP_INVOICE_LINES_ALL';
4061: ---------------------------------------------------------------------------
4062: INSERT INTO AP_INVOICE_LINES_ALL(
4063: invoice_id,
4064: line_number,
4065: line_type_lookup_code,
4066: requester_id,

Line 5700: ||'AP_INVOICE_LINES_ALL ';

5696: p_calling_sequence =>current_calling_sequence);
5697: --
5698: ------------------------------------------------------------------------
5699: debug_info := 'Insert_Ppa_Invoices Step 5. Insert into '
5700: ||'AP_INVOICE_LINES_ALL ';
5701: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
5702: AP_IMPORT_UTILITIES_PKG.Print(
5703: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
5704: END IF;

Line 5711: INSERT INTO AP_INVOICE_LINES_ALL(

5707: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
5708: END IF;
5709:
5710: ------------------------------------------------------------------------
5711: INSERT INTO AP_INVOICE_LINES_ALL(
5712: invoice_id,
5713: line_number,
5714: line_type_lookup_code,
5715: requester_id,

Line 6216: from ap_invoice_lines_all

6212:
6213: -- Bug 5525506
6214: UPDATE ap_invoices_all
6215: set invoice_amount = (select sum(amount)
6216: from ap_invoice_lines_all
6217: where invoice_id = l_ppa_invoice_id)
6218: where invoice_id = l_ppa_invoice_id;
6219: --
6220: END LOOP;