DBA Data[Home] [Help]

APPS.PA_PLAN_RL_FORMATS_PUB dependencies on PA_NUM_TBL_TYPE

Line 68: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE,

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,

Line 69: X_Plan_RL_Format_Id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

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)

Line 70: X_Record_Version_Number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,

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:

Line 83: X_Plan_RL_Format_Id := SYSTEM.PA_NUM_TBL_TYPE();

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:

Line 84: X_Record_Version_Number := SYSTEM.PA_NUM_TBL_TYPE();

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;

Line 173: P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE Default Null,

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)

Line 174: P_Plan_RL_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE Default Null,

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: