64: Procedure Create_Plan_RL_Format(
65: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67: P_Res_List_Id IN Number,
68: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE,
69: X_Plan_RL_Format_Id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
70: X_Record_Version_Number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
71: X_Return_Status OUT NOCOPY Varchar2,
72: X_Msg_Count OUT NOCOPY Number,
65: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67: P_Res_List_Id IN Number,
68: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE,
69: X_Plan_RL_Format_Id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
70: X_Record_Version_Number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
71: X_Return_Status OUT NOCOPY Varchar2,
72: X_Msg_Count OUT NOCOPY Number,
73: X_Msg_Data OUT NOCOPY Varchar2)
66: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67: P_Res_List_Id IN Number,
68: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE,
69: X_Plan_RL_Format_Id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
70: X_Record_Version_Number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
71: X_Return_Status OUT NOCOPY Varchar2,
72: X_Msg_Count OUT NOCOPY Number,
73: X_Msg_Data OUT NOCOPY Varchar2)
74:
79: THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: X_Plan_RL_Format_Id := SYSTEM.PA_NUM_TBL_TYPE();
84: X_Record_Version_Number := SYSTEM.PA_NUM_TBL_TYPE();
85: X_Plan_RL_Format_Id.extend(P_Res_Format_Id.count) ;
86: X_Record_Version_Number.extend(P_Res_Format_Id.count) ;
87:
80: FND_MSG_PUB.initialize;
81: END IF;
82:
83: X_Plan_RL_Format_Id := SYSTEM.PA_NUM_TBL_TYPE();
84: X_Record_Version_Number := SYSTEM.PA_NUM_TBL_TYPE();
85: X_Plan_RL_Format_Id.extend(P_Res_Format_Id.count) ;
86: X_Record_Version_Number.extend(P_Res_Format_Id.count) ;
87:
88: x_msg_count := 0;
169: Procedure Delete_Plan_RL_Format (
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
172: P_Res_List_Id IN Number Default Null,
173: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE Default Null,
174: P_Plan_RL_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE Default Null,
175: X_Return_Status OUT NOCOPY Varchar2,
176: X_Msg_Count OUT NOCOPY Number,
177: X_Msg_Data OUT NOCOPY Varchar2)
170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
171: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
172: P_Res_List_Id IN Number Default Null,
173: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE Default Null,
174: P_Plan_RL_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE Default Null,
175: X_Return_Status OUT NOCOPY Varchar2,
176: X_Msg_Count OUT NOCOPY Number,
177: X_Msg_Data OUT NOCOPY Varchar2)
178: