eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_UPGRADE dependencies on DUAL

Line 49: FROM dual;

45: substr(c_devl.orig_sys_ref, 1, instr(c_devl.orig_sys_ref, ':', 1) - 1),
46: '0',
47: 0,
48: sysdate
49: FROM dual;
50:
51: END LOOP;
52:
53: END generate_xfr_reference_bills;

Line 250: v_product_key from dual;

246:
247:
248: BEGIN
249: select substr(v_orig_sys_ref(i), instr(v_orig_sys_ref(i), ':')+1) into
250: v_product_key from dual;
251: EXCEPTION
252: WHEN OTHERS THEN
253: v_product_key := NULL;
254: END;

Line 258: v_top_item_id from dual;

254: END;
255:
256: BEGIN
257: select substr(v_product_key, instr(v_product_key, ':')+1) into
258: v_top_item_id from dual;
259: EXCEPTION
260: WHEN OTHERS THEN
261: v_top_item_id := NULL;
262: END;

Line 266: v_org_id from dual;

262: END;
263:
264: BEGIN
265: select substr(v_product_key, 1, instr(v_product_key, ':')-1) into
266: v_org_id from dual;
267: EXCEPTION
268: WHEN OTHERS THEN
269: v_org_id := NULL;
270: END;

Line 418: SELECT LPAD(TO_CHAR(p_number),p_sort_width,'0') INTO ret FROM dual;

414:
415: FUNCTION getNum(p_number IN INTEGER) RETURN VARCHAR2 IS
416: ret VARCHAR2(100);
417: BEGIN
418: SELECT LPAD(TO_CHAR(p_number),p_sort_width,'0') INTO ret FROM dual;
419: RETURN ret;
420: END getNum;
421:
422: PROCEDURE populate(p_ps_node_id IN INTEGER,p_string1 IN VARCHAR2,p_string2 IN VARCHAR2) IS

Line 482: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;

478: BEGIN
479:
480: --Initialize id allocation for model explosions ids
481:
482: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;
483: next_expl_id := base_expl_id;
484:
485: --Initialize id allocation for ps_node ids
486:

Line 487: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;

483: next_expl_id := base_expl_id;
484:
485: --Initialize id allocation for ps_node ids
486:
487: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;
488: next_node_id := base_node_id;
489:
490: --Set the virtual_flag for all the nodes
491:

Line 600: FROM dual

596: substr(v_origsysref, 1, instr(v_origsysref, ':') - 1),
597: '0',
598: 0,
599: sysdate -- fix for bug # 2406244
600: FROM dual
601: WHERE NOT EXISTS (SELECT NULL FROM cz_xfr_project_bills
602: WHERE model_ps_node_id = c_devl.devl_project_id);
603:
604: END IF;

Line 705: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;

701: BEGIN
702:
703: current_expl_id := next_expl_id;
704: IF(next_expl_id = base_expl_id)THEN
705: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;
706: END IF;
707: next_expl_id := next_expl_id + 1;
708:
709: IF(inparentexplid IS NULL)THEN

Line 732: FROM dual WHERE NOT EXISTS

728: localmodelid,
729: decode(npsnodetype, ps_node_type_bom_model, 0, /*PS_NODE_TYPE_PRODUCT, 0,*/ inlogicnetlevel),
730: decode(inlogicnetlevel, 0, flag_virtual, svirtualflag),
731: flag_not_deleted, npsnodetype
732: FROM dual WHERE NOT EXISTS
733: (SELECT NULL FROM cz_model_ref_expls WHERE model_id = localmodelid AND component_id = incomponentid);
734:
735: correct_expl_id := current_expl_id;
736:

Line 746: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;

742: BEGIN
743:
744: local_expl_id := next_expl_id;
745: IF(next_expl_id = base_expl_id)THEN
746: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;
747: END IF;
748: next_expl_id := next_expl_id + 1;
749:
750: IF(expl.model_id = root_model_id)THEN correct_expl_id := local_expl_id; END IF;

Line 759: FROM dual WHERE NOT EXISTS

