DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on MTL_PARAMETERS

Line 258: FROM mtl_parameters mp

254: NVL(mp.project_control_level,1)
255: INTO p_project_reference_enabled,
256: p_pm_cost_collection_enabled,
257: p_project_control_level
258: FROM mtl_parameters mp
259: WHERE organization_id = org_id ;
260:
261: EXCEPTION
262: WHEN OTHERS then

Line 449: FROM mtl_parameters

445: end if;
446:
447: SELECT NVL(project_reference_enabled,2), NVL(project_control_level,1)
448: INTO prj_ref_enabled, prj_cntrl_level
449: FROM mtl_parameters
450: WHERE organization_id = fm_org_id ;
451: /* We are going to get task ids no matter what the control level is
452: But are keeping reference for control level in case later we decide to
453: filter on this. So now, setting cntrl_level = 2 (task level)

Line 519: FROM mtl_parameters

515: end if;
516:
517: SELECT NVL(project_reference_enabled,2), NVL(project_control_level,1)
518: INTO to_org_prj_ref_enabled, to_org_prj_cntrl_level
519: FROM mtl_parameters
520: WHERE organization_id = to_org_id ;
521:
522: /* We are going to get task ids no matter what the control level is
523: But are keeping reference for control level in case later we decide to

Line 685: FROM mtl_parameters

681: end if;
682:
683: SELECT NVL(project_control_level,1)
684: INTO x_fm_org_project_control_level
685: FROM mtl_parameters
686: WHERE organization_id = v_org_id ;
687:
688: if ( v_txn_action_id = 3 ) then
689: SELECT NVL(project_control_level,1)

Line 691: FROM mtl_parameters

687:
688: if ( v_txn_action_id = 3 ) then
689: SELECT NVL(project_control_level,1)
690: INTO x_to_org_project_control_level
691: FROM mtl_parameters
692: WHERE organization_id = v_xfr_org_id ;
693: end if;
694:
695: /*

Line 1177: FROM mtl_parameters

1173: BEGIN
1174: success := 'TRUE';
1175: SELECT NVL(project_reference_enabled,2)
1176: INTO l_project_reference_enabled
1177: FROM mtl_parameters
1178: WHERE organization_id = p_org_id ;
1179:
1180: IF l_project_reference_enabled <> 1 THEN
1181: success := 'FALSE';