DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on WF_ACTIVITY_TRANSITIONS

Line 17: type t_transition_parent_list IS table of wf_activity_transitions.from_process_activity%type INDEX BY BINARY_INTEGER;

13: type t_parent_name IS table of amw_process.name%type INDEX BY BINARY_INTEGER;
14: v_parent_name t_parent_name;
15: type t_child_name IS table of amw_process.name%type INDEX BY BINARY_INTEGER;
16: v_child_name t_child_name;
17: type t_transition_parent_list IS table of wf_activity_transitions.from_process_activity%type INDEX BY BINARY_INTEGER;
18: v_transition_parent_list t_transition_parent_list;
19: type t_org_parent_id IS table of Amw_Process_Org_Relations.parent_process_id%type INDEX BY BINARY_INTEGER;
20: v_org_parent_id t_org_parent_id;
21: type t_org_child_id IS table of Amw_Process_Org_Relations.child_process_id%type INDEX BY BINARY_INTEGER;

Line 508: from wf_activity_transitions

504: procedure find_transition_children(p_instance_id in number)
505: is
506: cursor ct (l_instance_id number) is
507: select to_process_activity
508: from wf_activity_transitions
509: where from_process_activity = l_instance_id;
510:
511: ct_rec ct%rowtype;
512: