The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row => IGC_CC_MC_HEADERS
===============================================================================*/
PROCEDURE get_rsobs_Headers (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_CC_Header_Id IN NUMBER,
p_Set_Of_Books_Id IN NUMBER,
l_Application_Id IN NUMBER,
p_org_id IN NUMBER,
l_Conversion_Date IN DATE,
l_flag IN VARCHAR2
) IS
l_sob_list gl_mc_info.r_sob_list := gl_mc_info.r_sob_list();
SELECT conversion_type
FROM gl_mc_reporting_options
WHERE primary_set_of_books_id = p_Set_Of_Books_Id
AND reporting_set_of_books_id = l_rsob_id
AND ORG_ID = p_Org_Id
AND application_id = l_Application_Id; */
SELECT ALC_DEFAULT_CONV_RATE_TYPE
FROM GL_ALC_LEDGER_RSHIPS_V
WHERE primary_ledger_id = p_Set_Of_Books_Id
AND ledger_id = l_rsob_id
--AND ORG_ID = p_Org_Id
AND application_id = l_Application_Id;
IGC_CC_MC_HEADERS_PKG.Insert_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id,
p_CC_Header_Id,
l_sob_list(rec1).r_sob_id,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate
);
SELECT rowid
INTO l_row_id
FROM igc_cc_mc_headers
WHERE cc_header_id = p_CC_Header_Id
AND set_of_books_id = l_sob_list(rec1).r_sob_id;
IGC_CC_MC_HEADERS_PKG.Update_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id,
p_CC_Header_Id,
l_sob_list(rec1).r_sob_id,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate
);
END IF; -- Insert / Update Flag
PROCEDURE Insert_Row => IGC_CC_MC_ACCT_LINES
===============================================================================*/
PROCEDURE get_rsobs_Acct_Lines (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_CC_Acct_Line_Id IN NUMBER,
p_Set_Of_Books_Id IN NUMBER,
l_Application_Id IN NUMBER,
p_org_id IN NUMBER,
l_Conversion_Date IN DATE,
p_CC_Acct_Func_Amt IN NUMBER,
p_CC_Acct_Encmbrnc_Amt IN NUMBER,
p_CC_Func_Withheld_Amt IN NUMBER,
l_flag IN VARCHAR2
) IS
l_sob_list gl_mc_info.r_sob_list := gl_mc_info.r_sob_list();
SELECT conversion_type
FROM gl_mc_reporting_options
WHERE primary_set_of_books_id = p_Set_Of_Books_Id
AND reporting_set_of_books_id = l_rsob_id
AND ORG_ID = p_Org_Id
AND application_id = l_Application_Id;*/
SELECT ALC_DEFAULT_CONV_RATE_TYPE
FROM GL_ALC_LEDGER_RSHIPS_V
WHERE primary_ledger_id = p_Set_Of_Books_Id
AND ledger_id = l_rsob_id
-- AND ORG_ID = p_Org_Id
AND application_id = l_Application_Id;
IGC_CC_MC_ACCT_LINES_PKG.Insert_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id,
p_CC_Acct_Line_Id,
l_sob_list(rec1).r_sob_id,
l_CC_Acct_Func_Amt,
l_CC_Acct_Encmbrnc_Amt,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate,
l_cc_func_withheld_amt
);
SELECT rowid
INTO l_row_id
FROM igc_cc_mc_acct_lines
WHERE cc_acct_line_id = p_CC_Acct_Line_Id
AND set_of_books_id = l_sob_list(rec1).r_sob_id;
IGC_CC_MC_ACCT_LINES_PKG.Delete_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id
);
SELECT rowid
INTO l_row_id
FROM igc_cc_mc_acct_lines
WHERE cc_acct_line_id = p_CC_Acct_Line_Id
AND set_of_books_id = l_sob_list(rec1).r_sob_id;
IGC_CC_MC_ACCT_LINES_PKG.Update_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id,
p_CC_Acct_Line_Id,
l_sob_list(rec1).r_sob_id,
l_CC_Acct_Func_Amt,
l_CC_Acct_Encmbrnc_Amt,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate,
l_cc_func_withheld_amt
);
END IF; -- Insert / Update Flag
PROCEDURE Insert_Row => IGC_CC_MC_DET_PF
===============================================================================*/
PROCEDURE get_rsobs_DET_PF (
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
X_return_status OUT NOCOPY VARCHAR2,
X_msg_count OUT NOCOPY NUMBER,
X_msg_data OUT NOCOPY VARCHAR2,
p_CC_DET_PF_Line_Id IN NUMBER,
p_Set_Of_Books_Id IN NUMBER,
l_Application_Id IN NUMBER,
p_org_id IN NUMBER,
l_Conversion_Date IN DATE,
p_CC_Det_Pf_Func_Amt IN NUMBER,
p_CC_Det_Pf_ENCMBRNC_AMT IN NUMBER,
l_flag IN VARCHAR2
) IS
l_sob_list gl_mc_info.r_sob_list := gl_mc_info.r_sob_list();
SELECT conversion_type
FROM gl_mc_reporting_options
WHERE primary_set_of_books_id = p_Set_Of_Books_Id
AND reporting_set_of_books_id = l_rsob_id
AND ORG_ID = p_Org_Id
AND application_id = l_Application_Id; */
SELECT ALC_DEFAULT_CONV_RATE_TYPE
FROM GL_ALC_LEDGER_RSHIPS_V
WHERE primary_ledger_id = p_Set_Of_Books_Id
AND ledger_id = l_rsob_id
-- AND ORG_ID = p_Org_Id
AND application_id = l_Application_Id;
IGC_CC_MC_DET_PF_PKG.Insert_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id,
p_CC_Det_PF_Line_Id,
l_sob_list(rec1).r_sob_id,
l_CC_Det_PF_Func_Amt,
l_CC_Det_PF_Encmbrnc_Amt,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate
);
SELECT rowid
INTO l_row_id
FROM igc_cc_mc_det_pf
WHERE cc_det_pf_line_id = p_CC_Det_PF_Line_Id
AND set_of_books_id = l_sob_list(rec1).r_sob_id;
IGC_CC_MC_DET_PF_PKG.Delete_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id
);
SELECT rowid
INTO l_row_id
FROM igc_cc_mc_det_pf
WHERE cc_det_pf_line_id = p_CC_Det_PF_Line_Id
AND set_of_books_id = l_sob_list(rec1).r_sob_id;
IGC_CC_MC_DET_PF_PKG.Update_Row (
l_api_version,
FND_API.G_FALSE,
FND_API.G_FALSE,
FND_API.G_VALID_LEVEL_FULL,
l_return_status,
X_msg_count,
X_msg_data,
l_row_id,
p_CC_Det_PF_Line_Id,
l_sob_list(rec1).r_sob_id,
l_CC_Det_PF_Func_Amt,
l_CC_Det_PF_Encmbrnc_Amt,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate
);
END IF; -- Insert / Update Flag