DBA Data[Home] [Help]

APPS.IGW_BUDGET_DETAILS_TBH dependencies on FND_API

Line 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
36: l_last_update_date DATE := SYSDATE;
37:
38: begin
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: insert into igw_budget_details(
42: proposal_id
43: ,version_id

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

100: exception
101: when others then
102: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
103: ,p_procedure_name => 'INSERT_ROW' );
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: RAISE;
106: end insert_row;
107:
108:

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144: and budget_period_id = p_budget_period_id
145: and line_item_id = p_line_item_id;
146:
147: begin
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: IF l_row_id IS NULL THEN
151: OPEN get_row_id;
152: FETCH get_row_id INTO l_row_id;

Line 168: , project_id = decode(p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)

164: , underrecovery_amount = p_underrecovery_amount
165: , apply_inflation_flag = p_apply_inflation_flag
166: , budget_justification = p_budget_justification
167: , location_code = p_location_code
168: , project_id = decode(p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
169: , task_id = decode(p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
170: , award_id = decode(p_award_id , FND_API.G_MISS_NUM, NULL, p_award_id)
171: , record_version_number = record_version_number + 1
172: where rowid = l_row_id

Line 169: , task_id = decode(p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)

165: , apply_inflation_flag = p_apply_inflation_flag
166: , budget_justification = p_budget_justification
167: , location_code = p_location_code
168: , project_id = decode(p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
169: , task_id = decode(p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
170: , award_id = decode(p_award_id , FND_API.G_MISS_NUM, NULL, p_award_id)
171: , record_version_number = record_version_number + 1
172: where rowid = l_row_id
173: and record_version_number = p_record_version_number;

Line 170: , award_id = decode(p_award_id , FND_API.G_MISS_NUM, NULL, p_award_id)

166: , budget_justification = p_budget_justification
167: , location_code = p_location_code
168: , project_id = decode(p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
169: , task_id = decode(p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
170: , award_id = decode(p_award_id , FND_API.G_MISS_NUM, NULL, p_award_id)
171: , record_version_number = record_version_number + 1
172: where rowid = l_row_id
173: and record_version_number = p_record_version_number;
174:

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

181: exception
182: when others then
183: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
184: ,p_procedure_name => 'UPDATE_ROW' );
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: RAISE;
187: end update_row;
188: --------------------------------------------------------------------------------------------------
189:

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: and line_item_id = p_line_item_id;
209:
210: begin
211:
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: IF l_row_id IS NULL THEN
215: OPEN get_row_id;
216: FETCH get_row_id INTO l_row_id;

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

230: EXCEPTION
231: WHEN OTHERS THEN
232: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_package_name
233: ,p_procedure_name => 'DELETE_ROW' );
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
235: RAISE;
236: end DELETE_ROW;
237:
238: