1 PACKAGE Pa_Plan_RL_Formats_Pub AUTHID CURRENT_USER as
2 /* $Header: PARRFTPS.pls 120.0 2005/05/29 15:00:37 appldev noship $ */
3
4 /*********************************************
5 * Record : Plan_RL_Format_In_Rec
6 ******************************************/
7 TYPE Plan_RL_Format_In_Rec IS RECORD(
8 P_Res_Format_Id NUMBER DEFAULT NULL,
9 P_Plan_RL_Format_Id NUMBER DEFAULT NULL);
10
11 /*********************************************
12 * Record : Plan_RL_Format_Out_Rec
13 ******************************************/
14 TYPE Plan_RL_Format_Out_Rec IS RECORD(
15 X_Plan_RL_Format_Id NUMBER,
16 X_Record_Version_Number NUMBER);
17
18 /*************************************************************
19 * Table of records
20 * Table : Plan_RL_Format_In_Tbl
21 *************************************************************/
22 TYPE Plan_RL_Format_In_Tbl IS TABLE OF Plan_RL_Format_In_Rec
23 INDEX BY BINARY_INTEGER;
24
25 /*************************************************************
26 * Table of records
27 * Table : Plan_RL_Format_Out_Tbl
28 *************************************************************/
29 TYPE Plan_RL_Format_Out_Tbl IS TABLE OF Plan_RL_Format_Out_Rec
30 INDEX BY BINARY_INTEGER;
31
32 /**********************************************************
33 * Procedure : Create_Plan_RL_Format
34 * Description : This is a public procedure which would be called
35 * from the AMG API. It takes in a Table of Record.
36 * Details in the Pkg Body.
37 *********************************************************/
38 Procedure Create_Plan_RL_Format(
39 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41 P_Res_List_id IN NUMBER,
42 P_Plan_RL_Format_Tbl IN Plan_RL_Format_In_Tbl,
43 X_Plan_RL_Format_Tbl OUT NOCOPY Plan_RL_Format_Out_Tbl,
44 X_Return_Status OUT NOCOPY VARCHAR2,
45 X_Msg_Count OUT NOCOPY NUMBER,
46 X_Msg_Data OUT NOCOPY VARCHAR2);
47 /**********************************************************
48 * Procedure : Create_Plan_RL_Format
49 * Description : This is a public procedure which would be called
50 * from the front end. It takes in a Table of elements.
51 * Details in the Pkg Body.
52 *********************************************************/
53 Procedure Create_Plan_RL_Format(
54 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 P_Res_List_id IN NUMBER,
57 P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE,
58 X_Plan_RL_Format_Id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
59 X_Record_Version_Number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE,
60 X_Return_Status OUT NOCOPY VARCHAR2,
61 X_Msg_Count OUT NOCOPY NUMBER,
62 X_Msg_Data OUT NOCOPY VARCHAR2);
63
64 /**********************************************************
65 * Procedure : Delete_Plan_RL_Format
66 * Description : This is a public procedure which would be called
67 * from the AMG API. It takes in a Table of Record.
68 * Details in the Pkg Body.
69 *********************************************************/
70 Procedure Delete_Plan_RL_Format (
71 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73 P_Res_List_Id IN NUMBER DEFAULT NULL,
74 P_Plan_RL_Format_Tbl IN Plan_RL_Format_In_Tbl,
75 X_Return_Status OUT NOCOPY VARCHAR2,
76 X_Msg_Count OUT NOCOPY NUMBER,
77 X_Msg_Data OUT NOCOPY VARCHAR2);
78 /**********************************************************
79 * Procedure : Delete_Plan_RL_Format
80 * Description : This is a public procedure which would be called
81 * from the front end. It takes in a Table of elements.
82 * Details in the Pkg Body.
83 *********************************************************/
84 Procedure Delete_Plan_RL_Format (
85 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87 P_Res_List_Id IN NUMBER DEFAULT NULL,
88 P_Res_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
89 P_Plan_RL_Format_Id IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL,
90 X_Return_Status OUT NOCOPY VARCHAR2,
91 X_Msg_Count OUT NOCOPY NUMBER,
92 X_Msg_Data OUT NOCOPY VARCHAR2);
93
94 END Pa_Plan_RL_Formats_Pub;