eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_REP_UTIL dependencies on PA_PROJECTS_ALL

Line 98: SELECT ppa.project_id from PA_PROJECTS_ALL ppa, PA_PROJ_ELEM_VER_STRUCTURE ppevs WHERE

94: , last_updated_by, creation_date, created_by, last_update_login, attribute1, attribute2)
95: SELECT 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,
96: Fnd_Global.USER_ID,SYSDATE,Fnd_Global.USER_ID,Fnd_Global.LOGIN_ID,p_wbs_version_id_tbl(l_i),'N'
97: FROM dual WHERE exists (
98: SELECT ppa.project_id from PA_PROJECTS_ALL ppa, PA_PROJ_ELEM_VER_STRUCTURE ppevs WHERE
99: ppa.project_id = ppevs.project_id AND
100: ppevs.ELEMENT_VERSION_ID = p_wbs_version_id_tbl(l_i) AND
101: ppa.template_flag <> 'Y'
102: );

Line 119: PA_PROJECTS_ALL prj

115: index(prg PJI_XBS_DENORM_N1) */
116: distinct(prg.SUP_ID) SUP_ID
117: from
118: PJI_XBS_DENORM prg,
119: PA_PROJECTS_ALL prj
120: where
121: prg.STRUCT_VERSION_ID is null and
122: prg.SUB_ID = p_wbs_version_id_tbl(l_i) and
123: prg.SUP_PROJECT_ID = prj.PROJECT_ID and

Line 845: pa_projects_all projects,

841:
842: SELECT org.gl_calendar_id,org.pa_calendar_id
843: INTO l_gl_calendar_id, l_pa_calendar_id
844: FROM
845: pa_projects_all projects,
846: pji_org_extr_info org
847: /* WHERE NVL(projects.org_id,-99) = NVL(org.org_id,-99) -- Added NVL for bug 3989132 */
848: WHERE projects.org_id = org.org_id -- Removed NVL for Bug5376591
849: AND projects.project_id = p_project_id;

Line 1260: ** currency code: derive project currency code from pa_projects_all.

1256: -- IF g_project_id <> p_project_id THEN
1257: /*
1258: ** Following are the defaulting rules:
1259: ** currency rec type: always project currency (8).
1260: ** currency code: derive project currency code from pa_projects_all.
1261: ** currency_type: always project currency 'P'.
1262: */
1263: Derive_Project_Attributes(p_project_id, x_return_status, x_msg_count, x_msg_data);
1264: -- END IF;

Line 1479: FROM pa_projects_all prj

1475: , g_projfunc_currency_code
1476: , g_prg_flag
1477: , g_gl_calendar_id
1478: , g_pa_calendar_id
1479: FROM pa_projects_all prj
1480: , pji_org_extr_info info
1481: WHERE project_id = p_project_id
1482: /* AND NVL(info.org_id,-99) = NVL(prj.org_id,-99); -- Added NVL for bug 3989132 */
1483: AND info.org_id = prj.org_id; -- Removed NVL for Bug5376591

Line 1838: FROM pa_projects_all

1834: END IF;
1835:
1836: SELECT start_date,NVL(completion_date,TRUNC(SYSDATE))
1837: INTO l_start_date, l_end_date
1838: FROM pa_projects_all
1839: WHERE project_id = p_project_id;
1840:
1841: IF p_calendar_id = -1 THEN
1842:

Line 2351: FROM pji_org_extr_info info, pa_projects_all proj

2347: x_calendar_id := -1;
2348: ELSE
2349: SELECT info.gl_calendar_id, info.pa_calendar_id
2350: INTO l_gl_calendar_id, l_pa_calendar_id
2351: FROM pji_org_extr_info info, pa_projects_all proj
2352: WHERE info.org_id = proj.org_id
2353: AND proj.project_id = p_project_id;
2354:
2355: IF p_calendar_type = 'G' THEN

Line 2402: pa_projects_all proj

2398: params.value
2399: INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
2400: FROM pji_org_extr_info info,
2401: pji_system_parameters params,
2402: pa_projects_all proj
2403: WHERE proj.project_id = p_project_id
2404: AND info.org_id = proj.org_id
2405: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
2406:

Line 2568: l_struct_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;

2564:
2565: FUNCTION get_work_plan_actual_version(p_project_id NUMBER
2566: ) RETURN NUMBER
2567: IS
2568: l_struct_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;
2569: BEGIN
2570:
2571: IF g_debug_mode = 'Y' THEN
2572: Pji_Utils.WRITE2LOG( 'get_work_plan_actual_version: begining', TRUE , g_proc);

Line 3304: FROM pa_projects_all p

3300: END IF;
3301:
3302: SELECT DISTINCT UPPER(t.project_type_class_code)
3303: INTO x_project_type
3304: FROM pa_projects_all p
3305: , pa_project_types_all t
3306: WHERE 1=1
3307: AND p.project_id = p_project_Id
3308: AND p.project_type = t.project_type

Line 3434: FROM pa_projects_all

3430: FROM dual;
3431:
3432: SELECT org_id
3433: INTO l_project_org
3434: FROM pa_projects_all
3435: WHERE project_id = p_project_id;
3436:
3437: IF l_env_org = l_project_org THEN
3438: x_cross_org_flag := 'F';

