APPS.CSC_PROFILE_VARIABLE_PVT dependencies on CSC_PROF_BLOCKS_VL

Line 1010: l_OLD_PROF_VAR_REC CSC_PROF_BLOCKS_VL%ROWTYPE ;

1006: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
1007: l_api_version CONSTANT NUMBER := 1.0 ;
1008:
1009: -- record to get the old records
1010: l_OLD_PROF_VAR_REC CSC_PROF_BLOCKS_VL%ROWTYPE ;
1011:
1012: l_prof_var_rec ProfVar_Rec_Type := P_prof_Var_Rec;
1013:
1014: BEGIN

Line 1572: from csc_prof_blocks_vl

1568: ) IS
1569:
1570: Cursor get_block_name is
1571: Select block_id
1572: from csc_prof_blocks_vl
1573: where block_name = p_block_name;
1574: l_dummy number;
1575: BEGIN
1576:

Line 2070: X_PROF_BLOCKS_REC OUT NOCOPY CSC_PROF_BLOCKS_VL%ROWTYPE,

2066: PROCEDURE GET_PROF_BLOCKS(
2067: p_Api_Name IN VARCHAR2,
2068: p_BLOCK_ID IN NUMBER,
2069: p_object_version_number NUMBER,
2070: X_PROF_BLOCKS_REC OUT NOCOPY CSC_PROF_BLOCKS_VL%ROWTYPE,
2071: X_return_status OUT NOCOPY VARCHAR2 )
2072: IS
2073: --
2074: Cursor c_Get_prof_rec is

Line 2076: From CSC_PROF_BLOCKS_VL

2072: IS
2073: --
2074: Cursor c_Get_prof_rec is
2075: Select *
2076: From CSC_PROF_BLOCKS_VL
2077: Where block_id = p_block_id
2078: and object_version_number = p_object_version_number
2079: For update nowait;
2080: