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 437: INSERT INTO WIP_EAM_PARAMETERS

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

Line 685: UPDATE WIP_EAM_PARAMETERS

681: validate_boolean_flag(P_EAM_WO_WORKFLOW_ENABLED, 'EAM_WO_WORKFLOW_ENABLED');
682: validate_boolean_flag(P_AUTO_FIRM_ON_CREATE, 'EAM_AUTO_FIRM_ON_CREATE');
683:
684:
685: UPDATE WIP_EAM_PARAMETERS
686: SET
687: -- ORGANIZATION_ID = P_ORGANIZATION_ID ,
688: WORK_REQUEST_AUTO_APPROVE = P_WORK_REQUEST_AUTO_APPROVE ,
689: DEF_MAINT_COST_CATEGORY = P_DEF_MAINT_COST_CATEGORY ,