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.PA_ACTIONS_PUB dependencies on PA_PROJ_ELEMENTS

Line 117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

113: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
114: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
115: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
119: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
120: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

114: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
115: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
119: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
120: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 120: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

116: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
117: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
118: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
119: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
120: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
123: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
124: )

Line 365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

361: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
362: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 passing default null
363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
367: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

362: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 passing default null
363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
367: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
370: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 367: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

363: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
364: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
365: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
366: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
367: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
368: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
369: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
370: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
371: )

Line 761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

757: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
758: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
759: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
763: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
764: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
765: ,p_insert_or_update IN VARCHAR2 := 'INSERT'

Line 762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

758: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
759: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
763: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
764: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
765: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
766: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 764: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

760: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
761: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
762: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
763: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
764: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
765: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
766: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
767: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
768: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1453: ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := null

1449: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
1450: ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1451: ,p_carrying_out_org_id IN NUMBER := null
1452: ,p_action_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1453: ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := null
1454: ,p_insert_or_update IN VARCHAR2 := 'INSERT'
1455: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
1456: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1457: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1490: l_deliverable_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := NULL;

1486: l_carrying_out_org_id NUMBER;
1487: l_action_owner_id NUMBER;
1488:
1489: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE := NULL;
1490: l_deliverable_number PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := NULL;
1491:
1492: -- added for bug :4537865
1493: l_new_carrying_out_org_id NUMBER ;
1494: l_new_action_owner_id NUMBER;

Line 1506: CURSOR c_completed_flag (c_action_id IN pa_proj_elements.proj_element_id%TYPE)IS

1502: l_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1503: l_function_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() ;
1504: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
1505:
1506: CURSOR c_completed_flag (c_action_id IN pa_proj_elements.proj_element_id%TYPE)IS
1507: SELECT decode(pps.project_system_status_code,'DLVR_COMPLETED','Y','N')
1508: FROM pa_project_statuses pps,
1509: pa_proj_elements ppe
1510: WHERE ppe.proj_element_id = c_action_id

Line 1509: pa_proj_elements ppe

1505:
1506: CURSOR c_completed_flag (c_action_id IN pa_proj_elements.proj_element_id%TYPE)IS
1507: SELECT decode(pps.project_system_status_code,'DLVR_COMPLETED','Y','N')
1508: FROM pa_project_statuses pps,
1509: pa_proj_elements ppe
1510: WHERE ppe.proj_element_id = c_action_id
1511: AND pps.project_status_code = ppe.status_code ;
1512:
1513: CURSOR c_completed_date (c_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE) IS

Line 1527: FROM PA_PROJ_ELEMENTS PPE ,

1523: IS
1524: SELECT PPE.NAME ,
1525: PPE.FUNCTION_CODE,
1526: PPE.PROJ_ELEMENT_ID
1527: FROM PA_PROJ_ELEMENTS PPE ,
1528: PA_OBJECT_RELATIONSHIPS OBJ
1529: WHERE PPE.PROJECT_ID = p_project_id
1530: AND OBJ.OBJECT_ID_FROM2= p_object_id
1531: AND PPE.PROJ_ELEMENT_ID = OBJ.OBJECT_ID_TO2

Line 2094: FROM pa_Proj_elements

2090: Pa_Debug.WRITE(g_module_name, 'proj id ['||p_project_id||'] dlvr id ['||p_deliverable_id||']',l_debug_level3);
2091: END IF;
2092:
2093: SELECT element_Number INTO l_deliverable_number
2094: FROM pa_Proj_elements
2095: WHERE proj_element_id = p_deliverable_id
2096: AND project_id = p_project_id;
2097:
2098: SELECT segment1 INTO l_project_number

Line 2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

2382: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2383: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2384: ,p_debug_mode IN VARCHAR2 :='N'
2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2390: ,p_function_code IN pa_proj_elements.function_code%TYPE

Line 2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

2384: ,p_debug_mode IN VARCHAR2 :='N'
2385: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2390: ,p_function_code IN pa_proj_elements.function_code%TYPE
2391: ,p_project_id IN pa_projects_all.project_id%TYPE
2392: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2390: ,p_function_code IN pa_proj_elements.function_code%TYPE

2386: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
2387: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
2388: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2389: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2390: ,p_function_code IN pa_proj_elements.function_code%TYPE
2391: ,p_project_id IN pa_projects_all.project_id%TYPE
2392: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2393: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2394: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null

2609: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
2610: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE
2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE
2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
2615: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
2616: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
2617: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 2615: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE
2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE
2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
2615: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
2616: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
2617: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
2618: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
2619: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2616: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE
2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
2615: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
2616: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
2617: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
2618: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
2619: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2620: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2617: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

2613: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
2614: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
2615: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
2616: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
2617: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
2618: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
2619: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2620: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2621: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3020: l_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE := NULL ;

3016: l_attribute13_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3017: l_attribute14_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3018: l_attribute15_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3019:
3020: l_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE := NULL ;
3021: l_object_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL ;
3022: l_object_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL ;
3023: l_object_type PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := NULL ;
3024: l_pm_source_code VARCHAR2(30) := NULL ;

Line 3021: l_object_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL ;

3017: l_attribute14_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3018: l_attribute15_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
3019:
3020: l_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE := NULL ;
3021: l_object_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL ;
3022: l_object_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL ;
3023: l_object_type PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := NULL ;
3024: l_pm_source_code VARCHAR2(30) := NULL ;
3025: l_pm_source_reference VARCHAR2(30) := NULL ;

