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.WF_LOAD dependencies on WF_LOAD

Line 1: package body WF_LOAD as

1: package body WF_LOAD as
2: /* $Header: wfldrb.pls 120.8 2011/03/14 05:31:35 alsosa ship $ */
3:
4: --
5: -- UPLOAD_ITEM_TYPE

Line 157: Wf_Core.Context('Wf_Load', 'Upload_Item_Type', x_name);

153:
154:
155: exception
156: when OTHERS then
157: Wf_Core.Context('Wf_Load', 'Upload_Item_Type', x_name);
158: raise;
159: end UPLOAD_ITEM_TYPE;
160:
161: --

Line 209: Wf_Core.Context('Wf_Load', 'Reseq_Item_Attribute', itemtype,

205: and SEQUENCE = -1;
206:
207: exception
208: when others then
209: Wf_Core.Context('Wf_Load', 'Reseq_Item_Attribute', itemtype,
210: to_char(oldseq), to_char(newseq));
211: raise;
212: end Reseq_Item_Attribute;
213:

Line 340: Wf_Load.Reseq_Item_Attribute(

336: end if;
337:
338: -- Resequence attrs in db to match sequence being uploaded
339: if (old_sequence <> x_sequence) then
340: Wf_Load.Reseq_Item_Attribute(
341: itemtype => x_item_type,
342: oldseq => old_sequence,
343: newseq => x_sequence);
344: end if;

Line 386: Wf_Load.Reseq_Item_Attribute(

382: from WF_ITEM_ATTRIBUTES
383: where ITEM_TYPE = x_item_type;
384:
385: if (old_sequence <> x_sequence) then
386: Wf_Load.Reseq_Item_Attribute(
387: itemtype => x_item_type,
388: oldseq => old_sequence,
389: newseq => x_sequence);
390: end if;

Line 413: Wf_Core.Context('Wf_Load', 'Upload_Item_Attribute', x_item_type, x_name);

409: end;
410:
411: exception
412: when OTHERS then
413: Wf_Core.Context('Wf_Load', 'Upload_Item_Attribute', x_item_type, x_name);
414: raise;
415: end UPLOAD_ITEM_ATTRIBUTE;
416:
417: --

Line 554: Wf_Core.Context('Wf_Load', 'Upload_Lookup_Type', x_lookup_type);

550: end;
551:
552: exception
553: when OTHERS then
554: Wf_Core.Context('Wf_Load', 'Upload_Lookup_Type', x_lookup_type);
555: raise;
556: end UPLOAD_LOOKUP_TYPE;
557:
558: --

Line 703: Wf_Core.Context('Wf_Load', 'Upload_Lookup', x_lookup_type, x_lookup_code);

699: end;
700:
701: exception
702: when OTHERS then
703: Wf_Core.Context('Wf_Load', 'Upload_Lookup', x_lookup_type, x_lookup_code);
704: raise;
705: end UPLOAD_LOOKUP;
706:
707: --

Line 803: Wf_Core.Context('Wf_Load', 'Upload_Message', x_type, x_name);

799: end;
800:
801: exception
802: when OTHERS then
803: Wf_Core.Context('Wf_Load', 'Upload_Message', x_type, x_name);
804: raise;
805: end UPLOAD_MESSAGE;
806:
807: --

Line 861: Wf_Core.Context('Wf_Load', 'Reseq_Message_Attribute', msgtype,

857: and SEQUENCE = -1;
858:
859: exception
860: when others then
861: Wf_Core.Context('Wf_Load', 'Reseq_Message_Attribute', msgtype,
862: msgname, to_char(oldseq), to_char(newseq));
863: raise;
864: end Reseq_Message_Attribute;
865:

Line 1000: Wf_Load.Reseq_Message_Attribute(

996: end if;
997:
998: -- Resequence attrs in db to match sequence being uploaded
999: if (old_sequence <> x_sequence) then
1000: Wf_Load.Reseq_Message_Attribute(
1001: msgtype => x_message_type,
1002: msgname => x_message_name,
1003: oldseq => old_sequence,
1004: newseq => x_sequence);

Line 1036: Wf_Load.Reseq_Message_Attribute(

1032: where MESSAGE_TYPE = x_message_type
1033: and MESSAGE_NAME = x_message_name;
1034:
1035: if (old_sequence <> x_sequence) then
1036: Wf_Load.Reseq_Message_Attribute(
1037: msgtype => x_message_type,
1038: msgname => x_message_name,
1039: oldseq => old_sequence,
1040: newseq => x_sequence);

Line 1066: Wf_Core.Context('Wf_Load', 'Upload_Message_Attribute', x_message_type,

1062: end;
1063:
1064: exception
1065: when OTHERS then
1066: Wf_Core.Context('Wf_Load', 'Upload_Message_Attribute', x_message_type,
1067: x_message_name, x_name);
1068: raise;
1069: end UPLOAD_MESSAGE_ATTRIBUTE;
1070:

Line 1350: x_log_message := Wf_Load.logbuf;

1346: );
1347: end if;
1348:
1349: -- handle the extra log message for display name conflict
1350: x_log_message := Wf_Load.logbuf;
1351: -- if the message is not empty, there is a conflict.
1352: if (x_log_message is not null or x_log_message <> '') then
1353: x_level_error := 16;
1354: Wf_Load.logbuf := ''; -- clear the buffer now

Line 1354: Wf_Load.logbuf := ''; -- clear the buffer now

1350: x_log_message := Wf_Load.logbuf;
1351: -- if the message is not empty, there is a conflict.
1352: if (x_log_message is not null or x_log_message <> '') then
1353: x_level_error := 16;
1354: Wf_Load.logbuf := ''; -- clear the buffer now
1355: end if;
1356:
1357: if (not (x_name = 'ROOT' and x_type = 'FOLDER')) then
1358: WF_LOAD.UPLOAD_ACTIVITY(

Line 1358: WF_LOAD.UPLOAD_ACTIVITY(

1354: Wf_Load.logbuf := ''; -- clear the buffer now
1355: end if;
1356:
1357: if (not (x_name = 'ROOT' and x_type = 'FOLDER')) then
1358: WF_LOAD.UPLOAD_ACTIVITY(
1359: x_item_type=>x_item_type,
1360: x_name=>'ROOT',
1361: x_type=>'FOLDER',
1362: x_display_name=>'ROOT',

Line 1422: Wf_Core.Context('Wf_Load', 'Upload_Activity', x_item_type, x_name);

1418: /* ### Should not have a commit in this API */
1419: /* ### commit; */
1420: exception
1421: when OTHERS then
1422: Wf_Core.Context('Wf_Load', 'Upload_Activity', x_item_type, x_name);
1423: raise;
1424: end UPLOAD_ACTIVITY;
1425:
1426: --

Line 1459: WF_LOAD.UPLOAD_ACTIVITY(

1455: ) is
1456: dummy_log_message varchar2(32000);
1457: begin
1458: -- call the real UPLOAD_ACTIVITY and ignore the dummy_log_message
1459: WF_LOAD.UPLOAD_ACTIVITY(
1460: x_item_type=>x_item_type,
1461: x_name=>x_name,
1462: x_type=>x_type,
1463: x_display_name=>x_display_name,

Line 1556: Wf_Core.Context('Wf_Load', 'Reseq_Activity_Attribute', acttype,

1552: and SEQUENCE = -1;
1553:
1554: exception
1555: when others then
1556: Wf_Core.Context('Wf_Load', 'Reseq_Activity_Attribute', acttype,
1557: actname, to_char(actver), to_char(oldseq), to_char(newseq));
1558: raise;
1559: end Reseq_Activity_Attribute;
1560:

Line 1626: Wf_Load.Reseq_Activity_Attribute(

1622: end if;
1623:
1624: -- Resequence attrs in db to match sequence being uploaded
1625: if (old_sequence <> x_sequence) then
1626: Wf_Load.Reseq_Activity_Attribute(
1627: acttype => x_activity_item_type,
1628: actname => x_activity_name,
1629: actver => x_activity_version,
1630: oldseq => old_sequence,

Line 1679: Wf_Load.Reseq_Activity_Attribute(

1675: and ACTIVITY_NAME = x_activity_name
1676: and ACTIVITY_VERSION = x_activity_version;
1677:
1678: if (old_sequence <> x_sequence) then
1679: Wf_Load.Reseq_Activity_Attribute(
1680: acttype => x_activity_item_type,
1681: actname => x_activity_name,
1682: actver => x_activity_version,
1683: oldseq => old_sequence,

Line 1711: Wf_Core.Context('Wf_Load', 'Upload_Activity_Attribute',

1707: end;
1708:
1709: exception
1710: when OTHERS then
1711: Wf_Core.Context('Wf_Load', 'Upload_Activity_Attribute',
1712: x_activity_item_type, x_activity_name,
1713: to_char(x_activity_version), x_name);
1714: raise;
1715: end UPLOAD_ACTIVITY_ATTRIBUTE;

Line 1876: WF_LOAD.UPLOAD_ACTIVITY(

1872: where ITEM_TYPE = x_process_item_type
1873: and NAME = 'ROOT';
1874:
1875: if (noinsert <= 0) then
1876: WF_LOAD.UPLOAD_ACTIVITY(
1877: x_item_type=>x_process_item_type,
1878: x_name=>'ROOT',
1879: x_type=>'FOLDER',
1880: x_display_name=>'ROOT',

Line 1962: WF_LOAD.UPLOAD_PROCESS_ACTIVITY(

1958: -- statement.
1959: --
1960: if (x_process_name <> 'ROOT' and noinsert <= 0) then
1961: -- Insert a root process activity
1962: WF_LOAD.UPLOAD_PROCESS_ACTIVITY(
1963: x_process_item_type=>x_process_item_type,
1964: x_process_name=>'ROOT',
1965: x_process_version=>new_version,
1966: x_activity_item_type=>x_process_item_type,

Line 1986: Wf_Core.Context('Wf_Load', 'Upload_Process_Activity',x_process_name,

1982: end;
1983:
1984: exception
1985: when OTHERS then
1986: Wf_Core.Context('Wf_Load', 'Upload_Process_Activity',x_process_name,
1987: x_activity_name,
1988: to_char(x_instance_id));
1989: raise;
1990: end UPLOAD_PROCESS_ACTIVITY;

Line 2138: Wf_Core.Context('Wf_Load', 'Upload_Activity_Attr_Value',

2134: end;
2135:
2136: exception
2137: when OTHERS then
2138: Wf_Core.Context('Wf_Load', 'Upload_Activity_Attr_Value',
2139: to_char(x_process_activity_id), x_name);
2140: raise;
2141: end UPLOAD_ACTIVITY_ATTR_VALUE;
2142:

Line 2230: Wf_Core.Context('Wf_Load', 'Upload_Activity_Transition',

2226: end;
2227:
2228: exception
2229: when OTHERS then
2230: Wf_Core.Context('Wf_Load', 'Upload_Activity_Transition',
2231: to_char(x_from_process_activity),
2232: x_result_code,
2233: to_char(x_to_process_activity));
2234: raise;

Line 2261: Wf_Core.Context('Wf_Load', 'Upload_Resource', x_name, x_type);

2257: x_level_error);
2258:
2259: exception
2260: when others then
2261: Wf_Core.Context('Wf_Load', 'Upload_Resource', x_name, x_type);
2262: raise;
2263: end UPLOAD_RESOURCE;
2264:
2265: --

Line 2306: Wf_Core.Context('Wf_Load', 'Delete_Lookup_Type', x_lookup_type);

2302: exception
2303: when NO_DATA_FOUND then
2304: null;
2305: when OTHERS then
2306: Wf_Core.Context('Wf_Load', 'Delete_Lookup_Type', x_lookup_type);
2307: raise;
2308: end DELETE_LOOKUP_TYPE;
2309:
2310: --

Line 2353: Wf_Core.Context('Wf_Load', 'Delete_Lookup', x_lookup_type, x_lookup_code);

2349: exception
2350: when NO_DATA_FOUND then
2351: null;
2352: when OTHERS then
2353: Wf_Core.Context('Wf_Load', 'Delete_Lookup', x_lookup_type, x_lookup_code);
2354: raise;
2355: end DELETE_LOOKUP;
2356:
2357: --

Line 2395: wf_core.context('WF_LOAD', 'DELETE_LOOKUPS');

2391: exception
2392: when NO_DATA_FOUND then
2393: null;
2394: when OTHERS then
2395: wf_core.context('WF_LOAD', 'DELETE_LOOKUPS');
2396: raise;
2397: end DELETE_LOOKUPS;
2398:
2399: --

Line 2479: Wf_Core.Context('Wf_Load', 'Delete_Item_Type', x_name);

2475: exception
2476: when NO_DATA_FOUND then
2477: null;
2478: when OTHERS then
2479: Wf_Core.Context('Wf_Load', 'Delete_Item_Type', x_name);
2480: raise;
2481: end DELETE_ITEM_TYPE;
2482:
2483: --

Line 2525: Wf_Core.Context('Wf_Load', 'Delete_Item_Attribute', x_item_type, x_name);

2521: exception
2522: when NO_DATA_FOUND then
2523: null;
2524: when OTHERS then
2525: Wf_Core.Context('Wf_Load', 'Delete_Item_Attribute', x_item_type, x_name);
2526: raise;
2527: end DELETE_ITEM_ATTRIBUTE;
2528:
2529: --

Line 2570: Wf_Core.Context('Wf_Load', 'Delete_Item_Attributes', x_item_type);

2566: exception
2567: when NO_DATA_FOUND then
2568: null;
2569: when OTHERS then
2570: Wf_Core.Context('Wf_Load', 'Delete_Item_Attributes', x_item_type);
2571: raise;
2572: end DELETE_ITEM_ATTRIBUTES;
2573:
2574: --

Line 2644: Wf_Core.Context('Wf_Load', 'Delete_Message', x_type, x_name);

2640: exception
2641: when NO_DATA_FOUND then
2642: null;
2643: when OTHERS then
2644: Wf_Core.Context('Wf_Load', 'Delete_Message', x_type, x_name);
2645: raise;
2646: end DELETE_MESSAGE;
2647:
2648: --

Line 2691: Wf_Core.Context('Wf_Load', 'Delete_Message_Attribute', x_message_type,

2687: exception
2688: when NO_DATA_FOUND then
2689: null;
2690: when OTHERS then
2691: Wf_Core.Context('Wf_Load', 'Delete_Message_Attribute', x_message_type,
2692: x_message_name, x_name);
2693: raise;
2694: end DELETE_MESSAGE_ATTRIBUTE;
2695:

Line 2742: Wf_Core.Context('Wf_Load', 'Delete_Message_Attributes', x_message_type,

2738: exception
2739: when NO_DATA_FOUND then
2740: null;
2741: when OTHERS then
2742: Wf_Core.Context('Wf_Load', 'Delete_Message_Attributes', x_message_type,
2743: x_message_name);
2744: raise;
2745: end DELETE_MESSAGE_ATTRIBUTES;
2746:

Line 2808: Wf_Core.Context('Wf_Load', 'Delete_Activity', x_item_type, x_name);

2804: exception
2805: when NO_DATA_FOUND then
2806: null;
2807: when OTHERS then
2808: Wf_Core.Context('Wf_Load', 'Delete_Activity', x_item_type, x_name);
2809: raise;
2810: end DELETE_ACTIVITY;
2811:
2812: --

Line 2860: Wf_Core.Context('Wf_Load', 'Delete_Transition', p_previous_step,

2856: end if;
2857: end if;
2858: exception
2859: when OTHERS then
2860: Wf_Core.Context('Wf_Load', 'Delete_Transition', p_previous_step,
2861: p_next_step, p_result_code);
2862: raise;
2863: end;
2864:

Line 2899: Wf_Core.Context('Wf_Load', 'Get_Process_Activity', p_activity_instance);

2895: p_ycor := to_number(substr(l_icon_geometry, comma_position + 1));
2896:
2897: exception
2898: when OTHERS then
2899: Wf_Core.Context('Wf_Load', 'Get_Process_Activity', p_activity_instance);
2900: raise;
2901: end;
2902:
2903: --

Line 2938: Wf_Load.Get_Message(p_type, p_name, l_protect_level, l_custom_level,

2934: begin
2935: -- Reset any caches that might be running.
2936: WF_CACHE.Reset;
2937:
2938: Wf_Load.Get_Message(p_type, p_name, l_protect_level, l_custom_level,
2939: l_default_priority, l_display_name, l_description,
2940: l_subject, l_body, l_html_body);
2941:
2942: if (p_subject is not null) then

Line 2954: Wf_Load.UPLOAD_MESSAGE(

2950: if (p_html_body is not null) then
2951: l_html_body := p_html_body;
2952: end if;
2953:
2954: Wf_Load.UPLOAD_MESSAGE(
2955: x_type => p_type,
2956: x_name => p_name,
2957: x_display_name => l_display_name,
2958: x_description => l_description,

Line 2971: Wf_Core.Context('Wf_Load', 'Get_Message', p_type, p_name);

2967: x_level_error => p_level_error);
2968:
2969: exception
2970: when OTHERS then
2971: Wf_Core.Context('Wf_Load', 'Get_Message', p_type, p_name);
2972: raise;
2973: end;
2974:
2975: --

Line 3027: Wf_Core.Context('Wf_Load', 'Get_Message', p_type, p_name);

3023: and NAME = p_name;
3024:
3025: exception
3026: when OTHERS then
3027: Wf_Core.Context('Wf_Load', 'Get_Message', p_type, p_name);
3028: raise;
3029: end;
3030:
3031: --

Line 3206: Wf_Core.Context('Wf_Load', 'Selecting ITEM_TYPE', p_item_type);

3202: from WF_ITEM_TYPES_VL
3203: where NAME = p_item_type;
3204: exception
3205: when others then
3206: Wf_Core.Context('Wf_Load', 'Selecting ITEM_TYPE', p_item_type);
3207: raise;
3208: end;
3209:
3210: begin

Line 3223: Wf_Load.UPLOAD_ITEM_TYPE(

3219: when OTHERS then
3220: raise;
3221: end;
3222:
3223: Wf_Load.UPLOAD_ITEM_TYPE(
3224: x_name=> p_destination_item_type,
3225: x_display_name=> l_dname,
3226: x_description=> v_itt.description,
3227: x_protect_level=> v_itt.protect_level,

Line 3251: Wf_Load.UPLOAD_LOOKUP_TYPE (

3247: -- Copy Lookup Types
3248: i := 1;
3249: for lutr in lutcur(p_item_type) loop
3250: v_lut(i) := lutr.LOOKUP_TYPE;
3251: Wf_Load.UPLOAD_LOOKUP_TYPE (
3252: x_lookup_type=>substr(lutr.lookup_type||p_new_suffix, 1, 30),
3253: x_display_name=>substr(lutr.display_name||p_new_suffix, 1, 80),
3254: x_description=>lutr.description,
3255: x_protect_level=>lutr.protect_level,

Line 3272: Wf_Load.UPLOAD_LOOKUP (

3268:
3269: -- Copy Lookup Codes
3270: for j in 1..v_lut.count loop
3271: for lucr in luccur(v_lut(j)) loop
3272: Wf_Load.UPLOAD_LOOKUP (
3273: x_lookup_type=>substr(v_lut(j)||p_new_suffix, 1, 30),
3274: x_lookup_code=>lucr.lookup_code,
3275: x_meaning=>lucr.meaning,
3276: x_description=>lucr.description,

Line 3308: Wf_Load.UPLOAD_ITEM_ATTRIBUTE(

3304: else
3305: l_default := itar.text_default;
3306: end if;
3307:
3308: Wf_Load.UPLOAD_ITEM_ATTRIBUTE(
3309: x_item_type=>p_destination_item_type,
3310: x_name=>substr(itar.name||p_new_suffix, 1, 30),
3311: x_display_name=>substr(itar.display_name||p_new_suffix, 1, 80),
3312: x_description=>itar.description,

Line 3334: Wf_Load.UPLOAD_MESSAGE (

3330: -- Copy Message
3331: i := 1;
3332: for msgr in msgcur(p_item_type) loop
3333: v_msg(i) := msgr.name;
3334: Wf_Load.UPLOAD_MESSAGE (
3335: x_type=>p_destination_item_type,
3336: x_name=>substr(msgr.name||p_new_suffix,1,30),
3337: x_display_name=>substr(msgr.display_name||p_new_suffix,1,80),
3338: x_description=>msgr.description,

Line 3387: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(

3383: l_name := substr(msar.name||p_new_suffix, 1, 30);
3384: end if;
3385: end if;
3386:
3387: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(
3388: x_message_type=>p_destination_item_type,
3389: x_message_name=>substr(v_msg(j)||p_new_suffix,1,30),
3390: x_name=>l_name,
3391: x_display_name=>msar.display_name,

Line 3440: Wf_Load.UPLOAD_ACTIVITY (

3436: l_name := substr(actr.name||p_new_suffix,1,30);
3437: l_dname := substr(actr.display_name||p_new_suffix,1,80);
3438: end if;
3439:
3440: Wf_Load.UPLOAD_ACTIVITY (
3441: x_item_type=>p_destination_item_type,
3442: x_name=>l_name,
3443: x_display_name=>l_dname,
3444: x_description=>actr.description,

Line 3502: Wf_Load.UPLOAD_ACTIVITY_ATTRIBUTE(

3498: l_default := substr(atar.text_default||p_new_suffix, 1, 30);
3499: end if;
3500:
3501: -- version below is always 1, the first one.
3502: Wf_Load.UPLOAD_ACTIVITY_ATTRIBUTE(
3503: x_activity_item_type=>p_destination_item_type,
3504: x_activity_name=>substr(v_act(j).name||p_new_suffix,1,30),
3505: x_activity_version=>1,
3506: x_name=>atar.name,

Line 3567: Wf_Load.UPLOAD_PROCESS_ACTIVITY (

3563: exception
3564: when NO_DATA_FOUND then
3565: v_npac(i) := 0;
3566:
3567: Wf_Load.UPLOAD_PROCESS_ACTIVITY (
3568: x_process_item_type=>p_destination_item_type,
3569: x_process_name=>l_pname,
3570: x_process_version=>1,
3571: x_activity_item_type=>l_item_type,

Line 3616: Wf_Load.UPLOAD_ACTIVITY_TRANSITION (

3612: -- ### should raise error here.
3613: raise no_match;
3614: end if;
3615:
3616: Wf_Load.UPLOAD_ACTIVITY_TRANSITION (
3617: x_from_process_activity=>v_npac(j),
3618: x_result_code=>patr.result_code,
3619: x_to_process_activity=>v_npac(toid),
3620: x_protect_level=>patr.protect_level,

Line 3645: Wf_Load.UPLOAD_ACTIVITY_ATTR_VALUE (

3641: l_value := substr(aavr.text_value||p_new_suffix, 1, 30);
3642: end if;
3643:
3644:
3645: Wf_Load.UPLOAD_ACTIVITY_ATTR_VALUE (
3646: x_process_activity_id=>v_npac(j),
3647: x_name=>aavr.name,
3648: x_protect_level=>aavr.protect_level,
3649: x_custom_level=>aavr.custom_level,

Line 3681: Wf_Core.Context('Wf_Load', 'COPY_ITEM_TYPE', p_item_type,

3677: end if;
3678: if (msacur%isopen) then
3679: close msacur;
3680: end if;
3681: Wf_Core.Context('Wf_Load', 'COPY_ITEM_TYPE', p_item_type,
3682: p_destination_item_type,
3683: p_new_suffix);
3684: raise;
3685: end;

Line 3723: Wf_Load.Delete_Transition(p_previous_step=>p_step);

3719: -- raise;
3720: -- end;
3721:
3722: -- Delete all transitions to and from this process activity
3723: Wf_Load.Delete_Transition(p_previous_step=>p_step);
3724: Wf_Load.Delete_Transition(p_next_step=>p_step);
3725:
3726: -- Delete all related attribute values
3727: delete from WF_ACTIVITY_ATTR_VALUES where PROCESS_ACTIVITY_ID = p_step;

Line 3724: Wf_Load.Delete_Transition(p_next_step=>p_step);

3720: -- end;
3721:
3722: -- Delete all transitions to and from this process activity
3723: Wf_Load.Delete_Transition(p_previous_step=>p_step);
3724: Wf_Load.Delete_Transition(p_next_step=>p_step);
3725:
3726: -- Delete all related attribute values
3727: delete from WF_ACTIVITY_ATTR_VALUES where PROCESS_ACTIVITY_ID = p_step;
3728:

Line 3734: Wf_Core.Context('Wf_Load', 'Delete_Process_Activity',

3730: delete from WF_PROCESS_ACTIVITIES where INSTANCE_ID = p_step;
3731:
3732: exception
3733: when OTHERS then
3734: Wf_Core.Context('Wf_Load', 'Delete_Process_Activity',
3735: to_char(p_step));
3736: raise;
3737: end;
3738:

Line 3765: Wf_Core.Context('Wf_Load', 'Get_Activity_Attr_Val',

3761: where PROCESS_ACTIVITY_ID = p_process_instance_id
3762: and NAME = p_attribute_name;
3763: exception
3764: when OTHERS then
3765: Wf_Core.Context('Wf_Load', 'Get_Activity_Attr_Val',
3766: to_char(p_process_instance_id), p_attribute_name);
3767: raise;
3768: end;
3769:

Line 3809: Wf_Core.Context('Wf_Load', 'Get_Item_Attribute',

3805: end if;
3806:
3807: exception
3808: when OTHERS then
3809: Wf_Core.Context('Wf_Load', 'Get_Item_Attribute',
3810: p_item_type, p_attribute_name);
3811: raise;
3812: end;
3813:

Line 3916: Wf_Core.Context('Wf_Load', 'Get_Activity', p_item_type, p_name);

3912: and NAME = p_name
3913: and END_DATE is null;
3914: exception
3915: when OTHERS then
3916: Wf_Core.Context('Wf_Load', 'Get_Activity', p_item_type, p_name);
3917: raise;
3918: end;
3919:
3920: --

Line 3972: Wf_Load.GET_ACTIVITY (

3968: -- Reset any caches that might be running.
3969: WF_CACHE.Reset;
3970:
3971: begin
3972: Wf_Load.GET_ACTIVITY (
3973: p_item_type=>p_item_type,
3974: p_name=>p_name,
3975: p_display_name=>l_display_name,
3976: p_description=>l_description,

Line 4014: Wf_Core.Context('Wf_Load', 'Update_Activity Get_Activity');

4010: end if;
4011: exception
4012: when OTHERS then
4013: -- Don't proceed
4014: Wf_Core.Context('Wf_Load', 'Update_Activity Get_Activity');
4015: raise;
4016: end;
4017:
4018: if (p_display_name is not null) then

Line 4097: Wf_Core.Context('Wf_Load', 'Update_Activity', p_item_type, p_name,

4093: and VERSION = l_version;
4094:
4095: exception
4096: when OTHERS then
4097: Wf_Core.Context('Wf_Load', 'Update_Activity', p_item_type, p_name,
4098: p_display_name);
4099: raise;
4100: end;
4101:

Line 4156: Wf_Core.Context('Wf_Load', 'Get_Activity_Instance', p_process_item_type,

4152: return id;
4153:
4154: exception
4155: when OTHERS then
4156: Wf_Core.Context('Wf_Load', 'Get_Activity_Instance', p_process_item_type,
4157: p_process_name, p_process_version);
4158: return (-1);
4159: end;
4160:

Line 4183: Wf_Core.Context('Wf_Load', 'GetActNameFromInstId',

4179:
4180: return l_actname;
4181: exception
4182: when OTHERS then
4183: Wf_Core.Context('Wf_Load', 'GetActNameFromInstId',
4184: to_char(p_instance_id));
4185: return null;
4186: end;
4187: */

Line 4283: Wf_Core.Context('Wf_Load', 'Get_Activity_Transition',

4279: end if;
4280: end if;
4281: exception
4282: when OTHERS then
4283: Wf_Core.Context('Wf_Load', 'Get_Activity_Transition',
4284: to_char(p_from_activity),
4285: to_char(p_to_activity),
4286: p_result_code
4287: );

Line 4319: Wf_Core.Context('Wf_Load', 'Get_Attribute_Names', p_item_type, p_suffix);

4315: i := i + 1;
4316: end loop;
4317: exception
4318: when OTHERS then
4319: Wf_Core.Context('Wf_Load', 'Get_Attribute_Names', p_item_type, p_suffix);
4320: raise;
4321: end;
4322:
4323:

Line 4355: Wf_Core.Context('Wf_Load', 'Get_Notif_Activity_Names',

4351: i := i + 1;
4352: end loop;
4353: exception
4354: when OTHERS then
4355: Wf_Core.Context('Wf_Load', 'Get_Notif_Activity_Names',
4356: p_item_type, p_suffix);
4357: raise;
4358: end;
4359:

Line 4388: Wf_Core.Context('Wf_Load', 'Get_Message_Names', p_item_type, p_suffix);

4384: i := i + 1;
4385: end loop;
4386: exception
4387: when OTHERS then
4388: Wf_Core.Context('Wf_Load', 'Get_Message_Names', p_item_type, p_suffix);
4389: raise;
4390: end;
4391:
4392: -- Get_Process_Activity_Instances

Line 4424: Wf_Core.Context('Wf_Load', 'Get_Process_Activity_Instances',

4420: i := i + 1;
4421: end loop;
4422: exception
4423: when OTHERS then
4424: Wf_Core.Context('Wf_Load', 'Get_Process_Activity_Instances',
4425: p_process_item_type, p_process_name, p_process_version);
4426: raise;
4427: end;
4428:

Line 4458: Wf_Core.Context('Wf_Load', 'Get_Lookup', x_lookup_type, x_lookup_code);

4454: where LOOKUP_TYPE = x_lookup_type
4455: and LOOKUP_CODE = x_lookup_code;
4456: exception
4457: when OTHERS then
4458: Wf_Core.Context('Wf_Load', 'Get_Lookup', x_lookup_type, x_lookup_code);
4459: raise;
4460: end;
4461:
4462: --

Line 4497: Wf_Load.Get_Lookup(x_lookup_type, x_lookup_code,

4493: -- Reset any caches that might be running.
4494: WF_CACHE.Reset;
4495:
4496: -- Get Lookup
4497: Wf_Load.Get_Lookup(x_lookup_type, x_lookup_code,
4498: l_meaning, l_description, l_protect_level, l_custom_level);
4499:
4500: -- Upload Lookup
4501: if (x_meaning is not null) then

Line 4513: Wf_Load.UPLOAD_LOOKUP(

4509: end if;
4510: if (x_custom_level is not null) then
4511: l_custom_level := x_custom_level;
4512: end if;
4513: Wf_Load.UPLOAD_LOOKUP(
4514: x_lookup_type=>x_lookup_type,
4515: x_lookup_code=>x_lookup_code,
4516: x_meaning=>l_meaning,
4517: x_description=>l_description,

Line 4524: Wf_Core.Context('Wf_Load', 'Update_Lookup', x_lookup_type, x_lookup_code);

4520: x_level_error=>x_level_error
4521: );
4522: exception
4523: when OTHERS then
4524: Wf_Core.Context('Wf_Load', 'Update_Lookup', x_lookup_type, x_lookup_code);
4525: raise;
4526: end;
4527:
4528:

Line 4555: Wf_Core.Context('Wf_Load', 'Get_Lookup_Codes', p_lookup_type);

4551: i := i + 1;
4552: end loop;
4553: exception
4554: when OTHERS then
4555: Wf_Core.Context('Wf_Load', 'Get_Lookup_Codes', p_lookup_type);
4556: raise;
4557: end;
4558:
4559: --

Line 4601: -- Wf_Core.Context('Wf_Load', 'Activity_Exist_In_Process_Overflown',

4597: begin
4598: -- first check the iteration to avoid infinite loop
4599: if (iteration > 7) then
4600: -- debug only
4601: -- Wf_Core.Context('Wf_Load', 'Activity_Exist_In_Process_Overflown',
4602: -- p_process_item_type, p_process_name,
4603: -- nvl(p_activity_item_type, p_process_item_type),
4604: -- p_activity_name);
4605: return FALSE;

Line 4637: if (Wf_Load.Activity_Exist_In_Process(

4633:
4634: if (n = 0) then
4635: -- recursively check subprocesses
4636: for actr in actcur(m_version) loop
4637: if (Wf_Load.Activity_Exist_In_Process(
4638: actr.activity_item_type,
4639: actr.activity_name,
4640: nvl(p_activity_item_type, p_process_item_type),
4641: p_activity_name,

Line 4656: Wf_Core.Context('Wf_Load', 'Activity_Exist_In_Process',

4652: end if;
4653:
4654: exception
4655: when OTHERS then
4656: Wf_Core.Context('Wf_Load', 'Activity_Exist_In_Process',
4657: p_process_item_type, p_process_name,
4658: nvl(p_activity_item_type, p_process_item_type),
4659: p_activity_name);
4660: raise;

Line 4705: WF_CORE.context('WF_LOAD', 'Prepare_NZDT_WFRESGEN', 'WF_RESOURCES', sqlerrm);

4701: begin
4702: AD_ZD_SEED.PREPARE('WF_RESOURCES');
4703: exception
4704: when others then
4705: WF_CORE.context('WF_LOAD', 'Prepare_NZDT_WFRESGEN', 'WF_RESOURCES', sqlerrm);
4706: raise;
4707: end Prepare_NZDT_WFRESGEN;
4708:
4709: --

Line 4717: l_package_name varchar2(30) := 'WF_LOAD';

4713: -- calling AD_ZD_SEED.PREPARE(' 4714: -- is backed up in the current namespace.
4715: PROCEDURE Prepare_NZDT_WFLOAD
4716: is
4717: l_package_name varchar2(30) := 'WF_LOAD';
4718: l_module_name varchar2(30) := 'Prepare_NZDT_WFLOAD';
4719: l_tem_tab_name varchar2(50);
4720: TYPE TableName is VARRAY(17) OF VARCHAR2(50);
4721: WFTable TableName:=TableName ('WF_ACTIVITIES',

Line 4749: end WF_LOAD;

4745: WF_CORE.context(l_package_name, l_module_name, l_tem_tab_name, sqlerrm);
4746: raise;
4747: end Prepare_NZDT_WFLOAD;
4748:
4749: end WF_LOAD;