[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID IN OUT NOCOPY VARCHAR2,
X_INVOICE_ID IN NUMBER,
X_INVOICE_LINE_ID IN NUMBER,
X_LINE_NUMBER IN NUMBER,
X_LINE_TYPE_LOOKUP_CODE IN VARCHAR2,
X_LINE_GROUP_NUMBER IN NUMBER,
X_AMOUNT IN NUMBER,
X_ACCOUNTING_DATE IN DATE,
X_DESCRIPTION IN VARCHAR2,
-- X_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
X_PRORATE_ACROSS_FLAG IN VARCHAR2,
X_TAX_CODE IN VARCHAR2,
X_TAX_CODE_ID IN NUMBER,
-- X_TAX_CODE_OVERRIDE_FLAG IN VARCHAR2,
-- X_TAX_RECOVERY_RATE IN NUMBER,
-- X_TAX_RECOVERY_OVERRIDE_FLAG IN VARCHAR2,
-- X_TAX_RECOVERABLE_FLAG IN VARCHAR2,
X_FINAL_MATCH_FLAG IN VARCHAR2,
X_PO_HEADER_ID IN NUMBER,
X_PO_LINE_ID IN NUMBER,
X_PO_LINE_LOCATION_ID IN NUMBER,
X_PO_DISTRIBUTION_ID IN NUMBER,
X_UNIT_OF_MEAS_LOOKUP_CODE IN VARCHAR2,
X_INVENTORY_ITEM_ID IN NUMBER,
X_QUANTITY_INVOICED IN NUMBER,
X_UNIT_PRICE IN NUMBER,
X_DISTRIBUTION_SET_ID IN NUMBER,
X_DIST_CODE_CONCATENATED IN VARCHAR2,
X_DIST_CODE_COMBINATION_ID IN NUMBER,
X_AWT_GROUP_ID IN NUMBER,
X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_PO_RELEASE_ID IN NUMBER,
X_BALANCING_SEGMENT IN VARCHAR2,
X_COST_CENTER_SEGMENT IN VARCHAR2,
X_ACCOUNT_SEGMENT IN VARCHAR2,
X_PROJECT_ID IN NUMBER,
X_TASK_ID IN NUMBER,
X_EXPENDITURE_TYPE IN VARCHAR2,
X_EXPENDITURE_ITEM_DATE IN DATE,
X_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
X_PROJECT_ACCOUNTING_CONTEXT IN VARCHAR2,
X_PA_ADDITION_FLAG IN VARCHAR2,
X_PA_QUANTITY IN NUMBER,
X_STAT_AMOUNT IN NUMBER,
X_TYPE_1099 IN VARCHAR2,
X_INCOME_TAX_REGION IN VARCHAR2,
X_ASSETS_TRACKING_FLAG IN VARCHAR2,
X_PRICE_CORRECTION_FLAG IN VARCHAR2,
-- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
X_RECEIPT_NUMBER IN VARCHAR2,
X_MATCH_OPTION IN VARCHAR2,
X_RCV_TRANSACTION_ID IN NUMBER,
X_CREATION_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_ORG_ID IN NUMBER,
X_MODE IN VARCHAR2 DEFAULT 'R',
X_Calling_Sequence IN VARCHAR2,
X_award_id IN NUMBER DEFAULT NULL,
X_price_correct_inv_num IN VARCHAR2 DEFAULT NULL,
-- Invoice Lines Project Stage 1
X_PRICE_CORRECT_INV_LINE_NUM IN NUMBER DEFAULT NULL,
X_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
X_MANUFACTURER IN VARCHAR2 DEFAULT NULL,
X_MODEL_NUMBER IN VARCHAR2 DEFAULT NULL,
X_WARRANTY_NUMBER IN VARCHAR2 DEFAULT NULL,
X_ASSET_BOOK_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
X_ASSET_CATEGORY_ID IN NUMBER DEFAULT NULL,
X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
X_REQUESTER_ID IN NUMBER DEFAULT NULL,
X_DEFERRED_ACCTG_FLAG IN VARCHAR2 DEFAULT NULL,
X_DEF_ACCTG_START_DATE IN DATE DEFAULT NULL,
X_DEF_ACCTG_END_DATE IN DATE DEFAULT NULL,
X_DEF_ACCTG_NUMBER_OF_PERIODS IN NUMBER DEFAULT NULL,
X_DEF_ACCTG_PERIOD_TYPE IN VARCHAR2 DEFAULT NULL,
-- eTax Uptake
X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
X_ASSESSABLE_VALUE IN NUMBER DEFAULT NULL,
X_DEFAULT_DIST_CCID IN NUMBER DEFAULT NULL,
X_PRIMARY_INTENDED_USE IN VARCHAR2 DEFAULT NULL,
X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
X_PRODUCT_TYPE IN VARCHAR2 DEFAULT NULL,
X_PRODUCT_CATEGORY IN VARCHAR2 DEFAULT NULL,
X_PRODUCT_FISC_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
X_USER_DEFINED_FISC_CLASS IN VARCHAR2 DEFAULT NULL,
X_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
X_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX IN VARCHAR2 DEFAULT NULL,
X_TAX_JURISDICTION_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX_RATE_ID IN NUMBER DEFAULT NULL,
X_TAX_RATE_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX_RATE IN NUMBER DEFAULT NULL,
X_INCL_IN_TAXABLE_LINE_FLAG IN VARCHAR2 DEFAULT NULL,
X_PURCHASING_CATEGORY IN VARCHAR2 DEFAULT NULL,
X_PURCHASING_CATEGORY_ID IN NUMBER DEFAULT NULL,
X_COST_FACTOR_NAME IN VARCHAR2 DEFAULT NULL,
X_COST_FACTOR_ID IN NUMBER DEFAULT NULL,
X_TAX_CLASSIFICATION_CODE IN VARCHAR2 DEFAULT NULL)
IS
current_calling_sequence VARCHAR2(2000);
SELECT ROWID
FROM AP_INVOICE_LINES_INTERFACE
WHERE invoice_id = X_Invoice_Id
AND invoice_line_id = X_Invoice_Line_Id;
current_calling_sequence :='AP_INVOICE_LINES_INTERFACE_PKG.Insert_Row<-'||
X_Calling_Sequence;
debug_info := 'Insert into ap_invoice_distributions';
INSERT INTO AP_INVOICE_LINES_INTERFACE (
INVOICE_ID,
INVOICE_LINE_ID,
LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE,
LINE_GROUP_NUMBER,
AMOUNT,
ACCOUNTING_DATE,
DESCRIPTION,
-- AMOUNT_INCLUDES_TAX_FLAG,
PRORATE_ACROSS_FLAG,
TAX_CODE,
TAX_CODE_ID,
-- TAX_CODE_OVERRIDE_FLAG,
-- TAX_RECOVERY_RATE,
-- TAX_RECOVERY_OVERRIDE_FLAG,
-- TAX_RECOVERABLE_FLAG,
FINAL_MATCH_FLAG,
PO_HEADER_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_DISTRIBUTION_ID,
UNIT_OF_MEAS_LOOKUP_CODE,
INVENTORY_ITEM_ID,
QUANTITY_INVOICED,
UNIT_PRICE,
DISTRIBUTION_SET_ID,
DIST_CODE_CONCATENATED,
DIST_CODE_COMBINATION_ID,
AWT_GROUP_ID,
PAY_AWT_GROUP_ID,--bug6639866
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,
PO_RELEASE_ID,
BALANCING_SEGMENT,
COST_CENTER_SEGMENT,
ACCOUNT_SEGMENT,
PROJECT_ID,
TASK_ID,
EXPENDITURE_TYPE,
EXPENDITURE_ITEM_DATE,
EXPENDITURE_ORGANIZATION_ID,
PROJECT_ACCOUNTING_CONTEXT,
PA_ADDITION_FLAG,
PA_QUANTITY,
STAT_AMOUNT,
TYPE_1099,
INCOME_TAX_REGION,
ASSETS_TRACKING_FLAG,
PRICE_CORRECTION_FLAG,
-- USSGL_TRANSACTION_CODE, - Bug 4277744
RECEIPT_NUMBER,
MATCH_OPTION,
RCV_TRANSACTION_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
ORG_ID,
AWARD_ID,
PRICE_CORRECT_INV_NUM,
-- Invoice Lines Project Stage 1
PRICE_CORRECT_INV_LINE_NUM,
SERIAL_NUMBER,
MANUFACTURER,
MODEL_NUMBER,
WARRANTY_NUMBER,
ASSET_BOOK_TYPE_CODE,
ASSET_CATEGORY_ID,
REQUESTER_FIRST_NAME,
REQUESTER_LAST_NAME,
REQUESTER_EMPLOYEE_NUM,
REQUESTER_ID,
DEFERRED_ACCTG_FLAG,
DEF_ACCTG_START_DATE,
DEF_ACCTG_END_DATE,
DEF_ACCTG_NUMBER_OF_PERIODS,
DEF_ACCTG_PERIOD_TYPE,
CONTROL_AMOUNT,
ASSESSABLE_VALUE,
DEFAULT_DIST_CCID,
PRIMARY_INTENDED_USE,
SHIP_TO_LOCATION_ID,
PRODUCT_TYPE,
PRODUCT_CATEGORY,
PRODUCT_FISC_CLASSIFICATION,
USER_DEFINED_FISC_CLASS,
TRX_BUSINESS_CATEGORY,
TAX_REGIME_CODE,
TAX,
TAX_JURISDICTION_CODE,
TAX_STATUS_CODE,
TAX_RATE_ID,
TAX_RATE_CODE,
TAX_RATE,
INCL_IN_TAXABLE_LINE_FLAG,
PURCHASING_CATEGORY,
PURCHASING_CATEGORY_ID,
COST_FACTOR_NAME,
COST_FACTOR_ID,
TAX_CLASSIFICATION_CODE)
VALUES (
X_INVOICE_ID,
X_INVOICE_LINE_ID,
X_LINE_NUMBER,
X_LINE_TYPE_LOOKUP_CODE,
X_LINE_GROUP_NUMBER,
X_AMOUNT,
X_ACCOUNTING_DATE,
X_DESCRIPTION,
-- X_AMOUNT_INCLUDES_TAX_FLAG,
X_PRORATE_ACROSS_FLAG,
X_TAX_CODE,
X_TAX_CODE_ID,
-- X_TAX_CODE_OVERRIDE_FLAG,
-- X_TAX_RECOVERY_RATE,
-- X_TAX_RECOVERY_OVERRIDE_FLAG,
-- X_TAX_RECOVERABLE_FLAG,
X_FINAL_MATCH_FLAG,
X_PO_HEADER_ID,
X_PO_LINE_ID,
X_PO_LINE_LOCATION_ID,
X_PO_DISTRIBUTION_ID,
X_UNIT_OF_MEAS_LOOKUP_CODE,
X_INVENTORY_ITEM_ID,
X_QUANTITY_INVOICED,
X_UNIT_PRICE,
X_DISTRIBUTION_SET_ID,
X_DIST_CODE_CONCATENATED,
X_DIST_CODE_COMBINATION_ID,
X_AWT_GROUP_ID,
X_PAY_AWT_GROUP_ID,--bug6639866
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_GLOBAL_ATTRIBUTE_CATEGORY,
X_GLOBAL_ATTRIBUTE1,
X_GLOBAL_ATTRIBUTE2,
X_GLOBAL_ATTRIBUTE3,
X_GLOBAL_ATTRIBUTE4,
X_GLOBAL_ATTRIBUTE5,
X_GLOBAL_ATTRIBUTE6,
X_GLOBAL_ATTRIBUTE7,
X_GLOBAL_ATTRIBUTE8,
X_GLOBAL_ATTRIBUTE9,
X_GLOBAL_ATTRIBUTE10,
X_GLOBAL_ATTRIBUTE11,
X_GLOBAL_ATTRIBUTE12,
X_GLOBAL_ATTRIBUTE13,
X_GLOBAL_ATTRIBUTE14,
X_GLOBAL_ATTRIBUTE15,
X_GLOBAL_ATTRIBUTE16,
X_GLOBAL_ATTRIBUTE17,
X_GLOBAL_ATTRIBUTE18,
X_GLOBAL_ATTRIBUTE19,
X_GLOBAL_ATTRIBUTE20,
X_PO_RELEASE_ID,
X_BALANCING_SEGMENT,
X_COST_CENTER_SEGMENT,
X_ACCOUNT_SEGMENT,
X_PROJECT_ID,
X_TASK_ID,
X_EXPENDITURE_TYPE,
X_EXPENDITURE_ITEM_DATE,
X_EXPENDITURE_ORGANIZATION_ID,
X_PROJECT_ACCOUNTING_CONTEXT,
X_PA_ADDITION_FLAG,
X_PA_QUANTITY,
X_STAT_AMOUNT,
X_TYPE_1099,
X_INCOME_TAX_REGION,
X_ASSETS_TRACKING_FLAG,
X_PRICE_CORRECTION_FLAG,
-- X_USSGL_TRANSACTION_CODE, - Bug 4277744
X_RECEIPT_NUMBER,
X_MATCH_OPTION,
X_RCV_TRANSACTION_ID,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
X_ORG_ID,
X_AWARD_ID,
X_price_correct_inv_num,
-- Invoice Lines Project Stage 1
X_PRICE_CORRECT_INV_LINE_NUM,
X_SERIAL_NUMBER,
X_MANUFACTURER,
X_MODEL_NUMBER,
X_WARRANTY_NUMBER,
X_ASSET_BOOK_TYPE_CODE,
X_ASSET_CATEGORY_ID,
X_REQUESTER_FIRST_NAME,
X_REQUESTER_LAST_NAME,
X_REQUESTER_EMPLOYEE_NUM,
X_REQUESTER_ID,
X_DEFERRED_ACCTG_FLAG,
X_DEF_ACCTG_START_DATE,
X_DEF_ACCTG_END_DATE,
X_DEF_ACCTG_NUMBER_OF_PERIODS,
X_DEF_ACCTG_PERIOD_TYPE,
-- eTax Uptake
X_CONTROL_AMOUNT,
X_ASSESSABLE_VALUE,
X_DEFAULT_DIST_CCID,
X_PRIMARY_INTENDED_USE,
X_SHIP_TO_LOCATION_ID,
X_PRODUCT_TYPE,
X_PRODUCT_CATEGORY,
X_PRODUCT_FISC_CLASSIFICATION,
X_USER_DEFINED_FISC_CLASS,
X_TRX_BUSINESS_CATEGORY,
X_TAX_REGIME_CODE,
X_TAX,
X_TAX_JURISDICTION_CODE,
X_TAX_STATUS_CODE,
X_TAX_RATE_ID,
X_TAX_RATE_CODE,
X_TAX_RATE,
X_INCL_IN_TAXABLE_LINE_FLAG,
X_PURCHASING_CATEGORY,
X_PURCHASING_CATEGORY_ID,
X_COST_FACTOR_NAME,
X_COST_FACTOR_ID,
X_TAX_CLASSIFICATION_CODE);
END INSERT_ROW;
SELECT
INVOICE_ID,
INVOICE_LINE_ID,
LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE,
LINE_GROUP_NUMBER,
AMOUNT,
ACCOUNTING_DATE,
DESCRIPTION,
-- AMOUNT_INCLUDES_TAX_FLAG,
PRORATE_ACROSS_FLAG,
TAX_CODE,
TAX_CODE_ID,
-- TAX_CODE_OVERRIDE_FLAG,
-- TAX_RECOVERY_RATE,
-- TAX_RECOVERY_OVERRIDE_FLAG,
-- TAX_RECOVERABLE_FLAG,
FINAL_MATCH_FLAG,
PO_HEADER_ID,
PO_LINE_ID,
PO_LINE_LOCATION_ID,
PO_DISTRIBUTION_ID,
UNIT_OF_MEAS_LOOKUP_CODE,
INVENTORY_ITEM_ID,
QUANTITY_INVOICED,
UNIT_PRICE,
DISTRIBUTION_SET_ID,
DIST_CODE_CONCATENATED,
DIST_CODE_COMBINATION_ID,
AWT_GROUP_ID,
PAY_AWT_GROUP_ID,--bug6639866
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,
PO_RELEASE_ID,
BALANCING_SEGMENT,
COST_CENTER_SEGMENT,
ACCOUNT_SEGMENT,
PROJECT_ID,
TASK_ID,
EXPENDITURE_TYPE,
EXPENDITURE_ITEM_DATE,
EXPENDITURE_ORGANIZATION_ID,
PROJECT_ACCOUNTING_CONTEXT,
PA_ADDITION_FLAG,
PA_QUANTITY,
STAT_AMOUNT,
TYPE_1099,
INCOME_TAX_REGION,
ASSETS_TRACKING_FLAG,
PRICE_CORRECTION_FLAG,
-- USSGL_TRANSACTION_CODE, - Bug 4277744
RECEIPT_NUMBER,
MATCH_OPTION,
RCV_TRANSACTION_ID,
AWARD_ID,
PRICE_CORRECT_INV_NUM,
-- Invoice Lines Project Stage 1
PRICE_CORRECT_INV_LINE_NUM,
SERIAL_NUMBER,
MANUFACTURER,
MODEL_NUMBER,
WARRANTY_NUMBER,
ASSET_BOOK_TYPE_CODE,
ASSET_CATEGORY_ID,
REQUESTER_FIRST_NAME,
REQUESTER_LAST_NAME,
REQUESTER_EMPLOYEE_NUM,
REQUESTER_ID,
DEFERRED_ACCTG_FLAG,
DEF_ACCTG_START_DATE,
DEF_ACCTG_END_DATE,
DEF_ACCTG_NUMBER_OF_PERIODS,
DEF_ACCTG_PERIOD_TYPE,
CONTROL_AMOUNT,
ASSESSABLE_VALUE,
DEFAULT_DIST_CCID,
PRIMARY_INTENDED_USE,
SHIP_TO_LOCATION_ID,
PRODUCT_TYPE,
PRODUCT_CATEGORY,
PRODUCT_FISC_CLASSIFICATION,
USER_DEFINED_FISC_CLASS,
TRX_BUSINESS_CATEGORY,
TAX_REGIME_CODE,
TAX,
TAX_JURISDICTION_CODE,
TAX_STATUS_CODE,
TAX_RATE_ID,
TAX_RATE_CODE,
TAX_RATE,
INCL_IN_TAXABLE_LINE_FLAG,
PURCHASING_CATEGORY,
PURCHASING_CATEGORY_ID,
COST_FACTOR_NAME,
COST_FACTOR_ID,
TAX_CLASSIFICATION_CODE
FROM AP_INVOICE_LINES_INTERFACE
WHERE rowid = X_Rowid
FOR UPDATE OF Invoice_id NOWAIT;
debug_info := 'Select from ap_invoice_lines_interface';
procedure UPDATE_ROW (
X_Rowid IN VARCHAR2,
X_INVOICE_ID IN NUMBER,
X_INVOICE_LINE_ID IN NUMBER,
X_LINE_NUMBER IN NUMBER,
X_LINE_TYPE_LOOKUP_CODE IN VARCHAR2,
X_LINE_GROUP_NUMBER IN NUMBER,
X_AMOUNT IN NUMBER,
X_ACCOUNTING_DATE IN DATE,
X_DESCRIPTION IN VARCHAR2,
-- X_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
X_PRORATE_ACROSS_FLAG IN VARCHAR2,
X_TAX_CODE IN VARCHAR2,
X_TAX_CODE_ID IN NUMBER,
-- X_TAX_CODE_OVERRIDE_FLAG IN VARCHAR2,
-- X_TAX_RECOVERY_RATE IN NUMBER,
-- X_TAX_RECOVERY_OVERRIDE_FLAG IN VARCHAR2,
-- X_TAX_RECOVERABLE_FLAG IN VARCHAR2,
X_FINAL_MATCH_FLAG IN VARCHAR2,
X_PO_HEADER_ID IN NUMBER,
X_PO_LINE_ID IN NUMBER,
X_PO_LINE_LOCATION_ID IN NUMBER,
X_PO_DISTRIBUTION_ID IN NUMBER,
X_UNIT_OF_MEAS_LOOKUP_CODE IN VARCHAR2,
X_INVENTORY_ITEM_ID IN NUMBER,
X_QUANTITY_INVOICED IN NUMBER,
X_UNIT_PRICE IN NUMBER,
X_DISTRIBUTION_SET_ID IN NUMBER,
X_DIST_CODE_CONCATENATED IN VARCHAR2,
X_DIST_CODE_COMBINATION_ID IN NUMBER,
X_AWT_GROUP_ID IN NUMBER,
X_PAY_AWT_GROUP_ID IN NUMBER DEFAULT NULL,--bug6639866
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_PO_RELEASE_ID IN NUMBER,
X_BALANCING_SEGMENT IN VARCHAR2,
X_COST_CENTER_SEGMENT IN VARCHAR2,
X_ACCOUNT_SEGMENT IN VARCHAR2,
X_PROJECT_ID IN NUMBER,
X_TASK_ID IN NUMBER,
X_EXPENDITURE_TYPE IN VARCHAR2,
X_EXPENDITURE_ITEM_DATE IN DATE,
X_EXPENDITURE_ORGANIZATION_ID IN NUMBER,
X_PROJECT_ACCOUNTING_CONTEXT IN VARCHAR2,
X_PA_ADDITION_FLAG IN VARCHAR2,
X_PA_QUANTITY IN NUMBER,
X_STAT_AMOUNT IN NUMBER,
X_TYPE_1099 IN VARCHAR2,
X_INCOME_TAX_REGION IN VARCHAR2,
X_ASSETS_TRACKING_FLAG IN VARCHAR2,
X_PRICE_CORRECTION_FLAG IN VARCHAR2,
-- X_USSGL_TRANSACTION_CODE IN VARCHAR2, - Bug 4277744
X_RECEIPT_NUMBER IN VARCHAR2,
X_MATCH_OPTION IN VARCHAR2,
X_RCV_TRANSACTION_ID IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_MODE IN VARCHAR2 DEFAULT 'R',
X_CALLING_SEQUENCE IN VARCHAR2,
X_AWARD_ID IN NUMBER,
X_price_correct_inv_num IN VARCHAR2 DEFAULT NULL,
-- Invoice Lines Project Stage 1
X_PRICE_CORRECT_INV_LINE_NUM IN NUMBER DEFAULT NULL,
X_SERIAL_NUMBER IN VARCHAR2 DEFAULT NULL,
X_MANUFACTURER IN VARCHAR2 DEFAULT NULL,
X_MODEL_NUMBER IN VARCHAR2 DEFAULT NULL,
X_WARRANTY_NUMBER IN VARCHAR2 DEFAULT NULL,
X_ASSET_BOOK_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
X_ASSET_CATEGORY_ID IN NUMBER DEFAULT NULL,
X_REQUESTER_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
X_REQUESTER_LAST_NAME IN VARCHAR2 DEFAULT NULL,
X_REQUESTER_EMPLOYEE_NUM IN VARCHAR2 DEFAULT NULL,
X_REQUESTER_ID IN NUMBER DEFAULT NULL,
X_DEFERRED_ACCTG_FLAG IN VARCHAR2 DEFAULT NULL,
X_DEF_ACCTG_START_DATE IN DATE DEFAULT NULL,
X_DEF_ACCTG_END_DATE IN DATE DEFAULT NULL,
X_DEF_ACCTG_NUMBER_OF_PERIODS IN NUMBER DEFAULT NULL,
X_DEF_ACCTG_PERIOD_TYPE IN VARCHAR2 DEFAULT NULL,
-- eTax Uptake
X_CONTROL_AMOUNT IN NUMBER DEFAULT NULL,
X_ASSESSABLE_VALUE IN NUMBER DEFAULT NULL,
X_DEFAULT_DIST_CCID IN NUMBER DEFAULT NULL,
X_PRIMARY_INTENDED_USE IN VARCHAR2 DEFAULT NULL,
X_SHIP_TO_LOCATION_ID IN NUMBER DEFAULT NULL,
X_PRODUCT_TYPE IN VARCHAR2 DEFAULT NULL,
X_PRODUCT_CATEGORY IN VARCHAR2 DEFAULT NULL,
X_PRODUCT_FISC_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
X_USER_DEFINED_FISC_CLASS IN VARCHAR2 DEFAULT NULL,
X_TRX_BUSINESS_CATEGORY IN VARCHAR2 DEFAULT NULL,
X_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX IN VARCHAR2 DEFAULT NULL,
X_TAX_JURISDICTION_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX_RATE_ID IN NUMBER DEFAULT NULL,
X_TAX_RATE_CODE IN VARCHAR2 DEFAULT NULL,
X_TAX_RATE IN NUMBER DEFAULT NULL,
X_INCL_IN_TAXABLE_LINE_FLAG IN VARCHAR2 DEFAULT NULL,
X_PURCHASING_CATEGORY IN VARCHAR2 DEFAULT NULL,
X_PURCHASING_CATEGORY_ID IN NUMBER DEFAULT NULL,
X_COST_FACTOR_NAME IN VARCHAR2 DEFAULT NULL,
X_COST_FACTOR_ID IN NUMBER DEFAULT NULL,
X_TAX_CLASSIFICATION_CODE IN VARCHAR2 DEFAULT NULL)
IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_INVOICE_LINES_INTERFACE_PKG.Update_Row<-'
||X_Calling_Sequence;
debug_info := 'Update ap_invoice_lines_interface';
UPDATE AP_INVOICE_LINES_INTERFACE SET
INVOICE_ID = X_INVOICE_ID,
INVOICE_LINE_ID = X_INVOICE_LINE_ID,
LINE_NUMBER = X_LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE = X_LINE_TYPE_LOOKUP_CODE,
LINE_GROUP_NUMBER = X_LINE_GROUP_NUMBER,
AMOUNT = X_AMOUNT,
ACCOUNTING_DATE = X_ACCOUNTING_DATE,
DESCRIPTION = X_DESCRIPTION,
-- AMOUNT_INCLUDES_TAX_FLAG = X_AMOUNT_INCLUDES_TAX_FLAG,
PRORATE_ACROSS_FLAG = X_PRORATE_ACROSS_FLAG,
TAX_CODE = X_TAX_CODE,
TAX_CODE_ID = X_TAX_CODE_ID,
-- TAX_CODE_OVERRIDE_FLAG = X_TAX_CODE_OVERRIDE_FLAG,
-- TAX_RECOVERY_RATE = X_TAX_RECOVERY_RATE,
-- TAX_RECOVERY_OVERRIDE_FLAG = X_TAX_RECOVERY_OVERRIDE_FLAG,
-- TAX_RECOVERABLE_FLAG = X_TAX_RECOVERABLE_FLAG,
FINAL_MATCH_FLAG = X_FINAL_MATCH_FLAG,
PO_HEADER_ID = X_PO_HEADER_ID,
PO_LINE_ID = X_PO_LINE_ID,
PO_LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID,
PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID,
UNIT_OF_MEAS_LOOKUP_CODE = X_UNIT_OF_MEAS_LOOKUP_CODE,
INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
QUANTITY_INVOICED = X_QUANTITY_INVOICED,
UNIT_PRICE = X_UNIT_PRICE,
DISTRIBUTION_SET_ID = X_DISTRIBUTION_SET_ID,
DIST_CODE_CONCATENATED = X_DIST_CODE_CONCATENATED,
DIST_CODE_COMBINATION_ID = X_DIST_CODE_COMBINATION_ID,
AWT_GROUP_ID = X_AWT_GROUP_ID,
PAY_AWT_GROUP_ID = X_PAY_AWT_GROUP_ID,--bug6639866
ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = X_ATTRIBUTE1,
ATTRIBUTE2 = X_ATTRIBUTE2,
ATTRIBUTE3 = X_ATTRIBUTE3,
ATTRIBUTE4 = X_ATTRIBUTE4,
ATTRIBUTE5 = X_ATTRIBUTE5,
ATTRIBUTE6 = X_ATTRIBUTE6,
ATTRIBUTE7 = X_ATTRIBUTE7,
ATTRIBUTE8 = X_ATTRIBUTE8,
ATTRIBUTE9 = X_ATTRIBUTE9,
ATTRIBUTE10 = X_ATTRIBUTE10,
ATTRIBUTE11 = X_ATTRIBUTE11,
ATTRIBUTE12 = X_ATTRIBUTE12,
ATTRIBUTE13 = X_ATTRIBUTE13,
ATTRIBUTE14 = X_ATTRIBUTE14,
ATTRIBUTE15 = X_ATTRIBUTE15,
GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY,
GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20,
PO_RELEASE_ID = X_PO_RELEASE_ID,
BALANCING_SEGMENT = X_BALANCING_SEGMENT,
COST_CENTER_SEGMENT = X_COST_CENTER_SEGMENT,
ACCOUNT_SEGMENT = X_ACCOUNT_SEGMENT,
PROJECT_ID = X_PROJECT_ID,
TASK_ID = X_TASK_ID,
EXPENDITURE_TYPE = X_EXPENDITURE_TYPE,
EXPENDITURE_ITEM_DATE = X_EXPENDITURE_ITEM_DATE,
EXPENDITURE_ORGANIZATION_ID= X_EXPENDITURE_ORGANIZATION_ID,
PROJECT_ACCOUNTING_CONTEXT = X_PROJECT_ACCOUNTING_CONTEXT,
PA_ADDITION_FLAG = X_PA_ADDITION_FLAG,
PA_QUANTITY = X_PA_QUANTITY,
STAT_AMOUNT = X_STAT_AMOUNT,
TYPE_1099 = X_TYPE_1099,
INCOME_TAX_REGION = X_INCOME_TAX_REGION,
ASSETS_TRACKING_FLAG = X_ASSETS_TRACKING_FLAG,
PRICE_CORRECTION_FLAG = X_PRICE_CORRECTION_FLAG,
-- USSGL_TRANSACTION_CODE = X_USSGL_TRANSACTION_CODE, - Bug 4277744
RECEIPT_NUMBER = X_RECEIPT_NUMBER,
MATCH_OPTION = X_MATCH_OPTION,
RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID,
LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
LAST_UPDATED_BY = X_LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
AWARD_ID = X_AWARD_ID,
PRICE_CORRECT_INV_NUM = X_PRICE_CORRECT_INV_NUM,
-- Invoice Lines Project Stage 1
PRICE_CORRECT_INV_LINE_NUM = X_PRICE_CORRECT_INV_LINE_NUM,
SERIAL_NUMBER = X_SERIAL_NUMBER,
MANUFACTURER = X_MANUFACTURER,
MODEL_NUMBER = X_MODEL_NUMBER,
WARRANTY_NUMBER = X_WARRANTY_NUMBER,
ASSET_BOOK_TYPE_CODE = X_ASSET_BOOK_TYPE_CODE,
ASSET_CATEGORY_ID = X_ASSET_CATEGORY_ID,
REQUESTER_FIRST_NAME = X_REQUESTER_FIRST_NAME,
REQUESTER_LAST_NAME = X_REQUESTER_LAST_NAME,
REQUESTER_EMPLOYEE_NUM = X_REQUESTER_EMPLOYEE_NUM,
REQUESTER_ID = X_REQUESTER_ID,
DEFERRED_ACCTG_FLAG = X_DEFERRED_ACCTG_FLAG,
DEF_ACCTG_START_DATE = X_DEF_ACCTG_START_DATE,
DEF_ACCTG_END_DATE = X_DEF_ACCTG_END_DATE,
DEF_ACCTG_NUMBER_OF_PERIODS= X_DEF_ACCTG_NUMBER_OF_PERIODS,
DEF_ACCTG_PERIOD_TYPE = X_DEF_ACCTG_PERIOD_TYPE,
-- eTax Uptake
CONTROL_AMOUNT = X_CONTROL_AMOUNT,
ASSESSABLE_VALUE = X_ASSESSABLE_VALUE,
DEFAULT_DIST_CCID = X_DEFAULT_DIST_CCID,
PRIMARY_INTENDED_USE = X_PRIMARY_INTENDED_USE,
SHIP_TO_LOCATION_ID = X_SHIP_TO_LOCATION_ID,
PRODUCT_TYPE = X_PRODUCT_TYPE,
PRODUCT_CATEGORY = X_PRODUCT_CATEGORY,
PRODUCT_FISC_CLASSIFICATION = X_PRODUCT_FISC_CLASSIFICATION,
USER_DEFINED_FISC_CLASS = X_USER_DEFINED_FISC_CLASS,
TRX_BUSINESS_CATEGORY = X_TRX_BUSINESS_CATEGORY,
TAX_REGIME_CODE = X_TAX_REGIME_CODE,
TAX = X_TAX,
TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE,
TAX_STATUS_CODE = X_TAX_STATUS_CODE,
TAX_RATE_ID = X_TAX_RATE_ID,
TAX_RATE_CODE = X_TAX_RATE_CODE,
TAX_RATE = X_TAX_RATE,
INCL_IN_TAXABLE_LINE_FLAG = X_INCL_IN_TAXABLE_LINE_FLAG,
PURCHASING_CATEGORY = X_PURCHASING_CATEGORY,
PURCHASING_CATEGORY_ID = X_PURCHASING_CATEGORY_ID,
COST_FACTOR_NAME = X_COST_FACTOR_NAME,
COST_FACTOR_ID = X_COST_FACTOR_ID,
TAX_CLASSIFICATION_CODE = X_TAX_CLASSIFICATION_CODE
WHERE rowid = X_Rowid;
END UPDATE_ROW;
PROCEDURE Delete_Row(
X_INVOICE_LINE_ID NUMBER,
X_Calling_Sequence VARCHAR2)
IS
current_calling_sequence VARCHAR2(2000);
current_calling_sequence := 'AP_INVOICE_LINES_INTERFACE_PKG.Delete_Row<-'
||X_Calling_Sequence;
debug_info := 'Delete from ap_interface_rejections';
DELETE FROM AP_INTERFACE_REJECTIONS
WHERE parent_id = X_invoice_line_id
AND parent_table = 'AP_INVOICE_LINES_INTERFACE';
debug_info := 'Delete from ap_invoice_lines_interface';
DELETE FROM AP_INVOICE_LINES_INTERFACE
WHERE invoice_line_id = X_invoice_line_id;
END Delete_Row;