APPS.EAM_PARAMETERS_PUB dependencies on WIP_EAM_PARAMETERS

Line 73: FROM WIP_EAM_PARAMETERS

69: return boolean is
70: l_count number;
71: BEGIN
72: SELECT count(*) INTO l_count
73: FROM WIP_EAM_PARAMETERS
74: WHERE organization_id = p_organization_id;
75:
76: if l_count = 0
77: then

Line 261: FROM WIP_EAM_PARAMETERS

257: is
258: l_count number;
259: BEGIN
260: SELECT COUNT(*) INTO l_count
261: FROM WIP_EAM_PARAMETERS
262: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
263:
264: if (l_count = 0 and NOT p_create_flag)
265: then

Line 438: INSERT INTO WIP_EAM_PARAMETERS

434:
435: validate_boolean_flag(P_EAM_WO_WORKFLOW_ENABLED, 'EAM_WO_WORKFLOW_ENABLED');
436: validate_boolean_flag(P_AUTO_FIRM_ON_CREATE, 'EAM_AUTO_FIRM_ON_CREATE');
437:
438: INSERT INTO WIP_EAM_PARAMETERS
439: (
440: ORGANIZATION_ID ,
441: WORK_REQUEST_AUTO_APPROVE ,
442: DEF_MAINT_COST_CATEGORY ,

Line 689: UPDATE WIP_EAM_PARAMETERS

685: validate_boolean_flag(P_EAM_WO_WORKFLOW_ENABLED, 'EAM_WO_WORKFLOW_ENABLED');
686: validate_boolean_flag(P_AUTO_FIRM_ON_CREATE, 'EAM_AUTO_FIRM_ON_CREATE');
687:
688:
689: UPDATE WIP_EAM_PARAMETERS
690: SET
691: -- ORGANIZATION_ID = P_ORGANIZATION_ID ,
692: WORK_REQUEST_AUTO_APPROVE = P_WORK_REQUEST_AUTO_APPROVE ,
693: DEF_MAINT_COST_CATEGORY = P_DEF_MAINT_COST_CATEGORY ,