APPS.PJM_PROJECT dependencies on PJM_PROJECT

Line 1: package body PJM_PROJECT as

1: package body PJM_PROJECT as
2: /* $Header: PJMPROJB.pls 120.7.12010000.2 2008/09/17 06:43:10 ybabulal ship $ */
3:
4: FUNCTION Proj_Or_Seiban
5: ( X_project_id IN NUMBER

Line 164: from PJM_PROJECTS_ORG_OU_SECURE_V /*Bug 6684081: Changed the view that should be used for MOAC. This API is called by OM team.*/

160: L_project_num varchar2(30);
161: L_dummy number;
162: cursor C1 is
163: select project_number
164: from PJM_PROJECTS_ORG_OU_SECURE_V /*Bug 6684081: Changed the view that should be used for MOAC. This API is called by OM team.*/
165: where project_id = X_project_id;
166:
167: cursor C2 is
168: select 1

Line 169: from pjm_project_parameters

165: where project_id = X_project_id;
166:
167: cursor C2 is
168: select 1
169: from pjm_project_parameters
170: where project_id = X_project_id
171: and organization_id = X_organization_id;
172:
173: -- Bug Fix 7337239

Line 176: from PJM_PROJECTS_V

172:
173: -- Bug Fix 7337239
174: cursor C3 is
175: select project_number
176: from PJM_PROJECTS_V
177: where project_id = X_project_id;
178:
179: begin
180:

Line 217: from pjm_projects_v

213: L_project_name varchar2(30);
214: L_dummy number;
215: cursor C1 is
216: select project_name
217: from pjm_projects_v
218: where project_id = X_project_id;
219:
220: cursor C2 is
221: select 1

Line 222: from pjm_project_parameters

218: where project_id = X_project_id;
219:
220: cursor C2 is
221: select 1
222: from pjm_project_parameters
223: where project_id = X_project_id
224: and organization_id = X_organization_id;
225:
226: begin

Line 258: from pjm_projects_v

254: L_project_id number;
255: L_dummy number;
256: cursor C1 is
257: select project_id
258: from pjm_projects_v
259: where project_number = X_project_num;
260:
261: cursor C2 is
262: select 1

Line 263: from pjm_project_parameters

259: where project_number = X_project_num;
260:
261: cursor C2 is
262: select 1
263: from pjm_project_parameters
264: where project_id = L_project_id
265: and organization_id = X_organization_id;
266:
267: begin

Line 299: from pjm_projects_v

295: L_project_id number;
296: L_dummy number;
297: cursor C1 is
298: select project_id
299: from pjm_projects_v
300: where project_name = X_project_name;
301:
302: cursor C2 is
303: select 1

Line 304: from pjm_project_parameters

300: where project_name = X_project_name;
301:
302: cursor C2 is
303: select 1
304: from pjm_project_parameters
305: where project_id = L_project_id
306: and organization_id = X_organization_id;
307:
308: begin

Line 667: decode(PJM_PROJECT.Is_Exp_Proj(p.project_id,L_operating_unit),

663: cursor proj is
664: select p.segment1
665: , decode(pp.project_id ,
666: null , 'GEN-INVALID PROJ FOR ORG',
667: decode(PJM_PROJECT.Is_Exp_Proj(p.project_id,L_operating_unit),
668: 'Y', null,
669: decode(p.org_id,
670: L_operating_unit, 'GEN-INVALID PROJ' ,
671: 'GEN-INVALID PROJ FOR OU')))

Line 677: , pjm_project_parameters pp

673: , trunc(p.completion_date)
674: , trunc(pp.start_date_active)
675: , trunc(pp.end_date_active)
676: from pa_projects_all p
677: , pjm_project_parameters pp
678: where p.project_id = X_project_id
679: and pp.project_id (+) = p.project_id
680: and pp.organization_id (+) = X_inventory_org_id;
681:

Line 691: , pjm_project_parameters pp

687: , to_date(null)
688: , trunc(pp.start_date_active)
689: , trunc(pp.end_date_active)
690: from pjm_seiban_numbers sn
691: , pjm_project_parameters pp
692: where sn.project_id = X_project_id
693: and pp.organization_id (+) = X_inventory_org_id
694: and pp.project_id (+) = sn.project_id;
695:

Line 766: projflag := pjm_project.proj_or_seiban(X_project_id);

762: failures := failures + 1;
763: end if;
764:
765: L_operating_unit := nvl( X_operating_unit , Org_ID(X_inventory_org_id) );
766: projflag := pjm_project.proj_or_seiban(X_project_id);
767:
768: --
769: -- Now validating project reference; invalid if cursor returns
770: -- retcode value

Line 959: retsts := PJM_PROJECT_EXT.validate_proj_references

955:
956: --
957: -- Calling extension routine for any custom validations
958: --
959: retsts := PJM_PROJECT_EXT.validate_proj_references
960: ( X_inventory_org_id => X_inventory_org_id
961: , X_operating_unit => L_operating_unit
962: , X_project_id => X_project_id
963: , X_task_id => X_task_id

Line 1015: fnd_msg_pub.add_exc_msg( p_pkg_name => 'PJM_PROJECT'

1011: return ( G_VALIDATE_WARNING );
1012:
1013: when others then
1014: if fnd_msg_pub.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1015: fnd_msg_pub.add_exc_msg( p_pkg_name => 'PJM_PROJECT'
1016: , p_procedure_name => 'VALIDATE_PROJ_REFERENCES' );
1017: end if;
1018: return ( G_VALIDATE_FAILURE );
1019: end validate_proj_references;

Line 1022: end PJM_PROJECT;

1018: return ( G_VALIDATE_FAILURE );
1019: end validate_proj_references;
1020:
1021:
1022: end PJM_PROJECT;