APPS.PJM_PROJECT_LOCATOR dependencies on PJM_PROJECT

Line 1: PACKAGE BODY PJM_PROJECT_LOCATOR AS

1: PACKAGE BODY PJM_PROJECT_LOCATOR AS
2: /* $Header: PJMPLOCB.pls 120.9 2011/02/25 08:19:34 yaoli ship $ */
3:
4: -- ---------------------------------------------------------------------
5: -- Global Variables

Line 40: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id );

36: BEGIN
37: if (p_project_id is null) then
38: l_prj_ref := 'NULL';
39: elsif (p_task_id is null) then
40: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id );
41: else
42: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id )
43: || ' , ' || pjm_project.all_task_idtonum( p_task_id );
44: end if;

Line 42: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id )

38: l_prj_ref := 'NULL';
39: elsif (p_task_id is null) then
40: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id );
41: else
42: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id )
43: || ' , ' || pjm_project.all_task_idtonum( p_task_id );
44: end if;
45: return (l_prj_ref);
46: END Get_Project_References;

Line 43: || ' , ' || pjm_project.all_task_idtonum( p_task_id );

39: elsif (p_task_id is null) then
40: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id );
41: else
42: l_prj_ref := pjm_project.all_proj_idtonum( p_project_id )
43: || ' , ' || pjm_project.all_task_idtonum( p_task_id );
44: end if;
45: return (l_prj_ref);
46: END Get_Project_References;
47:

Line 654: FROM pjm_project_parameters

650: CURSOR C_Proj_Param ( C_organization_id NUMBER
651: , C_project_id NUMBER) IS
652: SELECT planning_group
653: , nvl(costing_group_id,0)
654: FROM pjm_project_parameters
655: WHERE organization_id = C_organization_id
656: AND project_id = C_project_id;
657:
658:

Line 876: FROM pjm_projects_v

872: AND organization_id = org_id;
873:
874: CURSOR C_Proj (p_id NUMBER) IS
875: SELECT project_id
876: FROM pjm_projects_v
877: WHERE project_id = p_id;
878:
879: CURSOR C_Task (t_id NUMBER) IS
880: SELECT task_id

Line 961: if ( pjm_project.val_proj_idtonum( l_loc_project_id

957: CLOSE C_Proj;
958:
959: /* Check to see if project is enabled in current org */
960:
961: if ( pjm_project.val_proj_idtonum( l_loc_project_id
962: , p_organization_id ) is null ) then
963:
964: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
965: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));

Line 1689: G_project_number := pjm_project.all_proj_idtonum( p_project_id );

1685: ) IS
1686:
1687: begin
1688: if (p_project_id is not null) then
1689: G_project_number := pjm_project.all_proj_idtonum( p_project_id );
1690: if (p_task_id is not null) then
1691: G_task_number := pjm_project.all_task_idtonum( p_task_id );
1692: --BUG Fix 4590465
1693: else

Line 1691: G_task_number := pjm_project.all_task_idtonum( p_task_id );

1687: begin
1688: if (p_project_id is not null) then
1689: G_project_number := pjm_project.all_proj_idtonum( p_project_id );
1690: if (p_task_id is not null) then
1691: G_task_number := pjm_project.all_task_idtonum( p_task_id );
1692: --BUG Fix 4590465
1693: else
1694: G_task_number := NULL;
1695:

Line 1726: END PJM_PROJECT_LOCATOR;

1722: begin
1723: return(G_Task_Number);
1724: end Task_Seg_Default;
1725:
1726: END PJM_PROJECT_LOCATOR;