APPS.WIP_EAM_WORKREQUEST_PVT dependencies on WIP_EAM_PARAMETERS

Line 120: from wip_eam_parameters

116: l_stmt_num := 60;
117: BEGIN
118: select NVL(work_request_auto_approve,'N')
119: into l_auto_approve_flag
120: from wip_eam_parameters
121: where organization_id = p_org_id;
122: EXCEPTION
123: WHEN OTHERS THEN
124: l_auto_approve_flag := 'N';

Line 192: FROM wip_eam_parameters

188: -- if asset does not have owning dept,
189: -- get owning dept from eam parameter
190: SELECT default_department_id
191: INTO l_owning_dept_id
192: FROM wip_eam_parameters
193: WHERE organization_id = p_org_id;
194: else
195: l_owning_dept_id := p_owning_dept_id;
196: end if;

Line 202: FROM WIP_EAM_PARAMETERS wep

198:
199: BEGIN
200: SELECT NVL(UPPER(wep.work_request_auto_approve),'N'), NVL(UPPER(work_request_asset_num_reqd),'Y')
201: INTO l_work_request_auto_approve, l_asset_num_reqd
202: FROM WIP_EAM_PARAMETERS wep
203: WHERE wep.organization_id = p_org_id;
204: EXCEPTION
205: WHEN OTHERS THEN
206: l_work_request_auto_approve := 'N';

Line 859: FROM WIP_EAM_PARAMETERS wep

855: -- Bug # 3574258
856: BEGIN
857: SELECT NVL(UPPER(work_request_asset_num_reqd),'Y')
858: INTO l_asset_num_reqd
859: FROM WIP_EAM_PARAMETERS wep
860: WHERE wep.organization_id = p_org_id;
861: EXCEPTION
862: WHEN NO_DATA_FOUND THEN
863: l_asset_num_reqd := 'Y';

Line 992: FROM WIP_EAM_PARAMETERS wep

988:
989: BEGIN
990: SELECT NVL(UPPER(wep.work_req_extended_log_flag), 'N'), NVL(UPPER(wep.work_request_auto_approve),'N')
991: INTO l_extended_log_flag, l_work_request_auto_approve
992: FROM WIP_EAM_PARAMETERS wep
993: WHERE wep.organization_id = p_org_id;
994:
995: EXCEPTION
996: WHEN OTHERS THEN

Line 1001: -- Check the extended log setting from wip_eam_parameters

997: l_extended_log_flag := 'Y';
998: END;
999:
1000:
1001: -- Check the extended log setting from wip_eam_parameters
1002:
1003: IF (l_extended_log_flag = 'Y') THEN
1004: l_stmt_num := 140;
1005:

Line 2635: from wip_eam_parameters

2631:
2632: begin
2633: select nvl(work_request_auto_approve,'N')
2634: into l_auto_approve
2635: from wip_eam_parameters
2636: where organization_id = p_org_id;
2637: exception
2638: when others then
2639: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 2944: FROM WIP_EAM_PARAMETERS

2940:
2941: -- check if the org id is valid
2942: BEGIN
2943: SELECT WORK_REQUEST_AUTO_APPROVE INTO l_auto_approve
2944: FROM WIP_EAM_PARAMETERS
2945: WHERE organization_id = p_org_id;
2946: EXCEPTION
2947: WHEN NO_DATA_FOUND THEN
2948: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3290: from wip_eam_parameters

3286: BEGIN
3287: l_stmt_num := 50;
3288: select NVL(work_request_auto_approve,'N')
3289: into l_auto_approve_flag
3290: from wip_eam_parameters
3291: where organization_id = p_org_id;
3292: EXCEPTION
3293: WHEN no_data_found THEN
3294: l_auto_approve_flag := 'N';

Line 3493: from wip_eam_parameters

3489: IF (l_owning_dept_id is null) then
3490: -- select owning dept from eam parameters
3491: select default_department_id
3492: into l_owning_dept_id
3493: from wip_eam_parameters
3494: where organization_id = p_org_id;
3495: END IF;
3496: ELSE
3497: l_owning_dept_id := p_owning_dept_id;

Line 3550: FROM wip_eam_parameters

3546: --dbms_output.put_line('Inside: Work Reques ID ='||l_work_request_id);
3547:
3548: SELECT work_request_auto_approve
3549: INTO l_work_request_auto_approve
3550: FROM wip_eam_parameters
3551: WHERE organization_id = p_org_id;
3552:
3553: IF l_work_request_auto_approve = 'N' then
3554: