APPS.PA_RBS_ASGMT_PUB dependencies on FND_API

Line 22: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

18: * associations.
19: * This Procedure would Call the PA_RBS_ASGMT_Pvt pkg.
20: ****************************************************************/
21: PROCEDURE Create_RBS_Assignment
22: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: p_rbs_header_id IN NUMBER,
25: p_rbs_version_id IN NUMBER DEFAULT NULL,
26: p_project_id IN NUMBER,

Line 23: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

19: * This Procedure would Call the PA_RBS_ASGMT_Pvt pkg.
20: ****************************************************************/
21: PROCEDURE Create_RBS_Assignment
22: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24: p_rbs_header_id IN NUMBER,
25: p_rbs_version_id IN NUMBER DEFAULT NULL,
26: p_project_id IN NUMBER,
27: p_wp_usage_flag IN VARCHAR2 DEFAULT NULL,

Line 39: IF FND_API.to_boolean( p_init_msg_list )

35: BEGIN
36: /****************************************
37: * First Initialize the message list.
38: ****************************************/
39: IF FND_API.to_boolean( p_init_msg_list )
40: THEN
41: FND_MSG_PUB.initialize;
42: END IF;
43:

Line 62: IF FND_API.to_boolean( p_commit )

58:
59: /************************************************
60: * Check the Commit flag. if it is true then Commit.
61: ***********************************************/
62: IF FND_API.to_boolean( p_commit )
63: THEN
64: COMMIT;
65: END IF;
66:

Line 71: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

67: END Create_RBS_Assignment;
68: /***************************/
69:
70: PROCEDURE Update_RBS_Assignment(
71: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: p_rbs_prj_assignment_id IN NUMBER,
74: p_wp_usage_flag IN VARCHAR2 DEFAULT 'N',
75: p_fp_usage_flag IN VARCHAR2 DEFAULT 'N',

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

68: /***************************/
69:
70: PROCEDURE Update_RBS_Assignment(
71: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: p_rbs_prj_assignment_id IN NUMBER,
74: p_wp_usage_flag IN VARCHAR2 DEFAULT 'N',
75: p_fp_usage_flag IN VARCHAR2 DEFAULT 'N',
76: p_prog_rep_usage_flag IN VARCHAR2 DEFAULT 'N',

Line 89: IF FND_API.to_boolean( p_init_msg_list )

85: BEGIN
86: /****************************************
87: * First Initialize the message list.
88: ****************************************/
89: IF FND_API.to_boolean( p_init_msg_list )
90: THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93:

Line 111: IF FND_API.to_boolean( p_commit )

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

Line 121: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

117: END Update_RBS_Assignment;
118:
119:
120: PROCEDURE Delete_RBS_Assignment(
121: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_rbs_prj_assignment_id IN NUMBER,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

118:
119:
120: PROCEDURE Delete_RBS_Assignment(
121: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
122: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
123: p_rbs_prj_assignment_id IN NUMBER,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_error_msg_data OUT NOCOPY VARCHAR2 )

Line 134: IF FND_API.to_boolean( p_init_msg_list )

130:
131: /****************************************
132: * First Initialize the message list.
133: ****************************************/
134: IF FND_API.to_boolean( p_init_msg_list )
135: THEN
136: FND_MSG_PUB.initialize;
137: END IF;
138:

Line 150: IF FND_API.to_boolean( p_commit )

146:
147: /************************************************
148: * Check the Commit flag. if it is true then Commit.
149: ***********************************************/
150: IF FND_API.to_boolean( p_commit )
151: THEN
152: COMMIT;
153: END IF;
154:

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: x_return_status OUT NOCOPY Varchar2)
161: IS
162:
163: BEGIN
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: INSERT INTO pa_rbs_prj_assignments
167: (RBS_PRJ_ASSIGNMENT_ID,
168: PROJECT_ID,

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: and a.rbs_version_id = b.rbs_version_id
208: and b.project_id = p_destination_project_id);
209: EXCEPTION
210: WHEN OTHERS THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: RETURN;
213: END Copy_rbs_assignments;
214:
215: