APPS.CN_SF_PARAMS_PKG dependencies on DUAL

Line 114: FROM dual;

110: fnd_global.login_id,
111: sysdate,
112: fnd_global.user_id,
113: 1
114: FROM dual;
115:
116: --DBMS_OUTPUT.PUT_LINE('End : I have just ran the insert_row.');
117: END insert_row;
118:

Line 183: FROM dual;

179:
180: SELECT decode(p_object_version_number, mn,
181: l_old_rec.object_version_number, p_object_version_number)
182: INTO l_object_version_number
183: FROM dual;
184: l_num := l_old_rec.repository_id ;
185:
186: --DBMS_OUTPUT.PUT_LINE('I have just ran the update_row.');
187:

Line 199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;

195: --DBMS_OUTPUT.PUT_LINE(' Table Handlers update : Started. ID : ');
196: --DBMS_OUTPUT.PUT_LINE('Old Num : ' || l_num || ' ID in procedure : ' || p_repository_id);
197: --DBMS_OUTPUT.PUT_LINE('Parameter version ' || p_object_version_number) ;
198: --DBMS_OUTPUT.PUT_LINE('version Number :' || l_object_version_number || ': OVN :' || l_old_rec.object_version_number) ;
199: --update cn_sf_repositories set contract_title = ( select 'wormsss4' from dual ) where repository_id = 10061 ;
200:
201: UPDATE cn_sf_repositories SET (
202: CONTRACT_TITLE,
203: TERMS_AND_CONDITIONS,

Line 263: FROM dual)

259: decode(p_object_version_number, mn,l_old_rec.object_version_number, p_object_version_number+1),
260: sysdate,
261: fnd_global.user_id,
262: fnd_global.login_id
263: FROM dual)
264: WHERE repository_id = p_repository_id;
265:
266: --DBMS_OUTPUT.PUT_LINE(' Table Handlers update : Completed. 1');
267: END update_row;