APPS.AMW_WF_HIERARCHY_PKG dependencies on WF_PURGE

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 3153: --wf_purge.Items(

3149: where name = v_delete_list(v_ind)
3150: and item_type = 'AUDITMGR'
3151: and end_date is null;
3152:
3153: --wf_purge.Items(
3154: -- itemtype => 'AUDITMGR',
3155: -- docommit => false);
3156: --wf_purge.Activities(
3157: -- itemtype => 'AUDITMGR');

Line 3156: --wf_purge.Activities(

3152:
3153: --wf_purge.Items(
3154: -- itemtype => 'AUDITMGR',
3155: -- docommit => false);
3156: --wf_purge.Activities(
3157: -- itemtype => 'AUDITMGR');
3158:
3159: v_child_name.delete;
3160: child_num := 0;

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 3406: wf_purge.Items(

3402: where name = v_delete_list(v_ind)
3403: and item_type = 'AUDITMGR'
3404: and end_date is null;
3405:
3406: wf_purge.Items(
3407: itemtype => 'AUDITMGR',
3408: docommit => false);
3409: wf_purge.Activities(
3410: itemtype => 'AUDITMGR');

Line 3409: wf_purge.Activities(

3405:
3406: wf_purge.Items(
3407: itemtype => 'AUDITMGR',
3408: docommit => false);
3409: wf_purge.Activities(
3410: itemtype => 'AUDITMGR');
3411:
3412: v_child_name.delete;
3413: child_num := 0;