[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure Insert_Row (
X_rowid IN OUT NOCOPY VARCHAR2,
X_txn_interface_id IN OUT NOCOPY NUMBER,
X_last_update_date IN DATE,
X_last_updated_by IN NUMBER,
X_creation_date IN DATE,
X_created_by IN NUMBER,
X_transaction_source IN VARCHAR2,
X_user_txn_source IN VARCHAR2,
X_batch_name IN VARCHAR2,
X_expenditure_end_date IN DATE,
X_person_business_group_name IN VARCHAR2 Default Null,
X_employee_number IN VARCHAR2,
X_organization_name IN VARCHAR2,
X_expenditure_item_date IN DATE,
X_project_number IN VARCHAR2,
X_task_number IN VARCHAR2,
X_expenditure_type IN VARCHAR2,
X_system_linkage IN VARCHAR2,
X_non_labor_resource IN VARCHAR2,
X_non_labor_res_org IN VARCHAR2,
X_quantity IN NUMBER,
X_raw_cost IN NUMBER,
X_raw_cost_rate IN NUMBER,
X_burden_cost IN NUMBER,
X_burden_cost_rate IN NUMBER,
X_expenditure_comment IN VARCHAR2,
X_gl_date IN DATE,
X_txn_status_code IN VARCHAR2,
X_txn_rejection_code IN VARCHAR2,
X_org_txn_reference IN VARCHAR2,
X_unmatched_txn_flag IN VARCHAR2,
X_expenditure_id IN NUMBER,
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_dr_ccid IN NUMBER,
X_cr_ccid IN NUMBER,
X_cdl_sys_ref1 IN VARCHAR2,
X_cdl_sys_ref2 IN VARCHAR2,
X_cdl_sys_ref3 IN VARCHAR2,
X_xface_id IN NUMBER,
X_receipt_currency_amount IN NUMBER,
X_receipt_currency_code IN VARCHAR2,
X_receipt_exchange_rate IN NUMBER,
X_denom_currency_code IN VARCHAR2,
X_denom_raw_cost IN NUMBER,
X_denom_burdened_cost IN NUMBER,
X_acct_rate_date IN DATE,
X_acct_rate_type IN VARCHAR2,
X_acct_exchange_rate IN NUMBER,
X_acct_raw_cost IN NUMBER,
X_acct_burdened_cost IN NUMBER,
X_acct_exchange_rounding_limit IN NUMBER,
X_project_currency_code IN VARCHAR2,
X_project_rate_date IN DATE,
X_project_rate_type IN VARCHAR2,
X_project_exchange_rate IN NUMBER,
-- Trx_import enhancement: These new parameters are
-- used to populate PA_TRANSACTION_INTERFACE table's
-- new columns
X_orig_exp_txn_reference1 IN VARCHAR2,
X_orig_exp_txn_reference2 IN VARCHAR2,
X_orig_exp_txn_reference3 IN VARCHAR2,
X_orig_user_exp_txn_reference IN VARCHAR2,
X_vendor_number IN VARCHAR2,
X_override_to_oname IN VARCHAR2,
-- SST Changes: New columns added into the table for
-- SST changes
x_reversed_orig_txn_reference IN VARCHAR2 DEFAULT NULL,
x_billable_flag IN VARCHAR2 DEFAULT NULL,
-- PA-I Changes
X_Projfunc_currency_code IN VARCHAR2 DEFAULT NULL,
X_Projfunc_cost_rate_date IN DATE DEFAULT NULL,
X_Projfunc_cost_rate_type IN VARCHAR2 DEFAULT NULL,
X_Projfunc_cost_exchange_rate IN NUMBER DEFAULT NULL,
X_project_raw_cost IN NUMBER DEFAULT NULL,
X_project_burdened_cost IN NUMBER DEFAULT NULL,
X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
-- AP Discounts
x_cdl_sys_ref4 IN VARCHAR2 DEFAULT NULL,
-- PA-J changes
x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
-- Pa-K Changes
P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
-- Begin PA.M/CWK changes
P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
-- End PA.M/CWK changes
P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
-- 12i MOAC changes
P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL )
IS
cursor return_rowid is
select rowid
from pa_transaction_interface_all
where txn_interface_id = X_txn_interface_id;
select pa_txn_interface_s.nextval
from dual;
Insert INTO Pa_Transaction_Interface (
TRANSACTION_SOURCE ,
BATCH_NAME ,
EXPENDITURE_ENDING_DATE ,
EMPLOYEE_NUMBER ,
ORGANIZATION_NAME ,
EXPENDITURE_ITEM_DATE ,
PROJECT_NUMBER ,
TASK_NUMBER ,
EXPENDITURE_TYPE ,
NON_LABOR_RESOURCE ,
NON_LABOR_RESOURCE_ORG_NAME ,
QUANTITY ,
RAW_COST ,
EXPENDITURE_COMMENT ,
TRANSACTION_STATUS_CODE ,
TRANSACTION_REJECTION_CODE ,
ORIG_TRANSACTION_REFERENCE ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
RAW_COST_RATE ,
UNMATCHED_NEGATIVE_TXN_FLAG ,
DR_CODE_COMBINATION_ID ,
CR_CODE_COMBINATION_ID ,
CDL_SYSTEM_REFERENCE1 ,
CDL_SYSTEM_REFERENCE2 ,
CDL_SYSTEM_REFERENCE3 ,
GL_DATE ,
BURDENED_COST ,
BURDENED_COST_RATE ,
SYSTEM_LINKAGE ,
TXN_INTERFACE_ID ,
USER_TRANSACTION_SOURCE,
INTERFACE_ID,
receipt_currency_amount,
receipt_currency_code,
receipt_exchange_rate,
denom_currency_code,
denom_raw_cost,
denom_burdened_cost,
acct_rate_date,
acct_rate_type,
acct_exchange_rate,
acct_raw_cost,
acct_burdened_cost,
acct_exchange_rounding_limit,
project_currency_code,
project_rate_date,
project_rate_type,
project_exchange_rate,
orig_exp_txn_reference1,
orig_exp_txn_reference2,
orig_exp_txn_reference3,
orig_user_exp_txn_reference,
vendor_number,
override_to_organization_name,
-- SST Changes
reversed_orig_txn_reference,
billable_flag,
expenditure_id,
person_business_group_name,
-- PA-I Changes
projfunc_currency_code,
projfunc_cost_rate_type,
projfunc_cost_rate_date,
projfunc_cost_exchange_rate,
project_raw_cost,
project_burdened_cost,
assignment_name,
work_type_name,
cdl_system_reference4,
-- PA-J Changes
accrual_flag,
-- PA-K Changes
Project_Id,
Task_Id,
Person_Business_Group_Id,
Person_Id,
Organization_Id,
Non_Labor_Resource_Org_Id,
Override_To_Organization_Id,
Assignment_Id,
Work_Type_Id,
Vendor_Id,
-- CWK changes PA.M
PO_Number,
PO_Header_Id,
PO_Line_Num,
PO_Line_Id,
PO_Price_Type,
Person_Type,
Inventory_Item_Id,
WIP_Resource_Id,
Unit_Of_Measure,
-- 12i MOAC changes
Org_Id,
Created_By /*Bug 5870008 */)
values (
X_transaction_source ,
X_batch_name ,
X_expenditure_end_date ,
X_employee_number ,
X_organization_name ,
X_expenditure_item_date ,
X_project_number ,
X_task_number ,
X_expenditure_type ,
X_non_labor_resource ,
X_non_labor_res_org ,
X_quantity ,
X_raw_cost ,
X_expenditure_comment ,
X_txn_status_code ,
X_txn_rejection_code ,
X_org_txn_reference ,
X_attribute_category ,
X_attribute1 ,
X_attribute2 ,
X_attribute3 ,
X_attribute4 ,
X_attribute5 ,
X_attribute6 ,
X_attribute7 ,
X_attribute8 ,
X_attribute9 ,
X_attribute10 ,
X_raw_cost_rate ,
X_unmatched_txn_flag ,
X_dr_ccid ,
X_cr_ccid ,
X_cdl_sys_ref1 ,
X_cdl_sys_ref2 ,
X_cdl_sys_ref3 ,
X_gl_date ,
X_burden_cost,
X_burden_cost_rate,
X_system_linkage ,
X_txn_interface_id,
X_user_txn_source,
X_xface_id,
X_receipt_currency_amount,
X_receipt_currency_code,
X_receipt_exchange_rate,
X_denom_currency_code,
X_denom_raw_cost,
X_denom_burdened_cost,
X_acct_rate_date,
X_acct_rate_type,
X_acct_exchange_rate,
X_acct_raw_cost,
X_acct_burdened_cost,
X_acct_exchange_rounding_limit,
X_project_currency_code,
X_project_rate_date,
X_project_rate_type,
X_project_exchange_rate,
X_orig_exp_txn_reference1,
X_orig_exp_txn_reference2,
X_orig_exp_txn_reference3,
X_orig_user_exp_txn_reference,
X_vendor_number,
X_override_to_oname,
-- SST Changes
X_reversed_orig_txn_reference,
X_billable_flag,
X_expenditure_id,
X_person_business_group_name,
-- PA-I Changes
X_projfunc_currency_code,
X_projfunc_cost_rate_type,
X_projfunc_cost_rate_date,
X_projfunc_cost_exchange_rate,
X_project_raw_cost,
X_project_burdened_cost,
X_assignment_name,
X_work_type_name,
X_cdl_sys_ref4,
-- PA-J Changes
X_accrual_flag,
-- PA-K Changes
P_Project_Id,
P_Task_Id,
P_Person_Business_Group_Id,
P_Person_Id,
P_Organization_Id,
P_Non_Labor_Res_Org_Id,
P_Override_To_Org_Id,
P_Assignment_Id,
P_Work_Type_Id,
P_Vendor_Id,
-- Begin PA.M/CWK changes
P_PO_Number,
P_PO_Header_Id,
P_PO_Line_Num,
P_PO_Line_Id,
P_PO_Price_Type,
P_Person_Type,
-- End PA.M/CWK changes
P_Inventory_Item_Id,
P_WIP_Resource_Id,
P_Unit_Of_Measure,
-- 12i MOAC changes
P_Org_Id,
X_created_by /*Bug-5870008*/);
End Insert_Row;
Procedure Update_Row (
x_rowid IN VARCHAR2,
X_txn_interface_id IN NUMBER,
X_last_update_date IN DATE,
X_last_updated_by IN NUMBER,
X_creation_date IN DATE,
X_created_by IN NUMBER,
X_transaction_source IN VARCHAR2,
X_user_txn_source IN VARCHAR2,
X_batch_name IN VARCHAR2,
X_expenditure_end_date IN DATE,
X_person_business_group_name IN VARCHAR2 Default Null,
X_employee_number IN VARCHAR2,
X_organization_name IN VARCHAR2,
X_expenditure_item_date IN DATE,
X_project_number IN VARCHAR2,
X_task_number IN VARCHAR2,
X_expenditure_type IN VARCHAR2,
X_system_linkage IN VARCHAR2,
X_non_labor_resource IN VARCHAR2,
X_non_labor_res_org IN VARCHAR2,
X_quantity IN NUMBER,
X_raw_cost IN NUMBER,
X_raw_cost_rate IN NUMBER,
X_burden_cost IN NUMBER,
X_burden_cost_rate IN NUMBER,
X_expenditure_comment IN VARCHAR2,
X_gl_date IN DATE,
X_txn_status_code IN VARCHAR2,
X_txn_rejection_code IN VARCHAR2,
X_org_txn_reference IN VARCHAR2,
X_unmatched_txn_flag IN VARCHAR2,
X_expenditure_id IN NUMBER,
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_dr_ccid IN NUMBER,
X_cr_ccid IN NUMBER,
X_cdl_sys_ref1 IN VARCHAR2,
X_cdl_sys_ref2 IN VARCHAR2,
X_cdl_sys_ref3 IN VARCHAR2,
x_receipt_currency_amount IN NUMBER,
x_receipt_currency_code IN VARCHAR2,
x_receipt_exchange_rate IN NUMBER,
x_denom_currency_code IN VARCHAR2,
x_denom_raw_cost IN NUMBER,
x_denom_burdened_cost IN NUMBER,
x_acct_rate_date IN DATE,
x_acct_rate_type IN VARCHAR2,
x_acct_exchange_rate IN NUMBER,
x_acct_raw_cost IN NUMBER,
x_acct_burdened_cost IN NUMBER,
x_acct_exchange_rounding_limit IN NUMBER,
x_project_currency_code IN VARCHAR2,
x_project_rate_date IN DATE,
x_project_rate_type IN VARCHAR2,
x_project_exchange_rate IN NUMBER,
-- Trx_import enhancement: These parameters are needed
-- to populate PA_TRANSACTION_INTERFACE table's new
-- columns
X_orig_exp_txn_reference1 IN VARCHAR2,
X_orig_exp_txn_reference2 IN VARCHAR2,
X_orig_exp_txn_reference3 IN VARCHAR2,
X_orig_user_exp_txn_reference IN VARCHAR2,
X_vendor_number IN VARCHAR2,
X_override_to_oname IN VARCHAR2,
-- SST Changes
X_Reversed_Orig_Txn_Reference IN VARCHAR2 DEFAULT NULL,
X_Billable_Flag IN VARCHAR2 DEFAULT NULL,
-- PA-I Changes
X_ProjFunc_Currency_Code IN VARCHAR2 DEFAULT NULL,
X_ProjFunc_Cost_Rate_Date IN DATE DEFAULT NULL,
X_ProjFunc_Cost_Rate_Type IN VARCHAR2 DEFAULT NULL,
X_ProjFunc_Cost_Exchange_Rate IN NUMBER DEFAULT NULL,
X_Project_Raw_Cost IN NUMBER DEFAULT NULL,
X_Project_Burdened_Cost IN NUMBER DEFAULT NULL,
X_Assignment_Name IN VARCHAR2 DEFAULT NULL,
X_Work_Type_Name IN VARCHAR2 DEFAULT NULL,
-- AP Discounts
X_Cdl_Sys_Ref4 IN VARCHAR2 DEFAULT NULL,
-- PA-J changes
X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
-- PA-K Changes
P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
-- Begin PA.M/CWK changes
P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
-- End PA.M/CWK changes
P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL)
IS
Begin
Update Pa_Transaction_Interface
Set Transaction_Source = X_transaction_source ,
Batch_Name = X_batch_name ,
Expenditure_Ending_Date = X_expenditure_end_date ,
Employee_Number = X_employee_number ,
Organization_Name = X_organization_name ,
Expenditure_Item_Date = X_expenditure_item_date ,
Project_Number = X_project_number ,
Task_Number = X_task_number ,
Expenditure_Type = X_expenditure_type ,
Non_Labor_Resource = X_non_labor_resource ,
Non_Labor_Resource_Org_Name = X_non_labor_res_org ,
Quantity = X_quantity ,
Raw_Cost = X_raw_cost ,
Expenditure_Comment = X_expenditure_comment ,
Transaction_Status_Code = X_txn_status_code ,
Transaction_Rejection_Code = X_txn_rejection_code ,
Orig_Transaction_Reference = X_org_txn_reference ,
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 ,
Raw_Cost_Rate = X_raw_cost_rate ,
Unmatched_Negative_Txn_Flag = X_unmatched_txn_flag ,
Dr_Code_Combination_Id = X_dr_ccid ,
Cr_Code_Combination_Id = X_cr_ccid ,
Cdl_System_Reference1 = X_cdl_sys_ref1 ,
Cdl_System_Reference2 = X_cdl_sys_ref2 ,
Cdl_System_Reference3 = X_cdl_sys_ref3 ,
Gl_Date = X_gl_date ,
Burdened_Cost = X_burden_cost ,
Burdened_Cost_Rate = X_burden_cost_rate ,
System_Linkage = X_system_linkage ,
User_Transaction_Source = X_user_txn_source ,
Receipt_Currency_Amount = X_receipt_currency_amount,
Receipt_Currency_Code = X_receipt_currency_code,
Receipt_Exchange_Rate = X_receipt_exchange_rate,
Denom_Currency_Code = X_denom_currency_code,
Denom_Raw_Cost = X_denom_raw_cost,
Denom_Burdened_Cost = X_denom_burdened_cost,
Acct_Rate_Date = X_acct_rate_date,
Acct_Rate_Type = X_acct_rate_type,
Acct_Exchange_Rate = X_acct_exchange_rate,
Acct_Raw_Cost = X_acct_raw_cost,
Acct_Burdened_Cost = X_acct_burdened_cost,
Acct_Exchange_Rounding_Limit = X_acct_exchange_rounding_limit,
Project_Currency_Code = X_project_currency_code,
Project_Rate_Date = X_project_rate_date,
Project_Rate_Type = X_project_rate_type,
Project_Exchange_Rate = X_project_exchange_rate,
Orig_Exp_Txn_Reference1 = X_orig_exp_txn_reference1,
Orig_Exp_Txn_Reference2 = X_orig_exp_txn_reference2,
Orig_Exp_Txn_Reference3 = X_orig_exp_txn_reference3,
Orig_User_Exp_Txn_Reference = X_orig_user_exp_txn_reference,
Vendor_Number = X_vendor_number,
Override_To_Organization_Name = X_override_to_oname,
-- SST Changes
Reversed_Orig_Txn_Reference = X_reversed_orig_txn_reference,
Billable_Flag = X_billable_flag,
Person_Business_Group_Name = X_person_business_group_name,
-- PA-I Changes
ProjFunc_Currency_Code = X_projfunc_currency_code,
ProjFunc_Cost_Rate_Type = X_projfunc_cost_rate_type,
ProjFunc_Cost_Rate_Date = X_projfunc_cost_rate_date,
ProjFunc_Cost_Exchange_Rate = X_projfunc_cost_exchange_rate,
Project_Raw_Cost = X_project_raw_cost,
Project_Burdened_Cost = X_project_burdened_cost,
Assignment_Name = X_assignment_name,
Work_Type_Name = X_work_type_name ,
Cdl_System_Reference4 = X_cdl_sys_ref4,
-- PA-J Changes
Accrual_Flag = X_accrual_flag,
-- PA-K Changes
Project_Id = P_Project_Id,
Task_Id = P_Task_Id,
Person_Business_Group_Id = P_Person_Business_Group_Id,
Person_Id = P_Person_Id,
Organization_Id = P_Organization_Id,
Non_Labor_Resource_Org_Id = P_Non_Labor_Res_Org_Id,
Override_To_Organization_Id = P_Override_To_Org_Id,
Assignment_Id = P_Assignment_Id,
Work_Type_Id = P_Work_Type_Id,
Vendor_Id = P_Vendor_Id,
-- Begin PA.M/CWK changes
PO_Number = P_PO_Number,
PO_Header_Id = P_PO_Header_Id,
PO_Line_Num = P_PO_Line_Num,
PO_Line_Id = P_PO_Line_Id,
PO_Price_Type = P_PO_Price_Type,
Person_Type = P_Person_Type,
-- End PA.M/CWK changes
Inventory_Item_Id = P_Inventory_Item_Id,
WIP_Resource_Id = P_WIP_Resource_Id,
Unit_Of_Measure = P_Unit_Of_Measure,
Last_Updated_By = X_last_updated_by /*Bug -5870008*/
Where
Txn_Interface_Id = X_Txn_Interface_Id;
End Update_Row;
Procedure Delete_Row (X_RowId IN Varchar2)
Is
Begin
Delete From Pa_Transaction_Interface_All
Where RowId = X_RowId ;
End Delete_Row;
Procedure Bulk_Insert (
P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
P_Accrual_flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_flag_Typ,
P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
-- Begin PA.M/CWK changes
P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
-- End PA.M/CWK changes
P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ,
-- 12i MOAC changes
P_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.OU_Id_Typ)
Is
Begin
ForAll i in P_Txn_Interface_Id_Tbl.First .. P_Txn_Interface_Id_Tbl.Last
Insert Into Pa_Transaction_Interface(
Transaction_Source ,
Batch_Name ,
Expenditure_Ending_Date ,
Employee_Number ,
Organization_Name ,
Expenditure_Item_Date ,
Project_Number ,
Task_Number ,
Expenditure_Type ,
Non_Labor_Resource ,
Non_Labor_Resource_Org_Name ,
Quantity ,
Raw_Cost ,
Expenditure_Comment ,
Transaction_Status_Code ,
Transaction_Rejection_Code ,
Orig_Transaction_Reference ,
Attribute_Category ,
Attribute1 ,
Attribute2 ,
Attribute3 ,
Attribute4 ,
Attribute5 ,
Attribute6 ,
Attribute7 ,
Attribute8 ,
Attribute9 ,
Attribute10 ,
Raw_Cost_Rate ,
Unmatched_Negative_Txn_Flag ,
Dr_Code_Combination_Id ,
Cr_Code_Combination_Id ,
Cdl_System_Reference1 ,
Cdl_System_Reference2 ,
Cdl_System_Reference3 ,
Gl_Date ,
Burdened_Cost ,
Burdened_Cost_Rate ,
System_Linkage ,
Txn_Interface_Id ,
User_Transaction_Source,
Interface_Id,
Receipt_Currency_Amount,
Receipt_Currency_Code,
Receipt_Exchange_Rate,
Denom_Currency_Code,
Denom_Raw_Cost,
Denom_Burdened_Cost,
Acct_Rate_Date,
Acct_Rate_Type,
Acct_Exchange_Rate,
Acct_Raw_Cost,
Acct_Burdened_Cost,
Acct_Exchange_Rounding_Limit,
Project_Currency_Code,
Project_Rate_Date,
Project_Rate_Type,
Project_Exchange_Rate,
Orig_Exp_Txn_Reference1,
Orig_Exp_Txn_Reference2,
Orig_Exp_Txn_Reference3,
Orig_User_Exp_Txn_Reference,
Vendor_Number,
Override_To_Organization_Name,
Reversed_Orig_Txn_Reference,
Billable_Flag,
Expenditure_Id,
Person_Business_Group_Name,
ProjFunc_Currency_Code,
ProjFunc_Cost_Rate_Type,
ProjFunc_Cost_Rate_Date,
ProjFunc_Cost_Exchange_Rate,
Project_Raw_Cost,
Project_Burdened_Cost,
Assignment_Name,
Work_Type_Name,
Cdl_System_Reference4,
Accrual_Flag,
Project_Id,
Task_Id,
Person_Business_Group_Id,
Person_Id,
Organization_Id,
Non_Labor_Resource_Org_Id,
Override_To_Organization_Id,
Assignment_Id,
Work_Type_Id,
Vendor_Id,
Last_Update_Date,
Last_Updated_By,
Creation_Date,
Created_By,
-- Begin PA.M/CWK changes
PO_Number,
PO_Header_Id,
PO_Line_Num,
PO_Line_Id,
PO_Price_Type,
Person_Type,
-- End PA.M/CWK changes
Inventory_Item_Id,
WIP_Resource_Id,
Unit_Of_Measure,
-- 12i MOAC changes
Org_Id)
VALUES (
P_Transaction_Source_Tbl(i) ,
P_Batch_Name_Tbl(i) ,
P_Expenditure_End_Date_Tbl(i) ,
P_Employee_Number_Tbl(i) ,
P_Organization_Name_Tbl(i) ,
P_Expenditure_Item_Date_Tbl(i) ,
P_Project_Number_Tbl(i) ,
P_Task_Number_Tbl(i) ,
P_Expenditure_Type_Tbl(i) ,
P_Non_Labor_Resource_Tbl(i) ,
P_Non_Labor_Res_Org_Name_Tbl(i) ,
P_Quantity_Tbl(i),
P_Raw_Cost_Tbl(i) ,
P_Expenditure_Comment_Tbl(i) ,
P_Transaction_Status_Code_Tbl(i) ,
P_Trans_Rejection_Code_Tbl(i) ,
P_Orig_Trans_Reference_Tbl(i) ,
P_Attribute_Category_Tbl(i) ,
P_Attribute1_Tbl(i) ,
P_Attribute2_Tbl(i) ,
P_Attribute3_Tbl(i) ,
P_Attribute4_Tbl(i) ,
P_Attribute5_Tbl(i) ,
P_Attribute6_Tbl(i) ,
P_Attribute7_Tbl(i) ,
P_Attribute8_Tbl(i) ,
P_Attribute9_Tbl(i) ,
P_Attribute10_Tbl(i) ,
P_Raw_Cost_Rate_Tbl(i) ,
P_Unmatched_Neg_Txn_Flag_Tbl(i) ,
P_Dr_Code_Combination_Id_Tbl(i) ,
P_Cr_Code_Combination_Id_Tbl(i) ,
P_Cdl_System_Reference1_Tbl(i) ,
P_Cdl_System_Reference2_Tbl(i) ,
P_Cdl_System_Reference3_Tbl(i) ,
P_Gl_Date_Tbl(i) ,
P_Burden_Cost_Tbl(i) ,
P_Burden_Cost_Rate_Tbl(i) ,
P_System_Linkage_Tbl(i) ,
P_Txn_Interface_Id_Tbl(i) ,
P_User_Transaction_Source_Tbl(i),
P_Interface_Id_Tbl(i),
P_Receipt_Currency_Amount_Tbl(i),
P_Receipt_Currency_Code_Tbl(i),
P_Receipt_Exchange_Rate_Tbl(i),
P_Denom_Currency_Code_Tbl(i),
P_Denom_Raw_Cost_Tbl(i),
P_Denom_Burdened_Cost_Tbl(i),
P_Acct_Rate_Date_Tbl(i),
P_Acct_Rate_Type_Tbl(i),
P_Acct_Exchange_Rate_Tbl(i),
P_Acct_Raw_Cost_Tbl(i),
P_Acct_Burdened_Cost_Tbl(i),
P_Acct_Exch_Rounding_Limit_Tbl(i),
P_Project_Currency_Code_Tbl(i),
P_Project_Rate_Date_Tbl(i),
P_Project_Rate_Type_Tbl(i),
P_Project_Exchange_Rate_Tbl(i),
P_Orig_Exp_Txn_Reference1_Tbl(i),
P_Orig_Exp_Txn_Reference2_Tbl(i),
P_Orig_Exp_Txn_Reference3_Tbl(i),
P_Orig_User_Exp_Txn_Ref_Tbl(i),
P_Vendor_Number_Tbl(i),
P_Override_To_Org_Name_Tbl(i),
P_Reversed_Orig_Txn_Ref_Tbl(i),
P_Billable_Flag_Tbl(i),
P_Expenditure_Id_Tbl(i),
P_Person_Bus_Grp_Name_Tbl(i),
P_ProjFunc_Currency_Code_Tbl(i),
P_ProjFunc_Cost_Rate_Type_Tbl(i),
P_ProjFunc_Cost_Rate_Date_Tbl(i),
P_ProjFunc_Cost_Exch_Rate_Tbl(i),
P_Project_Raw_Cost_Tbl(i),
P_Project_Burdened_Cost_Tbl(i),
P_Assignment_Name_Tbl(i),
P_Work_Type_Name_Tbl(i),
P_Cdl_System_Reference4_Tbl(i),
P_Accrual_Flag_Tbl(i),
P_Project_Id_Tbl(i),
P_Task_Id_Tbl(i),
P_Person_Bus_Grp_Id_Tbl(i),
P_Person_Id_Tbl(i),
P_Organization_Id_Tbl(i),
P_Non_Labor_Res_Org_Id_Tbl(i),
P_Override_To_Org_Id_Tbl(i),
P_Assignment_Id_Tbl(i),
P_Work_Type_Id_Tbl(i),
P_Vendor_Id_Tbl(i),
P_Last_Update_Date_Tbl(i),
P_Last_Updated_By_Tbl(i),
P_Creation_Date_Tbl(i),
P_Created_By_Tbl(i),
-- Begin PA.M/CWK changes
P_PO_Number_Tbl(i),
P_PO_Header_Id_Tbl(i),
P_PO_Line_Num_Tbl(i),
P_PO_Line_Id_Tbl(i),
P_PO_Price_Type_Tbl(i),
P_Person_Type_Tbl(i),
-- End PA.M/CWK changes
P_Inventory_Item_Id_Tbl(i),
P_WIP_Resource_Id_Tbl(i),
P_Unit_Of_Measure_Tbl(i),
-- 12i MOAC changes
P_Org_Id_Tbl(i));
End Bulk_Insert;
Procedure Bulk_Update (
P_Txn_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Txn_Interface_Id_Typ,
P_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Source_Typ,
P_User_Transaction_Source_Tbl IN Pa_Txn_Interface_Items_Pkg.User_Transaction_Source_Typ,
P_Batch_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Batch_Name_Typ,
P_Expenditure_End_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_End_Date_Typ,
P_Person_Bus_Grp_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Name_Typ,
P_Person_Bus_Grp_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Business_Group_Id_Typ,
P_Employee_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Employee_Number_Typ,
P_Person_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Id_Typ,
P_Organization_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Name_Typ,
P_Organization_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Organization_Id_Typ,
P_Expenditure_Item_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Item_Date_Typ,
P_Project_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Number_Typ,
P_Project_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Id_Typ,
P_Task_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Number_Typ,
P_Task_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Task_Id_Typ,
P_Expenditure_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Type_Typ,
P_System_Linkage_Tbl IN Pa_Txn_Interface_Items_Pkg.System_Linkage_Typ,
P_Non_Labor_Resource_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Resource_Typ,
P_Non_Labor_Res_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Name_Typ,
P_Non_Labor_Res_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Non_Labor_Res_Org_Id_Typ,
P_Quantity_Tbl IN Pa_Txn_Interface_Items_Pkg.Quantity_Typ,
P_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Typ,
P_Raw_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Raw_Cost_Rate_Typ,
P_Burden_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Typ,
P_Burden_Cost_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Burden_Cost_Rate_Typ,
P_Expenditure_Comment_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Comment_Typ,
P_Gl_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Gl_Date_Typ,
P_Transaction_Status_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Status_Code_Typ,
P_Trans_Rejection_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Transaction_Rejection_Code_Typ,
P_Orig_Trans_Reference_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Transaction_Reference_Typ,
P_Unmatched_Neg_Txn_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Unmatched_Neg_Txn_Flag_Typ,
P_Expenditure_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Expenditure_Id_Typ,
P_Attribute_Category_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute_Category_Typ,
P_Attribute1_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute1_Typ,
P_Attribute2_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute2_Typ,
P_Attribute3_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute3_Typ,
P_Attribute4_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute4_Typ,
P_Attribute5_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute5_Typ,
P_Attribute6_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute6_Typ,
P_Attribute7_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute7_Typ,
P_Attribute8_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute8_Typ,
P_Attribute9_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute9_Typ,
P_Attribute10_Tbl IN Pa_Txn_Interface_Items_Pkg.Attribute10_Typ,
P_Dr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Dr_Code_Combination_Id_Typ,
P_Cr_Code_Combination_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Cr_Code_Combination_Id_Typ,
P_Cdl_System_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference1_Typ,
P_Cdl_System_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference2_Typ,
P_Cdl_System_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference3_Typ,
P_Interface_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Interface_Id_Typ,
P_Receipt_Currency_Amount_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Amount_Typ,
P_Receipt_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Currency_Code_Typ,
P_Receipt_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Receipt_Exchange_Rate_Typ,
P_Denom_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Currency_Code_Typ,
P_Denom_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Raw_Cost_Typ,
P_Denom_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Denom_Burdened_Cost_Typ,
P_Acct_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Date_Typ,
P_Acct_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Rate_Type_Typ,
P_Acct_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exchange_Rate_Typ,
P_Acct_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Raw_Cost_Typ,
P_Acct_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Burdened_Cost_Typ,
P_Acct_Exch_Rounding_Limit_Tbl IN Pa_Txn_Interface_Items_Pkg.Acct_Exch_Rounding_Limit_Typ,
P_Project_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Currency_Code_Typ,
P_Project_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Date_Typ,
P_Project_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Rate_Type_Typ,
P_Project_Exchange_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Exchange_Rate_Typ,
P_Orig_Exp_Txn_Reference1_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference1_Typ,
P_Orig_Exp_Txn_Reference2_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference2_Typ,
P_Orig_Exp_Txn_Reference3_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_Exp_Txn_Reference3_Typ,
P_Orig_User_Exp_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Orig_User_Exp_Txn_Ref_Typ,
P_Vendor_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Number_Typ,
P_Vendor_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Vendor_Id_Typ,
P_Override_To_Org_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Name_Typ,
P_Override_To_Org_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Override_To_Org_Id_Typ,
P_Reversed_Orig_Txn_Ref_Tbl IN Pa_Txn_Interface_Items_Pkg.Reversed_Orig_Txn_Ref_Typ,
P_Billable_Flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Billable_Flag_Typ,
P_ProjFunc_Currency_Code_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Currency_Code_Typ,
P_ProjFunc_Cost_Rate_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Date_Typ,
P_ProjFunc_Cost_Rate_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Rate_Type_Typ,
P_ProjFunc_Cost_Exch_Rate_Tbl IN Pa_Txn_Interface_Items_Pkg.ProjFunc_Cost_Exch_Rate_Typ,
P_Project_Raw_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Raw_Cost_Typ,
P_Project_Burdened_Cost_Tbl IN Pa_Txn_Interface_Items_Pkg.Project_Burdened_Cost_Typ,
P_Assignment_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Name_Typ,
P_Assignment_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Assignment_Id_Typ,
P_Work_Type_Name_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Name_Typ,
P_Work_Type_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Work_Type_Id_Typ,
P_Cdl_System_Reference4_Tbl IN Pa_Txn_Interface_Items_Pkg.Cdl_System_Reference4_Typ,
P_Accrual_flag_Tbl IN Pa_Txn_Interface_Items_Pkg.Accrual_flag_Typ,
P_Last_Update_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Update_Date_Typ,
P_Last_Updated_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Last_Updated_By_Typ,
P_Creation_Date_Tbl IN Pa_Txn_Interface_Items_Pkg.Creation_Date_Typ,
P_Created_By_Tbl IN Pa_Txn_Interface_Items_Pkg.Created_By_Typ,
-- Begin PA.M/CWK changes
P_PO_Number_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Number_Typ,
P_PO_Header_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Header_Id_Typ,
P_PO_Line_Num_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Num_Typ,
P_PO_Line_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Line_Id_Typ,
P_PO_Price_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.PO_Price_Type_Typ,
P_Person_Type_Tbl IN Pa_Txn_Interface_Items_Pkg.Person_Type_Typ,
-- End PA.M/CWK changes
P_Inventory_Item_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.Inventory_Item_Id_Typ,
P_WIP_Resource_Id_Tbl IN Pa_Txn_Interface_Items_Pkg.WIP_Resource_Id_Typ,
P_Unit_Of_Measure_Tbl IN Pa_Txn_Interface_Items_Pkg.Unit_Of_Measure_Typ )
Is
Begin
ForAll i in P_Txn_Interface_Id_Tbl.First .. P_Txn_Interface_Id_Tbl.Last
Update Pa_Transaction_Interface
Set Transaction_Source = P_Transaction_Source_Tbl(i) ,
Batch_Name = P_Batch_Name_Tbl(i) ,
Expenditure_Ending_Date = P_Expenditure_End_Date_Tbl(i) ,
Employee_Number = P_Employee_Number_Tbl(i) ,
Organization_Name = P_Organization_Name_Tbl(i) ,
Expenditure_Item_Date = P_Expenditure_Item_Date_Tbl(i) ,
Project_Number = P_Project_Number_Tbl(i) ,
Task_Number = P_Task_Number_Tbl(i) ,
Expenditure_Type = P_Expenditure_Type_Tbl(i) ,
Non_Labor_Resource = P_Non_Labor_Resource_Tbl(i) ,
Non_Labor_Resource_Org_Name = P_Non_Labor_Res_Org_Name_Tbl(i) ,
Quantity = P_Quantity_Tbl(i) ,
Raw_Cost = P_Raw_Cost_Tbl(i) ,
Expenditure_Comment = P_Expenditure_Comment_Tbl(i) ,
Transaction_Status_Code = P_Transaction_Status_Code_Tbl(i) ,
Transaction_Rejection_Code = P_Trans_Rejection_Code_Tbl(i) ,
Orig_Transaction_Reference = P_Orig_Trans_Reference_Tbl(i) ,
Attribute_Category = P_Attribute_Category_Tbl(i) ,
Attribute1 = P_Attribute1_Tbl(i) ,
Attribute2 = P_Attribute2_Tbl(i) ,
Attribute3 = P_Attribute3_Tbl(i) ,
Attribute4 = P_Attribute4_Tbl(i) ,
Attribute5 = P_Attribute5_Tbl(i) ,
Attribute6 = P_Attribute6_Tbl(i) ,
Attribute7 = P_Attribute7_Tbl(i) ,
Attribute8 = P_Attribute8_Tbl(i) ,
Attribute9 = P_Attribute9_Tbl(i) ,
Attribute10 = P_Attribute10_Tbl(i) ,
Raw_Cost_Rate = P_Raw_Cost_Rate_Tbl(i) ,
Unmatched_Negative_Txn_Flag = P_Unmatched_Neg_Txn_Flag_Tbl(i) ,
Dr_Code_Combination_Id = P_Dr_Code_Combination_Id_Tbl(i) ,
Cr_Code_Combination_Id = P_Cr_Code_Combination_Id_Tbl(i) ,
Cdl_System_Reference1 = P_Cdl_System_Reference1_Tbl(i) ,
Cdl_System_Reference2 = P_Cdl_System_Reference2_Tbl(i) ,
Cdl_System_Reference3 = P_Cdl_System_Reference3_Tbl(i) ,
Gl_Date = P_Gl_Date_Tbl(i) ,
Burdened_Cost = P_Burden_Cost_Tbl(i) ,
Burdened_Cost_Rate = P_Burden_Cost_Rate_Tbl(i) ,
System_Linkage = P_System_Linkage_Tbl(i) ,
User_Transaction_Source = P_User_Transaction_Source_Tbl(i) ,
Receipt_Currency_Amount = P_Receipt_Currency_Amount_Tbl(i),
Receipt_Currency_Code = P_Receipt_Currency_Code_Tbl(i),
Receipt_Exchange_Rate = P_Receipt_Exchange_Rate_Tbl(i),
Denom_Currency_Code = P_Denom_Currency_Code_Tbl(i),
Denom_Raw_Cost = P_Denom_Raw_Cost_Tbl(i),
Denom_Burdened_Cost = P_Denom_Burdened_Cost_Tbl(i),
Acct_Rate_Date = P_Acct_Rate_Date_Tbl(i),
Acct_Rate_Type = P_Acct_Rate_Type_Tbl(i),
Acct_Exchange_Rate = P_Acct_Exchange_Rate_Tbl(i),
Acct_Raw_Cost = P_Acct_Raw_Cost_Tbl(i),
Acct_Burdened_Cost = P_Acct_Burdened_Cost_Tbl(i),
Acct_Exchange_Rounding_Limit = P_Acct_Exch_Rounding_Limit_Tbl(i),
Project_Currency_Code = P_Project_Currency_Code_Tbl(i),
Project_Rate_Date = P_Project_Rate_Date_Tbl(i),
Project_Rate_Type = P_Project_Rate_Type_Tbl(i),
Project_Exchange_Rate = P_Project_Exchange_Rate_Tbl(i),
Orig_Exp_Txn_Reference1 = P_Orig_Exp_Txn_Reference1_Tbl(i),
Orig_Exp_Txn_Reference2 = P_Orig_Exp_Txn_Reference2_Tbl(i),
Orig_Exp_Txn_Reference3 = P_Orig_Exp_Txn_Reference3_Tbl(i),
Orig_User_Exp_Txn_Reference = P_Orig_User_Exp_Txn_Ref_Tbl(i),
Vendor_Number = P_Vendor_Number_Tbl(i),
Override_To_Organization_Name = P_Override_To_Org_Name_Tbl(i),
Reversed_Orig_Txn_Reference = P_Reversed_Orig_Txn_Ref_Tbl(i),
Billable_Flag = P_Billable_Flag_Tbl(i),
Person_Business_Group_Name = P_Person_Bus_Grp_Name_Tbl(i),
ProjFunc_Currency_Code = P_ProjFunc_Currency_Code_Tbl(i),
ProjFunc_Cost_Rate_Type = P_ProjFunc_Cost_Rate_Type_Tbl(i),
ProjFunc_Cost_Rate_Date = P_ProjFunc_Cost_Rate_Date_Tbl(i),
ProjFunc_Cost_Exchange_Rate = P_ProjFunc_Cost_Exch_Rate_Tbl(i),
Project_Raw_Cost = P_Project_Raw_Cost_Tbl(i),
Project_Burdened_Cost = P_Project_Burdened_Cost_Tbl(i),
Assignment_Name = P_Assignment_Name_Tbl(i),
Work_Type_Name = P_Work_Type_Name_Tbl(i) ,
Cdl_System_Reference4 = P_Cdl_System_Reference4_Tbl(i),
Accrual_Flag = P_Accrual_Flag_Tbl(i),
Project_Id = P_Project_Id_Tbl(i),
Task_Id = P_Task_Id_Tbl(i),
Person_Business_Group_Id = P_Person_Bus_Grp_Id_Tbl(i),
Person_Id = P_Person_Id_Tbl(i),
Organization_Id = P_Organization_Id_Tbl(i),
Assignment_Id = P_Assignment_Id_Tbl(i),
Work_Type_Id = P_Work_Type_Id_Tbl(i),
Vendor_Id = P_Vendor_Id_Tbl(i),
Last_Update_Date = P_Last_Update_Date_Tbl(i),
Last_Updated_By = P_Last_Updated_By_Tbl(i),
-- Begin PA.M/CWK changes
PO_Number = P_PO_Number_Tbl(i),
PO_Header_Id = P_PO_Header_Id_Tbl(i),
PO_Line_Num = P_PO_Line_Num_Tbl(i),
PO_Line_Id = P_PO_Line_Id_Tbl(i),
PO_Price_Type = P_PO_Price_Type_Tbl(i),
Person_Type = P_Person_Type_Tbl(i),
-- End PA.M/CWK changes
Inventory_Item_Id = P_Inventory_Item_Id_Tbl(i),
WIP_Resource_Id = P_WIP_Resource_Id_Tbl(i),
Unit_Of_Measure = P_Unit_Of_Measure_Tbl(i)
Where
Txn_Interface_Id = P_Txn_Interface_Id_Tbl(i);
End Bulk_Update;