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_PROJECTS_ALL

Line 113: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

109: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
110: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
111: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
112: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 361: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

357: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
358: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
359: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
360: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 757: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

753: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
754: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
755: ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
756: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 1455: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%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
1458: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1459: IS

Line 1489: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE := NULL;

1485: l_function_code_valid VARCHAR2(1) := 'N';
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 ;

Line 2099: FROM Pa_Projects_All

2095: WHERE proj_element_id = p_deliverable_id
2096: AND project_id = p_project_id;
2097:
2098: SELECT segment1 INTO l_project_number
2099: FROM Pa_Projects_All
2100: WHERE project_id = p_project_id;
2101:
2102: IF l_debug_mode = 'Y' THEN
2103: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] deliverable ['||l_deliverable_Number||']',l_debug_level3);

Line 2391: ,p_project_id IN pa_projects_all.project_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
2395: )

Line 2611: ,p_source_project_id IN pa_projects_all.project_id%TYPE

2607: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
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

Line 2612: ,p_target_project_id IN pa_projects_all.project_id%TYPE

2608: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
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

Line 3050: l_project_number pa_projects_all.segment1%TYPE;

3046: l_action_out_tbl PA_PROJECT_PUB.action_out_tbl_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;

Line 3053: l_org_id PA_PROJECTS_ALL.ORG_ID%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 */
3057: l_item_dlv VARCHAR2(1);

Line 3055: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%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 */
3057: l_item_dlv VARCHAR2(1);
3058: l_action VARCHAR2(30);
3059: l_actn_version_id NUMBER; -- 3651489 added local variable to store action's element_version_id

Line 3077: , pa_projects_all proj

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

Line 4437: ,p_project_number_from IN pa_projects_all.segment1%TYPE := NULL

4433: (
4434: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4435: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4436: ,p_function IN pa_lookups.lookup_code%TYPE
4437: ,p_project_number_from IN pa_projects_all.segment1%TYPE := NULL
4438: ,p_project_number_to IN pa_projects_all.segment1%TYPE := NULL
4439: )
4440: IS
4441: l_project_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

Line 4438: ,p_project_number_to IN pa_projects_all.segment1%TYPE := NULL

4434: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4435: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4436: ,p_function IN pa_lookups.lookup_code%TYPE
4437: ,p_project_number_from IN pa_projects_all.segment1%TYPE := NULL
4438: ,p_project_number_to IN pa_projects_all.segment1%TYPE := NULL
4439: )
4440: IS
4441: l_project_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
4442: l_count NUMBER ;

Line 4454: l_project_number_from pa_projects_all.segment1%TYPE :=nvl(p_project_number_from,p_project_number_to);

4450: l_msg_index_out NUMBER;
4451: l_return_status VARCHAR2(2000);
4452: l_error_message_code VARCHAR2(2000);
4453: -- Added for Bug Number 4907103
4454: l_project_number_from pa_projects_all.segment1%TYPE :=nvl(p_project_number_from,p_project_number_to);
4455: l_project_number_to pa_projects_all.segment1%TYPE :=nvl(p_project_number_to,p_project_number_from) ;
4456: -- 3752898
4457: -- We need this variable only for passing to OKE API
4458: -- Though they dont have any logic as of now to re-initialise Message stack if l_init_msg_list is TRUE ,

Line 4455: l_project_number_to pa_projects_all.segment1%TYPE :=nvl(p_project_number_to,p_project_number_from) ;

4451: l_return_status VARCHAR2(2000);
4452: l_error_message_code VARCHAR2(2000);
4453: -- Added for Bug Number 4907103
4454: l_project_number_from pa_projects_all.segment1%TYPE :=nvl(p_project_number_from,p_project_number_to);
4455: l_project_number_to pa_projects_all.segment1%TYPE :=nvl(p_project_number_to,p_project_number_from) ;
4456: -- 3752898
4457: -- We need this variable only for passing to OKE API
4458: -- Though they dont have any logic as of now to re-initialise Message stack if l_init_msg_list is TRUE ,
4459: -- Its not correct to initialise this variable as TRUE .By default this value should be FALSE

Line 4467: FROM PA_PROJECTS_ALL proj

