APPS.IEU_NONMEDIA_ACTION_PVT dependencies on IEU_UWQ_NONMEDIA_ACTIONS

Line 32: l_nmedia_id IEU_UWQ_NONMEDIA_ACTIONS.NONMEDIA_ACTION_ID%type;

28: l_return_status VARCHAR2(4);
29:
30: l_msg_count NUMBER(2);
31:
32: l_nmedia_id IEU_UWQ_NONMEDIA_ACTIONS.NONMEDIA_ACTION_ID%type;
33: l_temp_str varchar2(80);
34:
35: BEGIN
36:

Line 48: select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;

44: x_msg_count := 0;
45: l_temp_str := null;
46:
47:
48: select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;
49:
50: EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||
51: '( NONMEDIA_ACTION_ID, ' ||
52: ' CREATED_BY, ' ||

Line 50: EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||

46:
47:
48: select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;
49:
50: EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||
51: '( NONMEDIA_ACTION_ID, ' ||
52: ' CREATED_BY, ' ||
53: ' CREATION_DATE, ' ||
54: ' LAST_UPDATED_BY,' ||

Line 132: l_nmedia_id IEU_UWQ_NONMEDIA_ACTIONS.NONMEDIA_ACTION_ID%type;

128: l_return_status VARCHAR2(4);
129:
130: l_msg_count NUMBER(2);
131:
132: l_nmedia_id IEU_UWQ_NONMEDIA_ACTIONS.NONMEDIA_ACTION_ID%type;
133: l_temp_str varchar2(80);
134:
135: BEGIN
136:

Line 148: update IEU_UWQ_NONMEDIA_ACTIONS set

144: x_msg_count := 0;
145: l_temp_str := null;
146:
147:
148: update IEU_UWQ_NONMEDIA_ACTIONS set
149: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
150: LAST_UPDATE_DATE = SYSDATE,
151: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
152: MACTION_DEF_ID = p_mdef_id,

Line 162: select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;

158:
159: if (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) then
160:
161:
162: select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;
163:
164: EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||
165: '( NONMEDIA_ACTION_ID, ' ||
166: ' CREATED_BY, ' ||

Line 164: EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||

160:
161:
162: select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;
163:
164: EXECUTE immediate 'INSERT INTO IEU_UWQ_NONMEDIA_ACTIONS '||
165: '( NONMEDIA_ACTION_ID, ' ||
166: ' CREATED_BY, ' ||
167: ' CREATION_DATE, ' ||
168: ' LAST_UPDATED_BY,' ||

Line 245: l_nmedia_id IEU_UWQ_NONMEDIA_ACTIONS.NONMEDIA_ACTION_ID%type;

241: l_return_status VARCHAR2(4);
242:
243: l_msg_count NUMBER(2);
244:
245: l_nmedia_id IEU_UWQ_NONMEDIA_ACTIONS.NONMEDIA_ACTION_ID%type;
246: l_temp_str varchar2(80);
247:
248: BEGIN
249:

Line 261: 'delete from IEU_UWQ_NONMEDIA_ACTIONS '||

257: x_msg_count := 0;
258: l_temp_str := null;
259:
260: EXECUTE immediate
261: 'delete from IEU_UWQ_NONMEDIA_ACTIONS '||
262: ' where NONMEDIA_ACTION_ID = :1'
263: USING x_nmedia_id;
264:
265: if (sql%notfound) then