APPS.IGW_PROP_PROGRAM_ADDRESS_PKG dependencies on IGW_PROP_PROGRAM_ADDRESSES

Line 11: cursor C is select ROWID from IGW_PROP_PROGRAM_ADDRESSES

7: X_NUMBER_OF_COPIES in NUMBER,
8: X_MAIL_DESCRIPTION in VARCHAR2,
9: X_MODE in VARCHAR2 default 'R'
10: ) is
11: cursor C is select ROWID from IGW_PROP_PROGRAM_ADDRESSES
12: where PROPOSAL_ID = X_PROPOSAL_ID
13: and ADDRESS_ID = X_ADDRESS_ID;
14: X_LAST_UPDATE_DATE DATE;
15: X_LAST_UPDATED_BY NUMBER;

Line 35: insert into IGW_PROP_PROGRAM_ADDRESSES (

31: else
32: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
33: app_exception.raise_exception;
34: end if;
35: insert into IGW_PROP_PROGRAM_ADDRESSES (
36: PROPOSAL_ID,
37: ADDRESS_ID,
38: NUMBER_OF_COPIES,
39: MAIL_DESCRIPTION,

Line 78: from IGW_PROP_PROGRAM_ADDRESSES

74: cursor c1 is select
75: ADDRESS_ID,
76: NUMBER_OF_COPIES,
77: MAIL_DESCRIPTION
78: from IGW_PROP_PROGRAM_ADDRESSES
79: where ROWID = X_ROWID
80: for update of PROPOSAL_ID nowait;
81: tlinfo c1%rowtype;
82:

Line 139: update IGW_PROP_PROGRAM_ADDRESSES set

135: else
136: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
137: app_exception.raise_exception;
138: end if;
139: update IGW_PROP_PROGRAM_ADDRESSES set
140: ADDRESS_ID = X_ADDRESS_ID,
141: NUMBER_OF_COPIES = X_NUMBER_OF_COPIES,
142: MAIL_DESCRIPTION = X_MAIL_DESCRIPTION,
143: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 160: cursor c1 is select rowid from IGW_PROP_PROGRAM_ADDRESSES

156: X_NUMBER_OF_COPIES in NUMBER,
157: X_MAIL_DESCRIPTION in VARCHAR2,
158: X_MODE in VARCHAR2 default 'R'
159: ) is
160: cursor c1 is select rowid from IGW_PROP_PROGRAM_ADDRESSES
161: where PROPOSAL_ID = X_PROPOSAL_ID
162: and ADDRESS_ID = X_ADDRESS_ID
163: ;
164: dummy c1%rowtype;

Line 193: delete from IGW_PROP_PROGRAM_ADDRESSES

189: procedure DELETE_ROW (
190: X_ROWID in VARCHAR2
191: ) is
192: begin
193: delete from IGW_PROP_PROGRAM_ADDRESSES
194: where ROWID = X_ROWID;
195: if (sql%notfound) then
196: raise no_data_found;
197: end if;