4463:
4464: /* Commented for Bug Number 4907103
4465: CURSOR c_project_id_range IS
4466: SELECT proj.project_id
4467: FROM PA_PROJECTS_ALL proj
4468: WHERE segment1 between nvl(p_project_number_from,p_project_number_to)
4469: and nvl(p_project_number_to,p_project_number_from) ;
4470: */
4471: -- Changed for Bug Number 4907103

Line 4474: FROM PA_PROJECTS_ALL proj

4470: */
4471: -- Changed for Bug Number 4907103
4472: CURSOR c_project_id_range IS
4473: SELECT proj.project_id
4474: FROM PA_PROJECTS_ALL proj
4475: WHERE segment1 between l_project_number_from and l_project_number_to;
4476: -- End of BugNumber 4907103
4477: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS
4478: SELECT 'Y'

Line 4477: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS

4473: SELECT proj.project_id
4474: FROM PA_PROJECTS_ALL proj
4475: WHERE segment1 between l_project_number_from and l_project_number_to;
4476: -- End of BugNumber 4907103
4477: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS
4478: SELECT 'Y'
4479: FROM PA_PROJECTS_ALL
4480: WHERE segment1 = l_project_number;
4481:

Line 4479: FROM PA_PROJECTS_ALL

4475: WHERE segment1 between l_project_number_from and l_project_number_to;
4476: -- End of BugNumber 4907103
4477: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS
4478: SELECT 'Y'
4479: FROM PA_PROJECTS_ALL
4480: WHERE segment1 = l_project_number;
4481:
4482: BEGIN
4483:

Line 5377: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

5373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5375: ,p_debug_mode IN VARCHAR2 :='N'
5376: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5377: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5378: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter
5379: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5380: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5381: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5378: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter

5374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5375: ,p_debug_mode IN VARCHAR2 :='N'
5376: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5377: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5378: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter
5379: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5380: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5381: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5382: )

Line 5385: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;

5381: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5382: )
5383: IS
5384: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5385: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5386: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;
5387: l_request_id PA_PROJ_ELEM_VER_STRUCTURE.CONC_REQUEST_ID%TYPE;
5388:
5389: l_debug_mode VARCHAR2(1);

Line 5400: FROM PA_PROJECTS_ALL

5396: -- as project_number is been directly passed to api,
5397: /*
5398: CURSOR c_project_number_from IS
5399: SELECT SEGMENT1
5400: FROM PA_PROJECTS_ALL
5401: WHERE PROJECT_ID = p_project_id ;
5402: */
5403: -- THE FOLLOWING CURSOR WILL NOT BE USED ANYWHERE
5404: /*CURSOR c_project_sys_status_code IS

Line 5407: PA_PROJECTS_ALL pa

5403: -- THE FOLLOWING CURSOR WILL NOT BE USED ANYWHERE
5404: /*CURSOR c_project_sys_status_code IS
5405: SELECT PROJECT_SYSTEM_STATUS_CODE
5406: FROM PA_PROJECT_STATUSES pps,
5407: PA_PROJECTS_ALL pa
5408: WHERE pa.PROJECT_ID = p_project_id
5409: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
5410: */
5411: PRAGMA AUTONOMOUS_TRANSACTION;

Line 5641: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

5637: ==================================================================================*/
5638:
5639: PROCEDURE RUN_ACTION_CONC_FRM_WRP
5640: (
5641: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5642: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5643: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5644: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5645: )

Line 5647: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;

5643: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5644: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5645: )
5646: IS
5647: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5648:
5649: -- 3671408 Added below cursor to retrieve project_number
5650:
5651: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS

Line 5651: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS

5647: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5648:
5649: -- 3671408 Added below cursor to retrieve project_number
5650:
5651: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
5652: SELECT segment1
5653: FROM PA_PROJECTS_ALL
5654: WHERE PROJECT_ID = p_project_id;
5655:

Line 5653: FROM PA_PROJECTS_ALL

5649: -- 3671408 Added below cursor to retrieve project_number
5650:
5651: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
5652: SELECT segment1
5653: FROM PA_PROJECTS_ALL
5654: WHERE PROJECT_ID = p_project_id;
5655:
5656: BEGIN
5657: x_msg_count := 0;