APPS.IGW_PROPOSALS_ALL_TBH dependencies on IGW_PROPOSALS_ALL

Line 1: package body IGW_PROPOSALS_ALL_TBH as

1: package body IGW_PROPOSALS_ALL_TBH as
2: /* $Header: igwtbasb.pls 115.9 2002/11/14 18:50:04 vmedikon ship $ */
3: procedure INSERT_ROW (
4: X_ROWID out NOCOPY rowid,
5: X_PROPOSAL_ID in NUMBER,

Line 55: cursor C is select ROWID from IGW_PROPOSALS_ALL

51: X_ATTRIBUTE15 in VARCHAR2,
52: X_MODE in VARCHAR2 default 'R',
53: X_RETURN_STATUS OUT NOCOPY VARCHAR2
54: ) is
55: cursor C is select ROWID from IGW_PROPOSALS_ALL
56: where PROPOSAL_ID = X_PROPOSAL_ID;
57: X_LAST_UPDATE_DATE DATE;
58: X_LAST_UPDATED_BY NUMBER;
59: X_LAST_UPDATE_LOGIN NUMBER;

Line 79: insert into IGW_PROPOSALS_ALL (

75: else
76: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
77: app_exception.raise_exception;
78: end if;
79: insert into IGW_PROPOSALS_ALL (
80: SPONSOR_ACTION_CODE,
81: SPONSOR_ACTION_DATE,
82: AWARD_AMOUNT,
83: PROPOSAL_ID,

Line 199: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'

195: close c;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
200: ,p_procedure_name => 'INSERT_ROW' );
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202: RAISE;
203:

Line 270: FROM igw_proposals_all

266: l_record_version_number NUMBER;
267:
268: CURSOR get_row_id IS
269: SELECT rowid
270: FROM igw_proposals_all
271: WHERE proposal_id = x_proposal_id;
272:
273: begin
274:

Line 300: update IGW_PROPOSALS_ALL set

296: else
297: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
298: app_exception.raise_exception;
299: end if;
300: update IGW_PROPOSALS_ALL set
301: SPONSOR_ACTION_CODE = X_SPONSOR_ACTION_CODE,
302: SPONSOR_ACTION_DATE = X_SPONSOR_ACTION_DATE,
303: AWARD_AMOUNT = X_AWARD_AMOUNT,
304: PROPOSAL_NUMBER = X_PROPOSAL_NUMBER,

Line 362: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'

358: end if;
359:
360: EXCEPTION
361: WHEN OTHERS THEN
362: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
363: ,p_procedure_name => 'UPDATE_ROW' );
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: RAISE;
366:

Line 383: FROM igw_proposals_all

379: l_record_version_number NUMBER;
380:
381: CURSOR get_row_id IS
382: SELECT rowid
383: FROM igw_proposals_all
384: WHERE proposal_id = p_proposal_id;
385:
386: begin
387:

Line 396: delete from IGW_PROPOSALS_ALL

392: FETCH get_row_id INTO l_row_id;
393: CLOSE get_row_id;
394: END IF;
395:
396: delete from IGW_PROPOSALS_ALL
397: where rowid = l_row_id
398: and record_version_number = p_record_version_number;
399:
400: if (sql%notfound) then

Line 406: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'

402: FND_MSG_PUB.Add;
403: end if;
404: EXCEPTION
405: WHEN OTHERS THEN
406: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
407: ,p_procedure_name => 'DELETE_ROW' );
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409: RAISE;
410: end DELETE_ROW;

Line 440: FROM igw_proposals_all

436: l_old_sponsor_action_comments varchar2(2000);
437:
438: CURSOR get_row_id IS
439: SELECT rowid
440: FROM igw_proposals_all
441: WHERE proposal_id = x_proposal_id;
442:
443: begin
444:

Line 477: from igw_proposals_all

473: sponsor_action_comments
474: into l_old_sponsor_action_date,
475: l_old_sponsor_action_code,
476: l_old_sponsor_action_comments
477: from igw_proposals_all
478: where proposal_id = x_proposal_id;
479:
480: update IGW_PROPOSALS_ALL set
481: SPONSOR_ACTION_DATE = X_SPONSOR_ACTION_DATE,

Line 480: update IGW_PROPOSALS_ALL set

476: l_old_sponsor_action_comments
477: from igw_proposals_all
478: where proposal_id = x_proposal_id;
479:
480: update IGW_PROPOSALS_ALL set
481: SPONSOR_ACTION_DATE = X_SPONSOR_ACTION_DATE,
482: SPONSOR_ACTION_CODE = X_SPONSOR_ACTION_CODE,
483: SPONSOR_ACTION_COMMENTS = X_SPONSOR_ACTION_COMMENTS,
484: SPONSOR_PROPOSAL_NUMBER = X_SPONSOR_PROPOSAL_NUMBER,

Line 537: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'

533: end if;
534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'IGW_PROPOSALS_ALL_TBH'
538: ,p_procedure_name => 'UPDATE_SPONSOR_ACTION' );
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
540: RAISE;
541:

Line 546: end IGW_PROPOSALS_ALL_TBH;

542: end UPDATE_SPONSOR_ACTION;
543:
544: ---------------------------------------------------------------------------------
545:
546: end IGW_PROPOSALS_ALL_TBH;