APPS.CSC_PROFILE_VARIABLE_PUB dependencies on CSC_PROFILE_VARIABLE_PVT

Line 14: x_pvt_Profile_Variables_rec OUT NOCOPY CSC_profile_variable_PVT.ProfVar_Rec_Type

10: ----------------------------------------------------------------------------
11:
12: PROCEDURE Convert_pub_to_pvt_Rec (
13: P_Profile_Variables_Rec IN CSC_profile_variable_PUB.ProfVar_Rec_Type,
14: x_pvt_Profile_Variables_rec OUT NOCOPY CSC_profile_variable_PVT.ProfVar_Rec_Type
15: )
16: IS
17: l_any_errors BOOLEAN := FALSE;
18: BEGIN

Line 211: l_pvt_prof_var_rec CSC_Profile_Variable_PVT.ProfVar_Rec_Type;

207: -- pass the parameter record type into a local
208: -- record type so that you can assign values
209:
210: l_prof_var_rec ProfVar_Rec_Type := p_prof_var_rec;
211: l_pvt_prof_var_rec CSC_Profile_Variable_PVT.ProfVar_Rec_Type;
212: BEGIN
213:
214: -- Standard Start of API Savepoint
215: SAVEPOINT Create_Profile_Variable_Pub ;

Line 241: CSC_Profile_Variable_PVT.Create_Profile_Variable(

237:
238: -- Initialize the API Return Success to True
239: x_return_status := FND_API.G_RET_STS_SUCCESS ;
240:
241: CSC_Profile_Variable_PVT.Create_Profile_Variable(
242: p_api_version_number => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_commit => FND_API.G_FALSE,
245: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 300: p_Table_Column_Tbl IN CSC_Profile_Variable_pvt.Table_Column_Tbl_Type,

296: P_Api_Version_Number IN NUMBER,
297: P_Init_Msg_List IN VARCHAR2,
298: P_Commit IN VARCHAR2,
299: P_Validation_level IN NUMBER,
300: p_Table_Column_Tbl IN CSC_Profile_Variable_pvt.Table_Column_Tbl_Type,
301: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: --p_BLOCK_ID IN NUMBER,
303: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
304: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,

Line 343: CSC_Profile_Variable_PVT.Create_table_column(

339:
340: -- Calling Private package: Create_Table_Column
341: -- Hint: Primary key needs to be returned
342:
343: CSC_Profile_Variable_PVT.Create_table_column(
344: P_Api_Version_Number => l_api_version_number,
345: P_Init_Msg_List => FND_API.G_FALSE,
346: P_Commit => FND_API.G_FALSE,
347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

Line 508: l_pvt_prof_var_rec CSC_Profile_Variable_PVT.ProfVar_Rec_Type;

504: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME || '.' || l_api_name ;
505: l_api_version CONSTANT NUMBER := 1.0 ;
506:
507: l_prof_var_rec ProfVar_Rec_Type := p_prof_var_rec;
508: l_pvt_prof_var_rec CSC_Profile_Variable_PVT.ProfVar_Rec_Type;
509: BEGIN
510:
511: -- Standard Start of API Savepoint
512: SAVEPOINT Update_Profile_Variable_Pub ;

Line 541: CSC_Profile_Variable_PVT.Update_Profile_Variable(

537:
538:
539: -- Call Private API to Update
540:
541: CSC_Profile_Variable_PVT.Update_Profile_Variable(
542: p_api_version_number => 1.0,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 601: p_Table_Column_Rec IN CSC_Profile_Variable_PVT.Table_Column_Rec_Type,

597: P_Api_Version_Number IN NUMBER,
598: P_Init_Msg_List IN VARCHAR2,
599: P_Commit IN VARCHAR2,
600: P_Validation_Level IN NUMBER,
601: p_Table_Column_Rec IN CSC_Profile_Variable_PVT.Table_Column_Rec_Type,
602: --p_Sql_Stmnt_For_Drilldown IN VARCHAR2 := FND_API.G_MISS_CHAR,
603: --p_BLOCK_ID IN NUMBER := FND_API.G_MISS_NUM,
604: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER ,
605: X_Return_Status OUT NOCOPY VARCHAR2,

Line 640: CSC_profile_variable_PVT.Update_table_column(

636: --
637: -- API body
638: --
639:
640: CSC_profile_variable_PVT.Update_table_column(
641: P_Api_Version_Number => l_api_version_number,
642: P_Init_Msg_List => FND_API.G_FALSE,
643: P_Commit => p_commit,
644: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,