APPS.WIP_EAM_WORKREQUEST_PVT dependencies on WIP_EAM_PARAMETERS

Line 119: from wip_eam_parameters

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

Line 191: FROM wip_eam_parameters

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

Line 201: FROM WIP_EAM_PARAMETERS wep

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

Line 841: FROM WIP_EAM_PARAMETERS wep

837: -- Bug # 3574258
838: BEGIN
839: SELECT NVL(UPPER(work_request_asset_num_reqd),'Y')
840: INTO l_asset_num_reqd
841: FROM WIP_EAM_PARAMETERS wep
842: WHERE wep.organization_id = p_org_id;
843: EXCEPTION
844: WHEN NO_DATA_FOUND THEN
845: l_asset_num_reqd := 'Y';

Line 962: FROM WIP_EAM_PARAMETERS wep

958:
959: BEGIN
960: SELECT NVL(UPPER(wep.work_req_extended_log_flag), 'N'), NVL(UPPER(wep.work_request_auto_approve),'N')
961: INTO l_extended_log_flag, l_work_request_auto_approve
962: FROM WIP_EAM_PARAMETERS wep
963: WHERE wep.organization_id = p_org_id;
964:
965: EXCEPTION
966: WHEN OTHERS THEN

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

1024:
1025: END IF;
1026:
1027:
1028: -- Check the extended log setting from wip_eam_parameters
1029:
1030: IF (l_extended_log_flag = 'Y') THEN
1031: l_stmt_num := 140;
1032:

Line 2588: from wip_eam_parameters

2584:
2585: begin
2586: select nvl(work_request_auto_approve,'N')
2587: into l_auto_approve
2588: from wip_eam_parameters
2589: where organization_id = p_org_id;
2590: exception
2591: when others then
2592: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 2888: FROM WIP_EAM_PARAMETERS

2884:
2885: -- check if the org id is valid
2886: BEGIN
2887: SELECT WORK_REQUEST_AUTO_APPROVE INTO l_auto_approve
2888: FROM WIP_EAM_PARAMETERS
2889: WHERE organization_id = p_org_id;
2890: EXCEPTION
2891: WHEN NO_DATA_FOUND THEN
2892: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

Line 3228: from wip_eam_parameters

3224: BEGIN
3225: l_stmt_num := 50;
3226: select NVL(work_request_auto_approve,'N')
3227: into l_auto_approve_flag
3228: from wip_eam_parameters
3229: where organization_id = p_org_id;
3230: EXCEPTION
3231: WHEN no_data_found THEN
3232: l_auto_approve_flag := 'N';

Line 3431: from wip_eam_parameters

3427: IF (l_owning_dept_id is null) then
3428: -- select owning dept from eam parameters
3429: select default_department_id
3430: into l_owning_dept_id
3431: from wip_eam_parameters
3432: where organization_id = p_org_id;
3433: END IF;
3434: ELSE
3435: l_owning_dept_id := p_owning_dept_id;

Line 3488: FROM wip_eam_parameters

3484: --dbms_output.put_line('Inside: Work Reques ID ='||l_work_request_id);
3485:
3486: SELECT work_request_auto_approve
3487: INTO l_work_request_auto_approve
3488: FROM wip_eam_parameters
3489: WHERE organization_id = p_org_id;
3490:
3491: IF l_work_request_auto_approve = 'N' then
3492: