APPS.IEU_WR_PUB dependencies on IEU_UWQ_GET_NEXT_WORK_PVT

Line 2634: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,

2630: p_commit IN VARCHAR2 DEFAULT NULL,
2631: p_resource_id IN NUMBER,
2632: p_language IN VARCHAR2,
2633: p_source_lang IN VARCHAR2,
2634: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
2635: x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
2636: x_msg_count OUT NOCOPY NUMBER,
2637: x_msg_data OUT NOCOPY VARCHAR2,
2638: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;

2649: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2655:
2656: BEGIN
2657:

Line 2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;

2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2655:
2656: BEGIN
2657:
2658: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');

Line 2721: IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE

2717:
2718: end loop;
2719:
2720: -- Get the extra where clause for Distribute_from and distribute_to based ont he ws_code
2721: IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE
2722: (p_type => 'DELIVER',
2723: p_ws_det_list => p_ws_det_list,
2724: p_resource_id => p_resource_id,
2725: x_dist_from_where => l_dist_from_where,

Line 2732: IEU_UWQ_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER_WR_ITEM

2728: x_bindvar_to_list => l_bindvar_to_list );
2729:
2730: --dbms_output.put_line('calling dist and deliver.. ret status : '||x_return_status );
2731:
2732: IEU_UWQ_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER_WR_ITEM
2733: ( p_api_version => p_api_version,
2734: p_resource_id => p_resource_id,
2735: p_language => p_language,
2736: p_source_lang => p_source_lang,

Line 7819: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,

7815: p_commit IN VARCHAR2 DEFAULT NULL,
7816: p_resource_id IN NUMBER,
7817: p_language IN VARCHAR2,
7818: p_source_lang IN VARCHAR2,
7819: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
7820: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
7821: x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
7822: x_msg_count OUT NOCOPY NUMBER,
7823: x_msg_data OUT NOCOPY VARCHAR2,

Line 7890: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;

7886: l_workitem_status_id NUMBER;
7887: l_dist_status_id NUMBER;
7888: l_reschedule_time DATE;
7889: l_audit_log_id NUMBER;
7890: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
7891: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
7892:
7893:
7894: BEGIN

Line 7891: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;

7887: l_dist_status_id NUMBER;
7888: l_reschedule_time DATE;
7889: l_audit_log_id NUMBER;
7890: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
7891: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
7892:
7893:
7894: BEGIN
7895:

Line 7960: IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE

7956: end loop;
7957:
7958: -- Get the extra where clause for Distribute_from and distribute_to based on the ws_code
7959:
7960: IEU_UWQ_GET_NEXT_WORK_PVT.GET_WS_WHERE_CLAUSE
7961: (p_type => 'DELIVER',
7962: p_ws_det_list => p_ws_det_list,
7963: p_resource_id => p_resource_id,
7964: x_dist_from_where => l_dist_from_where,

Line 7973: IEU_UWQ_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER_WR_ITEM

7969: --insert into p_temp(msg) values ('from: '||l_dist_from_where); commit;
7970: --insert into p_temp(msg) values ('from: '||l_dist_to_where); commit;
7971:
7972: BEGIN
7973: IEU_UWQ_GET_NEXT_WORK_PVT.DISTRIBUTE_AND_DELIVER_WR_ITEM
7974: ( p_api_version => p_api_version,
7975: p_resource_id => p_resource_id,
7976: p_language => p_language,
7977: p_source_lang => p_source_lang,

Line 12160: l_ws_det_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST;

12156: x_return_status OUT nocopy VARCHAR2,
12157: x_msg_data OUT nocopy VARCHAR2) IS
12158:
12159: --declare variables
12160: l_ws_det_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST;
12161: l_uwqm_workitem_data IEU_FRM_PVT.T_IEU_MEDIA_DATA;
12162: l_language VARCHAR2(10);
12163: l_source_lang VARCHAR2(10);
12164: j number;