APPS.AZW_HIER dependencies on WF_RESOURCES

Line 789: FROM wf_resources

785:
786: BEGIN
787: SELECT SUBSTRB(text, 0, 8)
788: INTO v_days
789: FROM wf_resources
790: WHERE language = v_language_code
791: AND type = 'WFTKN'
792: AND name = 'DAYS';
793: EXCEPTION

Line 801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');

797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');
802: APP_EXCEPTION.RAISE_EXCEPTION;
803: END;
804:
805: BEGIN

Line 808: FROM wf_resources

804:
805: BEGIN
806: SELECT SUBSTRB(text, 0, 8)
807: INTO v_done
808: FROM wf_resources
809: WHERE language = v_language_code
810: AND type = 'WFTKN'
811: AND name = 'WFMON_DONE';
812: EXCEPTION

Line 820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');

816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');
821: APP_EXCEPTION.RAISE_EXCEPTION;
822: END;
823:
824: BEGIN

Line 827: FROM wf_resources

823:
824: BEGIN
825: SELECT SUBSTRB(text, 0, 8)
826: INTO v_skip
827: FROM wf_resources
828: WHERE language = v_language_code
829: AND type = 'WFTKN'
830: AND name = 'WFMON_SKIP';
831: EXCEPTION

Line 839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');

835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');
840: APP_EXCEPTION.RAISE_EXCEPTION;
841: END;
842:
843: BEGIN

Line 846: FROM wf_resources

842:
843: BEGIN
844: SELECT SUBSTRB(text, 0, 16)
845: INTO v_priority_display
846: FROM wf_resources
847: WHERE language = v_language_code
848: AND type = 'WFTKN'
849: AND name = 'PRIORITY';
850: EXCEPTION

Line 858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');

854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: END;
861: END task_init;
862:

Line 1230: v_display_status wf_resources.text%TYPE;

1226: v_task_begin_date wf_items.begin_date%TYPE;
1227: v_task_tot_days NUMBER(5) DEFAULT 0;
1228: v_days_since NUMBER(5) DEFAULT 0;
1229: v_process_phase az_product_phases.phase%TYPE;
1230: v_display_status wf_resources.text%TYPE;
1231:
1232: CURSOR az_item_types IS
1233: SELECT distinct item_type
1234: FROM az_processes;