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.5 2006/09/20 02:03:10 exlin noship $ */
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 636: FROM pjm_project_parameters

632: CURSOR C_Proj_Param ( C_organization_id NUMBER
633: , C_project_id NUMBER) IS
634: SELECT planning_group
635: , nvl(costing_group_id,0)
636: FROM pjm_project_parameters
637: WHERE organization_id = C_organization_id
638: AND project_id = C_project_id;
639:
640: BEGIN

Line 822: FROM pjm_projects_v

818: AND organization_id = org_id;
819:
820: CURSOR C_Proj (p_id NUMBER) IS
821: SELECT project_id
822: FROM pjm_projects_v
823: WHERE project_id = p_id;
824:
825: CURSOR C_Task (t_id NUMBER) IS
826: SELECT task_id

Line 907: if ( pjm_project.val_proj_idtonum( l_loc_project_id

903: CLOSE C_Proj;
904:
905: /* Check to see if project is enabled in current org */
906:
907: if ( pjm_project.val_proj_idtonum( l_loc_project_id
908: , p_organization_id ) is null ) then
909:
910: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
911: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));

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

1626: ) IS
1627:
1628: begin
1629: if (p_project_id is not null) then
1630: G_project_number := pjm_project.all_proj_idtonum( p_project_id );
1631: if (p_task_id is not null) then
1632: G_task_number := pjm_project.all_task_idtonum( p_task_id );
1633: --BUG Fix 4590465
1634: else

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

1628: begin
1629: if (p_project_id is not null) then
1630: G_project_number := pjm_project.all_proj_idtonum( p_project_id );
1631: if (p_task_id is not null) then
1632: G_task_number := pjm_project.all_task_idtonum( p_task_id );
1633: --BUG Fix 4590465
1634: else
1635: G_task_number := NULL;
1636:

Line 1667: END PJM_PROJECT_LOCATOR;

1663: begin
1664: return(G_Task_Number);
1665: end Task_Seg_Default;
1666:
1667: END PJM_PROJECT_LOCATOR;