APPS.AP_RETRO_PRICING_PKG dependencies on AP_PPA_INVOICES_GT

Line 5091: FROM ap_ppa_invoices_gt

5087: ,null --PREPAY_PERIOD_NAME
5088: ,null --PREPAY_INV_ID
5089: ,null --PREPAY_CASE_NAME
5090: --bug 16092065 ends
5091: FROM ap_ppa_invoices_gt
5092: WHERE instruction_id = p_instruction_id;
5093:
5094: ---
5095: CURSOR invoice_lines(

Line 5438: UPDATE ap_ppa_invoices_gt

5434: ---------------------------------------------------------------------
5435:
5436: IF( l_invoice_header_rec.EXCHANGE_RATE IS NOT NULL) THEN
5437:
5438: UPDATE ap_ppa_invoices_gt
5439: set exchange_rate = l_invoice_header_rec.EXCHANGE_RATE
5440: where invoice_id = l_invoice_header_rec.invoice_id
5441: and exchange_rate is null
5442: and exchange_rate_type <> 'User';

Line 5599: FROM ap_ppa_invoices_gt

5595: FND_GLOBAL.user_id, --bugfix:4681253
5596: FND_GLOBAL.user_id, --bugfix:4681253
5597: batch_id,
5598: org_id
5599: FROM ap_ppa_invoices_gt
5600: WHERE instruction_id = p_instruction_id
5601: AND instr_status_flag = 'Y';
5602:
5603: l_ppa_invoice_id NUMBER;

Line 6105: FROM ap_ppa_invoices_gt

6101: USER_DEFINED_FISC_CLASS,
6102: l_doc_category_code,
6103: l_doc_sequence_id,
6104: l_doc_sequence_value
6105: FROM ap_ppa_invoices_gt
6106: WHERE instruction_id = p_instruction_id
6107: AND invoice_id = l_ppa_invoice_id
6108: AND instr_status_flag = 'Y';
6109: --

Line 7161: UPDATE AP_ppa_invoices_gt H

7157: AP_IMPORT_UTILITIES_PKG.Print(
7158: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
7159: END IF;
7160:
7161: UPDATE AP_ppa_invoices_gt H
7162: SET invoice_amount = AP_RETRO_PRICING_UTIL_PKG.get_invoice_amount(
7163: invoice_id,
7164: invoice_currency_code)
7165: WHERE instruction_id = p_instruction_rec.invoice_id;

Line 7239: UPDATE ap_ppa_invoices_gt

7235:
7236: p_instr_status_flag := l_instr_status_flag;
7237:
7238: IF l_instr_status_flag = 'Y' THEN
7239: UPDATE ap_ppa_invoices_gt
7240: SET instr_status_flag = 'Y'
7241: WHERE instruction_id = p_instruction_rec.invoice_id;
7242: ELSE
7243: UPDATE ap_ppa_invoices_gt

Line 7243: UPDATE ap_ppa_invoices_gt

7239: UPDATE ap_ppa_invoices_gt
7240: SET instr_status_flag = 'Y'
7241: WHERE instruction_id = p_instruction_rec.invoice_id;
7242: ELSE
7243: UPDATE ap_ppa_invoices_gt
7244: SET instr_status_flag = 'N'
7245: WHERE instruction_id = p_instruction_rec.invoice_id;
7246: END IF;
7247:

Line 7263: ||'ap_ppa_invoices_gt';

7259: -- need to create PPA invoice
7260: IF l_instr_status_flag = 'Y' THEN
7261: --
7262: debug_info := 'Import_Retroprice_Adjustments 8.1. delete from '
7263: ||'ap_ppa_invoices_gt';
7264: DELETE FROM ap_ppa_invoices_gt apig
7265: WHERE instruction_id = p_instruction_rec.invoice_id
7266: --bug#9573078
7267: --AND invoice_amount = 0

Line 7264: DELETE FROM ap_ppa_invoices_gt apig

7260: IF l_instr_status_flag = 'Y' THEN
7261: --
7262: debug_info := 'Import_Retroprice_Adjustments 8.1. delete from '
7263: ||'ap_ppa_invoices_gt';
7264: DELETE FROM ap_ppa_invoices_gt apig
7265: WHERE instruction_id = p_instruction_rec.invoice_id
7266: --bug#9573078
7267: --AND invoice_amount = 0
7268: AND NOT EXISTS (select 'No lines'

Line 7448: from ap_ppa_invoices_gt apig

7444: FROM ap_ppa_invoice_lines_gt apilg
7445: WHERE apilg.instruction_id = p_instruction_rec.invoice_id
7446: --Bug:9926348 added NOT exists to exclude PPA invoice
7447: and not exists (select apig.invoice_id
7448: from ap_ppa_invoices_gt apig
7449: where apig.invoice_id = apilg.invoice_id))
7450: loop
7451:
7452: AP_Accounting_Events_Pkg.Create_Events(

Line 7687: FROM ap_ppa_invoices_gt apig

7683:
7684: --Bug#16022947. Update total_tax_amount, self_assessed_tax_amount
7685: --on new PPA invoices
7686: FOR invs in(SELECT distinct invoice_id
7687: FROM ap_ppa_invoices_gt apig
7688: WHERE apig.instruction_id = p_instruction_rec.invoice_id)
7689: LOOP
7690: /*Bug 16450538 Start*/
7691: SELECT NVL(sum(NVL(ail.amount,0)),0)

Line 7741: from ap_ppa_invoices_gt apig

7737: FOR invs in( SELECT distinct invoice_id
7738: FROM ap_ppa_invoice_lines_gt apilg
7739: WHERE apilg.instruction_id = p_instruction_rec.invoice_id
7740: and not exists (select invoice_id
7741: from ap_ppa_invoices_gt apig
7742: where apig.invoice_id = apilg.invoice_id))
7743: LOOP
7744:
7745: AP_Accounting_Events_Pkg.Create_Events(