755: SELECT
756: local_expl_id, expl.model_ref_expl_id, expl.node_depth + 1, ps_node_type_reference,
757: flag_virtual, incomponentid, expl.model_id, inreferringnodeid, current_expl_id,
758: flag_not_deleted
759: FROM dual WHERE NOT EXISTS
760: (SELECT NULL FROM cz_model_ref_expls
761: WHERE component_id = incomponentid
762: AND model_id = expl.model_id
763: AND referring_node_id = inreferringnodeid

Line 882: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;

878: END;
879:
880: current_node_id := next_node_id;
881: IF(next_node_id = base_node_id)THEN
882: SELECT cz_ps_nodes_s.NEXTVAL INTO base_node_id FROM dual;
883: END IF;
884: next_node_id := next_node_id + 1;
885:
886: BEGIN

Line 900: FROM dual;

896: current_node_id, ntparentid(i), ps_node_type_reference, 1, 1, ntminimumsel(i), ntmaximumsel(i),
897: genname, nttreeseq(i), flag_not_deleted, localmodelid, flag_virtual, modelpsnodeid,
898: '0', '0', nteffectivefrom(i), nteffectiveuntil(i), ntorigsysref(i),
899: ntcomponentsequenceid(i)
900: FROM dual;
901:
902: ncutstart := instr(ntorigsysref(i), '-', -1, 1) + 1;
903: stopitemid := substr(ntorigsysref(i),ncutstart,instr(ntorigsysref(i),':')-ncutstart);
904:

Line 931: FROM dual WHERE NOT EXISTS

927: (rule_folder_id,name,tree_seq,devl_project_id,created_by,last_updated_by,
928: creation_date,last_update_date,deleted_flag)
929: SELECT cz_rule_folders_s.NEXTVAL,ntname(i)||' Rules',0,
930: ntpsnodeid(i),UID,UID,SYSDATE,SYSDATE,'0'
931: FROM dual WHERE NOT EXISTS
932: (SELECT 1 FROM cz_rule_folders WHERE
933: devl_project_id=ntpsnodeid(i) AND
934: parent_rule_folder_id IS NULL AND name=ntname(i)||' Rules');
935:

Line 945: FROM dual WHERE NOT EXISTS

941: ntpsnodeid(i), genname, ntpsnodeid(i), flag_not_deleted,
942: substr(ntorigsysref(i),instr(ntorigsysref(i),':',-1,3)+1,instr(ntorigsysref(i),':',-1,2)-instr(ntorigsysref(i),':',-1,3)-1) || ':' ||
943: substr(ntorigsysref(i),instr(ntorigsysref(i),':',-1,2)+1,instr(ntorigsysref(i),':',-1,1)-instr(ntorigsysref(i),':',-1,2)-1) || ':' ||
944: stopitemid /*substr(ntOrigSysRef(i),instr(ntOrigSysRef(i),':',-1,1)+1)*/
945: FROM dual WHERE NOT EXISTS
946: (SELECT NULL FROM cz_devl_projects WHERE devl_project_id = ntpsnodeid(i));
947:
948: --Insert into cz_rp_entries
949:

Line 954: FROM dual WHERE NOT EXISTS

950: INSERT INTO cz_rp_entries
951: (object_type,object_id,enclosing_folder,name,description,deleted_flag)
952: SELECT 'PRJ',ntpsnodeid(i),0,
953: genname,genname,'0'
954: FROM dual WHERE NOT EXISTS
955: (SELECT 1 FROM cz_rp_entries WHERE
956: (object_type='PRJ' AND object_id=ntpsnodeid(i)) OR
957: (enclosing_folder=0 AND name=genname));
958:

Line 1012: SELECT cz_xfr_run_infos_s.nextval into v_run_id FROM dual;

1008: v_run_id cz_db_logs.run_id%TYPE;
1009: v_caller cz_db_logs.caller%TYPE;
1010:
1011: BEGIN
1012: SELECT cz_xfr_run_infos_s.nextval into v_run_id FROM dual;
1013:
1014: v_message := 'Logic upgrade from schema '||p_from_schema||' for lce_header_id '||p_lce_header_id||' : '||p_err_message ;
1015: v_message := SUBSTR(v_message,1,2000);
1016:

Line 2998: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;

2994: --Get the logic generation run id. If a valid value has been passed as a parameter, use it,
2995: --else generate a new value.
2996:
2997: IF(thisRunId IS NULL OR thisRunId = 0)THEN
2998: SELECT cz_xfr_run_infos_s.NEXTVAL INTO thisRunId FROM DUAL;
2999: END IF;
3000:
3001: globalLevel := globalLevel + 1;
3002: globalStack(globalLevel) := inDevlProjectId;

Line 3040: SELECT LPAD(TO_CHAR(p_number),p_sort_width,'0') INTO ret FROM dual;

3036:
3037: FUNCTION getNum(p_number IN INTEGER) RETURN VARCHAR2 IS
3038: ret VARCHAR2(100);
3039: BEGIN
3040: SELECT LPAD(TO_CHAR(p_number),p_sort_width,'0') INTO ret FROM dual;
3041: RETURN ret;
3042: END getNum;
3043:
3044: PROCEDURE populate(p_config_item_id IN INTEGER,