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 120: FROM dual;

116: BEGIN
117: SELECT DECODE(ui_type, 'APPLET', UI_STYLE_APPLET, 'DHTML', UI_STYLE_DHTML,
118: 'JRAD', UI_STYLE_JRAD, 'WEGA', UI_STYLE_WEGA, NULL)
119: INTO v_ui_style
120: FROM dual;
121: RETURN v_ui_style;
122: END;
123:
124: ------------------------------------------------------------------------------------------

Line 133: FROM dual;

129: BEGIN
130: SELECT DECODE(ui_style, UI_STYLE_APPLET, 'APPLET', UI_STYLE_DHTML, 'DHTML',
131: UI_STYLE_JRAD, 'JRAD', UI_STYLE_WEGA, 'WEGA', NULL)
132: INTO v_ui_type
133: FROM dual;
134: RETURN v_ui_type;
135: END;
136:
137: ------------------------------------------------------------------------------------------

Line 146: FROM dual;

142: OR
143: (next_hdr_to_use = (NVL(last_hdr_allocated, 0) + id_increment)) ) THEN
144: SELECT cz_config_hdrs_s.NEXTVAL
145: INTO last_hdr_allocated
146: FROM dual;
147: next_hdr_to_use := last_hdr_allocated;
148: END IF;
149: id_to_return := next_hdr_to_use;
150: next_hdr_to_use := next_hdr_to_use + 1;

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

158:
159: BEGIN
160: IF ((last_msg_seq_allocated IS NULL) OR
161: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
162: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
163: next_msg_seq_to_use := last_msg_seq_allocated;
164: END IF;
165:
166: l_msg_seq := next_msg_seq_to_use;

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

722: OPEN ecc_cur(p_config_item_id);
723: LOOP
724: FETCH ecc_cur INTO l_inventory_item_id,l_instance_nbr;
725: EXIT WHEN ecc_cur%NOTFOUND;
726: SELECT decode(l_instance_nbr, -1,1,0,1,l_instance_nbr) into l_instance_nbr from dual;
727: l_ecc := l_ecc||l_inventory_item_id||'|'||nvl(l_instance_nbr,1)||'-';
728: l_depth := l_depth + 1;
729: END LOOP;
730: CLOSE ecc_cur;

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

3222: v_config_lookup_date := SYSDATE;
3223: END IF;
3224:
3225: IF v_language IS NULL THEN
3226: SELECT userenv('LANG') INTO v_language FROM dual;
3227: END IF;
3228:
3229: -- check usage_name: if null, get the profile option value from db
3230: IF v_usage_name IS NULL THEN

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

3503: v_config_lookup_date := SYSDATE;
3504: END IF;
3505:
3506: IF v_language IS NULL THEN
3507: SELECT userenv('LANG') INTO v_language FROM dual;
3508: END IF;
3509:
3510: -- check usage_name: if null, get the profile option value from db
3511: IF v_usage_name IS NULL THEN

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

3589: PROCEDURE DEFAULT_NEW_CFG_DATES(p_creation_date IN OUT NOCOPY DATE,
3590: p_lookup_date IN OUT NOCOPY DATE,
3591: p_effective_date IN OUT NOCOPY DATE) IS
3592: BEGIN
3593: ----SELECT NVL(p_creation_date, SYSDATE) INTO p_creation_date FROM dual;
3594: IF (p_creation_date IS NULL) THEN
3595: p_creation_date := SYSDATE;
3596: END iF;
3597:

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

3594: IF (p_creation_date IS NULL) THEN
3595: p_creation_date := SYSDATE;
3596: END iF;
3597:
3598: ----SELECT NVL(p_lookup_date, p_creation_date) INTO p_lookup_date FROM dual;
3599: IF (p_lookup_date IS NULL) THEN
3600: p_lookup_date := p_creation_date;
3601: END IF;
3602:

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

3599: IF (p_lookup_date IS NULL) THEN
3600: p_lookup_date := p_creation_date;
3601: END IF;
3602:
3603: -----SELECT NVL(p_effective_date, p_creation_date) INTO p_effective_date FROM dual;
3604: IF (p_effective_date IS NULL) THEN
3605: p_effective_date := p_creation_date;
3606: END IF;
3607:

Line 3643: p_creation_date FROM dual;

3639: END;
3640:
3641: -- config creation date defaults to creation date of saved config
3642: SELECT NVL(p_creation_date, NVL(l_config_creation_date, SYSDATE)) INTO
3643: p_creation_date FROM dual;
3644:
3645: --- get value for setting_id RestoredConfigDefaultModelLookupDate
3646: --- bug# 2406680 fix for Agilent
3647: --- Section_name for this should be ORAAPPS_INTEGRATE. Not adding this condition since it could break

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

3661: IF ( ( UPPER(LTRIM(RTRIM(l_rest_cfg_lookup_setting))) = UPPER('config_creation_date') )
3662: AND (p_lookup_date IS NULL) ) THEN
3663: p_lookup_date := p_creation_date ;
3664: ELSE
3665: SELECT NVL(p_lookup_date, SYSDATE) INTO p_lookup_date FROM dual;
3666: END IF;
3667: -- effective date defaults to effective date of saved config
3668: SELECT NVL(p_effective_date, NVL(l_config_effective_date, SYSDATE)) INTO
3669: p_effective_date FROM dual;

Line 3669: p_effective_date FROM dual;

3665: SELECT NVL(p_lookup_date, SYSDATE) INTO p_lookup_date FROM dual;
3666: END IF;
3667: -- effective date defaults to effective date of saved config
3668: SELECT NVL(p_effective_date, NVL(l_config_effective_date, SYSDATE)) INTO
3669: p_effective_date FROM dual;
3670: END DEFAULT_RESTORED_CFG_DATES;
3671:
3672: -------------------------------------------------
3673: FUNCTION icx_session_ticket RETURN VARCHAR2 IS