[Home] [Help]
11: PROCEDURE GET_NEXT_WORKITEM
12: ( p_api_version IN NUMBER,
13: p_resource_id IN NUMBER,
14: p_user_id IN NUMBER,
15: x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
16: x_msg_count OUT NOCOPY NUMBER,
17: x_msg_data OUT NOCOPY VARCHAR2,
18: x_return_status OUT NOCOPY VARCHAR2)
19: IS
25: END GET_NEXT_WORKITEM;
26:
27: PROCEDURE GET_WORKITEM_ACTION_FUNC_DATA
28: ( p_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data_rec,
29: x_workitem_action_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA )
30: AS
31:
32:
33: BEGIN
45: p_work_item_id IN NUMBER,
46: p_user_id IN NUMBER,
47: p_resource_id IN NUMBER,
48: p_worklist_cont_mode IN VARCHAR2,
49: x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
50: x_release_return_status OUT NOCOPY VARCHAR2,
51: x_release_msg_count OUT NOCOPY NUMBER,
52: x_release_msg_data OUT NOCOPY VARCHAR2,
53: x_nw_return_status OUT NOCOPY VARCHAR2,
930: p_dist_from_extra_where_clause IN VARCHAR2,
931: p_dist_to_extra_where_clause IN VARCHAR2,
932: p_bindvar_from_list IN IEU_UWQ_BINDVAR_LIST,
933: p_bindvar_to_list IN IEU_UWQ_BINDVAR_LIST,
934: x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
935: x_msg_count OUT NOCOPY NUMBER,
936: x_msg_data OUT NOCOPY VARCHAR2,
937: x_return_status OUT NOCOPY VARCHAR2) IS
938:
3835:
3836: /**
3837: ** Distribute Only returns the table of Records in a different format compared to Distribute and Deliver.
3838: ** This was required as Distribute Only can return multiple records. Distribute and Deliver requires the Return Record
3839: ** to be of type IEU_FRM_PVT.T_IEU_MEDIA_DATA for processing on the FORM.
3840: ** Called by PROCEDURE - DISTRIBUTE_AND_DELIVER_WR_ITEM
3841: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3842: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3843: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3841: ** The in var can be either a rec of type IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC OR
3842: ** table of objects SYSTEM.WR_ITEM_DATA_NST
3843: ** The In var - p_var_in_type_code indicates if its a record - 'REC' or an object - 'OBJ'
3844: ** Copies the Work Item data from table of objects - SYSTEM.WR_ITEM_DATA_NST or rec - IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC
3845: ** to table of records of type - IEU_FRM_PVT.T_IEU_MEDIA_DATA
3846: **/
3847:
3848: PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3849: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3848: PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
3849: p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
3850: p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
3851: x_ctr IN OUT NOCOPY NUMBER,
3852: x_workitem_action_data IN OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA) IS
3853:
3854:
3855: --l_ctr NUMBER := 0;
3856: l_enter_from_task VARCHAR2(1);