Line 3462: ( p_project_id IN pa_projects_all.project_id%TYPE

3458: This is a wrapper API which does the consistency check
3459: for program in workplan context.
3460: */
3461: PROCEDURE CHECK_WP_PARAM_CONSISTENCY
3462: ( p_project_id IN pa_projects_all.project_id%TYPE
3463: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3464: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3465: ,p_published_flag IN VARCHAR2
3466: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE

Line 3467: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE

3463: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3464: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3465: ,p_published_flag IN VARCHAR2
3466: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3467: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3468: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
3469: ,x_pc_flag OUT NOCOPY VARCHAR2
3470: ,x_pfc_flag OUT NOCOPY VARCHAR2
3471: ,x_margin_flag OUT NOCOPY VARCHAR2

Line 3605: ( p_project_id IN pa_projects_all.project_id%TYPE

3601: check if all the projects in the program hierarchy contain
3602: the same project and project functional currency.
3603: */
3604: PROCEDURE CHECK_WP_CURRENCY_CONSISTENCY
3605: ( p_project_id IN pa_projects_all.project_id%TYPE
3606: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3607: ,x_pc_flag OUT NOCOPY VARCHAR2
3608: ,x_pfc_flag OUT NOCOPY VARCHAR2
3609: ,x_return_status OUT NOCOPY VARCHAR2

Line 3614: CURSOR get_proj_currency_details(c_project_id pa_projects_all.project_id%TYPE)

3610: ,x_msg_count OUT NOCOPY NUMBER
3611: ,x_msg_data OUT NOCOPY VARCHAR2)
3612: AS
3613:
3614: CURSOR get_proj_currency_details(c_project_id pa_projects_all.project_id%TYPE)
3615: IS
3616: SELECT project_currency_code,projfunc_currency_code
3617: FROM pa_projects_all
3618: WHERE project_id = c_project_id;

Line 3617: FROM pa_projects_all

3613:
3614: CURSOR get_proj_currency_details(c_project_id pa_projects_all.project_id%TYPE)
3615: IS
3616: SELECT project_currency_code,projfunc_currency_code
3617: FROM pa_projects_all
3618: WHERE project_id = c_project_id;
3619:
3620: CURSOR check_project_currency(c_project_id pa_projects_all.project_id%TYPE,
3621: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,

Line 3620: CURSOR check_project_currency(c_project_id pa_projects_all.project_id%TYPE,

3616: SELECT project_currency_code,projfunc_currency_code
3617: FROM pa_projects_all
3618: WHERE project_id = c_project_id;
3619:
3620: CURSOR check_project_currency(c_project_id pa_projects_all.project_id%TYPE,
3621: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3622: c_currency_code pa_projects_all.project_currency_code%TYPE)
3623: IS
3624: SELECT 1

Line 3622: c_currency_code pa_projects_all.project_currency_code%TYPE)

3618: WHERE project_id = c_project_id;
3619:
3620: CURSOR check_project_currency(c_project_id pa_projects_all.project_id%TYPE,
3621: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3622: c_currency_code pa_projects_all.project_currency_code%TYPE)
3623: IS
3624: SELECT 1
3625: FROM pji_xbs_denorm denorm,
3626: pa_proj_elements ele,

Line 3627: pa_projects_all proj

3623: IS
3624: SELECT 1
3625: FROM pji_xbs_denorm denorm,
3626: pa_proj_elements ele,
3627: pa_projects_all proj
3628: WHERE denorm.sup_project_id = c_project_id
3629: AND denorm.sup_id = c_wbs_version_id
3630: AND denorm.struct_type = 'PRG'
3631: AND denorm.struct_version_id IS NULL

Line 3636: CURSOR check_projfunc_currency(c_project_id pa_projects_all.project_id%TYPE,

3632: AND denorm.sub_emt_id = ele.proj_element_id
3633: AND ele.project_id = proj.project_id
3634: AND proj.project_currency_code <> c_currency_code;
3635:
3636: CURSOR check_projfunc_currency(c_project_id pa_projects_all.project_id%TYPE,
3637: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3638: c_currency_code pa_projects_all.project_currency_code%TYPE)
3639: IS
3640: SELECT 1

Line 3638: c_currency_code pa_projects_all.project_currency_code%TYPE)

3634: AND proj.project_currency_code <> c_currency_code;
3635:
3636: CURSOR check_projfunc_currency(c_project_id pa_projects_all.project_id%TYPE,
3637: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3638: c_currency_code pa_projects_all.project_currency_code%TYPE)
3639: IS
3640: SELECT 1
3641: FROM pji_xbs_denorm denorm,
3642: pa_proj_elements ele,

Line 3643: pa_projects_all proj

3639: IS
3640: SELECT 1
3641: FROM pji_xbs_denorm denorm,
3642: pa_proj_elements ele,
3643: pa_projects_all proj
3644: WHERE denorm.sup_project_id = c_project_id
3645: AND denorm.sup_id = c_wbs_version_id
3646: AND denorm.struct_type = 'PRG'
3647: AND denorm.struct_version_id IS NULL

Line 3665: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

3661: l_debug_level5 CONSTANT NUMBER := 5;
3662:
3663: l_module_name VARCHAR2(100) := 'pa.plsql.CHECK_WP_CURRENCY_CONSISTENCY';
3664:
3665: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3666: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3667: l_dummy NUMBER;
3668:
3669: BEGIN

Line 3666: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

3662:
3663: l_module_name VARCHAR2(100) := 'pa.plsql.CHECK_WP_CURRENCY_CONSISTENCY';
3664:
3665: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
3666: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
3667: l_dummy NUMBER;
3668:
3669: BEGIN
3670: x_msg_count := 0;

Line 3735: ( p_project_id IN pa_projects_all.project_id%TYPE

3731: check if all the linked structure versions in the
3732: program hierarchy have the same margin mask.
3733: */
3734: PROCEDURE CHECK_WP_MARGIN_CONSISTENCY
3735: ( p_project_id IN pa_projects_all.project_id%TYPE
3736: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3737: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3738: ,x_margin_flag OUT NOCOPY VARCHAR2
3739: ,x_return_status OUT NOCOPY VARCHAR2

Line 3744: CURSOR check_margin_mask(c_project_id pa_projects_all.project_id%TYPE,

3740: ,x_msg_count OUT NOCOPY NUMBER
3741: ,x_msg_data OUT NOCOPY VARCHAR2)
3742: AS
3743:
3744: CURSOR check_margin_mask(c_project_id pa_projects_all.project_id%TYPE,
3745: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3746: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)
3747: IS
3748: SELECT 1

Line 3832: ( p_project_id IN pa_projects_all.project_id%TYPE

3828: have the same status. ie published/not published.
3829: */
3830:
3831: PROCEDURE CHECK_WP_STATUS_CONSISTENCY
3832: ( p_project_id IN pa_projects_all.project_id%TYPE
3833: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3834: ,p_published_flag IN VARCHAR2
3835: ,x_workpub_flag OUT NOCOPY VARCHAR2
3836: ,x_return_status OUT NOCOPY VARCHAR2

Line 3841: CURSOR check_published_flag(c_project_id pa_projects_all.project_id%TYPE,

3837: ,x_msg_count OUT NOCOPY NUMBER
3838: ,x_msg_data OUT NOCOPY VARCHAR2)
3839: AS
3840:
3841: CURSOR check_published_flag(c_project_id pa_projects_all.project_id%TYPE,
3842: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3843: c_published_flag VARCHAR2)
3844: IS
3845: SELECT 1

Line 3925: ( p_project_id IN pa_projects_all.project_id%TYPE

3921: check if all the structure versions in the program hierarchy have
3922: same time phasing.
3923: */
3924: PROCEDURE CHECK_WP_TIME_CONSISTENCY
3925: ( p_project_id IN pa_projects_all.project_id%TYPE
3926: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3927: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3928: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3929: ,x_time_phase_flag OUT NOCOPY VARCHAR2

Line 3928: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE

3924: PROCEDURE CHECK_WP_TIME_CONSISTENCY
3925: ( p_project_id IN pa_projects_all.project_id%TYPE
3926: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3927: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3928: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3929: ,x_time_phase_flag OUT NOCOPY VARCHAR2
3930: ,x_return_status OUT NOCOPY VARCHAR2
3931: ,x_msg_count OUT NOCOPY NUMBER
3932: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 3936: CURSOR get_pgm_ver_details(c_project_id pa_projects_all.project_id%TYPE,

3932: ,x_msg_data OUT NOCOPY VARCHAR2)
3933: AS
3934:
3935:
3936: CURSOR get_pgm_ver_details(c_project_id pa_projects_all.project_id%TYPE,
3937: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE)
3938: IS
3939: SELECT header.project_id, header.plan_version_id
3940: FROM pji_xbs_denorm denorm,

Line 3963: l_calendar_id pa_projects_all.calendar_id%TYPE;

3959: l_debug_level5 CONSTANT NUMBER := 5;
3960:
3961: l_module_name VARCHAR2(100) := 'pa.plsql.CHECK_WP_TIME_CONSISTENCY';
3962:
3963: l_calendar_id pa_projects_all.calendar_id%TYPE;
3964: l_calendar_type pji_fp_xbs_accum_f.calendar_type%TYPE;
3965:
3966: BEGIN
3967: x_msg_count := 0;

Line 4032: ( p_project_id IN pa_projects_all.project_id%TYPE

4028: check if all the structure versions in the program hierarchy have
4029: the same RBS.
4030: */
4031: PROCEDURE CHECK_WP_RBS_CONSISTENCY
4032: ( p_project_id IN pa_projects_all.project_id%TYPE
4033: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4034: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
4035: ,x_rbs_flag OUT NOCOPY VARCHAR2
4036: ,x_return_status OUT NOCOPY VARCHAR2

Line 4041: CURSOR check_rbs_flag(c_project_id pa_projects_all.project_id%TYPE,

4037: ,x_msg_count OUT NOCOPY NUMBER
4038: ,x_msg_data OUT NOCOPY VARCHAR2)
4039: AS
4040:
4041: CURSOR check_rbs_flag(c_project_id pa_projects_all.project_id%TYPE,
4042: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4043: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)
4044: IS
4045: SELECT 1

Line 4124: ( p_project_id IN pa_projects_all.project_id%TYPE)

4120: RAISE;
4121: END CHECK_WP_RBS_CONSISTENCY;
4122:
4123: FUNCTION GET_WP_BASELINED_PLAN_VERSION
4124: ( p_project_id IN pa_projects_all.project_id%TYPE)
4125: RETURN NUMBER
4126: IS
4127: CURSOR get_baselined_version(c_project_id pa_projects_all.project_id%TYPE)
4128: IS

Line 4127: CURSOR get_baselined_version(c_project_id pa_projects_all.project_id%TYPE)

4123: FUNCTION GET_WP_BASELINED_PLAN_VERSION
4124: ( p_project_id IN pa_projects_all.project_id%TYPE)
4125: RETURN NUMBER
4126: IS
4127: CURSOR get_baselined_version(c_project_id pa_projects_all.project_id%TYPE)
4128: IS
4129: SELECT header.plan_version_id
4130: FROM pa_proj_elem_ver_structure str,
4131: pji_pjp_wbs_header header

Line 4151: ( p_project_id IN pa_projects_all.project_id%TYPE)

4147: RETURN NULL;
4148: END;
4149:
4150: FUNCTION GET_WP_LATEST_VERSION
4151: ( p_project_id IN pa_projects_all.project_id%TYPE)
4152: RETURN NUMBER
4153: IS
4154: CURSOR get_latest_published_version(c_project_id pa_projects_all.project_id%TYPE)
4155: IS

Line 4154: CURSOR get_latest_published_version(c_project_id pa_projects_all.project_id%TYPE)

4150: FUNCTION GET_WP_LATEST_VERSION
4151: ( p_project_id IN pa_projects_all.project_id%TYPE)
4152: RETURN NUMBER
4153: IS
4154: CURSOR get_latest_published_version(c_project_id pa_projects_all.project_id%TYPE)
4155: IS
4156: SELECT header.plan_version_id
4157: FROM pa_proj_elem_ver_structure str,
4158: pji_pjp_wbs_header header

Line 4178: ( p_project_id IN pa_projects_all.project_id%TYPE

4174: RETURN NULL;
4175: END;
4176:
4177: FUNCTION GET_DEFAULT_EXPANSION_LEVEL
4178: ( p_project_id IN pa_projects_all.project_id%TYPE
4179: ,p_object_type IN VARCHAR2)
4180: RETURN NUMBER
4181: IS
4182: CURSOR get_wp_default_disp_lvl(c_project_id pa_projects_all.project_id%TYPE)

Line 4182: CURSOR get_wp_default_disp_lvl(c_project_id pa_projects_all.project_id%TYPE)

4178: ( p_project_id IN pa_projects_all.project_id%TYPE
4179: ,p_object_type IN VARCHAR2)
4180: RETURN NUMBER
4181: IS
4182: CURSOR get_wp_default_disp_lvl(c_project_id pa_projects_all.project_id%TYPE)
4183: IS
4184: SELECT wp_default_display_lvl
4185: FROM pa_workplan_options_v
4186: WHERE PROJECT_ID = c_project_id;

Line 4188: CURSOR get_fp_default_disp_lvl(c_project_id pa_projects_all.project_id%TYPE)

4184: SELECT wp_default_display_lvl
4185: FROM pa_workplan_options_v
4186: WHERE PROJECT_ID = c_project_id;
4187:
4188: CURSOR get_fp_default_disp_lvl(c_project_id pa_projects_all.project_id%TYPE)
4189: IS
4190: SELECT default_display_lvl
4191: FROM pa_financial_options_v
4192: WHERE PROJECT_ID = c_project_id;

Line 4707: p_project_id IN pa_projects_all.project_id%TYPE

4703: * have the same GL or same PA calendar or not. If GL calendar is same then x_gl_flag
4704: * will return 'T' else 'F'. This logic is true for PA calendar also.
4705: */
4706: PROCEDURE Check_Perf_Cal_Consistency(
4707: p_project_id IN pa_projects_all.project_id%TYPE
4708: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4709: ,x_gl_flag OUT NOCOPY VARCHAR2
4710: ,x_pa_flag OUT NOCOPY VARCHAR2
4711: ,x_return_status OUT NOCOPY VARCHAR2

Line 4749: , pa_projects_all proj

4745: l_num_of_pa_cal
4746: FROM
4747: pji_xbs_denorm denorm
4748: , pa_proj_elements elem
4749: , pa_projects_all proj
4750: , pji_org_extr_info info
4751: WHERE 1=1
4752: AND denorm.sup_project_id = p_project_id -- project_id
4753: AND denorm.sup_id = p_wbs_version_id -- wbs_version_id

Line 4803: p_project_id IN pa_projects_all.project_id%TYPE

4799: * have the same Project Functional Currency (PFC) or not. If PFC is same then x_pfc_flag
4800: * will return 'T' else 'F'.
4801: */
4802: PROCEDURE Check_Perf_Curr_Consistency(
4803: p_project_id IN pa_projects_all.project_id%TYPE
4804: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4805: ,x_pfc_flag OUT NOCOPY VARCHAR2
4806: ,x_return_status OUT NOCOPY VARCHAR2
4807: ,x_msg_count OUT NOCOPY NUMBER

Line 4840: , pa_projects_all proj

4836: INTO l_num_of_projfunc_curr
4837: FROM
4838: pji_xbs_denorm denorm
4839: , pa_proj_elements elem
4840: , pa_projects_all proj
4841: WHERE 1=1
4842: AND denorm.sup_project_id = p_project_id -- project_id
4843: AND denorm.sup_id = p_wbs_version_id -- wbs_version_id
4844: AND denorm.struct_type = 'PRG'

Line 5309: p_project_id IN pa_projects_all.project_id%TYPE

5305: NULL;
5306: END Chk_plan_vers_have_same_RBS;
5307:
5308: PROCEDURE GET_PROCESS_STATUS_MSG(
5309: p_project_id IN pa_projects_all.project_id%TYPE
5310: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
5311: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
5312: , p_prg_flag IN VARCHAR2 := NULL
5313: , x_message_name OUT NOCOPY VARCHAR2

Line 5334: l_project_id pa_projects_all.project_id%TYPE;

5330: AND denorm.sup_id = c_structure_version_id
5331: AND denorm.sub_id = vs.element_version_id;
5332:
5333: l_relationship_type VARCHAR2(2);
5334: l_project_id pa_projects_all.project_id%TYPE;
5335: l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
5336:
5337: BEGIN
5338:

Line 5431: ,pa_projects_all proj

5427: SELECT COUNT(DISTINCT UPPER(pt.project_type_class_code))
5428: INTO l_proj_type_count
5429: FROM pji_xbs_denorm denorm
5430: ,pa_proj_elem_ver_structure vs
5431: ,pa_projects_all proj
5432: ,pa_project_types_all pt
5433: WHERE struct_type = 'PRG'
5434: AND sup_project_id = p_project_id
5435: AND struct_version_id IS NULL

Line 5493: FROM pji_org_extr_info info, pa_projects_all proj

5489: END IF;
5490:
5491: SELECT info.gl_calendar_id, info.pa_calendar_id
5492: INTO l_gl_calendar_id, l_pa_calendar_id
5493: FROM pji_org_extr_info info, pa_projects_all proj
5494: WHERE info.org_id = proj.org_id
5495: AND proj.project_id = p_project_id;
5496:
5497: IF x_calendar_type IS NULL THEN

Line 5597: FROM pa_projects_all

5593: x_currency_code := Pji_Utils.get_global_secondary_currency;
5594: ELSE
5595: SELECT projfunc_currency_code, project_currency_code
5596: INTO l_projfunc_currency_code,l_project_currency_code
5597: FROM pa_projects_all
5598: WHERE project_id = p_project_id;
5599:
5600: IF p_currency_record_type = 4 THEN
5601: x_currency_code := l_projfunc_currency_code;