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_CF_API dependencies on DUAL

Line 109: FROM dual;

105: BEGIN
106: SELECT DECODE(ui_type, 'APPLET', UI_STYLE_APPLET, 'DHTML', UI_STYLE_DHTML,
107: 'JRAD', UI_STYLE_JRAD, 'WEGA', UI_STYLE_WEGA, NULL)
108: INTO v_ui_style
109: FROM dual;
110: RETURN v_ui_style;
111: END;
112:
113: ------------------------------------------------------------------------------------------

Line 122: FROM dual;

118: BEGIN
119: SELECT DECODE(ui_style, UI_STYLE_APPLET, 'APPLET', UI_STYLE_DHTML, 'DHTML',
120: UI_STYLE_JRAD, 'JRAD', UI_STYLE_WEGA, 'WEGA', NULL)
121: INTO v_ui_type
122: FROM dual;
123: RETURN v_ui_type;
124: END;
125:
126: ------------------------------------------------------------------------------------------

Line 135: FROM dual;

131: OR
132: (next_hdr_to_use = (NVL(last_hdr_allocated, 0) + id_increment)) ) THEN
133: SELECT cz_config_hdrs_s.NEXTVAL
134: INTO last_hdr_allocated
135: FROM dual;
136: next_hdr_to_use := last_hdr_allocated;
137: END IF;
138: id_to_return := next_hdr_to_use;
139: next_hdr_to_use := next_hdr_to_use + 1;

Line 151: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;

147:
148: BEGIN
149: IF ((last_msg_seq_allocated IS NULL) OR
150: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
151: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
152: next_msg_seq_to_use := last_msg_seq_allocated;
153: END IF;
154:
155: l_msg_seq := next_msg_seq_to_use;

Line 696: SELECT decode(l_instance_nbr, -1,1,0,1,l_instance_nbr) into l_instance_nbr from dual;

692: OPEN ecc_cur(p_config_item_id);
693: LOOP
694: FETCH ecc_cur INTO l_inventory_item_id,l_instance_nbr;
695: EXIT WHEN ecc_cur%NOTFOUND;
696: SELECT decode(l_instance_nbr, -1,1,0,1,l_instance_nbr) into l_instance_nbr from dual;
697: l_ecc := l_ecc||l_inventory_item_id||'|'||nvl(l_instance_nbr,1)||'-';
698: l_depth := l_depth + 1;
699: END LOOP;
700: CLOSE ecc_cur;

Line 2826: SELECT userenv('LANG') INTO v_language FROM dual;

2822: v_config_lookup_date := SYSDATE;
2823: END IF;
2824:
2825: IF v_language IS NULL THEN
2826: SELECT userenv('LANG') INTO v_language FROM dual;
2827: END IF;
2828:
2829: -- check usage_name: if null, get the profile option value from db
2830: IF v_usage_name IS NULL THEN

Line 3107: SELECT userenv('LANG') INTO v_language FROM dual;

3103: v_config_lookup_date := SYSDATE;
3104: END IF;
3105:
3106: IF v_language IS NULL THEN
3107: SELECT userenv('LANG') INTO v_language FROM dual;
3108: END IF;
3109:
3110: -- check usage_name: if null, get the profile option value from db
3111: IF v_usage_name IS NULL THEN

Line 3193: ----SELECT NVL(p_creation_date, SYSDATE) INTO p_creation_date FROM dual;

3189: PROCEDURE DEFAULT_NEW_CFG_DATES(p_creation_date IN OUT NOCOPY DATE,
3190: p_lookup_date IN OUT NOCOPY DATE,
3191: p_effective_date IN OUT NOCOPY DATE) IS
3192: BEGIN
3193: ----SELECT NVL(p_creation_date, SYSDATE) INTO p_creation_date FROM dual;
3194: IF (p_creation_date IS NULL) THEN
3195: p_creation_date := SYSDATE;
3196: END iF;
3197:

Line 3198: ----SELECT NVL(p_lookup_date, p_creation_date) INTO p_lookup_date FROM dual;

3194: IF (p_creation_date IS NULL) THEN
3195: p_creation_date := SYSDATE;
3196: END iF;
3197:
3198: ----SELECT NVL(p_lookup_date, p_creation_date) INTO p_lookup_date FROM dual;
3199: IF (p_lookup_date IS NULL) THEN
3200: p_lookup_date := p_creation_date;
3201: END IF;
3202:

Line 3203: -----SELECT NVL(p_effective_date, p_creation_date) INTO p_effective_date FROM dual;

3199: IF (p_lookup_date IS NULL) THEN
3200: p_lookup_date := p_creation_date;
3201: END IF;
3202:
3203: -----SELECT NVL(p_effective_date, p_creation_date) INTO p_effective_date FROM dual;
3204: IF (p_effective_date IS NULL) THEN
3205: p_effective_date := p_creation_date;
3206: END IF;
3207:

Line 3243: p_creation_date FROM dual;

3239: END;
3240:
3241: -- config creation date defaults to creation date of saved config
3242: SELECT NVL(p_creation_date, NVL(l_config_creation_date, SYSDATE)) INTO
3243: p_creation_date FROM dual;
3244:
3245: --- get value for setting_id RestoredConfigDefaultModelLookupDate
3246: --- bug# 2406680 fix for Agilent
3247: --- Section_name for this should be ORAAPPS_INTEGRATE. Not adding this condition since it could break

Line 3265: SELECT NVL(p_lookup_date, SYSDATE) INTO p_lookup_date FROM dual;

3261: IF ( ( UPPER(LTRIM(RTRIM(l_rest_cfg_lookup_setting))) = UPPER('config_creation_date') )
3262: AND (p_lookup_date IS NULL) ) THEN
3263: p_lookup_date := p_creation_date ;
3264: ELSE
3265: SELECT NVL(p_lookup_date, SYSDATE) INTO p_lookup_date FROM dual;
3266: END IF;
3267: -- effective date defaults to effective date of saved config
3268: SELECT NVL(p_effective_date, NVL(l_config_effective_date, SYSDATE)) INTO
3269: p_effective_date FROM dual;

Line 3269: p_effective_date FROM dual;

3265: SELECT NVL(p_lookup_date, SYSDATE) INTO p_lookup_date FROM dual;
3266: END IF;
3267: -- effective date defaults to effective date of saved config
3268: SELECT NVL(p_effective_date, NVL(l_config_effective_date, SYSDATE)) INTO
3269: p_effective_date FROM dual;
3270: END DEFAULT_RESTORED_CFG_DATES;
3271:
3272: -------------------------------------------------
3273: FUNCTION icx_session_ticket RETURN VARCHAR2 IS