The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_update_login igc_cbc_je_lines.last_update_login%TYPE;
g_update_by igc_cbc_je_lines.last_updated_by%TYPE;
Put_Debug_Msg (l_full_path,' IGCCCPCB - Starting to Insert Account Line.');
IGC_CC_ACCT_LINES_PKG.Insert_Row
(p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
X_return_status => l_return_status,
X_msg_count => l_msg_count,
X_msg_data => l_msg_data,
p_Rowid => l_rowid,
p_CC_Acct_Line_Id => l_cc_acct_line_id,
p_CC_Header_Id => g_new_cc_header_id,
p_Parent_Header_Id => NULL,
p_Parent_Acct_Line_Id => NULL,
p_CC_Charge_Code_Comb_Id => p_cc_acct_line.CC_Charge_Code_Combination_Id,
p_CC_Acct_Line_Num => p_cc_acct_line.CC_Acct_Line_Num,
p_CC_Budget_Code_Comb_Id => p_cc_acct_line.CC_Budget_Code_Combination_Id,
p_CC_Acct_Entered_Amt => p_cc_acct_line.CC_Acct_Entered_Amt,
p_CC_Acct_Func_Amt => l_functional_amount,
p_CC_Acct_Desc => p_cc_acct_line.CC_Acct_Desc,
p_CC_Acct_Billed_Amt => NULL,
p_CC_Acct_Unbilled_Amt => NULL,
p_CC_Acct_Taxable_Flag => p_cc_acct_line.CC_Acct_Taxable_Flag,
p_Tax_Id => p_cc_acct_line.Tax_Id,
p_CC_Acct_Encmbrnc_Amt => NULL,
p_CC_Acct_Encmbrnc_Date => NULL,
p_CC_Acct_Encmbrnc_Status => NULL,
p_Project_Id => p_cc_acct_line.Project_Id,
p_Task_Id => p_cc_acct_line.Task_Id,
p_Expenditure_Type => p_cc_acct_line.Expenditure_Type,
p_Expenditure_Org_Id => p_cc_acct_line.Expenditure_Org_Id,
p_Expenditure_Item_Date => p_cc_acct_line.Expenditure_Item_Date,
p_Last_Update_Date => SYSDATE,
p_Last_Updated_By => g_update_by,
p_Last_Update_Login => g_update_login,
p_Creation_Date => SYSDATE,
p_Created_By => g_update_by,
p_Attribute1 => p_cc_acct_line.Attribute1,
p_Attribute2 => p_cc_acct_line.Attribute2,
p_Attribute3 => p_cc_acct_line.Attribute3,
p_Attribute4 => p_cc_acct_line.Attribute4,
p_Attribute5 => p_cc_acct_line.Attribute5,
p_Attribute6 => p_cc_acct_line.Attribute6,
p_Attribute7 => p_cc_acct_line.Attribute7,
p_Attribute8 => p_cc_acct_line.Attribute8,
p_Attribute9 => p_cc_acct_line.Attribute9,
p_Attribute10 => p_cc_acct_line.Attribute10,
p_Attribute11 => p_cc_acct_line.Attribute11,
p_Attribute12 => p_cc_acct_line.Attribute12,
p_Attribute13 => p_cc_acct_line.Attribute13,
p_Attribute14 => p_cc_acct_line.Attribute14,
p_Attribute15 => p_cc_acct_line.Attribute15,
p_Context => p_cc_acct_line.Context,
--bug 2043221 ssmales - 2 arguments below added
p_CC_Func_Withheld_Amt => l_func_withheld_amt,
p_CC_Ent_Withheld_Amt => p_cc_acct_line.CC_Ent_Withheld_Amt,
G_FLAG => l_flag,
P_Tax_Classif_Code => p_cc_acct_line.Tax_Classif_Code
);
Put_Debug_Msg (l_full_path,' IGCCCPCB - Failure Inserting new Account Line ID......');
IGC_CC_DET_PF_PKG.Insert_Row
(p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
X_return_status => l_return_status,
X_msg_count => l_msg_count,
X_msg_data => l_msg_data,
p_Rowid => l_rowid,
p_CC_Det_PF_Line_Id => l_cc_pmt_fcst_id,
p_CC_Det_PF_Line_Num => p_cc_pmt_fcst.CC_Det_PF_Line_Num,
p_CC_Acct_Line_Id => p_cc_acct_line_id,
p_Parent_Acct_Line_Id => NULL,
p_Parent_Det_PF_Line_Id => NULL,
p_CC_Det_PF_Entered_Amt => p_cc_pmt_fcst.CC_Det_PF_Entered_Amt,
p_CC_Det_PF_Func_Amt => l_functional_amount,
p_CC_Det_PF_Date => p_cc_pmt_fcst.CC_Det_PF_Date,
p_CC_Det_PF_Billed_Amt => NULL,
p_CC_Det_PF_Unbilled_Amt => NULL,
p_CC_Det_PF_Encmbrnc_Amt => NULL,
p_CC_Det_PF_Encmbrnc_Date => NULL,
p_CC_Det_PF_Encmbrnc_Status => NULL,
p_Last_Update_Date => SYSDATE,
p_Last_Updated_By => g_update_by,
p_Last_Update_Login => g_update_login,
p_Creation_Date => SYSDATE,
p_Created_By => g_update_by,
p_Attribute1 => p_cc_pmt_fcst.Attribute1,
p_Attribute2 => p_cc_pmt_fcst.Attribute2,
p_Attribute3 => p_cc_pmt_fcst.Attribute3,
p_Attribute4 => p_cc_pmt_fcst.Attribute4,
p_Attribute5 => p_cc_pmt_fcst.Attribute5,
p_Attribute6 => p_cc_pmt_fcst.Attribute6,
p_Attribute7 => p_cc_pmt_fcst.Attribute7,
p_Attribute8 => p_cc_pmt_fcst.Attribute8,
p_Attribute9 => p_cc_pmt_fcst.Attribute9,
p_Attribute10 => p_cc_pmt_fcst.Attribute10,
p_Attribute11 => p_cc_pmt_fcst.Attribute11,
p_Attribute12 => p_cc_pmt_fcst.Attribute12,
p_Attribute13 => p_cc_pmt_fcst.Attribute13,
p_Attribute14 => p_cc_pmt_fcst.Attribute14,
p_Attribute15 => p_cc_pmt_fcst.Attribute15,
p_Context => p_cc_pmt_fcst.Context,
G_FLAG => l_flag
);
Put_Debug_Msg (l_full_path,' IGCCCPCB - Failure Inserting Det PF Line ID on Copy.......');
Put_Debug_Msg (l_full_path,' IGCCCPCB - Successfully inserted Det PF Line ID.' || l_cc_pmt_fcst_id);
IGC_CC_ACCESS_PKG.Insert_Row
(p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_row_id => l_rowid,
p_CC_HEADER_ID => g_new_cc_header_id,
p_USER_ID => p_access_lines.user_id,
p_CC_GROUP_ID => p_access_lines.cc_group_id,
p_CC_ACCESS_ID => l_cc_access_id,
p_CC_ACCESS_LEVEL => p_access_lines.cc_access_level,
p_CC_ACCESS_TYPE => p_access_lines.cc_access_type,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => g_update_by,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => g_update_by,
p_LAST_UPDATE_LOGIN => g_update_login
);
Put_Debug_Msg (l_full_path,' IGCCCPCB - EXC ERROR in inserting new Access ID........');
SELECT *
FROM igc_cc_acct_lines ccac
WHERE ccac.cc_header_id = t_cc_header_id;
SELECT *
FROM igc_cc_det_pf
WHERE cc_acct_line_id = t_cc_acct_line_id;
SELECT *
FROM igc_cc_access
WHERE cc_header_id = t_cc_header_id;
SELECT *
FROM igc_cc_headers
WHERE cc_header_id = t_cc_header_id;
g_update_login := FND_GLOBAL.LOGIN_ID;
g_update_by := FND_GLOBAL.USER_ID;
IGC_CC_HEADERS_PKG.Insert_Row
(p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
X_return_status => l_return_status,
X_msg_count => l_msg_count,
X_msg_data => l_msg_data,
p_Rowid => l_rowid,
p_CC_Header_Id => p_new_CC_Header_Id,
p_Org_id => l_cc_headers_rec.org_id,
p_CC_Type => l_cc_type_val,
p_CC_Num => l_CC_Num_val,
p_CC_Version_num => 0,
p_Parent_Header_Id => NULL,
p_CC_State => l_cc_state,
p_CC_ctrl_status => l_cc_ctrl_status,
p_CC_Encmbrnc_Status => l_cc_encmbrnc_status,
p_CC_Apprvl_Status => l_cc_apprvl_status,
p_Vendor_Id => l_cc_headers_rec.vendor_id,
p_Vendor_Site_Id => l_cc_headers_rec.vendor_site_id,
p_Vendor_Contact_Id => l_cc_headers_rec.vendor_contact_id,
p_Term_Id => l_cc_headers_rec.term_id,
p_Location_Id => l_cc_headers_rec.location_id,
p_Set_Of_Books_Id => l_cc_headers_rec.set_of_books_id,
p_CC_Acct_Date => NULL,
p_CC_Desc => l_cc_headers_rec.cc_desc,
p_CC_Start_Date => l_cc_headers_rec.cc_start_date, -- bug 12628254
p_CC_End_Date => NULL,
p_CC_Owner_User_Id => l_cc_headers_rec.cc_owner_user_id,
p_CC_Preparer_User_Id => l_cc_headers_rec.cc_preparer_user_id,
p_Currency_Code => l_cc_headers_rec.currency_code,
p_Conversion_Type => l_cc_headers_rec.conversion_type,
p_Conversion_Date => trunc(SYSDATE),
p_Conversion_Rate => l_cc_headers_rec.conversion_rate,
p_Last_Update_Date => SYSDATE,
p_Last_Updated_By => g_update_by,
p_Last_Update_Login => g_update_login,
p_Created_By => g_update_by,
p_Creation_Date => SYSDATE,
p_CC_Current_User_Id => l_cc_headers_rec.cc_current_user_id,
p_Wf_Item_Type => NULL,
p_Wf_Item_Key => NULL,
p_Attribute1 => l_cc_headers_rec.Attribute1,
p_Attribute2 => l_cc_headers_rec.Attribute2,
p_Attribute3 => l_cc_headers_rec.Attribute3,
p_Attribute4 => l_cc_headers_rec.Attribute4,
p_Attribute5 => l_cc_headers_rec.Attribute5,
p_Attribute6 => l_cc_headers_rec.Attribute6,
p_Attribute7 => l_cc_headers_rec.Attribute7,
p_Attribute8 => l_cc_headers_rec.Attribute8,
p_Attribute9 => l_cc_headers_rec.Attribute9,
p_Attribute10 => l_cc_headers_rec.Attribute10,
p_Attribute11 => l_cc_headers_rec.Attribute11,
p_Attribute12 => l_cc_headers_rec.Attribute12,
p_Attribute13 => l_cc_headers_rec.Attribute13,
p_Attribute14 => l_cc_headers_rec.Attribute14,
p_Attribute15 => l_cc_headers_rec.Attribute15,
p_Context => l_cc_headers_rec.Context,
p_CC_Guarantee_Flag => l_cc_headers_rec.CC_Guarantee_Flag,
G_FLAG => l_flag
);
Put_Debug_Msg (l_full_path,' IGCCCPCB - Failure inserting New CC Header id.........');
IGC_CC_ACTIONS_PKG.Insert_Row(
1.0,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
l_msg_count,
l_msg_data,
l_action_rowid,
p_new_CC_Header_Id,
0, -- Version number
'CP', -- Action Type "COPY"
l_CC_State,
l_cc_ctrl_status,
l_CC_Apprvl_Status,
'Copied From CC Number : ' || l_cc_headers_rec.cc_num, -- Note Field
Sysdate,
g_update_by,
g_update_login,
Sysdate,
g_update_by
);
Put_Debug_Msg (l_full_path,' IGCCCPCB - Failure inserting New CC Header id.........');