eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLAN_RL_FORMATS_PUB dependencies on FND_API

Line 12: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

8: * Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format
9: * procedure, which would create the res formats.
10: *************************************************************/
11: Procedure Create_Plan_RL_Format(
12: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: P_Res_List_Id IN Number,
15: P_Plan_RL_Format_Tbl IN Plan_RL_Format_In_Tbl,
16: X_Plan_RL_Format_Tbl OUT NOCOPY Plan_RL_Format_Out_Tbl,

Line 13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

9: * procedure, which would create the res formats.
10: *************************************************************/
11: Procedure Create_Plan_RL_Format(
12: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: P_Res_List_Id IN Number,
15: P_Plan_RL_Format_Tbl IN Plan_RL_Format_In_Tbl,
16: X_Plan_RL_Format_Tbl OUT NOCOPY Plan_RL_Format_Out_Tbl,
17: X_Return_Status OUT NOCOPY Varchar2,

Line 23: IF FND_API.to_boolean( p_init_msg_list )

19: X_Msg_Data OUT NOCOPY Varchar2)
20: IS
21: BEGIN
22: -- First clear the message stack.
23: IF FND_API.to_boolean( p_init_msg_list )
24: THEN
25: FND_MSG_PUB.initialize;
26: END IF;
27:

Line 29: x_return_status := FND_API.G_RET_STS_SUCCESS;

25: FND_MSG_PUB.initialize;
26: END IF;
27:
28: x_msg_count := 0;
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: /***************************************************************
32: * For Loop. To loop through the table of records and
33: * Validate each one of them and insert accordingly.

Line 50: IF FND_API.to_boolean( p_commit )

46: END LOOP;
47: /************************************************
48: * Check the Commit flag. if it is true then Commit.
49: ***********************************************/
50: IF FND_API.to_boolean( p_commit )
51: THEN
52: COMMIT;
53: END IF;
54:

Line 65: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

61: * Pa_Plan_RL_Formats_Pvt.Create_Plan_RL_Format
62: * procedure, which would create the res formats.
63: *************************************************************/
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,

Line 66: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

62: * procedure, which would create the res formats.
63: *************************************************************/
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,

Line 78: IF FND_API.to_boolean( p_init_msg_list )

74:
75: Is
76: BEGIN
77: -- First clear the message stack.
78: IF FND_API.to_boolean( p_init_msg_list )
79: THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82:

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: /***************************************************************
91: * For Loop. To loop through the table of records and
92: * Validate each one of them and insert accordingly.
93: ***************************************************************/

Line 109: IF FND_API.to_boolean( p_commit )

105: END LOOP;
106: /************************************************
107: * Check the Commit flag. if it is true then Commit.
108: ***********************************************/
109: IF FND_API.to_boolean( p_commit )
110: THEN
111: COMMIT;
112: END IF;
113:

Line 125: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

121: * Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format
122: * procedure, which would Delete the res formats.
123: *************************************************************/
124: Procedure Delete_Plan_RL_Format (
125: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: P_Res_List_Id IN NUMBER DEFAULT Null,
128: P_Plan_RL_Format_Tbl IN Plan_RL_Format_In_Tbl ,
129: X_Return_Status OUT NOCOPY VARCHAR2,

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

122: * procedure, which would Delete the res formats.
123: *************************************************************/
124: Procedure Delete_Plan_RL_Format (
125: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: P_Res_List_Id IN NUMBER DEFAULT Null,
128: P_Plan_RL_Format_Tbl IN Plan_RL_Format_In_Tbl ,
129: X_Return_Status OUT NOCOPY VARCHAR2,
130: X_Msg_Count OUT NOCOPY NUMBER,

Line 135: IF FND_API.to_boolean( p_init_msg_list )

131: X_Msg_Data OUT NOCOPY VARCHAR2)
132: IS
133: BEGIN
134: -- First clear the message stack.
135: IF FND_API.to_boolean( p_init_msg_list )
136: THEN
137: FND_MSG_PUB.initialize;
138: END IF;
139: /***************************************************************

Line 157: IF FND_API.to_boolean( p_commit )

153:
154: /************************************************
155: * Check the Commit flag. if it is true then Commit.
156: ***********************************************/
157: IF FND_API.to_boolean( p_commit )
158: THEN
159: COMMIT;
160: END IF;
161: END Delete_Plan_RL_Format;

Line 170: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

166: * Pa_Plan_RL_Formats_Pvt.Delete_Plan_RL_Format
167: * procedure, which would Delete the res formats.
168: *************************************************************/
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,

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

167: * procedure, which would Delete the res formats.
168: *************************************************************/
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,

Line 182: IF FND_API.to_boolean( p_init_msg_list )

178:
179: Is
180: Begin
181: -- First clear the message stack.
182: IF FND_API.to_boolean( p_init_msg_list )
183: THEN
184: FND_MSG_PUB.initialize;
185: END IF;
186: /***************************************************************

Line 203: IF FND_API.to_boolean( p_commit )

199: END LOOP;
200: /************************************************
201: * Check the Commit flag. if it is true then Commit.
202: ***********************************************/
203: IF FND_API.to_boolean( p_commit )
204: THEN
205: COMMIT;
206: END IF;
207: