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 3076: , pa_projects_all proj

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
3080: AND elem.project_id = proj.project_id

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

4364: (
4365: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4366: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4367: ,p_function IN pa_lookups.lookup_code%TYPE
4368: ,p_project_number_from IN pa_projects_all.segment1%TYPE := NULL
4369: ,p_project_number_to IN pa_projects_all.segment1%TYPE := NULL
4370: )
4371: IS
4372: l_project_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

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

4365: errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4366: ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4367: ,p_function IN pa_lookups.lookup_code%TYPE
4368: ,p_project_number_from IN pa_projects_all.segment1%TYPE := NULL
4369: ,p_project_number_to IN pa_projects_all.segment1%TYPE := NULL
4370: )
4371: IS
4372: l_project_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
4373: l_count NUMBER ;

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

4381: l_msg_index_out NUMBER;
4382: l_return_status VARCHAR2(2000);
4383: l_error_message_code VARCHAR2(2000);
4384: -- Added for Bug Number 4907103
4385: l_project_number_from pa_projects_all.segment1%TYPE :=nvl(p_project_number_from,p_project_number_to);
4386: l_project_number_to pa_projects_all.segment1%TYPE :=nvl(p_project_number_to,p_project_number_from) ;
4387: -- 3752898
4388: -- We need this variable only for passing to OKE API
4389: -- Though they dont have any logic as of now to re-initialise Message stack if l_init_msg_list is TRUE ,

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

4382: l_return_status VARCHAR2(2000);
4383: l_error_message_code VARCHAR2(2000);
4384: -- Added for Bug Number 4907103
4385: l_project_number_from pa_projects_all.segment1%TYPE :=nvl(p_project_number_from,p_project_number_to);
4386: l_project_number_to pa_projects_all.segment1%TYPE :=nvl(p_project_number_to,p_project_number_from) ;
4387: -- 3752898
4388: -- We need this variable only for passing to OKE API
4389: -- Though they dont have any logic as of now to re-initialise Message stack if l_init_msg_list is TRUE ,
4390: -- Its not correct to initialise this variable as TRUE .By default this value should be FALSE

Line 4398: FROM PA_PROJECTS_ALL proj

4394:
4395: /* Commented for Bug Number 4907103
4396: CURSOR c_project_id_range IS
4397: SELECT proj.project_id
4398: FROM PA_PROJECTS_ALL proj
4399: WHERE segment1 between nvl(p_project_number_from,p_project_number_to)
4400: and nvl(p_project_number_to,p_project_number_from) ;
4401: */
4402: -- Changed for Bug Number 4907103

Line 4405: FROM PA_PROJECTS_ALL proj

4401: */
4402: -- Changed for Bug Number 4907103
4403: CURSOR c_project_id_range IS
4404: SELECT proj.project_id
4405: FROM PA_PROJECTS_ALL proj
4406: WHERE segment1 between l_project_number_from and l_project_number_to;
4407: -- End of BugNumber 4907103
4408: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS
4409: SELECT 'Y'

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

4404: SELECT proj.project_id
4405: FROM PA_PROJECTS_ALL proj
4406: WHERE segment1 between l_project_number_from and l_project_number_to;
4407: -- End of BugNumber 4907103
4408: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS
4409: SELECT 'Y'
4410: FROM PA_PROJECTS_ALL
4411: WHERE segment1 = l_project_number;
4412:

Line 4410: FROM PA_PROJECTS_ALL

4406: WHERE segment1 between l_project_number_from and l_project_number_to;
4407: -- End of BugNumber 4907103
4408: CURSOR c_valid_project_number_entry(l_project_number IN pa_projects_all.segment1%TYPE) IS
4409: SELECT 'Y'
4410: FROM PA_PROJECTS_ALL
4411: WHERE segment1 = l_project_number;
4412:
4413: BEGIN
4414:

Line 5308: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

5304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5306: ,p_debug_mode IN VARCHAR2 :='N'
5307: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5308: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5309: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter
5310: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5311: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5312: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

5305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5306: ,p_debug_mode IN VARCHAR2 :='N'
5307: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5308: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5309: ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN paramter
5310: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5311: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5312: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5313: )

Line 5316: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;

5312: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5313: )
5314: IS
5315: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5316: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5317: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;
5318: l_request_id PA_PROJ_ELEM_VER_STRUCTURE.CONC_REQUEST_ID%TYPE;
5319:
5320: l_debug_mode VARCHAR2(1);

Line 5331: FROM PA_PROJECTS_ALL

5327: -- as project_number is been directly passed to api,
5328: /*
5329: CURSOR c_project_number_from IS
5330: SELECT SEGMENT1
5331: FROM PA_PROJECTS_ALL
5332: WHERE PROJECT_ID = p_project_id ;
5333: */
5334: -- THE FOLLOWING CURSOR WILL NOT BE USED ANYWHERE
5335: /*CURSOR c_project_sys_status_code IS

Line 5338: PA_PROJECTS_ALL pa

5334: -- THE FOLLOWING CURSOR WILL NOT BE USED ANYWHERE
5335: /*CURSOR c_project_sys_status_code IS
5336: SELECT PROJECT_SYSTEM_STATUS_CODE
5337: FROM PA_PROJECT_STATUSES pps,
5338: PA_PROJECTS_ALL pa
5339: WHERE pa.PROJECT_ID = p_project_id
5340: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
5341: */
5342: PRAGMA AUTONOMOUS_TRANSACTION;

Line 5572: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE

5568: ==================================================================================*/
5569:
5570: PROCEDURE RUN_ACTION_CONC_FRM_WRP
5571: (
5572: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
5573: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5574: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5575: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5576: )

Line 5578: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;

5574: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5575: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5576: )
5577: IS
5578: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5579:
5580: -- 3671408 Added below cursor to retrieve project_number
5581:
5582: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS

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

5578: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5579:
5580: -- 3671408 Added below cursor to retrieve project_number
5581:
5582: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
5583: SELECT segment1
5584: FROM PA_PROJECTS_ALL
5585: WHERE PROJECT_ID = p_project_id;
5586:

Line 5584: FROM PA_PROJECTS_ALL

5580: -- 3671408 Added below cursor to retrieve project_number
5581:
5582: CURSOR c_project_details(p_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
5583: SELECT segment1
5584: FROM PA_PROJECTS_ALL
5585: WHERE PROJECT_ID = p_project_id;
5586:
5587: BEGIN
5588: x_msg_count := 0;