[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row => IGC_CC_MC_HEADER_HISTORY
===============================================================================*/
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,
p_CC_Version_num IN NUMBER,
p_CC_Version_Action 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_HEADER_HST_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,
p_CC_Version_num,
p_CC_Version_Action,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate
);
PROCEDURE Insert_Row => IGC_CC_MC_ACCT_LINE_HISTORY
===============================================================================*/
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_Acct_Version_Num IN NUMBER,
p_CC_Acct_Version_Action IN VARCHAR2,
p_cc_func_withheld_amt IN NUMBER
) 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_LINE_HST_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,
p_CC_Acct_Version_Num,
p_CC_Acct_Version_Action,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate,
l_cc_func_withheld_amt
);
PROCEDURE Insert_Row => IGC_CC_MC_DET_PF_HISTORY
===============================================================================*/
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,
p_Det_PF_Version_Num IN NUMBER,
p_Det_PF_Version_Action 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_HST_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,
p_Det_PF_Version_Num,
p_Det_PF_Version_Action,
l_Conversion_Type,
l_Conversion_Date,
l_conversion_Rate
);