APPS.WF_LOAD dependencies on WF_ACTIVITY_TRANSITIONS

Line 2166: from WF_ACTIVITY_TRANSITIONS

2162: x_level_error := 0;
2163: begin
2164: select PROTECT_LEVEL, CUSTOM_LEVEL
2165: into protection_level, customization_level
2166: from WF_ACTIVITY_TRANSITIONS
2167: where FROM_PROCESS_ACTIVITY = x_from_process_activity
2168: and RESULT_CODE = x_result_code
2169: and TO_PROCESS_ACTIVITY = x_to_process_activity;
2170:

Line 2184: update WF_ACTIVITY_TRANSITIONS set

2180: return;
2181: end if;
2182:
2183: -- Update existing row
2184: update WF_ACTIVITY_TRANSITIONS set
2185: FROM_PROCESS_ACTIVITY = x_from_process_activity,
2186: RESULT_CODE = x_result_code,
2187: TO_PROCESS_ACTIVITY = x_to_process_activity,
2188: PROTECT_LEVEL = x_protect_level,

Line 2211: insert into WF_ACTIVITY_TRANSITIONS (

2207: return;
2208: end if;
2209:
2210: -- Insert new row
2211: insert into WF_ACTIVITY_TRANSITIONS (
2212: FROM_PROCESS_ACTIVITY,
2213: RESULT_CODE,
2214: TO_PROCESS_ACTIVITY,
2215: PROTECT_LEVEL,

Line 2842: delete WF_ACTIVITY_TRANSITIONS

2838: return;
2839: end if;
2840:
2841: if (p_next_step is null) then
2842: delete WF_ACTIVITY_TRANSITIONS
2843: where FROM_PROCESS_ACTIVITY = p_previous_step
2844: and RESULT_CODE = nvl(p_result_code, RESULT_CODE);
2845: else
2846: if (p_previous_step is null) then

Line 2847: delete WF_ACTIVITY_TRANSITIONS

2843: where FROM_PROCESS_ACTIVITY = p_previous_step
2844: and RESULT_CODE = nvl(p_result_code, RESULT_CODE);
2845: else
2846: if (p_previous_step is null) then
2847: delete WF_ACTIVITY_TRANSITIONS
2848: where TO_PROCESS_ACTIVITY = p_next_step
2849: and RESULT_CODE = nvl(p_result_code, RESULT_CODE);
2850: else
2851: -- both are non-null

Line 2852: delete WF_ACTIVITY_TRANSITIONS

2848: where TO_PROCESS_ACTIVITY = p_next_step
2849: and RESULT_CODE = nvl(p_result_code, RESULT_CODE);
2850: else
2851: -- both are non-null
2852: delete WF_ACTIVITY_TRANSITIONS
2853: where FROM_PROCESS_ACTIVITY = p_previous_step
2854: and RESULT_CODE = nvl(p_result_code, RESULT_CODE)
2855: and TO_PROCESS_ACTIVITY = p_next_step;
2856: end if;

Line 3165: from WF_ACTIVITY_TRANSITIONS

3161:
3162: cursor patcur(id in number) is
3163: select RESULT_CODE, TO_PROCESS_ACTIVITY, ARROW_GEOMETRY,
3164: PROTECT_LEVEL, CUSTOM_LEVEL
3165: from WF_ACTIVITY_TRANSITIONS
3166: where FROM_PROCESS_ACTIVITY = id
3167: order by RESULT_CODE;
3168:
3169: cursor aavcur(id in number) is

Line 4214: from WF_ACTIVITY_TRANSITIONS

4210: p_result_codes out NOCOPY t_resultcodeTab)
4211: is
4212: cursor rccur(from_act in number, to_act in number) is
4213: select RESULT_CODE
4214: from WF_ACTIVITY_TRANSITIONS
4215: where FROM_PROCESS_ACTIVITY = from_act
4216: and TO_PROCESS_ACTIVITY = to_act;
4217:
4218: cursor tpcur(from_act in number, res_code in varchar2) is

Line 4220: from WF_ACTIVITY_TRANSITIONS

4216: and TO_PROCESS_ACTIVITY = to_act;
4217:
4218: cursor tpcur(from_act in number, res_code in varchar2) is
4219: select TO_PROCESS_ACTIVITY
4220: from WF_ACTIVITY_TRANSITIONS
4221: where FROM_PROCESS_ACTIVITY = from_act
4222: and RESULT_CODE = res_code;
4223:
4224: cursor tp2cur(from_act in number) is

Line 4226: from WF_ACTIVITY_TRANSITIONS

4222: and RESULT_CODE = res_code;
4223:
4224: cursor tp2cur(from_act in number) is
4225: select TO_PROCESS_ACTIVITY, RESULT_CODE
4226: from WF_ACTIVITY_TRANSITIONS
4227: where FROM_PROCESS_ACTIVITY = from_act;
4228:
4229: cursor fpcur(to_act in number, res_code in varchar2) is
4230: select FROM_PROCESS_ACTIVITY

Line 4231: from WF_ACTIVITY_TRANSITIONS

4227: where FROM_PROCESS_ACTIVITY = from_act;
4228:
4229: cursor fpcur(to_act in number, res_code in varchar2) is
4230: select FROM_PROCESS_ACTIVITY
4231: from WF_ACTIVITY_TRANSITIONS
4232: where TO_PROCESS_ACTIVITY = to_act
4233: and RESULT_CODE = res_code;
4234:
4235: cursor fp2cur(to_act in number) is

Line 4237: from WF_ACTIVITY_TRANSITIONS

4233: and RESULT_CODE = res_code;
4234:
4235: cursor fp2cur(to_act in number) is
4236: select FROM_PROCESS_ACTIVITY, RESULT_CODE
4237: from WF_ACTIVITY_TRANSITIONS
4238: where TO_PROCESS_ACTIVITY = to_act;
4239:
4240: i pls_integer;
4241: begin

Line 4726: 'WF_ACTIVITY_TRANSITIONS',

4722: 'WF_ACTIVITIES_TL',
4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',
4730: 'WF_ITEM_TYPES_TL',