Line 3023: l_object_type PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := NULL ;

3019:
3020: l_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE := NULL ;
3021: l_object_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL ;
3022: l_object_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL ;
3023: l_object_type PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := NULL ;
3024: l_pm_source_code VARCHAR2(30) := NULL ;
3025: l_pm_source_reference VARCHAR2(30) := NULL ;
3026: -- to be modified l_pm_source_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() ;
3027: -- to be modified l_pm_source_reference_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() ; -- should be 25 instead of 30

Line 3028: l_carrying_out_organization_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL ;

3024: l_pm_source_code VARCHAR2(30) := NULL ;
3025: l_pm_source_reference VARCHAR2(30) := NULL ;
3026: -- to be modified l_pm_source_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() ;
3027: -- to be modified l_pm_source_reference_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() ; -- should be 25 instead of 30
3028: l_carrying_out_organization_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL ;
3029:
3030: -- 3749462 changes for financial top task and lowest chargeable task validation
3031: l_fin_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
3032: l_fin_task_num_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;

Line 3051: l_deliverable_number pa_proj_elements.element_number%TYPE;

3047: l_dlv_ship_action_tbl dlv_ship_action_tbl_type;
3048: l_dlv_req_action_tbl dlv_req_action_tbl_type;
3049:
3050: l_project_number pa_projects_all.segment1%TYPE;
3051: l_deliverable_number pa_proj_elements.element_number%TYPE;
3052: l_action_id pa_proj_elements.proj_element_id%TYPE;
3053: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
3054: l_organization_name pa_organizations_event_v.name%TYPE;
3055: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

Line 3052: l_action_id pa_proj_elements.proj_element_id%TYPE;

3048: l_dlv_req_action_tbl dlv_req_action_tbl_type;
3049:
3050: l_project_number pa_projects_all.segment1%TYPE;
3051: l_deliverable_number pa_proj_elements.element_number%TYPE;
3052: l_action_id pa_proj_elements.proj_element_id%TYPE;
3053: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
3054: l_organization_name pa_organizations_event_v.name%TYPE;
3055: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
3056: l_action_owner_id NUMBER; /* Bug # 3590235 */

Line 3075: , pa_proj_elements elem

3071: , elem.element_Number
3072: , proj.project_id
3073: , Pa_Deliverable_Utils.IS_Dlvr_Item_Based(vers.element_version_id)
3074: FROM pa_proj_element_versions vers
3075: , pa_proj_elements elem
3076: , pa_projects_all proj
3077: WHERE vers.proj_element_id = elem.proj_element_id
3078: AND elem.project_id = vers.project_id
3079: AND elem.proj_element_id = p_Proj_element_id

Line 3100: l_fin_task_id pa_proj_elements.proj_element_id%TYPE;

3096: AND pev.object_type = 'PA_ACTIONS';
3097:
3098: -- 3749462 changes for financial top task and lowest chargeable task validation
3099:
3100: l_fin_task_id pa_proj_elements.proj_element_id%TYPE;
3101: --added for bug: 4537865
3102: l_new_fin_task_id pa_proj_elements.proj_element_id%TYPE;
3103: --added for bug: 4537865
3104: l_fin_task_ref VARCHAR2(25);

Line 3102: l_new_fin_task_id pa_proj_elements.proj_element_id%TYPE;

3098: -- 3749462 changes for financial top task and lowest chargeable task validation
3099:
3100: l_fin_task_id pa_proj_elements.proj_element_id%TYPE;
3101: --added for bug: 4537865
3102: l_new_fin_task_id pa_proj_elements.proj_element_id%TYPE;
3103: --added for bug: 4537865
3104: l_fin_task_ref VARCHAR2(25);
3105:
3106:

Line 3133: FROM PA_PROJ_ELEMENTS

3129: l_unique_flag VARCHAR2(1);
3130:
3131: Cursor C_dlvr_type(l_project_id NUMBER, l_deliverable_id NUMBER) IS
3132: SELECT type_id
3133: FROM PA_PROJ_ELEMENTS
3134: WHERE proj_element_id = l_deliverable_id
3135: AND project_id = l_project_id
3136: AND OBJECT_TYPE = 'PA_DELIVERABLES';
3137:

Line 3138: l_dlvr_type_id Pa_Proj_Elements.type_id%TYPE;

3134: WHERE proj_element_id = l_deliverable_id
3135: AND project_id = l_project_id
3136: AND OBJECT_TYPE = 'PA_DELIVERABLES';
3137:
3138: l_dlvr_type_id Pa_Proj_Elements.type_id%TYPE;
3139:
3140: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
3141: l_dlvr_action_enabled VARCHAR2(1) := NULL;
3142: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;

Line 3142: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;

3138: l_dlvr_type_id Pa_Proj_Elements.type_id%TYPE;
3139:
3140: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
3141: l_dlvr_action_enabled VARCHAR2(1) := NULL;
3142: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
3143:
3144: -- end 3749447
3145:
3146: -- 3651542 added local variable for defaulting

Line 4886: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

4882: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4883: ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4884: ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4885: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
4886: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
4887: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
4888: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
4889: ,p_insert_or_update IN VARCHAR2 := 'UPDATE'
4890: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4887: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

4883: ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4884: ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
4885: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
4886: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
4887: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
4888: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
4889: ,p_insert_or_update IN VARCHAR2 := 'UPDATE'
4890: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4891: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895