[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select regime_id
from JAI_RGM_DEFINITIONS
where regime_code = jai_constants.service_regime;
FUNCTION update_payment_schedule (p_total_tax NUMBER, p_invoice_id NUMBER, p_precision NUMBER) RETURN boolean IS
v_total_tax_in_payment number;
select sum(gross_amount)
from ap_payment_schedules_all
where invoice_id = p_invoice_id;
l_api_name CONSTANT VARCHAR2(30) := 'update_payment_schedule';
Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');
Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
|| to_char(v_total_payment_amt));
select gross_amount,
payment_num
from ap_payment_schedules_all
where invoice_id = p_invoice_id
order by payment_num
)
loop
v_tax_installment := 0;
update ap_payment_schedules_all
set gross_amount = gross_amount + v_tax_installment,
amount_remaining = amount_remaining + v_tax_installment,
inv_curr_gross_amount = inv_curr_gross_amount + v_tax_installment,
payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)
where invoice_id = p_invoice_id
and payment_num = v_payment_num;
update ap_payment_schedules_all
set gross_amount = gross_amount + v_diff_tax_amount,
amount_remaining = amount_remaining + v_diff_tax_amount,
inv_curr_gross_amount = inv_curr_gross_amount + v_diff_tax_amount
where invoice_id = p_invoice_id
and payment_num = v_payment_num;
end update_payment_schedule;
ln_lines_to_insert NUMBER;
SELECT * FROM
ap_invoice_lines_all
WHERE invoice_id = Pn_invoice_id
AND LINE_NUMBER = pn_invoice_line_num;
SELECT * FROM
ap_invoice_distributions_all
WHERE invoice_id = pn_invoice_id
AND invoice_line_number = pn_invoice_line_num
AND distribution_line_number = ( SELECT min(distribution_line_number)
FROM ap_invoice_distributions_all apid
WHERE apid.invoice_id = Pn_invoice_id
AND apid.invoice_line_number = pn_invoice_line_num);
SELECT SOURCE FROM
ap_invoices_all
WHERE invoice_id = pn_invoice_id;
,pn_lines_to_insert => ln_lines_to_insert
,pv_accrue_on_receipt_flag => lv_accrue_on_receipt_flag
,pv_is_item_an_expense => lv_is_item_an_expense
,pv_tax_type => lv_tax_type
,pn_rec_tax_amt => ln_rec_tax_amt
,pn_nrec_tax_amt => ln_nrec_tax_amt
,pn_inclurec_tax_amt => ln_inclurec_tax_amt
,pn_currency_precision => ln_currency_precision
,pn_rvs_charge_liability_acct=>ln_rvs_liablity_acct
,pn_incls_acct_id => ln_incls_acct_id
,pr_ap_inv_dist_tax => r_ap_inv_dist_tax
);
FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'out parameters after prepare_copy_tax,ln_lines_to_insert:'||
ln_lines_to_insert||',lv_accrue_on_receipt_flag:'||lv_accrue_on_receipt_flag||',lv_is_item_an_expense:'||
lv_is_item_an_expense||',lv_tax_type'||lv_tax_type||',ln_rec_tax_amt:'||
ln_rec_tax_amt||',ln_nrec_tax_amt'||ln_nrec_tax_amt||',ln_inclurec_tax_amt:'||
ln_inclurec_tax_amt||',ln_currency_precision'||ln_currency_precision||',ln_rvs_liablity_acct:'||
ln_rvs_liablity_acct||',ln_incls_acct_id'||ln_incls_acct_id);
,pn_lines_to_insert => ln_lines_to_insert
,pv_is_item_an_expense => lv_is_item_an_expense
,pv_accrue_on_receipt_flag => lv_accrue_on_receipt_flag
,pv_tax_type => lv_tax_type
,pn_rec_tax_amt => ln_rec_tax_amt
,pn_nrec_tax_amt => ln_nrec_tax_amt
,pn_inclurec_tax_amt => ln_inclurec_tax_amt
,pn_rvs_charge_liability_acct => ln_rvs_liablity_acct
,pn_incls_acct_id => ln_incls_acct_id
,pn_currency_precision => ln_currency_precision
);
,pn_lines_to_insert IN NUMBER
,pv_is_item_an_expense IN VARCHAR2
,pv_accrue_on_receipt_flag VARCHAR2
,pv_tax_type IN VARCHAR2
,pn_rec_tax_amt IN NUMBER
,pn_nrec_tax_amt NUMBER
,pn_inclurec_tax_amt NUMBER
,pn_rvs_charge_liability_acct NUMBER DEFAULT NULL
,pn_incls_acct_id IN NUMBER
,pn_currency_precision IN NUMBER
) IS
v_tax_amount NUMBER;
v_assets_tracking_flag VARCHAR2(1) := 'N';--Updated by Wenqiong on Mar-21-2013 for bug16526089
v_update_payment_schedule BOOLEAN;
SELECT a.accounting_date,
a.accrual_posted_flag,
a.assets_addition_flag,
a.assets_tracking_flag,
a.cash_posted_flag,
a.dist_code_combination_id,
a.last_updated_by,
a.last_update_date,
a.line_type_lookup_code,
a.period_name,
a.set_of_books_id,
a.amount,
a.base_amount,
a.batch_id,
a.created_by,
a.creation_date,
a.description,
a.accts_pay_code_combination_id,
a.exchange_rate_variance,
a.last_update_login,
a.match_status_flag,
a.posted_flag,
a.rate_var_code_combination_id,
a.reversal_flag,
a.vat_code,
a.exchange_date,
a.exchange_rate,
a.exchange_rate_type,
a.price_adjustment_flag,
a.program_application_id,
a.program_id,
a.program_update_date,
a.global_attribute1,
a.global_attribute2,
a.global_attribute3,
a.po_distribution_id,
a.project_id,
a.task_id,
a.expenditure_type,
a.expenditure_item_date,
a.expenditure_organization_id,
a.quantity_invoiced,
Nvl(a.quantity_invoiced,1)/Nvl(b.quantity_invoiced,1) qty_apportion_factor,
a.unit_price,
price_var_code_combination_id,
invoice_distribution_id,
matched_uom_lookup_code,
invoice_price_variance,
a.distribution_line_number,
a.org_id
,project_accounting_context
,pa_addition_flag
,a.dist_match_type
FROM ap_invoice_distributions_all a,
ap_invoice_lines_all b
WHERE a.invoice_id = ln_invoice_id
AND a.invoice_line_number = pr_ap_inv_line_item.line_number
AND b.invoice_id = ln_invoice_id
AND b.line_number = pr_ap_inv_line_item.line_number
AND a.invoice_id = b.invoice_id
AND a.invoice_line_number = b.line_number
ORDER BY a.distribution_line_number;
SELECT chart_of_accounts_id,currency_code
FROM gl_sets_of_books
WHERE set_of_books_id = c_sob_id;
SELECT accts_pay_code_combination_id apccid,legal_entity_id, NVL(exchange_rate, 1) exchange_rate,invoice_currency_code
FROM ap_invoices_all
WHERE invoice_id = ln_invoice_id;
SELECT pod.po_header_id,
pod.po_line_id,
pod.line_location_id,
pod.set_of_books_id,
pod.org_id,
poh.rate,
poh.rate_type,
pod.rate_date,
poh.currency_code,
api.last_update_login,
apd.dist_code_combination_id,
api.creation_date,
api.created_by,
api.last_update_date,
api.last_updated_by,
api.invoice_date
FROM ap_invoices_all api,
ap_invoice_distributions_all apd,
po_distributions_all pod,
po_headers_all poh
WHERE apd.invoice_id = api.invoice_id
AND pod.po_header_id = poh.po_header_id
AND apd.po_distribution_id = pod.po_distribution_id
AND apd.invoice_line_number = pr_ap_inv_line_item.line_number
AND api.invoice_id = ln_invoice_id
AND apd.distribution_line_number = pr_ap_inv_dist_item.distribution_line_number;
SELECT max(line_number)
INTO ln_inv_line_num
FROM ap_invoice_lines_all
WHERE invoice_id = ln_invoice_id;
for line in 1..pn_lines_to_insert
loop
/*
-------------------------------------------------------------------------------------
-- v_tax_amount is for storing the tax amount and saving into the those 2 ap tables.
-- lv_tax_line_amount is for storing the tax amount and saving into the tax table.
-----------Exclusive Tax :
-- *In FR/NR tax case, ln_lines_to_insert =1
-- v_tax_amount :=v_tax_amount; ( ln_rec_tax_amt IS Null)
END IF;--( tax_type ='PR' and (ln_lines_to_insert =4 OR )
lr_ap_inv_line_tax.LAST_UPDATED_BY := ln_user_id;
lr_ap_inv_line_tax.LAST_UPDATE_DATE := sysdate;
lr_ap_inv_line_tax.LAST_UPDATE_LOGIN := ln_login_id;
jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_tax);
/*new LOOP added to insert multiple distributions for same line, if the matched PO shipment has multiple distributions*/
v_distribution_no := 1;
SELECT tax_account_id
FROM jai_cmn_taxes_all
WHERE tax_id = p_tax_line_rec.tax_id
AND tax_type = 'Other';
v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_tax);
lr_jai_ap_match_taxes.last_update_login := pr_ap_inv_line_item.last_update_login;
lr_jai_ap_match_taxes.last_update_date := pr_ap_inv_line_item.last_update_date;
lr_jai_ap_match_taxes.last_updated_by := pr_ap_inv_line_item.last_updated_by;
jai_ap_match_tax_proc_pkg.insert_jai_ap_match(lr_jai_ap_match_taxes);
v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_tax);
lr_jai_ap_match_taxes.last_update_login := pr_ap_inv_line_item.last_update_login;
lr_jai_ap_match_taxes.last_update_date := pr_ap_inv_line_item.last_update_date;
lr_jai_ap_match_taxes.last_updated_by := pr_ap_inv_line_item.last_updated_by;
jai_ap_match_tax_proc_pkg.insert_jai_ap_match(lr_jai_ap_match_taxes);
end loop ;--> for line in 1 to ln_lines_to_insert
fnd_file.put_line(fnd_file.log ,'Start the Insertion of Inclusive Service tax lines for POT recoverable service amount is '||pn_inclurec_tax_amt);
Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'
|| ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);
lr_ap_inv_line_incl_tax.LAST_UPDATED_BY := ln_user_id;
lr_ap_inv_line_incl_tax.LAST_UPDATE_DATE := sysdate;
lr_ap_inv_line_incl_tax.LAST_UPDATE_LOGIN := ln_login_id;
FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Before inserting
Inclusive Service tax lines for POT into ap_line ');
jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_incl_tax);
FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Before inserting
Inclusive Service tax lines for POT into ap_dist ');
v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist( p_ap_invoice_dist_all_rec => lr_ap_inv_dist_incl_tax);
UPDATE JAI_AP_MATCH_INV_TAXES jat
SET jat.invoice_distribution_id = v_invoice_distribution_id
, jat.INVOICE_LINE_NUMBER = ln_inv_line_num
WHERE jat.invoice_id = ln_invoice_id
AND jat.po_header_id = pr_ap_inv_line_item.po_header_id
AND jat.po_line_id = pr_ap_inv_line_item.po_line_id
AND jat.line_location_id = pr_ap_inv_line_item.po_line_location_id
AND jat.set_of_books_id = pr_ap_inv_line_item.set_of_books_id
AND jat.line_no = p_tax_line_rec.tax_line_no
AND jat.tax_id = p_tax_line_rec.tax_id
AND jat.recoverable_flag = decode(inclu_Serv_line,1,'Y',2,'N','N');
jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_liability);
FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'insert_ap_inv_line liability line for reverse charge with amt:'||lr_ap_inv_line_liability.amount);
v_liability_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_liability);
cum_tax_amt is initialized with -1 for Bug 5593895. Bug updates are not clear as to why it was done
This causes Tax Amount to be less by 1 when PO Matched Invoice is created from iSupplier
Hence incrementing Tax Amount by 1 for this specific scenario as modifying initialization to 0 may cause regression
*/
cum_tax_amt := cum_tax_amt + 1;
v_update_payment_schedule:=update_payment_schedule(cum_tax_amt,ln_invoice_id,pn_currency_precision);
UPDATE ap_invoices_all
SET invoice_amount = invoice_amount + cum_tax_amt,
approved_amount = approved_amount + cum_tax_amt,
pay_curr_invoice_amount = pay_curr_invoice_amount + cum_tax_amt,
amount_applicable_to_discount = amount_applicable_to_discount + cum_tax_amt,
payment_status_flag = decode(payment_status_flag, 'Y', 'P', payment_status_flag)
WHERE invoice_id = ln_invoice_id;
update ap_invoices_all
set base_amount = invoice_amount * exchange_rate
where invoice_id = ln_invoice_id;
REM pn_lines_to_insert OUT NUMBER Y Numbers of lines will be inserted in AP lines.
REM pv_accrue_on_receipt_flag OUT VARCHAR2 Y Accrue on receipt flag.
REM pv_is_item_an_expense OUT VARCHAR2 Y Expense item flag.
REM pv_tax_type OUT VARCHAR2 Y 'RE'--Recoverable tax part.
REM 'NR'--Non recoverable tax part.
REM 'PR'--Partially recoverable tax part.
REM pn_rec_tax_amt OUT NUMBER Y recoverale tax amount
REM pn_nrec_tax_amt OUT NUMBER Y non-recoverable tax amount
REM pn_inclurec_tax_amt OUT NUMBER Y inclusive recoverable tax amount
REM pn_currency_precision OUT NUMBER Y currency precision.
REM pn_rvs_charge_liability_acct OUT NUMBER Y reverse charge liablity account id.
REM pn_incls_acct_id OUT NUMBER Y inclusive tax account id.
REM pr_ap_inv_dist_tax OUT ap_invoice_distributions_all%ROWTYPE Y The AP dist line with prepared data.
REM
REM CALLED BY copy_tax_from_po_rcv
REM -------------------------------------------------------------------------------------------------------------------------------------
REM | | = 1 | Exclusive tax or inlcusive tax without project info
REM |pn_lines_to_insert | = 2 | Inclusive recoverable tax with project info
REM | | = 2 * pn_lines_to_insert | Partially recoverable tax will be split two part
REM -------------------------------------------------------------------------------------------------------------------------------------
REM |pv_accrue_on_receipt_flag | jai_rcv_trx_processing_pkg.get_accrue_on_receipt
REM -------------------------------------------------------------------------------------------------------------------------------------
REM |pv_is_item_an_expense | jai_general_pkg.is_item_an_expense
REM |pv_tax_type | = 'RE' |Full Recoverable
REM | | = 'NR' |Non Recoverable
REM | | = 'PR' |Partially Recoverable
REM |pn_rec_tax_amt | = recoverable tax amount
REM |pn_nrec_tax_amt | = non recoverable tax amount
REM |pn_inclurec_tax_amt | = Inclusive recoverable tax amount
REM |pn_currency_precision | = Precision setup for this currency
REM |pn_rvs_charge_liability_acct | = Service tax liability account if it's reverse charge tax.
REM |pn_incls_acct_id | = Recovery account for inclusive Service Tax .
REM |pn_currency_precision | = Precision setup for this currency
REM +===========================================================================================================================================+
*/
PROCEDURE prepare_copy_tax(pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE
,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE
,pr_tax_line_rec IN OUT NOCOPY l_tax_line_rec_type
,pv_rematch IN VARCHAR2
,pn_shipment_hdr_id IN NUMBER
,pn_shipment_line_id IN NUMBER
,pn_lines_to_insert OUT NOCOPY NUMBER
,pv_accrue_on_receipt_flag OUT NOCOPY VARCHAR2
,pv_is_item_an_expense OUT NOCOPY VARCHAR2
,pv_tax_type OUT NOCOPY VARCHAR2
,pn_rec_tax_amt OUT NOCOPY NUMBER
,pn_nrec_tax_amt OUT NOCOPY NUMBER
,pn_inclurec_tax_amt OUT NOCOPY NUMBER
,pn_currency_precision OUT NOCOPY NUMBER
,pn_rvs_charge_liability_acct OUT NOCOPY NUMBER
,pn_incls_acct_id OUT NOCOPY NUMBER
,pr_ap_inv_dist_tax OUT NOCOPY ap_invoice_distributions_all%ROWTYPE
) IS
CURSOR c_get_item_id IS
SELECT item_id
FROM po_lines_all pla,po_distributions_all pda
WHERE pla.po_line_id = pda.po_line_id
AND pda.po_distribution_id = pr_ap_inv_line_item.po_distribution_id;
SELECT account_type
FROM gl_code_combinations
WHERE code_combination_id = pr_ap_inv_dist_item.dist_code_combination_id;
SELECT Shipment_Line_Id, Shipment_Header_Id
FROM Rcv_Shipment_Lines
WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
FROM Rcv_Shipment_Headers
WHERE Receipt_Num = receiptnum )
AND Po_Line_location_Id = ( SELECT Line_Location_Id
FROM Po_Distributions_All
WHERE Po_Distribution_Id = pr_ap_inv_line_item.po_line_location_id)
AND To_Organization_Id = invorg;
select jrr.regime_id,attribute_code tax_type
from JAI_RGM_REGISTRATIONS jrr,JAI_RGM_DEFINITIONS jrd
where jrr.regime_id = jrd.regime_id
and jrr.registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
AND jrd.regime_code = cp_regime_code
and jrr.attribute_code = cp_tax_type;
SELECT tax_name,
tax_account_id,
mod_cr_percentage,
adhoc_flag,
nvl(tax_rate,-1) tax_rate,
tax_type,
NVL(rounding_factor,0) rounding_factor
FROM JAI_CMN_TAXES_ALL
WHERE tax_id = t_id;
SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code,batch_id
FROM ap_invoices_all
WHERE invoice_id = pr_ap_inv_line_item.invoice_id;
select attribute2 excise_costing_flag
from jai_rcv_transactions jrcvt
where jrcvt.parent_transaction_id = cp_rcv_transaction_id
and jrcvt.organization_id = cp_organization_id
and jrcvt.shipment_header_id = cp_shipment_header_id
and jrcvt.transaction_type = cp_txn_type ;
select precision
from fnd_currencies
where currency_code = cp_currency_code;
v_assets_tracking_flag VARCHAR2(1) := 'N';--Updated by Wenqiong on Mar-21-2013 for bug16526089
SELECT Min(po_distribution_id)
INTO ln_po_dist_id
FROM po_distributions_all
WHERE po_line_id = pr_ap_inv_line_item.po_line_id
AND line_location_id = pr_ap_inv_line_item.po_line_location_id;
pn_lines_to_insert := 1;
)--exclusive tax or inlcusive tax without project info, pn_lines_to_insert := 1;
pn_lines_to_insert := 1;
THEN --inclusive recoverable tax with project info, pn_lines_to_insert := 2;
pn_lines_to_insert := 2;
pn_lines_to_insert := 2 * pn_lines_to_insert;
pr_ap_inv_dist_tax.last_updated_by := pr_ap_inv_dist_item.last_updated_by;
pr_ap_inv_dist_tax.last_update_date := pr_ap_inv_dist_item.last_update_date;
pr_ap_inv_dist_tax.last_update_login := pr_ap_inv_dist_item.last_update_login;
pr_ap_inv_dist_tax.program_update_date := pr_ap_inv_dist_item.program_update_date;
PROCEDURE insert_jai_ap_match(
p_jai_ap_match_taxes_rec IN JAI_AP_MATCH_INV_TAXES%ROWTYPE
)IS
l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_match()';
INSERT INTO JAI_AP_MATCH_INV_TAXES
(
tax_distribution_id,
assets_tracking_flag,
invoice_id,
po_header_id,
po_line_id,
line_location_id,
set_of_books_id,
exchange_rate,
exchange_rate_type,
exchange_date,
currency_code,
code_combination_id,
last_update_login,
creation_date,
created_by,
last_update_date,
last_updated_by,
acct_pay_code_combination_id,
accounting_date,
tax_id,
tax_amount,
base_amount,
chart_of_accounts_id,
distribution_line_number,
po_distribution_id,
parent_invoice_distribution_id,
legal_entity_id
,INVOICE_LINE_NUMBER
,INVOICE_DISTRIBUTION_ID
,PARENT_INVOICE_LINE_NUMBER
,RCV_TRANSACTION_ID
,LINE_TYPE_LOOKUP_CODE
, recoverable_flag
, line_no
)
VALUES
(
JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
p_jai_ap_match_taxes_rec.assets_tracking_flag,
p_jai_ap_match_taxes_rec.invoice_id,
p_jai_ap_match_taxes_rec.po_header_id,
p_jai_ap_match_taxes_rec.po_line_id,
p_jai_ap_match_taxes_rec.line_location_id,
p_jai_ap_match_taxes_rec.set_of_books_id,
p_jai_ap_match_taxes_rec.exchange_rate,
p_jai_ap_match_taxes_rec.exchange_rate_type,
p_jai_ap_match_taxes_rec.exchange_date,
p_jai_ap_match_taxes_rec.currency_code,
p_jai_ap_match_taxes_rec.code_combination_id,
p_jai_ap_match_taxes_rec.last_update_login,
p_jai_ap_match_taxes_rec.creation_date,
p_jai_ap_match_taxes_rec.created_by,
p_jai_ap_match_taxes_rec.last_update_date,
p_jai_ap_match_taxes_rec.last_updated_by,
p_jai_ap_match_taxes_rec.acct_pay_code_combination_id,
p_jai_ap_match_taxes_rec.accounting_date,
p_jai_ap_match_taxes_rec.tax_id,
p_jai_ap_match_taxes_rec.tax_amount,
p_jai_ap_match_taxes_rec.base_amount,
p_jai_ap_match_taxes_rec.chart_of_accounts_id,
p_jai_ap_match_taxes_rec.distribution_line_number,
p_jai_ap_match_taxes_rec.po_distribution_id,
p_jai_ap_match_taxes_rec.parent_invoice_distribution_id,
p_jai_ap_match_taxes_rec.legal_entity_id ,
p_jai_ap_match_taxes_rec.INVOICE_LINE_NUMBER,
p_jai_ap_match_taxes_rec.INVOICE_DISTRIBUTION_ID ,
p_jai_ap_match_taxes_rec.PARENT_INVOICE_LINE_NUMBER ,
p_jai_ap_match_taxes_rec.RCV_TRANSACTION_ID ,
p_jai_ap_match_taxes_rec.LINE_TYPE_LOOKUP_CODE ,
p_jai_ap_match_taxes_rec.recoverable_flag ,
p_jai_ap_match_taxes_rec.line_no
);
END insert_jai_ap_match;
PROCEDURE insert_ap_inv_line(
p_ap_invoice_lines_all_rec IN ap_invoice_lines_all%ROWTYPE
)IS
l_api_name CONSTANT VARCHAR2(50) := 'insert_ap_inv_line()';
INSERT INTO ap_invoice_lines_all
(INVOICE_ID
,LINE_NUMBER
,LINE_TYPE_LOOKUP_CODE
,REQUESTER_ID
,DESCRIPTION
,LINE_SOURCE
,ORG_ID
,LINE_GROUP_NUMBER
,INVENTORY_ITEM_ID
,ITEM_DESCRIPTION
,SERIAL_NUMBER
,MANUFACTURER
,MODEL_NUMBER
,WARRANTY_NUMBER
,GENERATE_DISTS
,MATCH_TYPE
,DISTRIBUTION_SET_ID
,ACCOUNT_SEGMENT
,BALANCING_SEGMENT
,COST_CENTER_SEGMENT
,OVERLAY_DIST_CODE_CONCAT
,DEFAULT_DIST_CCID
,PRORATE_ACROSS_ALL_ITEMS
,ACCOUNTING_DATE
,PERIOD_NAME
,DEFERRED_ACCTG_FLAG
,DEF_ACCTG_START_DATE
,DEF_ACCTG_END_DATE
,DEF_ACCTG_NUMBER_OF_PERIODS
,DEF_ACCTG_PERIOD_TYPE
,SET_OF_BOOKS_ID
,AMOUNT
,BASE_AMOUNT
,ROUNDING_AMT
,QUANTITY_INVOICED
,UNIT_MEAS_LOOKUP_CODE
,UNIT_PRICE
,WFAPPROVAL_STATUS
,USSGL_TRANSACTION_CODE
,DISCARDED_FLAG
,ORIGINAL_AMOUNT
,ORIGINAL_BASE_AMOUNT
,ORIGINAL_ROUNDING_AMT
,CANCELLED_FLAG
,INCOME_TAX_REGION
,TYPE_1099
,STAT_AMOUNT
,PREPAY_INVOICE_ID
,PREPAY_LINE_NUMBER
,INVOICE_INCLUDES_PREPAY_FLAG
,CORRECTED_INV_ID
,CORRECTED_LINE_NUMBER
,PO_HEADER_ID
,PO_LINE_ID
,PO_RELEASE_ID
,PO_LINE_LOCATION_ID
,PO_DISTRIBUTION_ID
,RCV_TRANSACTION_ID
,FINAL_MATCH_FLAG
,ASSETS_TRACKING_FLAG
,ASSET_BOOK_TYPE_CODE
,ASSET_CATEGORY_ID
,PROJECT_ID
,TASK_ID
,EXPENDITURE_TYPE
,EXPENDITURE_ITEM_DATE
,EXPENDITURE_ORGANIZATION_ID
,PA_QUANTITY
,PA_CC_AR_INVOICE_ID
,PA_CC_AR_INVOICE_LINE_NUM
,PA_CC_PROCESSED_CODE
,AWARD_ID
,AWT_GROUP_ID
,REFERENCE_1
,REFERENCE_2
,RECEIPT_VERIFIED_FLAG
,RECEIPT_REQUIRED_FLAG
,RECEIPT_MISSING_FLAG
,JUSTIFICATION
,EXPENSE_GROUP
,START_EXPENSE_DATE
,END_EXPENSE_DATE
,RECEIPT_CURRENCY_CODE
,RECEIPT_CONVERSION_RATE
,RECEIPT_CURRENCY_AMOUNT
,DAILY_AMOUNT
,WEB_PARAMETER_ID
,ADJUSTMENT_REASON
,MERCHANT_DOCUMENT_NUMBER
,MERCHANT_NAME
,MERCHANT_REFERENCE
,MERCHANT_TAX_REG_NUMBER
,MERCHANT_TAXPAYER_ID
,COUNTRY_OF_SUPPLY
,CREDIT_CARD_TRX_ID
,COMPANY_PREPAID_INVOICE_ID
,CC_REVERSAL_FLAG
,CREATION_DATE
,CREATED_BY
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,GLOBAL_ATTRIBUTE_CATEGORY
,GLOBAL_ATTRIBUTE1
,GLOBAL_ATTRIBUTE2
,GLOBAL_ATTRIBUTE3
,GLOBAL_ATTRIBUTE4
,GLOBAL_ATTRIBUTE5
,GLOBAL_ATTRIBUTE6
,GLOBAL_ATTRIBUTE7
,GLOBAL_ATTRIBUTE8
,GLOBAL_ATTRIBUTE9
,GLOBAL_ATTRIBUTE10
,GLOBAL_ATTRIBUTE11
,GLOBAL_ATTRIBUTE12
,GLOBAL_ATTRIBUTE13
,GLOBAL_ATTRIBUTE14
,GLOBAL_ATTRIBUTE15
,GLOBAL_ATTRIBUTE16
,GLOBAL_ATTRIBUTE17
,GLOBAL_ATTRIBUTE18
,GLOBAL_ATTRIBUTE19
,GLOBAL_ATTRIBUTE20
,LINE_SELECTED_FOR_APPL_FLAG
,PREPAY_APPL_REQUEST_ID
,APPLICATION_ID
,PRODUCT_TABLE
,REFERENCE_KEY1
,REFERENCE_KEY2
,REFERENCE_KEY3
,REFERENCE_KEY4
,REFERENCE_KEY5
,PURCHASING_CATEGORY_ID
,COST_FACTOR_ID
,CONTROL_AMOUNT
,ASSESSABLE_VALUE
,TOTAL_REC_TAX_AMOUNT
,TOTAL_NREC_TAX_AMOUNT
,TOTAL_REC_TAX_AMT_FUNCL_CURR
,TOTAL_NREC_TAX_AMT_FUNCL_CURR
,INCLUDED_TAX_AMOUNT
,PRIMARY_INTENDED_USE
,TAX_ALREADY_CALCULATED_FLAG
,SHIP_TO_LOCATION_ID
,PRODUCT_TYPE
,PRODUCT_CATEGORY
,PRODUCT_FISC_CLASSIFICATION
,USER_DEFINED_FISC_CLASS
,TRX_BUSINESS_CATEGORY
,SUMMARY_TAX_LINE_ID
,TAX_REGIME_CODE
,TAX
,TAX_JURISDICTION_CODE
,TAX_STATUS_CODE
,TAX_RATE_ID
,TAX_RATE_CODE
,TAX_RATE
,TAX_CODE_ID
,HISTORICAL_FLAG
,TAX_CLASSIFICATION_CODE
,SOURCE_APPLICATION_ID
,SOURCE_EVENT_CLASS_CODE
,SOURCE_ENTITY_CODE
,SOURCE_TRX_ID
,SOURCE_LINE_ID
,SOURCE_TRX_LEVEL_TYPE
,RETAINED_AMOUNT
,RETAINED_AMOUNT_REMAINING
,RETAINED_INVOICE_ID
,RETAINED_LINE_NUMBER
,LINE_SELECTED_FOR_RELEASE_FLAG
,LINE_OWNER_ROLE
,DISPUTABLE_FLAG
,RCV_SHIPMENT_LINE_ID
,AIL_INVOICE_ID
,AIL_DISTRIBUTION_LINE_NUMBER
,AIL_INVOICE_ID2
,AIL_DISTRIBUTION_LINE_NUMBER2
,AIL_INVOICE_ID3
,AIL_DISTRIBUTION_LINE_NUMBER3
,AIL_INVOICE_ID4
,PAY_AWT_GROUP_ID
)
VALUES
(p_ap_invoice_lines_all_rec.INVOICE_ID
,p_ap_invoice_lines_all_rec.LINE_NUMBER
,p_ap_invoice_lines_all_rec.LINE_TYPE_LOOKUP_CODE
,p_ap_invoice_lines_all_rec.REQUESTER_ID
,p_ap_invoice_lines_all_rec.DESCRIPTION
,p_ap_invoice_lines_all_rec.LINE_SOURCE
,p_ap_invoice_lines_all_rec.ORG_ID
,p_ap_invoice_lines_all_rec.LINE_GROUP_NUMBER
,p_ap_invoice_lines_all_rec.INVENTORY_ITEM_ID
,p_ap_invoice_lines_all_rec.ITEM_DESCRIPTION
,p_ap_invoice_lines_all_rec.SERIAL_NUMBER
,p_ap_invoice_lines_all_rec.MANUFACTURER
,p_ap_invoice_lines_all_rec.MODEL_NUMBER
,p_ap_invoice_lines_all_rec.WARRANTY_NUMBER
,p_ap_invoice_lines_all_rec.GENERATE_DISTS
,p_ap_invoice_lines_all_rec.MATCH_TYPE
,p_ap_invoice_lines_all_rec.DISTRIBUTION_SET_ID
,p_ap_invoice_lines_all_rec.ACCOUNT_SEGMENT
,p_ap_invoice_lines_all_rec.BALANCING_SEGMENT
,p_ap_invoice_lines_all_rec.COST_CENTER_SEGMENT
,p_ap_invoice_lines_all_rec.OVERLAY_DIST_CODE_CONCAT
,p_ap_invoice_lines_all_rec.DEFAULT_DIST_CCID
,p_ap_invoice_lines_all_rec.PRORATE_ACROSS_ALL_ITEMS
,p_ap_invoice_lines_all_rec.ACCOUNTING_DATE
,p_ap_invoice_lines_all_rec.PERIOD_NAME
,p_ap_invoice_lines_all_rec.DEFERRED_ACCTG_FLAG
,p_ap_invoice_lines_all_rec.DEF_ACCTG_START_DATE
,p_ap_invoice_lines_all_rec.DEF_ACCTG_END_DATE
,p_ap_invoice_lines_all_rec.DEF_ACCTG_NUMBER_OF_PERIODS
,p_ap_invoice_lines_all_rec.DEF_ACCTG_PERIOD_TYPE
,p_ap_invoice_lines_all_rec.SET_OF_BOOKS_ID
,p_ap_invoice_lines_all_rec.AMOUNT
,p_ap_invoice_lines_all_rec.BASE_AMOUNT
,p_ap_invoice_lines_all_rec.ROUNDING_AMT
,p_ap_invoice_lines_all_rec.QUANTITY_INVOICED
,p_ap_invoice_lines_all_rec.UNIT_MEAS_LOOKUP_CODE
,p_ap_invoice_lines_all_rec.UNIT_PRICE
,p_ap_invoice_lines_all_rec.WFAPPROVAL_STATUS
,p_ap_invoice_lines_all_rec.USSGL_TRANSACTION_CODE
,p_ap_invoice_lines_all_rec.DISCARDED_FLAG
,p_ap_invoice_lines_all_rec.ORIGINAL_AMOUNT
,p_ap_invoice_lines_all_rec.ORIGINAL_BASE_AMOUNT
,p_ap_invoice_lines_all_rec.ORIGINAL_ROUNDING_AMT
,p_ap_invoice_lines_all_rec.CANCELLED_FLAG
,p_ap_invoice_lines_all_rec.INCOME_TAX_REGION
,p_ap_invoice_lines_all_rec.TYPE_1099
,p_ap_invoice_lines_all_rec.STAT_AMOUNT
,p_ap_invoice_lines_all_rec.PREPAY_INVOICE_ID
,p_ap_invoice_lines_all_rec.PREPAY_LINE_NUMBER
,p_ap_invoice_lines_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
,p_ap_invoice_lines_all_rec.CORRECTED_INV_ID
,p_ap_invoice_lines_all_rec.CORRECTED_LINE_NUMBER
,p_ap_invoice_lines_all_rec.PO_HEADER_ID
,p_ap_invoice_lines_all_rec.PO_LINE_ID
,p_ap_invoice_lines_all_rec.PO_RELEASE_ID
,p_ap_invoice_lines_all_rec.PO_LINE_LOCATION_ID
,p_ap_invoice_lines_all_rec.PO_DISTRIBUTION_ID
,p_ap_invoice_lines_all_rec.RCV_TRANSACTION_ID
,p_ap_invoice_lines_all_rec.FINAL_MATCH_FLAG
,p_ap_invoice_lines_all_rec.ASSETS_TRACKING_FLAG
,p_ap_invoice_lines_all_rec.ASSET_BOOK_TYPE_CODE
,p_ap_invoice_lines_all_rec.ASSET_CATEGORY_ID
,p_ap_invoice_lines_all_rec.PROJECT_ID
,p_ap_invoice_lines_all_rec.TASK_ID
,p_ap_invoice_lines_all_rec.EXPENDITURE_TYPE
,p_ap_invoice_lines_all_rec.EXPENDITURE_ITEM_DATE
,p_ap_invoice_lines_all_rec.EXPENDITURE_ORGANIZATION_ID
,p_ap_invoice_lines_all_rec.PA_QUANTITY
,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_ID
,p_ap_invoice_lines_all_rec.PA_CC_AR_INVOICE_LINE_NUM
,p_ap_invoice_lines_all_rec.PA_CC_PROCESSED_CODE
,p_ap_invoice_lines_all_rec.AWARD_ID
,p_ap_invoice_lines_all_rec.AWT_GROUP_ID
,p_ap_invoice_lines_all_rec.REFERENCE_1
,p_ap_invoice_lines_all_rec.REFERENCE_2
,p_ap_invoice_lines_all_rec.RECEIPT_VERIFIED_FLAG
,p_ap_invoice_lines_all_rec.RECEIPT_REQUIRED_FLAG
,p_ap_invoice_lines_all_rec.RECEIPT_MISSING_FLAG
,p_ap_invoice_lines_all_rec.JUSTIFICATION
,p_ap_invoice_lines_all_rec.EXPENSE_GROUP
,p_ap_invoice_lines_all_rec.START_EXPENSE_DATE
,p_ap_invoice_lines_all_rec.END_EXPENSE_DATE
,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_CODE
,p_ap_invoice_lines_all_rec.RECEIPT_CONVERSION_RATE
,p_ap_invoice_lines_all_rec.RECEIPT_CURRENCY_AMOUNT
,p_ap_invoice_lines_all_rec.DAILY_AMOUNT
,p_ap_invoice_lines_all_rec.WEB_PARAMETER_ID
,p_ap_invoice_lines_all_rec.ADJUSTMENT_REASON
,p_ap_invoice_lines_all_rec.MERCHANT_DOCUMENT_NUMBER
,p_ap_invoice_lines_all_rec.MERCHANT_NAME
,p_ap_invoice_lines_all_rec.MERCHANT_REFERENCE
,p_ap_invoice_lines_all_rec.MERCHANT_TAX_REG_NUMBER
,p_ap_invoice_lines_all_rec.MERCHANT_TAXPAYER_ID
,p_ap_invoice_lines_all_rec.COUNTRY_OF_SUPPLY
,p_ap_invoice_lines_all_rec.CREDIT_CARD_TRX_ID
,p_ap_invoice_lines_all_rec.COMPANY_PREPAID_INVOICE_ID
,p_ap_invoice_lines_all_rec.CC_REVERSAL_FLAG
,p_ap_invoice_lines_all_rec.CREATION_DATE
,p_ap_invoice_lines_all_rec.CREATED_BY
,p_ap_invoice_lines_all_rec.LAST_UPDATED_BY
,p_ap_invoice_lines_all_rec.LAST_UPDATE_DATE
,p_ap_invoice_lines_all_rec.LAST_UPDATE_LOGIN
,p_ap_invoice_lines_all_rec.PROGRAM_APPLICATION_ID
,p_ap_invoice_lines_all_rec.PROGRAM_ID
,p_ap_invoice_lines_all_rec.PROGRAM_UPDATE_DATE
,p_ap_invoice_lines_all_rec.REQUEST_ID
,p_ap_invoice_lines_all_rec.ATTRIBUTE_CATEGORY
,p_ap_invoice_lines_all_rec.ATTRIBUTE1
,p_ap_invoice_lines_all_rec.ATTRIBUTE2
,p_ap_invoice_lines_all_rec.ATTRIBUTE3
,p_ap_invoice_lines_all_rec.ATTRIBUTE4
,p_ap_invoice_lines_all_rec.ATTRIBUTE5
,p_ap_invoice_lines_all_rec.ATTRIBUTE6
,p_ap_invoice_lines_all_rec.ATTRIBUTE7
,p_ap_invoice_lines_all_rec.ATTRIBUTE8
,p_ap_invoice_lines_all_rec.ATTRIBUTE9
,p_ap_invoice_lines_all_rec.ATTRIBUTE10
,p_ap_invoice_lines_all_rec.ATTRIBUTE11
,p_ap_invoice_lines_all_rec.ATTRIBUTE12
,p_ap_invoice_lines_all_rec.ATTRIBUTE13
,p_ap_invoice_lines_all_rec.ATTRIBUTE14
,p_ap_invoice_lines_all_rec.ATTRIBUTE15
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE1
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE2
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE3
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE4
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE5
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE6
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE7
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE8
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE9
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE10
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE11
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE12
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE13
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE14
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE15
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE16
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE17
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE18
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE19
,p_ap_invoice_lines_all_rec.GLOBAL_ATTRIBUTE20
,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_APPL_FLAG
,p_ap_invoice_lines_all_rec.PREPAY_APPL_REQUEST_ID
,p_ap_invoice_lines_all_rec.APPLICATION_ID
,p_ap_invoice_lines_all_rec.PRODUCT_TABLE
,p_ap_invoice_lines_all_rec.REFERENCE_KEY1
,p_ap_invoice_lines_all_rec.REFERENCE_KEY2
,p_ap_invoice_lines_all_rec.REFERENCE_KEY3
,p_ap_invoice_lines_all_rec.REFERENCE_KEY4
,p_ap_invoice_lines_all_rec.REFERENCE_KEY5
,p_ap_invoice_lines_all_rec.PURCHASING_CATEGORY_ID
,p_ap_invoice_lines_all_rec.COST_FACTOR_ID
,p_ap_invoice_lines_all_rec.CONTROL_AMOUNT
,p_ap_invoice_lines_all_rec.ASSESSABLE_VALUE
,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMOUNT
,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMOUNT
,p_ap_invoice_lines_all_rec.TOTAL_REC_TAX_AMT_FUNCL_CURR
,p_ap_invoice_lines_all_rec.TOTAL_NREC_TAX_AMT_FUNCL_CURR
,p_ap_invoice_lines_all_rec.INCLUDED_TAX_AMOUNT
,p_ap_invoice_lines_all_rec.PRIMARY_INTENDED_USE
,p_ap_invoice_lines_all_rec.TAX_ALREADY_CALCULATED_FLAG
,p_ap_invoice_lines_all_rec.SHIP_TO_LOCATION_ID
,p_ap_invoice_lines_all_rec.PRODUCT_TYPE
,p_ap_invoice_lines_all_rec.PRODUCT_CATEGORY
,p_ap_invoice_lines_all_rec.PRODUCT_FISC_CLASSIFICATION
,p_ap_invoice_lines_all_rec.USER_DEFINED_FISC_CLASS
,p_ap_invoice_lines_all_rec.TRX_BUSINESS_CATEGORY
,p_ap_invoice_lines_all_rec.SUMMARY_TAX_LINE_ID
,p_ap_invoice_lines_all_rec.TAX_REGIME_CODE
,p_ap_invoice_lines_all_rec.TAX
,p_ap_invoice_lines_all_rec.TAX_JURISDICTION_CODE
,p_ap_invoice_lines_all_rec.TAX_STATUS_CODE
,p_ap_invoice_lines_all_rec.TAX_RATE_ID
,p_ap_invoice_lines_all_rec.TAX_RATE_CODE
,p_ap_invoice_lines_all_rec.TAX_RATE
,p_ap_invoice_lines_all_rec.TAX_CODE_ID
,p_ap_invoice_lines_all_rec.HISTORICAL_FLAG
,p_ap_invoice_lines_all_rec.TAX_CLASSIFICATION_CODE
,p_ap_invoice_lines_all_rec.SOURCE_APPLICATION_ID
,p_ap_invoice_lines_all_rec.SOURCE_EVENT_CLASS_CODE
,p_ap_invoice_lines_all_rec.SOURCE_ENTITY_CODE
,p_ap_invoice_lines_all_rec.SOURCE_TRX_ID
,p_ap_invoice_lines_all_rec.SOURCE_LINE_ID
,p_ap_invoice_lines_all_rec.SOURCE_TRX_LEVEL_TYPE
,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT
,p_ap_invoice_lines_all_rec.RETAINED_AMOUNT_REMAINING
,p_ap_invoice_lines_all_rec.RETAINED_INVOICE_ID
,p_ap_invoice_lines_all_rec.RETAINED_LINE_NUMBER
,p_ap_invoice_lines_all_rec.LINE_SELECTED_FOR_RELEASE_FLAG
,p_ap_invoice_lines_all_rec.LINE_OWNER_ROLE
,p_ap_invoice_lines_all_rec.DISPUTABLE_FLAG
,p_ap_invoice_lines_all_rec.RCV_SHIPMENT_LINE_ID
,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID
,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER
,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID2
,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER2
,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID3
,p_ap_invoice_lines_all_rec.AIL_DISTRIBUTION_LINE_NUMBER3
,p_ap_invoice_lines_all_rec.AIL_INVOICE_ID4
,p_ap_invoice_lines_all_rec.PAY_AWT_GROUP_ID
);
END insert_ap_inv_line;
FUNCTION insert_ap_inv_dist(
p_ap_invoice_dist_all_rec IN ap_invoice_distributions_all%ROWTYPE
)RETURN NUMBER IS
CURSOR c_get_inv_dist_id IS
select ap_invoice_distributions_s.nextval
from dual;
l_api_name CONSTANT VARCHAR2(50) := 'insert_ap_inv_dist()';
INSERT INTO ap_invoice_distributions_all
(ACCOUNTING_DATE
,ACCRUAL_POSTED_FLAG
,ASSETS_ADDITION_FLAG
,ASSETS_TRACKING_FLAG
,CASH_POSTED_FLAG
,DISTRIBUTION_LINE_NUMBER
,DIST_CODE_COMBINATION_ID
,INVOICE_ID
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LINE_TYPE_LOOKUP_CODE
,PERIOD_NAME
,SET_OF_BOOKS_ID
,ACCTS_PAY_CODE_COMBINATION_ID
,AMOUNT
,BASE_AMOUNT
,BASE_INVOICE_PRICE_VARIANCE
,BATCH_ID
,CREATED_BY
,CREATION_DATE
,DESCRIPTION
,EXCHANGE_RATE_VARIANCE
,FINAL_MATCH_FLAG
,INCOME_TAX_REGION
,INVOICE_PRICE_VARIANCE
,LAST_UPDATE_LOGIN
,MATCH_STATUS_FLAG
,POSTED_FLAG
,PO_DISTRIBUTION_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,QUANTITY_INVOICED
,RATE_VAR_CODE_COMBINATION_ID
,REQUEST_ID
,REVERSAL_FLAG
,TYPE_1099
,UNIT_PRICE
,AMOUNT_ENCUMBERED
,BASE_AMOUNT_ENCUMBERED
,ENCUMBERED_FLAG
,EXCHANGE_DATE
,EXCHANGE_RATE
,EXCHANGE_RATE_TYPE
,PRICE_ADJUSTMENT_FLAG
,PRICE_VAR_CODE_COMBINATION_ID
,QUANTITY_UNENCUMBERED
,STAT_AMOUNT
,AMOUNT_TO_POST
,ATTRIBUTE1
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE_CATEGORY
,BASE_AMOUNT_TO_POST
,CASH_JE_BATCH_ID
,EXPENDITURE_ITEM_DATE
,EXPENDITURE_ORGANIZATION_ID
,EXPENDITURE_TYPE
,JE_BATCH_ID
,PARENT_INVOICE_ID
,PA_ADDITION_FLAG
,PA_QUANTITY
,POSTED_AMOUNT
,POSTED_BASE_AMOUNT
,PREPAY_AMOUNT_REMAINING
,PROJECT_ACCOUNTING_CONTEXT
,PROJECT_ID
,TASK_ID
,USSGL_TRANSACTION_CODE
,USSGL_TRX_CODE_CONTEXT
,EARLIEST_SETTLEMENT_DATE
,REQ_DISTRIBUTION_ID
,QUANTITY_VARIANCE
,BASE_QUANTITY_VARIANCE
,PACKET_ID
,AWT_FLAG
,AWT_GROUP_ID
,AWT_TAX_RATE_ID
,AWT_GROSS_AMOUNT
,AWT_INVOICE_ID
,AWT_ORIGIN_GROUP_ID
,REFERENCE_1
,REFERENCE_2
,ORG_ID
,OTHER_INVOICE_ID
,AWT_INVOICE_PAYMENT_ID
,GLOBAL_ATTRIBUTE_CATEGORY
,GLOBAL_ATTRIBUTE1
,GLOBAL_ATTRIBUTE2
,GLOBAL_ATTRIBUTE3
,GLOBAL_ATTRIBUTE4
,GLOBAL_ATTRIBUTE5
,GLOBAL_ATTRIBUTE6
,GLOBAL_ATTRIBUTE7
,GLOBAL_ATTRIBUTE8
,GLOBAL_ATTRIBUTE9
,GLOBAL_ATTRIBUTE10
,GLOBAL_ATTRIBUTE11
,GLOBAL_ATTRIBUTE12
,GLOBAL_ATTRIBUTE13
,GLOBAL_ATTRIBUTE14
,GLOBAL_ATTRIBUTE15
,GLOBAL_ATTRIBUTE16
,GLOBAL_ATTRIBUTE17
,GLOBAL_ATTRIBUTE18
,GLOBAL_ATTRIBUTE19
,GLOBAL_ATTRIBUTE20
,LINE_GROUP_NUMBER
,RECEIPT_VERIFIED_FLAG
,RECEIPT_REQUIRED_FLAG
,RECEIPT_MISSING_FLAG
,JUSTIFICATION
,EXPENSE_GROUP
,START_EXPENSE_DATE
,END_EXPENSE_DATE
,RECEIPT_CURRENCY_CODE
,RECEIPT_CONVERSION_RATE
,RECEIPT_CURRENCY_AMOUNT
,DAILY_AMOUNT
,WEB_PARAMETER_ID
,ADJUSTMENT_REASON
,AWARD_ID
,MRC_ACCRUAL_POSTED_FLAG
,MRC_CASH_POSTED_FLAG
,MRC_DIST_CODE_COMBINATION_ID
,MRC_AMOUNT
,MRC_BASE_AMOUNT
,MRC_BASE_INV_PRICE_VARIANCE
,MRC_EXCHANGE_RATE_VARIANCE
,MRC_POSTED_FLAG
,MRC_PROGRAM_APPLICATION_ID
,MRC_PROGRAM_ID
,MRC_PROGRAM_UPDATE_DATE
,MRC_RATE_VAR_CCID
,MRC_REQUEST_ID
,MRC_EXCHANGE_DATE
,MRC_EXCHANGE_RATE
,MRC_EXCHANGE_RATE_TYPE
,MRC_AMOUNT_TO_POST
,MRC_BASE_AMOUNT_TO_POST
,MRC_CASH_JE_BATCH_ID
,MRC_JE_BATCH_ID
,MRC_POSTED_AMOUNT
,MRC_POSTED_BASE_AMOUNT
,MRC_RECEIPT_CONVERSION_RATE
,CREDIT_CARD_TRX_ID
,DIST_MATCH_TYPE
,RCV_TRANSACTION_ID
,INVOICE_DISTRIBUTION_ID
,PARENT_REVERSAL_ID
,TAX_RECOVERABLE_FLAG
,PA_CC_AR_INVOICE_ID
,PA_CC_AR_INVOICE_LINE_NUM
,PA_CC_PROCESSED_CODE
,MERCHANT_DOCUMENT_NUMBER
,MERCHANT_NAME
,MERCHANT_REFERENCE
,MERCHANT_TAX_REG_NUMBER
,MERCHANT_TAXPAYER_ID
,COUNTRY_OF_SUPPLY
,MATCHED_UOM_LOOKUP_CODE
,GMS_BURDENABLE_RAW_COST
,ACCOUNTING_EVENT_ID
,PREPAY_DISTRIBUTION_ID
,UPGRADE_POSTED_AMT
,UPGRADE_BASE_POSTED_AMT
,INVENTORY_TRANSFER_STATUS
,COMPANY_PREPAID_INVOICE_ID
,CC_REVERSAL_FLAG
,AWT_WITHHELD_AMT
,INVOICE_INCLUDES_PREPAY_FLAG
,PRICE_CORRECT_INV_ID
,PRICE_CORRECT_QTY
,PA_CMT_XFACE_FLAG
,CANCELLATION_FLAG
,INVOICE_LINE_NUMBER
,CORRECTED_INVOICE_DIST_ID
,ROUNDING_AMT
,CHARGE_APPLICABLE_TO_DIST_ID
,CORRECTED_QUANTITY
,RELATED_ID
,ASSET_BOOK_TYPE_CODE
,ASSET_CATEGORY_ID
,DISTRIBUTION_CLASS
,FINAL_PAYMENT_ROUNDING
,FINAL_APPLICATION_ROUNDING
,AMOUNT_AT_PREPAY_XRATE
,CASH_BASIS_FINAL_APP_ROUNDING
,AMOUNT_AT_PREPAY_PAY_XRATE
,INTENDED_USE
,DETAIL_TAX_DIST_ID
,REC_NREC_RATE
,RECOVERY_RATE_ID
,RECOVERY_RATE_NAME
,RECOVERY_TYPE_CODE
,RECOVERY_RATE_CODE
,WITHHOLDING_TAX_CODE_ID
,TAX_ALREADY_DISTRIBUTED_FLAG
,SUMMARY_TAX_LINE_ID
,TAXABLE_AMOUNT
,TAXABLE_BASE_AMOUNT
,EXTRA_PO_ERV
,PREPAY_TAX_DIFF_AMOUNT
,TAX_CODE_ID
,VAT_CODE
,AMOUNT_INCLUDES_TAX_FLAG
,TAX_CALCULATED_FLAG
,TAX_RECOVERY_RATE
,TAX_RECOVERY_OVERRIDE_FLAG
,TAX_CODE_OVERRIDE_FLAG
,TOTAL_DIST_AMOUNT
,TOTAL_DIST_BASE_AMOUNT
,PREPAY_TAX_PARENT_ID
,CANCELLED_FLAG
,OLD_DISTRIBUTION_ID
,OLD_DIST_LINE_NUMBER
,AMOUNT_VARIANCE
,BASE_AMOUNT_VARIANCE
,HISTORICAL_FLAG
,RCV_CHARGE_ADDITION_FLAG
,AWT_RELATED_ID
,RELATED_RETAINAGE_DIST_ID
,RETAINED_AMOUNT_REMAINING
,BC_EVENT_ID
,RETAINED_INVOICE_DIST_ID
,FINAL_RELEASE_ROUNDING
,FULLY_PAID_ACCTD_FLAG
,ROOT_DISTRIBUTION_ID
,XINV_PARENT_REVERSAL_ID
,RECURRING_PAYMENT_ID
,RELEASE_INV_DIST_DERIVED_FROM
,PAY_AWT_GROUP_ID
)
VALUES
(p_ap_invoice_dist_all_rec.ACCOUNTING_DATE
,p_ap_invoice_dist_all_rec.ACCRUAL_POSTED_FLAG
,p_ap_invoice_dist_all_rec.ASSETS_ADDITION_FLAG
,p_ap_invoice_dist_all_rec.ASSETS_TRACKING_FLAG
,p_ap_invoice_dist_all_rec.CASH_POSTED_FLAG
,p_ap_invoice_dist_all_rec.DISTRIBUTION_LINE_NUMBER
,p_ap_invoice_dist_all_rec.DIST_CODE_COMBINATION_ID
,p_ap_invoice_dist_all_rec.INVOICE_ID
,p_ap_invoice_dist_all_rec.LAST_UPDATED_BY
,p_ap_invoice_dist_all_rec.LAST_UPDATE_DATE
,p_ap_invoice_dist_all_rec.LINE_TYPE_LOOKUP_CODE
,p_ap_invoice_dist_all_rec.PERIOD_NAME
,p_ap_invoice_dist_all_rec.SET_OF_BOOKS_ID
,p_ap_invoice_dist_all_rec.ACCTS_PAY_CODE_COMBINATION_ID
,p_ap_invoice_dist_all_rec.AMOUNT
,p_ap_invoice_dist_all_rec.BASE_AMOUNT
,p_ap_invoice_dist_all_rec.BASE_INVOICE_PRICE_VARIANCE
,p_ap_invoice_dist_all_rec.BATCH_ID
,p_ap_invoice_dist_all_rec.CREATED_BY
,p_ap_invoice_dist_all_rec.CREATION_DATE
,p_ap_invoice_dist_all_rec.DESCRIPTION
,p_ap_invoice_dist_all_rec.EXCHANGE_RATE_VARIANCE
,p_ap_invoice_dist_all_rec.FINAL_MATCH_FLAG
,p_ap_invoice_dist_all_rec.INCOME_TAX_REGION
,p_ap_invoice_dist_all_rec.INVOICE_PRICE_VARIANCE
,p_ap_invoice_dist_all_rec.LAST_UPDATE_LOGIN
,p_ap_invoice_dist_all_rec.MATCH_STATUS_FLAG
,p_ap_invoice_dist_all_rec.POSTED_FLAG
,p_ap_invoice_dist_all_rec.PO_DISTRIBUTION_ID
,p_ap_invoice_dist_all_rec.PROGRAM_APPLICATION_ID
,p_ap_invoice_dist_all_rec.PROGRAM_ID
,p_ap_invoice_dist_all_rec.PROGRAM_UPDATE_DATE
,p_ap_invoice_dist_all_rec.QUANTITY_INVOICED
,p_ap_invoice_dist_all_rec.RATE_VAR_CODE_COMBINATION_ID
,p_ap_invoice_dist_all_rec.REQUEST_ID
,p_ap_invoice_dist_all_rec.REVERSAL_FLAG
,p_ap_invoice_dist_all_rec.TYPE_1099
,p_ap_invoice_dist_all_rec.UNIT_PRICE
,p_ap_invoice_dist_all_rec.AMOUNT_ENCUMBERED
,p_ap_invoice_dist_all_rec.BASE_AMOUNT_ENCUMBERED
,p_ap_invoice_dist_all_rec.ENCUMBERED_FLAG
,p_ap_invoice_dist_all_rec.EXCHANGE_DATE
,p_ap_invoice_dist_all_rec.EXCHANGE_RATE
,p_ap_invoice_dist_all_rec.EXCHANGE_RATE_TYPE
,p_ap_invoice_dist_all_rec.PRICE_ADJUSTMENT_FLAG
,p_ap_invoice_dist_all_rec.PRICE_VAR_CODE_COMBINATION_ID
,p_ap_invoice_dist_all_rec.QUANTITY_UNENCUMBERED
,p_ap_invoice_dist_all_rec.STAT_AMOUNT
,p_ap_invoice_dist_all_rec.AMOUNT_TO_POST
,p_ap_invoice_dist_all_rec.ATTRIBUTE1
,p_ap_invoice_dist_all_rec.ATTRIBUTE10
,p_ap_invoice_dist_all_rec.ATTRIBUTE11
,p_ap_invoice_dist_all_rec.ATTRIBUTE12
,p_ap_invoice_dist_all_rec.ATTRIBUTE13
,p_ap_invoice_dist_all_rec.ATTRIBUTE14
,p_ap_invoice_dist_all_rec.ATTRIBUTE15
,p_ap_invoice_dist_all_rec.ATTRIBUTE2
,p_ap_invoice_dist_all_rec.ATTRIBUTE3
,p_ap_invoice_dist_all_rec.ATTRIBUTE4
,p_ap_invoice_dist_all_rec.ATTRIBUTE5
,p_ap_invoice_dist_all_rec.ATTRIBUTE6
,p_ap_invoice_dist_all_rec.ATTRIBUTE7
,p_ap_invoice_dist_all_rec.ATTRIBUTE8
,p_ap_invoice_dist_all_rec.ATTRIBUTE9
,p_ap_invoice_dist_all_rec.ATTRIBUTE_CATEGORY
,p_ap_invoice_dist_all_rec.BASE_AMOUNT_TO_POST
,p_ap_invoice_dist_all_rec.CASH_JE_BATCH_ID
,p_ap_invoice_dist_all_rec.EXPENDITURE_ITEM_DATE
,p_ap_invoice_dist_all_rec.EXPENDITURE_ORGANIZATION_ID
,p_ap_invoice_dist_all_rec.EXPENDITURE_TYPE
,p_ap_invoice_dist_all_rec.JE_BATCH_ID
,p_ap_invoice_dist_all_rec.PARENT_INVOICE_ID
,p_ap_invoice_dist_all_rec.PA_ADDITION_FLAG
,p_ap_invoice_dist_all_rec.PA_QUANTITY
,p_ap_invoice_dist_all_rec.POSTED_AMOUNT
,p_ap_invoice_dist_all_rec.POSTED_BASE_AMOUNT
,p_ap_invoice_dist_all_rec.PREPAY_AMOUNT_REMAINING
,p_ap_invoice_dist_all_rec.PROJECT_ACCOUNTING_CONTEXT
,p_ap_invoice_dist_all_rec.PROJECT_ID
,p_ap_invoice_dist_all_rec.TASK_ID
,p_ap_invoice_dist_all_rec.USSGL_TRANSACTION_CODE
,p_ap_invoice_dist_all_rec.USSGL_TRX_CODE_CONTEXT
,p_ap_invoice_dist_all_rec.EARLIEST_SETTLEMENT_DATE
,p_ap_invoice_dist_all_rec.REQ_DISTRIBUTION_ID
,p_ap_invoice_dist_all_rec.QUANTITY_VARIANCE
,p_ap_invoice_dist_all_rec.BASE_QUANTITY_VARIANCE
,p_ap_invoice_dist_all_rec.PACKET_ID
,p_ap_invoice_dist_all_rec.AWT_FLAG
,p_ap_invoice_dist_all_rec.AWT_GROUP_ID
,p_ap_invoice_dist_all_rec.AWT_TAX_RATE_ID
,p_ap_invoice_dist_all_rec.AWT_GROSS_AMOUNT
,p_ap_invoice_dist_all_rec.AWT_INVOICE_ID
,p_ap_invoice_dist_all_rec.AWT_ORIGIN_GROUP_ID
,p_ap_invoice_dist_all_rec.REFERENCE_1
,p_ap_invoice_dist_all_rec.REFERENCE_2
,p_ap_invoice_dist_all_rec.ORG_ID
,p_ap_invoice_dist_all_rec.OTHER_INVOICE_ID
,p_ap_invoice_dist_all_rec.AWT_INVOICE_PAYMENT_ID
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE_CATEGORY
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE1
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE2
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE3
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE4
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE5
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE6
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE7
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE8
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE9
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE10
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE11
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE12
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE13
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE14
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE15
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE16
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE17
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE18
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE19
,p_ap_invoice_dist_all_rec.GLOBAL_ATTRIBUTE20
,p_ap_invoice_dist_all_rec.LINE_GROUP_NUMBER
,p_ap_invoice_dist_all_rec.RECEIPT_VERIFIED_FLAG
,p_ap_invoice_dist_all_rec.RECEIPT_REQUIRED_FLAG
,p_ap_invoice_dist_all_rec.RECEIPT_MISSING_FLAG
,p_ap_invoice_dist_all_rec.JUSTIFICATION
,p_ap_invoice_dist_all_rec.EXPENSE_GROUP
,p_ap_invoice_dist_all_rec.START_EXPENSE_DATE
,p_ap_invoice_dist_all_rec.END_EXPENSE_DATE
,p_ap_invoice_dist_all_rec.RECEIPT_CURRENCY_CODE
,p_ap_invoice_dist_all_rec.RECEIPT_CONVERSION_RATE
,p_ap_invoice_dist_all_rec.RECEIPT_CURRENCY_AMOUNT
,p_ap_invoice_dist_all_rec.DAILY_AMOUNT
,p_ap_invoice_dist_all_rec.WEB_PARAMETER_ID
,p_ap_invoice_dist_all_rec.ADJUSTMENT_REASON
,p_ap_invoice_dist_all_rec.AWARD_ID
,p_ap_invoice_dist_all_rec.MRC_ACCRUAL_POSTED_FLAG
,p_ap_invoice_dist_all_rec.MRC_CASH_POSTED_FLAG
,p_ap_invoice_dist_all_rec.MRC_DIST_CODE_COMBINATION_ID
,p_ap_invoice_dist_all_rec.MRC_AMOUNT
,p_ap_invoice_dist_all_rec.MRC_BASE_AMOUNT
,p_ap_invoice_dist_all_rec.MRC_BASE_INV_PRICE_VARIANCE
,p_ap_invoice_dist_all_rec.MRC_EXCHANGE_RATE_VARIANCE
,p_ap_invoice_dist_all_rec.MRC_POSTED_FLAG
,p_ap_invoice_dist_all_rec.MRC_PROGRAM_APPLICATION_ID
,p_ap_invoice_dist_all_rec.MRC_PROGRAM_ID
,p_ap_invoice_dist_all_rec.MRC_PROGRAM_UPDATE_DATE
,p_ap_invoice_dist_all_rec.MRC_RATE_VAR_CCID
,p_ap_invoice_dist_all_rec.MRC_REQUEST_ID
,p_ap_invoice_dist_all_rec.MRC_EXCHANGE_DATE
,p_ap_invoice_dist_all_rec.MRC_EXCHANGE_RATE
,p_ap_invoice_dist_all_rec.MRC_EXCHANGE_RATE_TYPE
,p_ap_invoice_dist_all_rec.MRC_AMOUNT_TO_POST
,p_ap_invoice_dist_all_rec.MRC_BASE_AMOUNT_TO_POST
,p_ap_invoice_dist_all_rec.MRC_CASH_JE_BATCH_ID
,p_ap_invoice_dist_all_rec.MRC_JE_BATCH_ID
,p_ap_invoice_dist_all_rec.MRC_POSTED_AMOUNT
,p_ap_invoice_dist_all_rec.MRC_POSTED_BASE_AMOUNT
,p_ap_invoice_dist_all_rec.MRC_RECEIPT_CONVERSION_RATE
,p_ap_invoice_dist_all_rec.CREDIT_CARD_TRX_ID
,p_ap_invoice_dist_all_rec.DIST_MATCH_TYPE
,p_ap_invoice_dist_all_rec.RCV_TRANSACTION_ID
,ln_dist_id--p_ap_invoice_dist_all_rec.INVOICE_DISTRIBUTION_ID
,p_ap_invoice_dist_all_rec.PARENT_REVERSAL_ID
,p_ap_invoice_dist_all_rec.TAX_RECOVERABLE_FLAG
,p_ap_invoice_dist_all_rec.PA_CC_AR_INVOICE_ID
,p_ap_invoice_dist_all_rec.PA_CC_AR_INVOICE_LINE_NUM
,p_ap_invoice_dist_all_rec.PA_CC_PROCESSED_CODE
,p_ap_invoice_dist_all_rec.MERCHANT_DOCUMENT_NUMBER
,p_ap_invoice_dist_all_rec.MERCHANT_NAME
,p_ap_invoice_dist_all_rec.MERCHANT_REFERENCE
,p_ap_invoice_dist_all_rec.MERCHANT_TAX_REG_NUMBER
,p_ap_invoice_dist_all_rec.MERCHANT_TAXPAYER_ID
,p_ap_invoice_dist_all_rec.COUNTRY_OF_SUPPLY
,p_ap_invoice_dist_all_rec.MATCHED_UOM_LOOKUP_CODE
,p_ap_invoice_dist_all_rec.GMS_BURDENABLE_RAW_COST
,p_ap_invoice_dist_all_rec.ACCOUNTING_EVENT_ID
,p_ap_invoice_dist_all_rec.PREPAY_DISTRIBUTION_ID
,p_ap_invoice_dist_all_rec.UPGRADE_POSTED_AMT
,p_ap_invoice_dist_all_rec.UPGRADE_BASE_POSTED_AMT
,p_ap_invoice_dist_all_rec.INVENTORY_TRANSFER_STATUS
,p_ap_invoice_dist_all_rec.COMPANY_PREPAID_INVOICE_ID
,p_ap_invoice_dist_all_rec.CC_REVERSAL_FLAG
,p_ap_invoice_dist_all_rec.AWT_WITHHELD_AMT
,p_ap_invoice_dist_all_rec.INVOICE_INCLUDES_PREPAY_FLAG
,p_ap_invoice_dist_all_rec.PRICE_CORRECT_INV_ID
,p_ap_invoice_dist_all_rec.PRICE_CORRECT_QTY
,p_ap_invoice_dist_all_rec.PA_CMT_XFACE_FLAG
,p_ap_invoice_dist_all_rec.CANCELLATION_FLAG
,p_ap_invoice_dist_all_rec.INVOICE_LINE_NUMBER
,p_ap_invoice_dist_all_rec.CORRECTED_INVOICE_DIST_ID
,p_ap_invoice_dist_all_rec.ROUNDING_AMT
,p_ap_invoice_dist_all_rec.CHARGE_APPLICABLE_TO_DIST_ID
,p_ap_invoice_dist_all_rec.CORRECTED_QUANTITY
,p_ap_invoice_dist_all_rec.RELATED_ID
,p_ap_invoice_dist_all_rec.ASSET_BOOK_TYPE_CODE
,p_ap_invoice_dist_all_rec.ASSET_CATEGORY_ID
,p_ap_invoice_dist_all_rec.DISTRIBUTION_CLASS
,p_ap_invoice_dist_all_rec.FINAL_PAYMENT_ROUNDING
,p_ap_invoice_dist_all_rec.FINAL_APPLICATION_ROUNDING
,p_ap_invoice_dist_all_rec.AMOUNT_AT_PREPAY_XRATE
,p_ap_invoice_dist_all_rec.CASH_BASIS_FINAL_APP_ROUNDING
,p_ap_invoice_dist_all_rec.AMOUNT_AT_PREPAY_PAY_XRATE
,p_ap_invoice_dist_all_rec.INTENDED_USE
,p_ap_invoice_dist_all_rec.DETAIL_TAX_DIST_ID
,p_ap_invoice_dist_all_rec.REC_NREC_RATE
,p_ap_invoice_dist_all_rec.RECOVERY_RATE_ID
,p_ap_invoice_dist_all_rec.RECOVERY_RATE_NAME
,p_ap_invoice_dist_all_rec.RECOVERY_TYPE_CODE
,p_ap_invoice_dist_all_rec.RECOVERY_RATE_CODE
,p_ap_invoice_dist_all_rec.WITHHOLDING_TAX_CODE_ID
,p_ap_invoice_dist_all_rec.TAX_ALREADY_DISTRIBUTED_FLAG
,p_ap_invoice_dist_all_rec.SUMMARY_TAX_LINE_ID
,p_ap_invoice_dist_all_rec.TAXABLE_AMOUNT
,p_ap_invoice_dist_all_rec.TAXABLE_BASE_AMOUNT
,p_ap_invoice_dist_all_rec.EXTRA_PO_ERV
,p_ap_invoice_dist_all_rec.PREPAY_TAX_DIFF_AMOUNT
,p_ap_invoice_dist_all_rec.TAX_CODE_ID
,p_ap_invoice_dist_all_rec.VAT_CODE
,p_ap_invoice_dist_all_rec.AMOUNT_INCLUDES_TAX_FLAG
,p_ap_invoice_dist_all_rec.TAX_CALCULATED_FLAG
,p_ap_invoice_dist_all_rec.TAX_RECOVERY_RATE
,p_ap_invoice_dist_all_rec.TAX_RECOVERY_OVERRIDE_FLAG
,p_ap_invoice_dist_all_rec.TAX_CODE_OVERRIDE_FLAG
,p_ap_invoice_dist_all_rec.TOTAL_DIST_AMOUNT
,p_ap_invoice_dist_all_rec.TOTAL_DIST_BASE_AMOUNT
,p_ap_invoice_dist_all_rec.PREPAY_TAX_PARENT_ID
,p_ap_invoice_dist_all_rec.CANCELLED_FLAG
,p_ap_invoice_dist_all_rec.OLD_DISTRIBUTION_ID
,p_ap_invoice_dist_all_rec.OLD_DIST_LINE_NUMBER
,p_ap_invoice_dist_all_rec.AMOUNT_VARIANCE
,p_ap_invoice_dist_all_rec.BASE_AMOUNT_VARIANCE
,p_ap_invoice_dist_all_rec.HISTORICAL_FLAG
,p_ap_invoice_dist_all_rec.RCV_CHARGE_ADDITION_FLAG
,p_ap_invoice_dist_all_rec.AWT_RELATED_ID
,p_ap_invoice_dist_all_rec.RELATED_RETAINAGE_DIST_ID
,p_ap_invoice_dist_all_rec.RETAINED_AMOUNT_REMAINING
,p_ap_invoice_dist_all_rec.BC_EVENT_ID
,p_ap_invoice_dist_all_rec.RETAINED_INVOICE_DIST_ID
,p_ap_invoice_dist_all_rec.FINAL_RELEASE_ROUNDING
,p_ap_invoice_dist_all_rec.FULLY_PAID_ACCTD_FLAG
,p_ap_invoice_dist_all_rec.ROOT_DISTRIBUTION_ID
,p_ap_invoice_dist_all_rec.XINV_PARENT_REVERSAL_ID
,p_ap_invoice_dist_all_rec.RECURRING_PAYMENT_ID
,p_ap_invoice_dist_all_rec.RELEASE_INV_DIST_DERIVED_FROM
,p_ap_invoice_dist_all_rec.PAY_AWT_GROUP_ID
);
END insert_ap_inv_dist;
SELECT *
FROM ap_invoice_lines_all
WHERE invoice_id = pn_invoice_id AND line_number = pn_invoice_line_num;
SELECT SOURCE FROM ap_invoices_all WHERE invoice_id = pn_invoice_id;
SELECT vendor_id, vendor_site_id, invoice_type_lookup_code, cancelled_date
FROM ap_invoices_all
WHERE invoice_id = pn_invoice_id;
SELECT po_header_id,po_line_id
FROM rcv_transactions
WHERE transaction_id = v_rcv_trans_id;
SELECT COUNT(*)
FROM JAI_AP_MATCH_INV_TAXES
WHERE po_header_id = v_po_header_id
AND po_line_id = v_po_line_id
AND invoice_id = v_invoice_id;
SELECT SUBSTR(SUBSTR(invoice_num, INSTR(invoice_num, '-', 1, 1) + 1 ,
(INSTR(invoice_num, '-', 1, 2)-1) - INSTR(invoice_num, '-', 1, 1)
),1,30), Source
FROM ap_invoices_all
WHERE invoice_id = pn_invoice_id;
SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
FROM rcv_shipment_headers rsh, rcv_transactions rt
WHERE rsh.shipment_header_id = rt.shipment_header_id
AND rsh.packing_slip = p_pck_slip
AND rsh.vendor_id = ven_id
AND rt.transaction_type = cpv_transaction_type;
SELECT pay_on_code, pay_on_receipt_summary_code
FROM po_vendor_sites_all
WHERE vendor_id = ven_id
AND vendor_site_id = ven_site_id
AND NVL(org_id, 0) = NVL(v_org_id, 0);
SELECT Inventory_Organization_Id
FROM Hr_Locations
WHERE Location_Id = ( SELECT Ship_To_Location_Id
FROM Po_Headers_All
WHERE Po_Header_Id = ( SELECT Po_Header_Id
FROM Po_Distributions_All
WHERE Po_Distribution_Id = c_po_dist_id
)
);
SELECT Shipment_Line_Id, Shipment_Header_Id
FROM Rcv_Shipment_Lines
WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
FROM Rcv_Shipment_Headers
WHERE Receipt_Num = receiptnum )
AND Po_Line_location_Id = ( SELECT Line_Location_Id
FROM Po_Distributions_All
WHERE Po_Distribution_Id = c_po_dist_id)
AND To_Organization_Id = invorg;
SELECT COUNT( Shipment_Line_Id )
FROM Rcv_Shipment_Lines
WHERE Shipment_Header_Id = v_shipment_header_id
AND To_Organization_Id = invorg;
SELECT amount, invoice_distribution_id
FROM ap_invoice_distributions_all
WHERE invoice_id = p_price_correct_inv_id AND
po_distribution_id = p_po_distribution_id AND
line_type_lookup_code = 'ITEM';
SELECT SUM(jam.tax_amount) tax_amount
FROM jai_ap_match_inv_taxes jam, jai_cmn_taxes_all jct
WHERE p_orig_invoice_id = p_orig_invoice_id AND
parent_invoice_distribution_id = p_orig_invoice_dist_id AND
jam.tax_id = p_tax_id
AND jam.tax_id = jct.tax_id AND
(nvl(jct.adhoc_flag,'N') = 'Y' OR
(jct.adhoc_flag = 'Y' AND
jct.tax_type NOT IN ('Freight', 'Insurance', 'Octrai', 'Other','PURCHASE TAX', 'ENTRY TAX')));
EXECUTE IMMEDIATE 'select /* price_correct_inv_id */, po_distribution_id, amount, quantity_invoiced
from ap_invoice_lines_all
where invoice_id = :inv_id
and line_number = :inv_line_num'
INTO cur_price_correct_inv_id, cur_po_distribution_id, cur_amount, cur_quantity_invoiced
USING p_inv_id, p_invoice_line_num;
SELECT organization_id, location_id
FROM rcv_transactions
WHERE transaction_id = pn_rcv_trx_id;
SELECT ship_to_organization_id, ship_to_location_id
FROM po_line_locations_all plla, po_distributions_all pod
WHERE plla.line_location_id = pod.line_location_id AND
pod.po_distribution_id = pn_po_dist_id;
procedure update_ap_inv_line(p_invoice_id number,
p_invoice_line_number number) is
begin
Update ap_invoice_lines_all
set discarded_flag = 'Y',
amount = 0,
last_update_date = sysdate,
last_updated_by = -1
Where invoice_id = p_invoice_id
and line_number = p_invoice_line_number
and line_type_lookup_code = 'MISCELLANEOUS';
end update_ap_inv_line;
select la.invoice_id,
la.po_distribution_id,
da.invoice_distribution_id,
la.rcv_transaction_id,
la.line_number invoice_line_number
from ap_invoice_lines_all la, ap_invoice_distributions_all da
where la.invoice_id = p_invoice_id
and la.invoice_id = da.invoice_id
and la.line_number = da.invoice_line_number
and la.line_type_lookup_code = 'MISCELLANEOUS'
and la.amount < 0
and la.reference_key1 is not null
and la.reference_key2 = p_invoice_line_number
union all
select invoice_id,
po_distribution_id,
invoice_distribution_id,
rcv_transaction_id,
invoice_line_number
from jai_ap_match_inv_taxes
where line_type_lookup_code = 'MISCELLANEOUS'
and invoice_id = p_invoice_id
and parent_invoice_line_number = p_invoice_line_number
and invoice_line_number <> p_invoice_line_number
AND tax_amount <> 0
and po_distribution_id = p_po_dist_id;
select accounting_date,
accrual_posted_flag,
assets_addition_flag,
assets_tracking_flag,
cash_posted_flag,
distribution_line_number,
dist_code_combination_id,
invoice_id,
line_type_lookup_code,
period_name,
set_of_books_id,
amount,
base_amount,
batch_id,
description,
exchange_rate_variance,
last_update_login,
match_status_flag,
posted_flag,
rate_var_code_combination_id,
reversal_flag,
program_application_id,
program_id,
program_update_date,
accts_pay_code_combination_id,
invoice_distribution_id,
quantity_invoiced,
po_distribution_id,
rcv_transaction_id,
price_var_code_combination_id,
invoice_price_variance,
base_invoice_price_variance,
matched_uom_lookup_code,
invoice_line_number,
org_id,
charge_applicable_to_dist_id,
project_id,
task_id,
expenditure_type,
expenditure_item_date,
expenditure_organization_id,
project_accounting_context,
pa_addition_flag,
distribution_class,
dist_match_type
from ap_invoice_distributions_all
where invoice_id = ln_invoice_id
and invoice_distribution_id = ln_invoice_distribution_id;
select accounting_date,
accrual_posted_flag,
assets_addition_flag,
assets_tracking_flag,
cash_posted_flag,
distribution_line_number,
dist_code_combination_id,
invoice_id,
line_type_lookup_code,
period_name,
set_of_books_id,
amount,
base_amount,
batch_id,
description,
exchange_rate_variance,
last_update_login,
match_status_flag,
posted_flag,
rate_var_code_combination_id,
reversal_flag,
program_application_id,
program_id,
program_update_date,
accts_pay_code_combination_id,
invoice_distribution_id,
quantity_invoiced,
po_distribution_id,
rcv_transaction_id,
price_var_code_combination_id,
invoice_price_variance,
base_invoice_price_variance,
matched_uom_lookup_code,
invoice_line_number,
org_id,
charge_applicable_to_dist_id,
project_id,
task_id,
expenditure_type,
expenditure_item_date,
expenditure_organization_id,
project_accounting_context,
pa_addition_flag,
distribution_class,
dist_match_type
from ap_invoice_distributions_all
where invoice_id = ln_invoice_id
and po_distribution_id = ln_po_distribution_id
and line_type_lookup_code = 'MISCELLANEOUS';
select source from ap_invoices_all where invoice_id = cp_invoice_id;
lc_inv_dist.last_update_login := ins_reverse_dist_lines.last_update_login;
lc_inv_dist.program_update_date := ins_reverse_dist_lines.program_update_date;
lc_inv_dist.Last_Updated_By := -1;
lc_inv_dist.Last_Update_date := sysdate;
lc_inv_dist.program_update_date := sysdate;
ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
jai_ap_match_tax_proc_pkg.update_ap_inv_line(ident_rec.invoice_id,
ident_rec.invoice_line_number);
lc_inv_dist.last_update_login := ins_reverse_dist_lines_ers.last_update_login;
lc_inv_dist.program_update_date := ins_reverse_dist_lines_ers.program_update_date;
lc_inv_dist.Last_Updated_By := -1;
lc_inv_dist.Last_Update_date := sysdate;
lc_inv_dist.program_update_date := sysdate;
ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
jai_ap_match_tax_proc_pkg.update_ap_inv_line(ins_reverse_dist_lines_ers.invoice_id,
ins_reverse_dist_lines_ers.invoice_line_number);
select sum(nm)
from (select count(1) nm
from ap_invoice_lines_all la, JAI_PO_TAXES pt
where la.match_type in ('ITEM_TO_PO')
and la.invoice_id = cp_invoice_id
and la.po_line_location_id = pt.line_location_id
and la.po_header_id = pt.po_header_id
and la.po_line_id = pt.po_line_id
and la.line_number = p_invoice_line_number
union all
select count(1) nm
from ap_invoice_lines_all la, JAI_RCV_LINE_TAXES lt
where la.match_type in ('ITEM_TO_RECEIPT')
and la.invoice_id = cp_invoice_id
and la.line_number = p_invoice_line_number
and la.rcv_transaction_id = lt.transaction_id);
select count(1)
from JAI_AP_MATCH_INV_TAXES
where invoice_id = cp_invoice_id
and PARENT_INVOICE_LINE_NUMBER = p_invoice_line_number;
select count(1)
from ap_invoice_lines_all
where invoice_id = cn_invoice_id;
select invoice_type_lookup_code
from ap_invoices_all
where invoice_id = cn_invoice_id;
select * from ap_invoice_lines_all where invoice_id = cn_invoice_id;