APPS.WF_LOAD dependencies on WF_ACTIVITY_TRANSITIONS

Line 2165: from WF_ACTIVITY_TRANSITIONS

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

Line 2183: update WF_ACTIVITY_TRANSITIONS set

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

Line 2210: insert into WF_ACTIVITY_TRANSITIONS (

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

Line 2841: delete WF_ACTIVITY_TRANSITIONS

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

Line 2846: delete WF_ACTIVITY_TRANSITIONS

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

Line 2851: delete WF_ACTIVITY_TRANSITIONS

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

Line 3164: from WF_ACTIVITY_TRANSITIONS

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

Line 4213: from WF_ACTIVITY_TRANSITIONS

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

Line 4219: from WF_ACTIVITY_TRANSITIONS

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

Line 4225: from WF_ACTIVITY_TRANSITIONS

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

Line 4230: from WF_ACTIVITY_TRANSITIONS

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

Line 4236: from WF_ACTIVITY_TRANSITIONS

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