APPS.IGW_PROPOSALS_ALL_PKG dependencies on IGW_PROPOSALS_ALL

Line 1: package body IGW_PROPOSALS_ALL_PKG as

1: package body IGW_PROPOSALS_ALL_PKG as
2: /* $Header: igwpr10b.pls 115.19 2002/03/28 19:13:23 pkm ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out VARCHAR2,
5: X_PROPOSAL_ID in NUMBER,

Line 55: cursor C is select ROWID from IGW_PROPOSALS_ALL

51: X_ATTRIBUTE14 in VARCHAR2,
52: X_ATTRIBUTE15 in VARCHAR2,
53: X_MODE in VARCHAR2 default 'R'
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 78: insert into IGW_PROPOSALS_ALL (

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

Line 297: from IGW_PROPOSALS_ALL

293: ATTRIBUTE12,
294: ATTRIBUTE13,
295: ATTRIBUTE14,
296: ATTRIBUTE15
297: from IGW_PROPOSALS_ALL
298: where ROWID = X_ROWID
299: for update of PROPOSAL_ID nowait;
300: tlinfo c1%rowtype;
301:

Line 537: from igw_proposals_all

533: sponsor_action_comments
534: into l_old_sponsor_action_date,
535: l_old_sponsor_action_code,
536: l_old_sponsor_action_comments
537: from igw_proposals_all
538: where proposal_id = x_proposal_id;
539:
540: update IGW_PROPOSALS_ALL set
541: SPONSOR_ACTION_CODE = X_SPONSOR_ACTION_CODE,

Line 540: update IGW_PROPOSALS_ALL set

536: l_old_sponsor_action_comments
537: from igw_proposals_all
538: where proposal_id = x_proposal_id;
539:
540: update IGW_PROPOSALS_ALL set
541: SPONSOR_ACTION_CODE = X_SPONSOR_ACTION_CODE,
542: SPONSOR_ACTION_DATE = X_SPONSOR_ACTION_DATE,
543: SPONSOR_ACTION_COMMENTS = X_SPONSOR_ACTION_COMMENTS,
544: AWARD_AMOUNT = X_AWARD_AMOUNT,

Line 691: cursor c1 is select rowid from IGW_PROPOSALS_ALL

687: X_ATTRIBUTE14 in VARCHAR2,
688: X_ATTRIBUTE15 in VARCHAR2,
689: X_MODE in VARCHAR2 default 'R'
690: ) is
691: cursor c1 is select rowid from IGW_PROPOSALS_ALL
692: where PROPOSAL_ID = X_PROPOSAL_ID
693: ;
694: dummy c1%rowtype;
695: begin

Line 811: delete from IGW_PROPOSALS_ALL

807: procedure DELETE_ROW (
808: X_ROWID in VARCHAR2
809: ) is
810: begin
811: delete from IGW_PROPOSALS_ALL
812: where ROWID = X_ROWID;
813: if (sql%notfound) then
814: raise no_data_found;
815: end if;

Line 818: end IGW_PROPOSALS_ALL_PKG;

814: raise no_data_found;
815: end if;
816: end DELETE_ROW;
817:
818: end IGW_PROPOSALS_ALL_PKG;