DBA Data[Home] [Help]

APPS.AZW_PROC dependencies on WF_RESOURCES

Line 798: FROM wf_resources

794: END IF;
795: BEGIN
796: SELECT substr(text, 1, 8)
797: INTO v_days
798: FROM wf_resources
799: WHERE language = v_language_code
800: AND type = 'WFTKN'
801: AND name = 'DAYS';
802: EXCEPTION

Line 815: FROM wf_resources

811:
812: BEGIN
813: SELECT substr(text, 1, 8)
814: INTO v_done
815: FROM wf_resources
816: WHERE language = v_language_code
817: AND type = 'WFTKN'
818: AND name = 'WFMON_DONE';
819: EXCEPTION

Line 832: FROM wf_resources

828:
829: BEGIN
830: SELECT substr(text, 1, 8)
831: INTO v_skip
832: FROM wf_resources
833: WHERE language = v_language_code
834: AND type = 'WFTKN'
835: AND name = 'WFMON_SKIP';
836: EXCEPTION

Line 2143: v_display_status wf_resources.text%TYPE;

2139: FUNCTION get_old_task_label(p_type VARCHAR2, p_key VARCHAR2, p_name VARCHAR2,
2140: p_role VARCHAR2) RETURN VARCHAR2
2141: IS
2142: v_begin_date wf_item_activity_statuses.begin_date%TYPE;
2143: v_display_status wf_resources.text%TYPE;
2144: v_label az_webform_messages.mesg%TYPE;
2145: v_task_tot_days NUMBER(5) := 0;
2146: v_count NUMBER(5) := 0;
2147: v_skip_count NUMBER(4) := 0;

Line 2270: v_display_status wf_resources.text%TYPE;

2266: RETURN VARCHAR2
2267: IS
2268: label az_webform_messages.mesg%TYPE;
2269: v_begin_date wf_item_activity_statuses.begin_date%TYPE;
2270: v_display_status wf_resources.text%TYPE;
2271: v_mesg az_webform_messages.mesg%TYPE;
2272: v_node_id VARCHAR2(300);
2273: v_parent_node_id VARCHAR2(300);
2274: