APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_PROF_BLOCKS_VL

Line 1199: l_OLD_PROF_VAR_REC CSC_PROF_BLOCKS_VL%ROWTYPE ;

1195: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
1196: l_api_version CONSTANT NUMBER := 1.0 ;
1197:
1198: -- record to get the old records
1199: l_OLD_PROF_VAR_REC CSC_PROF_BLOCKS_VL%ROWTYPE ;
1200:
1201: l_prof_var_rec ProfVar_Rec_Type := P_prof_Var_Rec;
1202:
1203: BEGIN

Line 1765: from csc_prof_blocks_vl

1761: ) IS
1762:
1763: Cursor get_block_name is
1764: Select block_id
1765: from csc_prof_blocks_vl
1766: where block_name = p_block_name;
1767: l_dummy number;
1768: BEGIN
1769: -- initialize the return status

Line 2252: X_PROF_BLOCKS_REC OUT NOCOPY CSC_PROF_BLOCKS_VL%ROWTYPE,

2248: PROCEDURE GET_PROF_BLOCKS(
2249: p_Api_Name IN VARCHAR2,
2250: p_BLOCK_ID IN NUMBER,
2251: p_object_version_number NUMBER,
2252: X_PROF_BLOCKS_REC OUT NOCOPY CSC_PROF_BLOCKS_VL%ROWTYPE,
2253: X_return_status OUT NOCOPY VARCHAR2 )
2254: IS
2255: --
2256: Cursor c_Get_prof_rec is

Line 2258: From CSC_PROF_BLOCKS_VL

2254: IS
2255: --
2256: Cursor c_Get_prof_rec is
2257: Select *
2258: From CSC_PROF_BLOCKS_VL
2259: Where block_id = p_block_id
2260: and object_version_number = p_object_version_number
2261: For update nowait;
2262: