The following lines contain the word 'select', 'insert', 'update' or 'delete':
debug_info := 'Select from ap_invoice_lines_all';
SELECT COUNT(1)
INTO dummy
FROM ap_invoice_Lines_all
where (invoice_id = p_INVOICE_ID AND
line_number = p_LINE_NUMBER)
AND ((p_ROWID is null) OR
(rowid <> p_ROWID));
PROCEDURE Insert_Row (
p_ROWID IN OUT NOCOPY VARCHAR2,
p_INVOICE_ID NUMBER,
p_LINE_NUMBER NUMBER,
p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
p_LINE_GROUP_NUMBER NUMBER,
p_REQUESTER_ID NUMBER,
p_DESCRIPTION VARCHAR2,
p_LINE_SOURCE VARCHAR2,
p_ORG_ID NUMBER,
p_INVENTORY_ITEM_ID NUMBER,
p_ITEM_DESCRIPTION VARCHAR2,
p_SERIAL_NUMBER VARCHAR2,
p_MANUFACTURER VARCHAR2,
p_MODEL_NUMBER VARCHAR2,
p_WARRANTY_NUMBER VARCHAR2,
p_GENERATE_DISTS VARCHAR2,
p_MATCH_TYPE VARCHAR2,
p_DISTRIBUTION_SET_ID NUMBER,
p_ACCOUNT_SEGMENT VARCHAR2,
p_BALANCING_SEGMENT VARCHAR2,
p_COST_CENTER_SEGMENT VARCHAR2,
p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
p_DEFAULT_DIST_CCID NUMBER,
p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
p_ACCOUNTING_DATE DATE,
p_PERIOD_NAME VARCHAR2,
p_DEFERRED_ACCTG_FLAG VARCHAR2,
p_DEF_ACCTG_START_DATE DATE,
p_DEF_ACCTG_END_DATE DATE,
p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
p_SET_OF_BOOKS_ID NUMBER,
p_AMOUNT NUMBER,
p_BASE_AMOUNT NUMBER,
p_ROUNDING_AMT NUMBER,
p_QUANTITY_INVOICED NUMBER,
p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
p_UNIT_PRICE NUMBER,
p_WFAPPROVAL_STATUS VARCHAR2,
p_DISCARDED_FLAG VARCHAR2,
p_ORIGINAL_AMOUNT NUMBER,
p_ORIGINAL_BASE_AMOUNT NUMBER,
p_ORIGINAL_ROUNDING_AMT NUMBER,
p_CANCELLED_FLAG VARCHAR2,
p_INCOME_TAX_REGION VARCHAR2,
p_TYPE_1099 VARCHAR2,
p_STAT_AMOUNT NUMBER,
p_PREPAY_INVOICE_ID NUMBER,
p_PREPAY_LINE_NUMBER NUMBER,
p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
p_CORRECTED_INV_ID NUMBER,
p_CORRECTED_LINE_NUMBER NUMBER,
p_PO_HEADER_ID NUMBER,
p_PO_LINE_ID NUMBER,
p_PO_RELEASE_ID NUMBER,
p_PO_LINE_LOCATION_ID NUMBER,
p_PO_DISTRIBUTION_ID NUMBER,
p_RCV_TRANSACTION_ID NUMBER,
p_FINAL_MATCH_FLAG VARCHAR2,
p_ASSETS_TRACKING_FLAG VARCHAR2,
p_ASSET_BOOK_TYPE_CODE VARCHAR2,
p_ASSET_CATEGORY_ID NUMBER,
p_PROJECT_ID NUMBER,
p_TASK_ID NUMBER,
p_EXPENDITURE_TYPE VARCHAR2,
p_EXPENDITURE_ITEM_DATE DATE,
p_EXPENDITURE_ORGANIZATION_ID NUMBER,
p_PA_QUANTITY NUMBER,
p_PA_CC_AR_INVOICE_ID NUMBER,
p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
p_PA_CC_PROCESSED_CODE VARCHAR2,
p_AWARD_ID NUMBER,
p_AWT_GROUP_ID NUMBER,
p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
p_REFERENCE_1 VARCHAR2,
p_REFERENCE_2 VARCHAR2,
p_RECEIPT_VERIFIED_FLAG VARCHAR2,
p_RECEIPT_REQUIRED_FLAG VARCHAR2,
p_RECEIPT_MISSING_FLAG VARCHAR2,
p_JUSTIFICATION VARCHAR2,
p_EXPENSE_GROUP VARCHAR2,
p_START_EXPENSE_DATE DATE,
p_END_EXPENSE_DATE DATE,
p_RECEIPT_CURRENCY_CODE VARCHAR2,
p_RECEIPT_CONVERSION_RATE NUMBER,
p_RECEIPT_CURRENCY_AMOUNT NUMBER,
p_DAILY_AMOUNT NUMBER,
p_WEB_PARAMETER_ID NUMBER,
p_ADJUSTMENT_REASON VARCHAR2,
p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
p_MERCHANT_NAME VARCHAR2,
p_MERCHANT_REFERENCE VARCHAR2,
p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
p_MERCHANT_TAXPAYER_ID VARCHAR2,
p_COUNTRY_OF_SUPPLY VARCHAR2,
p_CREDIT_CARD_TRX_ID NUMBER,
p_COMPANY_PREPAID_INVOICE_ID NUMBER,
p_CC_REVERSAL_FLAG VARCHAR2,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_REQUEST_ID NUMBER,
p_ATTRIBUTE_CATEGORY VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
--ETAX: Invwkb
p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
p_TAX VARCHAR2 DEFAULT NULL,
p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
p_TAX_RATE_ID NUMBER DEFAULT NULL,
p_TAX_RATE NUMBER DEFAULT NULL,
p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
p_COST_FACTOR_ID NUMBER DEFAULT NULL,
p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
p_Calling_Sequence VARCHAR2)
IS
current_calling_sequence VARCHAR2(2000);
SELECT rowid
FROM AP_INVOICE_LINES_ALL
WHERE invoice_id = p_Invoice_Id
AND line_number = p_Line_Number;
current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Insert_Row<-'
||p_Calling_Sequence;
'AP_AIL_TABLE_HANDLER_PKG.Insert_Row');
debug_info := 'Insert into ap_invoice_lines_all';
INSERT INTO AP_INVOICE_LINES_ALL(
INVOICE_ID ,
LINE_NUMBER ,
LINE_TYPE_LOOKUP_CODE ,
LINE_GROUP_NUMBER ,
REQUESTER_ID ,
DESCRIPTION ,
LINE_SOURCE ,
ORG_ID ,
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 ,
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 ,
PAY_AWT_GROUP_ID ,--bug6639866
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 ,
PRIMARY_INTENDED_USE ,
SHIP_TO_LOCATION_ID ,
PRODUCT_FISC_CLASSIFICATION,
USER_DEFINED_FISC_CLASS ,
TRX_BUSINESS_CATEGORY ,
PRODUCT_TYPE ,
PRODUCT_CATEGORY ,
ASSESSABLE_VALUE ,
CONTROL_AMOUNT ,
TAX_REGIME_CODE ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_CODE ,
TAX_RATE_ID ,
TAX_RATE ,
TAX_JURISDICTION_CODE ,
PURCHASING_CATEGORY_ID ,
COST_FACTOR_ID ,
RETAINED_AMOUNT ,
RETAINED_AMOUNT_REMAINING,
RETAINED_INVOICE_ID ,
RETAINED_LINE_NUMBER ,
TAX_CLASSIFICATION_CODE
)
VALUES (
p_INVOICE_ID ,
p_LINE_NUMBER ,
p_LINE_TYPE_LOOKUP_CODE ,
p_LINE_GROUP_NUMBER ,
p_REQUESTER_ID ,
p_DESCRIPTION ,
p_LINE_SOURCE ,
p_ORG_ID ,
p_INVENTORY_ITEM_ID ,
p_ITEM_DESCRIPTION ,
p_SERIAL_NUMBER ,
p_MANUFACTURER ,
p_MODEL_NUMBER ,
p_WARRANTY_NUMBER ,
p_GENERATE_DISTS ,
p_MATCH_TYPE ,
p_DISTRIBUTION_SET_ID ,
p_ACCOUNT_SEGMENT ,
p_BALANCING_SEGMENT ,
p_COST_CENTER_SEGMENT ,
p_OVERLAY_DIST_CODE_CONCAT ,
p_DEFAULT_DIST_CCID ,
p_PRORATE_ACROSS_ALL_ITEMS ,
p_ACCOUNTING_DATE ,
p_PERIOD_NAME ,
p_DEFERRED_ACCTG_FLAG ,
p_DEF_ACCTG_START_DATE ,
p_DEF_ACCTG_END_DATE ,
p_DEF_ACCTG_NUMBER_OF_PERIODS,
p_DEF_ACCTG_PERIOD_TYPE ,
p_SET_OF_BOOKS_ID ,
p_AMOUNT ,
p_BASE_AMOUNT ,
p_ROUNDING_AMT ,
p_QUANTITY_INVOICED ,
p_UNIT_MEAS_LOOKUP_CODE ,
p_UNIT_PRICE ,
p_WFAPPROVAL_STATUS ,
p_DISCARDED_FLAG ,
p_ORIGINAL_AMOUNT ,
p_ORIGINAL_BASE_AMOUNT ,
p_ORIGINAL_ROUNDING_AMT ,
p_CANCELLED_FLAG ,
p_INCOME_TAX_REGION ,
p_TYPE_1099 ,
p_STAT_AMOUNT ,
p_PREPAY_INVOICE_ID ,
p_PREPAY_LINE_NUMBER ,
p_INVOICE_INCLUDES_PREPAY_FLAG,
p_CORRECTED_INV_ID ,
p_CORRECTED_LINE_NUMBER ,
p_PO_HEADER_ID ,
p_PO_LINE_ID ,
p_PO_RELEASE_ID ,
p_PO_LINE_LOCATION_ID ,
p_PO_DISTRIBUTION_ID ,
p_RCV_TRANSACTION_ID ,
p_FINAL_MATCH_FLAG ,
p_ASSETS_TRACKING_FLAG ,
p_ASSET_BOOK_TYPE_CODE ,
p_ASSET_CATEGORY_ID ,
p_PROJECT_ID ,
p_TASK_ID ,
p_EXPENDITURE_TYPE ,
p_EXPENDITURE_ITEM_DATE ,
p_EXPENDITURE_ORGANIZATION_ID,
p_PA_QUANTITY ,
p_PA_CC_AR_INVOICE_ID ,
p_PA_CC_AR_INVOICE_LINE_NUM,
p_PA_CC_PROCESSED_CODE ,
p_AWARD_ID ,
p_AWT_GROUP_ID ,
p_PAY_AWT_GROUP_ID ,--bug6639866
p_REFERENCE_1 ,
p_REFERENCE_2 ,
p_RECEIPT_VERIFIED_FLAG ,
p_RECEIPT_REQUIRED_FLAG ,
p_RECEIPT_MISSING_FLAG ,
p_JUSTIFICATION ,
p_EXPENSE_GROUP ,
p_START_EXPENSE_DATE ,
p_END_EXPENSE_DATE ,
p_RECEIPT_CURRENCY_CODE ,
p_RECEIPT_CONVERSION_RATE ,
p_RECEIPT_CURRENCY_AMOUNT ,
p_DAILY_AMOUNT ,
p_WEB_PARAMETER_ID ,
p_ADJUSTMENT_REASON ,
p_MERCHANT_DOCUMENT_NUMBER ,
p_MERCHANT_NAME ,
p_MERCHANT_REFERENCE ,
p_MERCHANT_TAX_REG_NUMBER ,
p_MERCHANT_TAXPAYER_ID ,
p_COUNTRY_OF_SUPPLY ,
p_CREDIT_CARD_TRX_ID ,
p_COMPANY_PREPAID_INVOICE_ID,
p_CC_REVERSAL_FLAG ,
p_CREATION_DATE ,
p_CREATED_BY ,
p_LAST_UPDATED_BY ,
p_LAST_UPDATE_DATE ,
p_LAST_UPDATE_LOGIN ,
p_PROGRAM_APPLICATION_ID ,
p_PROGRAM_ID ,
p_PROGRAM_UPDATE_DATE ,
p_REQUEST_ID ,
p_ATTRIBUTE_CATEGORY ,
p_ATTRIBUTE1 ,
p_ATTRIBUTE2 ,
p_ATTRIBUTE3 ,
p_ATTRIBUTE4 ,
p_ATTRIBUTE5 ,
p_ATTRIBUTE6 ,
p_ATTRIBUTE7 ,
p_ATTRIBUTE8 ,
p_ATTRIBUTE9 ,
p_ATTRIBUTE10 ,
p_ATTRIBUTE11 ,
p_ATTRIBUTE12 ,
p_ATTRIBUTE13 ,
p_ATTRIBUTE14 ,
p_ATTRIBUTE15 ,
p_GLOBAL_ATTRIBUTE_CATEGORY,
p_GLOBAL_ATTRIBUTE1 ,
p_GLOBAL_ATTRIBUTE2 ,
p_GLOBAL_ATTRIBUTE3 ,
p_GLOBAL_ATTRIBUTE4 ,
p_GLOBAL_ATTRIBUTE5 ,
p_GLOBAL_ATTRIBUTE6 ,
p_GLOBAL_ATTRIBUTE7 ,
p_GLOBAL_ATTRIBUTE8 ,
p_GLOBAL_ATTRIBUTE9 ,
p_GLOBAL_ATTRIBUTE10 ,
p_GLOBAL_ATTRIBUTE11 ,
p_GLOBAL_ATTRIBUTE12 ,
p_GLOBAL_ATTRIBUTE13 ,
p_GLOBAL_ATTRIBUTE14 ,
p_GLOBAL_ATTRIBUTE15 ,
p_GLOBAL_ATTRIBUTE16 ,
p_GLOBAL_ATTRIBUTE17 ,
p_GLOBAL_ATTRIBUTE18 ,
p_GLOBAL_ATTRIBUTE19 ,
p_GLOBAL_ATTRIBUTE20 ,
p_PRIMARY_INTENDED_USE ,
p_SHIP_TO_LOCATION_ID ,
p_PRODUCT_FISC_CLASSIFICATION,
p_USER_DEFINED_FISC_CLASS ,
p_TRX_BUSINESS_CATEGORY ,
p_PRODUCT_TYPE ,
p_PRODUCT_CATEGORY ,
p_ASSESSABLE_VALUE ,
p_CONTROL_AMOUNT ,
p_TAX_REGIME_CODE ,
p_TAX ,
p_TAX_STATUS_CODE ,
p_TAX_RATE_CODE ,
p_TAX_RATE_ID ,
p_TAX_RATE ,
p_TAX_JURISDICTION_CODE ,
p_PURCHASING_CATEGORY_ID ,
p_COST_FACTOR_ID ,
p_RETAINED_AMOUNT ,
-(p_RETAINED_AMOUNT) ,
p_RETAINED_INVOICE_ID ,
p_RETAINED_LINE_NUMBER ,
p_TAX_CLASSIFICATION_CODE );
END Insert_Row;
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_REQUEST_ID NUMBER,
p_ATTRIBUTE_CATEGORY VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
p_TAX VARCHAR2 DEFAULT NULL,
p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
p_TAX_RATE_ID NUMBER DEFAULT NULL,
p_TAX_RATE NUMBER DEFAULT NULL,
p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
p_COST_FACTOR_ID NUMBER DEFAULT NULL,
p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
p_Calling_Sequence VARCHAR2)
IS
current_calling_sequence VARCHAR2(2000);
SELECT
INVOICE_ID ,
LINE_NUMBER ,
LINE_TYPE_LOOKUP_CODE ,
LINE_GROUP_NUMBER ,
REQUESTER_ID ,
DESCRIPTION ,
LINE_SOURCE ,
ORG_ID ,
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 ,
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 ,
PAY_AWT_GROUP_ID ,--bug6639866
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 ,
TRUNC(PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE, --BUG 16282205
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 ,
PRIMARY_INTENDED_USE ,
SHIP_TO_LOCATION_ID ,
PRODUCT_FISC_CLASSIFICATION,
USER_DEFINED_FISC_CLASS ,
TRX_BUSINESS_CATEGORY ,
PRODUCT_TYPE ,
PRODUCT_CATEGORY ,
ASSESSABLE_VALUE ,
CONTROL_AMOUNT ,
TAX_REGIME_CODE ,
TAX ,
TAX_STATUS_CODE ,
TAX_RATE_CODE ,
TAX_RATE_ID ,
TAX_RATE ,
TAX_JURISDICTION_CODE ,
PURCHASING_CATEGORY_ID ,
COST_FACTOR_ID ,
RETAINED_AMOUNT ,
RETAINED_INVOICE_ID ,
RETAINED_LINE_NUMBER ,
TAX_CLASSIFICATION_CODE
FROM AP_INVOICE_LINES_ALL
WHERE rowid = P_Rowid
FOR UPDATE of Invoice_Id NOWAIT;
debug_info := 'Select from ap_invoice_lines_all';
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.program_update_date = TRUNC(P_Program_Update_Date)) -- BUG 16282205
OR ( (Recinfo.program_update_date IS NULL)
AND (P_Program_Update_Date IS NULL)))
AND ( (Recinfo.request_id = P_Request_Id)
OR ( (Recinfo.request_id IS NULL)
AND (P_Request_Id IS NULL)))
AND ( (Recinfo.award_id = P_Award_Id)
OR ( (Recinfo.award_id IS NULL)
AND (P_Award_Id IS NULL)))
AND ( (Recinfo.Expense_Group = P_Expense_Group)
OR ( (Recinfo.Expense_Group IS NULL)
AND (P_Expense_Group IS NULL)))
AND ( (Recinfo.start_expense_date = P_Start_Expense_Date)
OR ( (Recinfo.start_expense_date IS NULL)
AND (P_Start_Expense_Date IS NULL)))
AND ( (Recinfo.End_Expense_Date = P_End_Expense_Date)
OR ( (Recinfo.End_Expense_Date IS NULL)
AND (P_End_Expense_Date IS NULL)))
AND ( (Recinfo.merchant_document_number
= P_Merchant_Document_Number)
OR ( (Recinfo.merchant_document_number IS NULL)
AND (P_Merchant_Document_Number IS NULL)))
AND ( (Recinfo.merchant_name = P_Merchant_Name)
OR ( (Recinfo.merchant_name IS NULL)
AND (P_Merchant_Name IS NULL)))
AND ( (Recinfo.merchant_tax_reg_number
= P_Merchant_Tax_Reg_Number)
OR ( (Recinfo.merchant_tax_reg_number IS NULL)
AND (P_Merchant_Tax_Reg_Number IS NULL)))
AND ( (Recinfo.merchant_taxpayer_id = P_Merchant_Taxpayer_Id)
OR ( (Recinfo.merchant_taxpayer_id IS NULL)
AND (P_Merchant_Taxpayer_Id IS NULL)))
AND ( (Recinfo.merchant_reference = P_Merchant_Reference)
OR ( (Recinfo.merchant_reference IS NULL)
AND (P_Merchant_Reference IS NULL)))
AND ( (Recinfo.country_of_supply = P_Country_Of_Supply)
OR ( (Recinfo.country_of_supply IS NULL)
AND (P_Country_Of_Supply IS NULL)))) THEN
NULL;
PROCEDURE Update_Row (
p_ROWID IN OUT NOCOPY VARCHAR2,
p_INVOICE_ID NUMBER,
p_LINE_NUMBER NUMBER,
p_LINE_TYPE_LOOKUP_CODE VARCHAR2,
p_LINE_GROUP_NUMBER NUMBER,
p_REQUESTER_ID NUMBER,
p_DESCRIPTION VARCHAR2,
p_LINE_SOURCE VARCHAR2,
p_ORG_ID NUMBER,
p_INVENTORY_ITEM_ID NUMBER,
p_ITEM_DESCRIPTION VARCHAR2,
p_SERIAL_NUMBER VARCHAR2,
p_MANUFACTURER VARCHAR2,
p_MODEL_NUMBER VARCHAR2,
p_WARRANTY_NUMBER VARCHAR2,
p_GENERATE_DISTS VARCHAR2,
p_MATCH_TYPE VARCHAR2,
p_DISTRIBUTION_SET_ID NUMBER,
p_ACCOUNT_SEGMENT VARCHAR2,
p_BALANCING_SEGMENT VARCHAR2,
p_COST_CENTER_SEGMENT VARCHAR2,
p_OVERLAY_DIST_CODE_CONCAT VARCHAR2,
p_DEFAULT_DIST_CCID NUMBER,
p_PRORATE_ACROSS_ALL_ITEMS VARCHAR2,
p_ACCOUNTING_DATE DATE,
p_PERIOD_NAME VARCHAR2,
p_DEFERRED_ACCTG_FLAG VARCHAR2,
p_DEF_ACCTG_START_DATE DATE,
p_DEF_ACCTG_END_DATE DATE,
p_DEF_ACCTG_NUMBER_OF_PERIODS NUMBER,
p_DEF_ACCTG_PERIOD_TYPE VARCHAR2,
p_SET_OF_BOOKS_ID NUMBER,
p_AMOUNT NUMBER,
p_BASE_AMOUNT NUMBER,
p_ROUNDING_AMT NUMBER,
p_QUANTITY_INVOICED NUMBER,
p_UNIT_MEAS_LOOKUP_CODE VARCHAR2,
p_UNIT_PRICE NUMBER,
p_WFAPPROVAL_STATUS VARCHAR2,
p_DISCARDED_FLAG VARCHAR2,
p_ORIGINAL_AMOUNT NUMBER,
p_ORIGINAL_BASE_AMOUNT NUMBER,
p_ORIGINAL_ROUNDING_AMT NUMBER,
p_CANCELLED_FLAG VARCHAR2,
p_INCOME_TAX_REGION VARCHAR2,
p_TYPE_1099 VARCHAR2,
p_STAT_AMOUNT NUMBER,
p_PREPAY_INVOICE_ID NUMBER,
p_PREPAY_LINE_NUMBER NUMBER,
p_INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2,
p_CORRECTED_INV_ID NUMBER,
p_CORRECTED_LINE_NUMBER NUMBER,
p_PO_HEADER_ID NUMBER,
p_PO_LINE_ID NUMBER,
p_PO_RELEASE_ID NUMBER,
p_PO_LINE_LOCATION_ID NUMBER,
p_PO_DISTRIBUTION_ID NUMBER,
p_RCV_TRANSACTION_ID NUMBER,
p_FINAL_MATCH_FLAG VARCHAR2,
p_ASSETS_TRACKING_FLAG VARCHAR2,
p_ASSET_BOOK_TYPE_CODE VARCHAR2,
p_ASSET_CATEGORY_ID NUMBER,
p_PROJECT_ID NUMBER,
p_TASK_ID NUMBER,
p_EXPENDITURE_TYPE VARCHAR2,
p_EXPENDITURE_ITEM_DATE DATE,
p_EXPENDITURE_ORGANIZATION_ID NUMBER,
p_PA_QUANTITY NUMBER,
p_PA_CC_AR_INVOICE_ID NUMBER,
p_PA_CC_AR_INVOICE_LINE_NUM NUMBER,
p_PA_CC_PROCESSED_CODE VARCHAR2,
p_AWARD_ID NUMBER,
p_AWT_GROUP_ID NUMBER,
p_PAY_AWT_GROUP_ID NUMBER,--bug6639866
p_REFERENCE_1 VARCHAR2,
p_REFERENCE_2 VARCHAR2,
p_RECEIPT_VERIFIED_FLAG VARCHAR2,
p_RECEIPT_REQUIRED_FLAG VARCHAR2,
p_RECEIPT_MISSING_FLAG VARCHAR2,
p_JUSTIFICATION VARCHAR2,
p_EXPENSE_GROUP VARCHAR2,
p_START_EXPENSE_DATE DATE,
p_END_EXPENSE_DATE DATE,
p_RECEIPT_CURRENCY_CODE VARCHAR2,
p_RECEIPT_CONVERSION_RATE NUMBER,
p_RECEIPT_CURRENCY_AMOUNT NUMBER,
p_DAILY_AMOUNT NUMBER,
p_WEB_PARAMETER_ID NUMBER,
p_ADJUSTMENT_REASON VARCHAR2,
p_MERCHANT_DOCUMENT_NUMBER VARCHAR2,
p_MERCHANT_NAME VARCHAR2,
p_MERCHANT_REFERENCE VARCHAR2,
p_MERCHANT_TAX_REG_NUMBER VARCHAR2,
p_MERCHANT_TAXPAYER_ID VARCHAR2,
p_COUNTRY_OF_SUPPLY VARCHAR2,
p_CREDIT_CARD_TRX_ID NUMBER,
p_COMPANY_PREPAID_INVOICE_ID NUMBER,
p_CC_REVERSAL_FLAG VARCHAR2,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
p_LAST_UPDATED_BY NUMBER,
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_PROGRAM_APPLICATION_ID NUMBER,
p_PROGRAM_ID NUMBER,
p_PROGRAM_UPDATE_DATE DATE,
p_REQUEST_ID NUMBER,
p_ATTRIBUTE_CATEGORY VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
p_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE1 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE2 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE3 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE4 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE5 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE6 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE7 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE8 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE9 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE10 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE11 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE12 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE13 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE14 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE15 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE16 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE17 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE18 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE19 VARCHAR2 DEFAULT NULL,
p_GLOBAL_ATTRIBUTE20 VARCHAR2 DEFAULT NULL,
--ETAX: Invwkb
p_PRIMARY_INTENDED_USE VARCHAR2 DEFAULT NULL,
p_SHIP_TO_LOCATION_ID NUMBER DEFAULT NULL,
p_PRODUCT_FISC_CLASSIFICATION VARCHAR2 DEFAULT NULL,
p_USER_DEFINED_FISC_CLASS VARCHAR2 DEFAULT NULL,
p_TRX_BUSINESS_CATEGORY VARCHAR2 DEFAULT NULL,
p_PRODUCT_TYPE VARCHAR2 DEFAULT NULL,
p_PRODUCT_CATEGORY VARCHAR2 DEFAULT NULL,
p_ASSESSABLE_VALUE NUMBER DEFAULT NULL,
p_CONTROL_AMOUNT NUMBER DEFAULT NULL,
p_TAX_REGIME_CODE VARCHAR2 DEFAULT NULL,
p_TAX VARCHAR2 DEFAULT NULL,
p_TAX_STATUS_CODE VARCHAR2 DEFAULT NULL,
p_TAX_RATE_CODE VARCHAR2 DEFAULT NULL,
p_TAX_RATE_ID NUMBER DEFAULT NULL,
p_TAX_RATE NUMBER DEFAULT NULL,
p_TAX_JURISDICTION_CODE VARCHAR2 DEFAULT NULL,
p_PURCHASING_CATEGORY_ID NUMBER DEFAULT NULL,
p_COST_FACTOR_ID NUMBER DEFAULT NULL,
p_RETAINED_AMOUNT NUMBER DEFAULT NULL,
p_RETAINED_INVOICE_ID NUMBER DEFAULT NULL,
p_RETAINED_LINE_NUMBER NUMBER DEFAULT NULL,
p_TAX_CLASSIFICATION_CODE VARCHAR2 DEFAULT NULL,
p_Calling_Sequence VARCHAR2)
IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Update_Row<-'
||p_Calling_Sequence;
'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
debug_info := 'Update ap_invoice_lines_all';
UPDATE AP_INVOICE_LINES_ALL
SET
INVOICE_ID = P_INVOICE_ID,
LINE_NUMBER = P_LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE = P_LINE_TYPE_LOOKUP_CODE,
LINE_GROUP_NUMBER = p_LINE_GROUP_NUMBER,
REQUESTER_ID = P_REQUESTER_ID,
DESCRIPTION = P_DESCRIPTION,
LINE_SOURCE = P_LINE_SOURCE,
ORG_ID = P_ORG_ID,
INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID,
ITEM_DESCRIPTION = P_ITEM_DESCRIPTION,
SERIAL_NUMBER = P_SERIAL_NUMBER,
MANUFACTURER = P_MANUFACTURER,
MODEL_NUMBER = P_MODEL_NUMBER,
WARRANTY_NUMBER = P_WARRANTY_NUMBER,
GENERATE_DISTS = P_GENERATE_DISTS,
MATCH_TYPE = P_MATCH_TYPE,
DISTRIBUTION_SET_ID = P_DISTRIBUTION_SET_ID,
ACCOUNT_SEGMENT = P_ACCOUNT_SEGMENT,
BALANCING_SEGMENT = P_BALANCING_SEGMENT,
COST_CENTER_SEGMENT = P_COST_CENTER_SEGMENT,
OVERLAY_DIST_CODE_CONCAT = P_OVERLAY_DIST_CODE_CONCAT,
DEFAULT_DIST_CCID = P_DEFAULT_DIST_CCID,
PRORATE_ACROSS_ALL_ITEMS = P_PRORATE_ACROSS_ALL_ITEMS,
ACCOUNTING_DATE = P_ACCOUNTING_DATE,
PERIOD_NAME = P_PERIOD_NAME,
DEFERRED_ACCTG_FLAG = P_DEFERRED_ACCTG_FLAG ,
DEF_ACCTG_START_DATE = P_DEF_ACCTG_START_DATE,
DEF_ACCTG_END_DATE = P_DEF_ACCTG_END_DATE ,
DEF_ACCTG_NUMBER_OF_PERIODS = P_DEF_ACCTG_NUMBER_OF_PERIODS,
DEF_ACCTG_PERIOD_TYPE = P_DEF_ACCTG_PERIOD_TYPE,
SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID,
AMOUNT = P_AMOUNT,
BASE_AMOUNT = P_BASE_AMOUNT,
ROUNDING_AMT = P_ROUNDING_AMT ,
QUANTITY_INVOICED = P_QUANTITY_INVOICED,
UNIT_MEAS_LOOKUP_CODE = P_UNIT_MEAS_LOOKUP_CODE,
UNIT_PRICE = P_UNIT_PRICE,
WFAPPROVAL_STATUS = P_WFAPPROVAL_STATUS,
DISCARDED_FLAG = P_DISCARDED_FLAG,
ORIGINAL_AMOUNT = P_ORIGINAL_AMOUNT,
ORIGINAL_BASE_AMOUNT = P_ORIGINAL_BASE_AMOUNT,
ORIGINAL_ROUNDING_AMT = P_ORIGINAL_ROUNDING_AMT,
CANCELLED_FLAG = P_CANCELLED_FLAG,
INCOME_TAX_REGION = P_INCOME_TAX_REGION,
TYPE_1099 = P_TYPE_1099,
STAT_AMOUNT = P_STAT_AMOUNT,
PREPAY_INVOICE_ID = P_PREPAY_INVOICE_ID,
PREPAY_LINE_NUMBER = P_PREPAY_LINE_NUMBER,
INVOICE_INCLUDES_PREPAY_FLAG = P_INVOICE_INCLUDES_PREPAY_FLAG,
CORRECTED_INV_ID = P_CORRECTED_INV_ID,
CORRECTED_LINE_NUMBER = P_CORRECTED_LINE_NUMBER,
PO_HEADER_ID = P_PO_HEADER_ID,
PO_LINE_ID = P_PO_LINE_ID,
--bugfix:4990529, changed the p_po_line_location_id to
--p_po_release_id
PO_RELEASE_ID = P_PO_RELEASE_ID,
PO_LINE_LOCATION_ID = P_PO_LINE_LOCATION_ID,
PO_DISTRIBUTION_ID = P_PO_DISTRIBUTION_ID,
RCV_TRANSACTION_ID = P_RCV_TRANSACTION_ID,
FINAL_MATCH_FLAG = P_FINAL_MATCH_FLAG,
ASSETS_TRACKING_FLAG = P_ASSETS_TRACKING_FLAG,
ASSET_BOOK_TYPE_CODE = P_ASSET_BOOK_TYPE_CODE,
ASSET_CATEGORY_ID = P_ASSET_CATEGORY_ID,
PROJECT_ID = P_PROJECT_ID,
TASK_ID = P_TASK_ID,
EXPENDITURE_TYPE = P_EXPENDITURE_TYPE,
EXPENDITURE_ITEM_DATE = P_EXPENDITURE_ITEM_DATE,
EXPENDITURE_ORGANIZATION_ID = P_EXPENDITURE_ORGANIZATION_ID,
PA_QUANTITY = P_PA_QUANTITY,
PA_CC_AR_INVOICE_ID = P_PA_CC_AR_INVOICE_ID,
PA_CC_AR_INVOICE_LINE_NUM = P_PA_CC_AR_INVOICE_LINE_NUM,
PA_CC_PROCESSED_CODE = P_PA_CC_PROCESSED_CODE,
AWARD_ID = P_AWARD_ID,
AWT_GROUP_ID = P_AWT_GROUP_ID,
PAY_AWT_GROUP_ID = P_PAY_AWT_GROUP_ID,--bug6639866
REFERENCE_1 = P_REFERENCE_1,
REFERENCE_2 = P_REFERENCE_2,
RECEIPT_VERIFIED_FLAG = P_RECEIPT_REQUIRED_FLAG,
RECEIPT_REQUIRED_FLAG = P_RECEIPT_REQUIRED_FLAG,
RECEIPT_MISSING_FLAG = P_RECEIPT_MISSING_FLAG,
JUSTIFICATION = P_JUSTIFICATION,
EXPENSE_GROUP = P_EXPENSE_GROUP,
START_EXPENSE_DATE = P_START_EXPENSE_DATE,
END_EXPENSE_DATE = P_END_EXPENSE_DATE,
RECEIPT_CURRENCY_CODE = P_RECEIPT_CURRENCY_CODE,
RECEIPT_CONVERSION_RATE = P_RECEIPT_CONVERSION_RATE,
RECEIPT_CURRENCY_AMOUNT = P_RECEIPT_CURRENCY_AMOUNT,
DAILY_AMOUNT = P_DAILY_AMOUNT,
WEB_PARAMETER_ID = P_WEB_PARAMETER_ID,
ADJUSTMENT_REASON = P_ADJUSTMENT_REASON,
MERCHANT_DOCUMENT_NUMBER = P_MERCHANT_DOCUMENT_NUMBER,
MERCHANT_NAME = P_MERCHANT_NAME,
MERCHANT_REFERENCE = P_MERCHANT_REFERENCE,
MERCHANT_TAX_REG_NUMBER = P_MERCHANT_TAX_REG_NUMBER,
MERCHANT_TAXPAYER_ID = P_MERCHANT_TAXPAYER_ID,
COUNTRY_OF_SUPPLY = P_COUNTRY_OF_SUPPLY,
CREDIT_CARD_TRX_ID = P_CREDIT_CARD_TRX_ID,
COMPANY_PREPAID_INVOICE_ID = P_COMPANY_PREPAID_INVOICE_ID,
CC_REVERSAL_FLAG = P_CC_REVERSAL_FLAG,
CREATION_DATE = P_CREATION_DATE,
CREATED_BY = P_CREATED_BY,
LAST_UPDATED_BY = P_LAST_UPDATED_BY,
LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
PROGRAM_APPLICATION_ID = P_PROGRAM_APPLICATION_ID,
PROGRAM_ID = P_PROGRAM_ID,
PROGRAM_UPDATE_DATE = P_PROGRAM_UPDATE_DATE,
REQUEST_ID = P_REQUEST_ID,
ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = P_ATTRIBUTE1,
ATTRIBUTE2 = P_ATTRIBUTE2,
ATTRIBUTE3 = P_ATTRIBUTE3,
ATTRIBUTE4 = P_ATTRIBUTE4,
ATTRIBUTE5 = P_ATTRIBUTE5,
ATTRIBUTE6 = P_ATTRIBUTE6,
ATTRIBUTE7 = P_ATTRIBUTE7,
ATTRIBUTE8 = P_ATTRIBUTE8,
ATTRIBUTE9 = P_ATTRIBUTE9,
ATTRIBUTE10 = P_ATTRIBUTE10,
ATTRIBUTE11 = P_ATTRIBUTE11,
ATTRIBUTE12 = P_ATTRIBUTE12,
ATTRIBUTE13 = P_ATTRIBUTE13,
ATTRIBUTE14 = P_ATTRIBUTE14,
ATTRIBUTE15 = P_ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY = P_GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1 = P_GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2 = P_GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3 = P_GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4 = P_GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5 = P_GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6 = P_GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7 = P_GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8 = P_GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9 = P_GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10 = P_GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11 = P_GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12 = P_GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13 = P_GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14 = P_GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15 = P_GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16 = P_GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17 = P_GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18 = P_GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19 = P_GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20 = P_GLOBAL_ATTRIBUTE20,
PRIMARY_INTENDED_USE = P_PRIMARY_INTENDED_USE,
SHIP_TO_LOCATION_ID = P_SHIP_TO_LOCATION_ID,
PRODUCT_FISC_CLASSIFICATION = P_PRODUCT_FISC_CLASSIFICATION,
USER_DEFINED_FISC_CLASS = P_USER_DEFINED_FISC_CLASS,
TRX_BUSINESS_CATEGORY = P_TRX_BUSINESS_CATEGORY,
PRODUCT_TYPE = P_PRODUCT_TYPE,
PRODUCT_CATEGORY = P_PRODUCT_CATEGORY,
ASSESSABLE_VALUE = P_ASSESSABLE_VALUE,
CONTROL_AMOUNT = P_CONTROL_AMOUNT,
TAX_REGIME_CODE = P_TAX_REGIME_CODE,
TAX = P_TAX,
TAX_STATUS_CODE = P_TAX_STATUS_CODE,
TAX_RATE_CODE = P_TAX_RATE_CODE,
TAX_RATE_ID = P_TAX_RATE_ID,
TAX_RATE = P_TAX_RATE,
TAX_JURISDICTION_CODE = P_TAX_JURISDICTION_CODE,
PURCHASING_CATEGORY_ID = P_PURCHASING_CATEGORY_ID,
COST_FACTOR_ID = P_COST_FACTOR_ID,
RETAINED_AMOUNT = P_RETAINED_AMOUNT,
RETAINED_AMOUNT_REMAINING = -(P_RETAINED_AMOUNT),
RETAINED_INVOICE_ID = P_RETAINED_INVOICE_ID,
RETAINED_LINE_NUMBER = P_RETAINED_LINE_NUMBER,
TAX_CLASSIFICATION_CODE = P_TAX_CLASSIFICATION_CODE
WHERE rowid = p_Rowid;
END Update_Row;
PROCEDURE Delete_Row (
p_Rowid VARCHAR2,
p_Calling_Sequence VARCHAR2)
IS
current_calling_sequence VARCHAR2(2000);
l_api_name CONSTANT VARCHAR2(200) := 'Delete_Row';
current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.Delete_Row<-' ||
p_Calling_Sequence;
debug_info := 'Delete from child entity ap_invoice_distributions_all';
SELECT invoice_id,line_number,line_type_lookup_code,tax_already_calculated_flag
INTO l_invoice_id,l_line_number, l_line_type, l_tax_calculated_flag
FROM ap_invoice_lines_all
WHERE rowid=p_rowid;
DELETE FROM ap_invoice_distributions_all
WHERE invoice_id = l_invoice_id
AND invoice_line_number = l_line_number;
debug_info := 'Calling eTax to delete corresponding tax data';
P_Calling_Mode => 'MARK TAX LINES DELETED',
P_Line_Number_To_Delete =>l_line_number,
P_All_Error_Messages => 'N',
P_error_code => l_error_code,
P_calling_sequence => current_calling_sequence);
debug_info := 'Delete from ap_invoice_lines';
DELETE FROM AP_INVOICE_LINES_ALL
WHERE rowid = p_Rowid;
END Delete_Row;