APPS.AP_RETRO_PRICING_PKG dependencies on AP_PPA_INVOICES_GT

Line 4772: FROM ap_ppa_invoices_gt

4768: null,
4769: null,
4770: null,
4771: null
4772: FROM ap_ppa_invoices_gt
4773: WHERE instruction_id = p_instruction_id;
4774:
4775: ---
4776: CURSOR invoice_lines(

Line 5244: FROM ap_ppa_invoices_gt

5240: exclusive_payment_flag,
5241: FND_GLOBAL.user_id, --bugfix:4681253
5242: FND_GLOBAL.user_id, --bugfix:4681253
5243: batch_id
5244: FROM ap_ppa_invoices_gt
5245: WHERE instruction_id = p_instruction_id
5246: AND instr_status_flag = 'Y';
5247:
5248: l_ppa_invoice_id NUMBER;

Line 5647: FROM ap_ppa_invoices_gt

5643: TRX_BUSINESS_CATEGORY ,
5644: UNIQUE_REMITTANCE_IDENTIFIER ,
5645: URI_CHECK_DIGIT ,
5646: USER_DEFINED_FISC_CLASS
5647: FROM ap_ppa_invoices_gt
5648: WHERE instruction_id = p_instruction_id
5649: AND invoice_id = l_ppa_invoice_id
5650: AND instr_status_flag = 'Y';
5651: --

Line 6667: UPDATE AP_ppa_invoices_gt H

6663: AP_IMPORT_UTILITIES_PKG.Print(
6664: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
6665: END IF;
6666:
6667: UPDATE AP_ppa_invoices_gt H
6668: SET invoice_amount = AP_RETRO_PRICING_UTIL_PKG.get_invoice_amount(
6669: invoice_id,
6670: invoice_currency_code)
6671: WHERE instruction_id = p_instruction_rec.invoice_id;

Line 6745: UPDATE ap_ppa_invoices_gt

6741:
6742: p_instr_status_flag := l_instr_status_flag;
6743:
6744: IF l_instr_status_flag = 'Y' THEN
6745: UPDATE ap_ppa_invoices_gt
6746: SET instr_status_flag = 'Y'
6747: WHERE instruction_id = p_instruction_rec.invoice_id;
6748: ELSE
6749: UPDATE ap_ppa_invoices_gt

Line 6749: UPDATE ap_ppa_invoices_gt

6745: UPDATE ap_ppa_invoices_gt
6746: SET instr_status_flag = 'Y'
6747: WHERE instruction_id = p_instruction_rec.invoice_id;
6748: ELSE
6749: UPDATE ap_ppa_invoices_gt
6750: SET instr_status_flag = 'N'
6751: WHERE instruction_id = p_instruction_rec.invoice_id;
6752: END IF;
6753:

Line 6769: ||'ap_ppa_invoices_gt';

6765: -- need to create PPA invoice
6766: IF l_instr_status_flag = 'Y' THEN
6767: --
6768: debug_info := 'Import_Retroprice_Adjustments 8.1. delete from '
6769: ||'ap_ppa_invoices_gt';
6770: DELETE FROM ap_ppa_invoices_gt
6771: WHERE invoice_amount = 0
6772: AND instruction_id = p_instruction_rec.invoice_id
6773: RETURNING invoice_id

Line 6770: DELETE FROM ap_ppa_invoices_gt

6766: IF l_instr_status_flag = 'Y' THEN
6767: --
6768: debug_info := 'Import_Retroprice_Adjustments 8.1. delete from '
6769: ||'ap_ppa_invoices_gt';
6770: DELETE FROM ap_ppa_invoices_gt
6771: WHERE invoice_amount = 0
6772: AND instruction_id = p_instruction_rec.invoice_id
6773: RETURNING invoice_id
6774: BULK COLLECT INTO l_invoice_id_list;