APPS.CZ_DEVELOPER_UTILS_PVT dependencies on DUAL

Line 73: SELECT CZ_PS_NODES_S.NEXTVAL INTO currentPSNode FROM dual;

69: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
70:
71: PROCEDURE Initialize IS
72: BEGIN
73: SELECT CZ_PS_NODES_S.NEXTVAL INTO currentPSNode FROM dual;
74: currPSSeqVal:=currentPSNode;
75:
76: SELECT TO_NUMBER(value) INTO mINCREMENT FROM cz_db_settings
77: WHERE UPPER(setting_id)=UPPER('OracleSequenceIncr') AND section_name='SCHEMA';

Line 94: SELECT CZ_PS_NODES_S.nextval INTO currPSSeqVal FROM dual;

90:
91: IF currentPSNode 92: currentPSNode:=currentPSNode+1;
93: ELSE
94: SELECT CZ_PS_NODES_S.nextval INTO currPSSeqVal FROM dual;
95: currentPSNode:=currPSSeqVal;
96: END IF;
97: RETURN currentPSNode;
98: END getPSSeqVal;

Line 126: select CZ_XFR_RUN_INFOS_S.NEXTVAL INTO RUN_ID FROM dual;

122:
123: FUNCTION GetRunID return INTEGER IS
124: RUN_ID NUMBER;
125: BEGIN
126: select CZ_XFR_RUN_INFOS_S.NEXTVAL INTO RUN_ID FROM dual;
127: return RUN_ID;
128: END GetRunID;
129:
130: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 153: -- SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO gRUN_ID FROM dual;

149: -- initialize global run_id ( <-> CZ_DB_LOGS.run_id )
150: --
151: --PROCEDURE Initialize IS
152: --BEGIN
153: -- SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO gRUN_ID FROM dual;
154: -- fnd_msg_pub.initialize;
155: --END Initialize;
156:
157: --

Line 579: 'SELECT '||p_sequence_name||'.NEXTVAL FROM dual' INTO l_id;

575: FUNCTION allocateId(p_sequence_name IN VARCHAR2) RETURN NUMBER IS
576: l_id NUMBER;
577: BEGIN
578: EXECUTE IMMEDIATE
579: 'SELECT '||p_sequence_name||'.NEXTVAL FROM dual' INTO l_id;
580: RETURN l_id;
581: END allocateId;
582:
583: --

Line 2514: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;

2510:
2511: END IF;
2512:
2513: BEGIN
2514: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO x_out_rule_folder_id FROM dual;
2515: INSERT INTO CZ_RULE_FOLDERS
2516: (RULE_FOLDER_ID,
2517: FOLDER_TYPE,
2518: NAME,

Line 5314: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;

5310: -- 5311: IF ( g_attribute_map.EXISTS(p_attrib_val) ) THEN
5312: l_attrib_val := g_attribute_map(p_attrib_val);
5313: ELSE
5314: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;
5315: l_attrib_val := '_czc'||l_new_seq;
5316: g_attribute_map(p_attrib_val) := l_attrib_val;
5317: END IF;
5318:

Line 5331: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;

5327: -- This case can happen when user:attribute3 is processed before the id attribute
5328: -- We have no control over the order in which these attributes are returned.
5329: -- So this case can occur. Since id is not yet processed we dont have the new id
5330: -- So let us just create a new id for the switcher right now and put it in the map
5331: SELECT cz_ui_page_elements_s.nextval INTO l_new_seq FROM dual;
5332: -- this is the new id attribute value for the switcher.
5333: -- We will put it in the map so that it gets used when processing the id attribute in the
5334: -- first If block in this function
5335: l_attrib_val := '_czc'||l_new_seq;

Line 5513: SELECT cz_ui_actions_s.nextval INTO l_new_element_id FROM dual;

5509: END IF;
5510:
5511: ELSE
5512:
5513: SELECT cz_ui_actions_s.nextval INTO l_new_element_id FROM dual;
5514:
5515: INSERT INTO CZ_UI_ACTIONS
5516: (UI_ACTION_ID,UI_DEF_ID,SOURCE_PAGE_ID,CONTEXT_COMPONENT_ID,ELEMENT_ID,RENDER_CONDITION_ID,
5517: UI_ACTION_TYPE,TARGET_UI_DEF_ID,TARGET_PERSISTENT_NODE_ID,TARGET_NODE_PATH,TARGET_PAGE_SET_ID,

Line 10618: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;

10614: ---------------------------------------------------------------------------------------
10615: BEGIN
10616:
10617: IF(x_run_id IS NULL OR x_run_id = 0)THEN
10618: SELECT cz_xfr_run_infos_s.NEXTVAL INTO x_run_id FROM DUAL;
10619: END IF;
10620:
10621: SELECT rule_type, component_id, model_ref_expl_id, devl_project_id, rule_folder_id, name,
10622: class_name, seeded_flag, invalid_flag, instantiation_scope

Line 11902: SELECT REVERSE(p_class_name) INTO l_reverse_string FROM dual;

11898: l_index NUMBER;
11899: l_next_index NUMBER;
11900: BEGIN
11901:
11902: SELECT REVERSE(p_class_name) INTO l_reverse_string FROM dual;
11903: SELECT REVERSE(p_pattern) INTO l_reverse_pattern FROM dual;
11904:
11905: l_index := INSTR(l_reverse_string,'.');
11906:

Line 11903: SELECT REVERSE(p_pattern) INTO l_reverse_pattern FROM dual;

11899: l_next_index NUMBER;
11900: BEGIN
11901:
11902: SELECT REVERSE(p_class_name) INTO l_reverse_string FROM dual;
11903: SELECT REVERSE(p_pattern) INTO l_reverse_pattern FROM dual;
11904:
11905: l_index := INSTR(l_reverse_string,'.');
11906:
11907: IF l_index=0 THEN