DBA Data[Home] [Help]

APPS.WF_TASKFLOW dependencies on WF_CORE

Line 155: wf_core.raise('WFSEC_NO_SESSION');

151: /*res := ICX_SEC.ValidateSession( c_validate_only => 'Y',
152: c_update => FALSE);
153:
154: if (res = FALSE ) then
155: wf_core.raise('WFSEC_NO_SESSION');
156: end if; */
157:
158: IF (x_parent_type IS NULL OR x_parent_name IS NULL) THEN
159: temp_name := 'ROOT';

Line 275: l_tab varchar2(30) := wf_core.local_chr(9);

271: OR wav.end_date > x_start_date);
272:
273: base base_definition_cursor%ROWTYPE;
274:
275: l_tab varchar2(30) := wf_core.local_chr(9);
276:
277: BEGIN
278: /*dbms_output.put_line('get_base_definition:' ||
279: x_parent_type || ','||

Line 369: l_tab varchar2(30) := wf_core.local_chr(9);

365: OR wav.end_date > x_start_date);
366:
367: activity activity_definitions_cursor%ROWTYPE;
368:
369: l_tab varchar2(30) := wf_core.local_chr(9);
370:
371: BEGIN
372:
373: OPEN activity_definitions_cursor;

Line 430: DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),

426:
427: CURSOR transition_definitions_cursor IS
428: SELECT wpa.icon_geometry from_icon,
429: wpa.instance_id from_instance,
430: DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),
431: '*', ' ',
432: wf_core.activity_result(wav2.result_type,wat.result_code))
433: label,
434: wpa2.icon_geometry to_icon,

Line 432: wf_core.activity_result(wav2.result_type,wat.result_code))

428: SELECT wpa.icon_geometry from_icon,
429: wpa.instance_id from_instance,
430: DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),
431: '*', ' ',
432: wf_core.activity_result(wav2.result_type,wat.result_code))
433: label,
434: wpa2.icon_geometry to_icon,
435: wpa2.instance_id to_instance,
436: wat.arrow_geometry

Line 461: l_tab varchar2(30) := wf_core.local_chr(9);

457: AND wpa2.instance_id = wat.to_process_activity;
458:
459: transition transition_definitions_cursor%ROWTYPE;
460:
461: l_tab varchar2(30) := wf_core.local_chr(9);
462:
463: BEGIN
464:
465: OPEN transition_definitions_cursor;

Line 540: wf_core.raise('WFSEC_NO_SESSION');

536: /*res := ICX_SEC.ValidateSession( c_validate_only => 'Y',
537: c_update => FALSE);
538:
539: if (res = FALSE ) then
540: wf_core.raise('WFSEC_NO_SESSION');
541: end if; */
542:
543: BEGIN
544: SELECT root_activity, root_activity_version, begin_date

Line 626: DECODE(wf_core.activity_result(wav.result_type,wpa.default_result),

622: wav.icon_name,
623: wpa.instance_id,
624: DECODE(wpa.start_end, '', ' ', wpa.start_end) start_end,
625: DECODE(wpa.icon_geometry, '', '0,0', wpa.icon_geometry) geometry,
626: DECODE(wf_core.activity_result(wav.result_type,wpa.default_result),
627: '', ' ',
628: wf_core.activity_result(wav.result_type,wpa.default_result))
629: usage_result,
630: DECODE(wias.activity_status, '', ' ', wias.activity_status)

Line 628: wf_core.activity_result(wav.result_type,wpa.default_result))

624: DECODE(wpa.start_end, '', ' ', wpa.start_end) start_end,
625: DECODE(wpa.icon_geometry, '', '0,0', wpa.icon_geometry) geometry,
626: DECODE(wf_core.activity_result(wav.result_type,wpa.default_result),
627: '', ' ',
628: wf_core.activity_result(wav.result_type,wpa.default_result))
629: usage_result,
630: DECODE(wias.activity_status, '', ' ', wias.activity_status)
631: activity_status
632: FROM wf_process_activities wpa,

Line 657: l_tab varchar2(30) := wf_core.local_chr(9);

653: AND wias.process_activity (+) = wpa.instance_id;
654:
655: base base_instance_cursor%ROWTYPE;
656:
657: l_tab varchar2(30) := wf_core.local_chr(9);
658:
659: BEGIN
660:
661: OPEN base_instance_cursor;

Line 732: DECODE(wf_core.activity_result(wav.result_type, wpa.default_result),

728: wav.icon_name,
729: wpa.instance_id,
730: DECODE(wpa.start_end, '', ' ', wpa.start_end) start_end,
731: wpa.icon_geometry,
732: DECODE(wf_core.activity_result(wav.result_type, wpa.default_result),
733: '', ' ',
734: wf_core.activity_result(wav.result_type, wpa.default_result))
735: usage_result,
736: DECODE(wias.activity_status, '', ' ', wias.activity_status)

Line 734: wf_core.activity_result(wav.result_type, wpa.default_result))

730: DECODE(wpa.start_end, '', ' ', wpa.start_end) start_end,
731: wpa.icon_geometry,
732: DECODE(wf_core.activity_result(wav.result_type, wpa.default_result),
733: '', ' ',
734: wf_core.activity_result(wav.result_type, wpa.default_result))
735: usage_result,
736: DECODE(wias.activity_status, '', ' ', wias.activity_status)
737: activity_status
738: FROM wf_process_activities wpa,

Line 761: l_tab varchar2(30) := wf_core.local_chr(9);

757: AND wias.process_activity (+) = wpa.instance_id;
758:
759: activity activity_instances_cursor%ROWTYPE;
760:
761: l_tab varchar2(30) := wf_core.local_chr(9);
762:
763: BEGIN
764:
765: OPEN activity_instances_cursor;

Line 831: DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),

827:
828: CURSOR transition_instances_cursor IS
829: SELECT wpa.icon_geometry from_icon,
830: wpa.instance_id from_instance,
831: DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),
832: '*',' ',
833: wf_core.activity_result(wav2.result_type,wat.result_code))
834: label,
835: wpa2.icon_geometry to_icon,

Line 833: wf_core.activity_result(wav2.result_type,wat.result_code))

829: SELECT wpa.icon_geometry from_icon,
830: wpa.instance_id from_instance,
831: DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),
832: '*',' ',
833: wf_core.activity_result(wav2.result_type,wat.result_code))
834: label,
835: wpa2.icon_geometry to_icon,
836: wpa2.instance_id to_instance,
837: wat.arrow_geometry,

Line 885: l_tab varchar2(30) := wf_core.local_chr(9);

881: AND wl.lookup_code = 'F');
882:
883: transition transition_instances_cursor%ROWTYPE;
884:
885: l_tab varchar2(30) := wf_core.local_chr(9);
886:
887: BEGIN
888:
889: OPEN transition_instances_cursor;

Line 953: wf_core.raise('WFSEC_NO_SESSION');

949: /*res := ICX_SEC.ValidateSession( c_validate_only => 'Y',
950: c_update => FALSE);
951:
952: if (res = FALSE ) then
953: wf_core.raise('WFSEC_NO_SESSION');
954: end if;*/
955:
956: SELECT LENGTH(x_name_list) INTO temp FROM DUAL;
957: len := TO_NUMBER(temp);

Line 969: SUBSTR(wf_core.translate(token),1, 40) || wf_core.local_chr(9);

965:
966: --dbms_output.put_line('token=' || token);
967:
968: translated := translated ||
969: SUBSTR(wf_core.translate(token),1, 40) || wf_core.local_chr(9);
970:
971: EXIT WHEN (break_point = len);
972: total := break_point + 1;
973: