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.6 2006/08/24 07:03:06 hgandiko ship $ */
3:
4: --
5: -- UPLOAD_ITEM_TYPE

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

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

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

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

Line 339: Wf_Load.Reseq_Item_Attribute(

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

Line 385: Wf_Load.Reseq_Item_Attribute(

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

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

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

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

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

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

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

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

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

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

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

Line 999: Wf_Load.Reseq_Message_Attribute(

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

Line 1035: Wf_Load.Reseq_Message_Attribute(

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

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

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

Line 1349: x_log_message := Wf_Load.logbuf;

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

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

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

Line 1357: WF_LOAD.UPLOAD_ACTIVITY(

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

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

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

Line 1458: WF_LOAD.UPLOAD_ACTIVITY(

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

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

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

Line 1625: Wf_Load.Reseq_Activity_Attribute(

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

Line 1678: Wf_Load.Reseq_Activity_Attribute(

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

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

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

Line 1875: WF_LOAD.UPLOAD_ACTIVITY(

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

Line 1961: WF_LOAD.UPLOAD_PROCESS_ACTIVITY(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2953: Wf_Load.UPLOAD_MESSAGE(

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

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

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

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

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

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

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

Line 3222: Wf_Load.UPLOAD_ITEM_TYPE(

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

Line 3250: Wf_Load.UPLOAD_LOOKUP_TYPE (

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

Line 3271: Wf_Load.UPLOAD_LOOKUP (

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

Line 3307: Wf_Load.UPLOAD_ITEM_ATTRIBUTE(

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

Line 3333: Wf_Load.UPLOAD_MESSAGE (

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

Line 3386: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(

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

Line 3439: Wf_Load.UPLOAD_ACTIVITY (

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

Line 3501: Wf_Load.UPLOAD_ACTIVITY_ATTRIBUTE(

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

Line 3566: Wf_Load.UPLOAD_PROCESS_ACTIVITY (

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

Line 3615: Wf_Load.UPLOAD_ACTIVITY_TRANSITION (

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

Line 3644: Wf_Load.UPLOAD_ACTIVITY_ATTR_VALUE (

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3971: Wf_Load.GET_ACTIVITY (

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4496: Wf_Load.Get_Lookup(x_lookup_type, x_lookup_code,

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

Line 4512: Wf_Load.UPLOAD_LOOKUP(

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

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

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

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

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

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

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

Line 4636: if (Wf_Load.Activity_Exist_In_Process(

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

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

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

Line 4692: end WF_LOAD;

4688: end if;
4689: commit; --Commit the work.
4690: end;
4691:
4692: end WF_LOAD;