APPS.AMW_WF_HIERARCHY_PKG dependencies on WF_ACTIVITIES

Line 971: wf_activities wa

967:
968: select wpa.instance_id
969: into instance_id
970: from wf_process_activities wpa,
971: wf_activities wa
972: where wpa.process_item_type = 'AUDITMGR'
973: and wpa.process_name = p_process_name
974: and wpa.process_name = wa.name
975: and wa.end_date is null

Line 1645: from wf_activities_tl watl, wf_activities wa, amw_process ap

1641: where party_id = p_process_owner_party_id;
1642:
1643: select watl.display_name
1644: into l_parent_disp_name
1645: from wf_activities_tl watl, wf_activities wa, amw_process ap
1646: where ap.process_id = p_parent_process_id
1647: and ap.name = wa.name
1648: and wa.item_type = 'AUDITMGR'
1649: and wa.end_date is null

Line 1657: from wf_activities_tl watl, wf_activities wa, amw_process ap

1653: and watl.language = userenv('LANG');
1654:
1655: select watl.display_name
1656: into l_child_disp_name
1657: from wf_activities_tl watl, wf_activities wa, amw_process ap
1658: where ap.process_id = p_child_process_id
1659: and ap.name = wa.name
1660: and wa.item_type = 'AUDITMGR'
1661: and wa.end_date is null

Line 2900: type t_wf_name is table of wf_activities.name%type;

2896: v_amwp_name_pid t_amwp_name_pid;
2897: */
2898: -- added by abedajna
2899: /*
2900: type t_wf_name is table of wf_activities.name%type;
2901: v_wf_name t_wf_name;
2902: type t_wf_name_table IS table of t_wf_name index by binary_integer;
2903: v_wf_name_table t_wf_name_table;
2904: */

Line 3145: -- endate these processes in wf_activities and call wf purge api's to delete them

3141: FORALL v_ind IN 1..delete_row_cnt
3142: DELETE from amw_process
3143: where name = v_delete_list(v_ind);
3144:
3145: -- endate these processes in wf_activities and call wf purge api's to delete them
3146: FORALL v_ind IN 1..delete_row_cnt
3147: update wf_activities
3148: set end_date = sysdate
3149: where name = v_delete_list(v_ind)

Line 3147: update wf_activities

3143: where name = v_delete_list(v_ind);
3144:
3145: -- endate these processes in wf_activities and call wf purge api's to delete them
3146: FORALL v_ind IN 1..delete_row_cnt
3147: update wf_activities
3148: set end_date = sysdate
3149: where name = v_delete_list(v_ind)
3150: and item_type = 'AUDITMGR'
3151: and end_date is null;

Line 3186: (select name from wf_activities w where w.name = a.name and w.item_type = 'AUDITMGR' and w.end_date is null);

3182: close exceptions_to_be_del;
3183:
3184: -- delete those process rows from amw_process which have been deleted from wf
3185: delete from amw_process a where not exists
3186: (select name from wf_activities w where w.name = a.name and w.item_type = 'AUDITMGR' and w.end_date is null);
3187:
3188: --populate_proc_flatlist;
3189: --reset_org_count;
3190: --reset_process_risk_ctrl_count;

Line 3398: -- endate these processes in wf_activities and call wf purge api's to delete them

3394: FORALL v_ind IN 1..delete_row_cnt
3395: DELETE from amw_process
3396: where name = v_delete_list(v_ind);
3397:
3398: -- endate these processes in wf_activities and call wf purge api's to delete them
3399: FORALL v_ind IN 1..delete_row_cnt
3400: update wf_activities
3401: set end_date = sysdate
3402: where name = v_delete_list(v_ind)

Line 3400: update wf_activities

3396: where name = v_delete_list(v_ind);
3397:
3398: -- endate these processes in wf_activities and call wf purge api's to delete them
3399: FORALL v_ind IN 1..delete_row_cnt
3400: update wf_activities
3401: set end_date = sysdate
3402: where name = v_delete_list(v_ind)
3403: and item_type = 'AUDITMGR'
3404: and end_date is null;

Line 3439: (select name from wf_activities w where w.name = a.name and w.item_type = 'AUDITMGR' and w.end_date is null);

3435: close exceptions_to_be_del;
3436:
3437: -- delete those process rows from amw_process which have been deleted from wf
3438: delete from amw_process a where not exists
3439: (select name from wf_activities w where w.name = a.name and w.item_type = 'AUDITMGR' and w.end_date is null);
3440:
3441: populate_proc_flatlist;
3442: reset_org_count;
3443: reset_process_risk_ctrl_count;