APPS.IGW_CREATE_PROPOSAL_TBH dependencies on IGW_PROPOSALS_ALL

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 220: FROM igw_proposals_all

216: l_record_version_number NUMBER;
217:
218: CURSOR get_row_id IS
219: SELECT rowid
220: FROM igw_proposals_all
221: WHERE proposal_id = p_proposal_id;
222:
223: begin
224:

Line 233: delete from IGW_PROPOSALS_ALL

229: FETCH get_row_id INTO l_row_id;
230: CLOSE get_row_id;
231: END IF;
232:
233: delete from IGW_PROPOSALS_ALL
234: where rowid = l_row_id
235: and record_version_number = p_record_version_number;
236:
237: if (sql%notfound) then

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 301: update IGW_PROPOSALS_ALL set

297: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
298: app_exception.raise_exception;
299: end if;
300:
301: update IGW_PROPOSALS_ALL set
302: SPONSOR_PROPOSAL_NUMBER = X_SPONSOR_PROPOSAL_NUMBER,
303: FUNDED_DIRECT_COST = X_FUNDED_DIRECT_COST,
304: FUNDED_INDIRECT_COST = X_FUNDED_INDIRECT_COST,
305: RECORD_VERSION_NUMBER = X_RECORD_VERSION_NUMBER +1,