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_TASK_PUB1 dependencies on PA_PROJECTS_ALL

Line 211: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

207: l_err_code NUMBER := 0;
208: l_err_stack VARCHAR2(200) := NULL;
209: l_err_stage VARCHAR2(200) := NULL;
210:
211: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
212:
213: CURSOR get_product_code ( c_project_id NUMBER ) IS
214: SELECT pm_product_code
215: FROM PA_PROJECTS_ALL

Line 215: FROM PA_PROJECTS_ALL

211: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
212:
213: CURSOR get_product_code ( c_project_id NUMBER ) IS
214: SELECT pm_product_code
215: FROM PA_PROJECTS_ALL
216: WHERE project_id = c_project_id;
217:
218: -- end hyau Bug 2852753
219:

Line 855: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

851: l_err_code NUMBER := 0;
852: l_err_stack VARCHAR2(200) := NULL;
853: l_err_stage VARCHAR2(200) := NULL;
854:
855: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
856:
857: CURSOR get_product_code ( c_project_id NUMBER ) IS
858: SELECT pm_product_code
859: FROM PA_PROJECTS_ALL

Line 859: FROM PA_PROJECTS_ALL

855: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
856:
857: CURSOR get_product_code ( c_project_id NUMBER ) IS
858: SELECT pm_product_code
859: FROM PA_PROJECTS_ALL
860: WHERE project_id = c_project_id;
861:
862: l_cur_project_id NUMBER;
863: CURSOR cur_proj_id IS

Line 2088: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

2084: x_err_stack VARCHAR2(200) := NULL;
2085: x_err_stage VARCHAR2(200) := NULL;
2086: l_error_occured VARCHAR2(1) := 'N' ; --Bug2929411
2087:
2088: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2089:
2090: CURSOR get_product_code ( c_project_id NUMBER ) IS
2091: SELECT pm_product_code
2092: FROM PA_PROJECTS_ALL

Line 2092: FROM PA_PROJECTS_ALL

2088: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2089:
2090: CURSOR get_product_code ( c_project_id NUMBER ) IS
2091: SELECT pm_product_code
2092: FROM PA_PROJECTS_ALL
2093: WHERE project_id = c_project_id;
2094:
2095: l_project_id NUMBER;
2096: CURSOR cur_proj_id

Line 2172: AND text_value like (select segment1 from pa_projects_all

2168: SELECT /*+ NO_UNNEST */ 1
2169: FROM WF_NOTIFICATION_ATTRIBUTES
2170: WHERE notification_id = wfn.notification_id
2171: AND name = 'PROJECT_NUMBER'
2172: AND text_value like (select segment1 from pa_projects_all
2173: where project_id = c_project_id)
2174: );
2175:
2176:

Line 2959: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

2955: l_err_code NUMBER := 0;
2956: l_err_stack VARCHAR2(200) := NULL;
2957: l_err_stage VARCHAR2(200) := NULL;
2958:
2959: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2960:
2961: CURSOR get_product_code ( c_project_id NUMBER ) IS
2962: SELECT pm_product_code
2963: FROM PA_PROJECTS_ALL

Line 2963: FROM PA_PROJECTS_ALL

2959: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2960:
2961: CURSOR get_product_code ( c_project_id NUMBER ) IS
2962: SELECT pm_product_code
2963: FROM PA_PROJECTS_ALL
2964: WHERE project_id = c_project_id;
2965:
2966: l_project_id NUMBER;
2967:

Line 3399: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

3395: l_err_code NUMBER := 0;
3396: l_err_stack VARCHAR2(200) := NULL;
3397: l_err_stage VARCHAR2(200) := NULL;
3398:
3399: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
3400:
3401: ----------------------------------- FP_M changes : Begin
3402: -- Refer to tracking bug 3305199
3403: /* Bug #: 3305199 SMukka */

Line 3431: FROM PA_PROJECTS_ALL

3427:
3428:
3429: CURSOR get_product_code ( c_project_id NUMBER ) IS
3430: SELECT pm_product_code
3431: FROM PA_PROJECTS_ALL
3432: WHERE project_id = c_project_id;
3433:
3434: -- end hyau Bug 2852753
3435:

Line 3737: from pa_projects_all

3733:
3734: --hsiu added for task version status
3735: CURSOR cur_proj_is_template(c_project_id NUMBER)
3736: IS select 'Y'
3737: from pa_projects_all
3738: where project_id = c_project_id
3739: and template_flag = 'Y';
3740: l_template_flag VARCHAR2(1);
3741:

Line 3775: FROM pa_projects_all

3771: CURSOR check_cost_code_enabled(c_project_id NUMBER) IS
3772: select 'Y' from dual where
3773: EXISTS
3774: (SELECT *
3775: FROM pa_projects_all
3776: WHERE project_id = c_project_id
3777: AND CBS_VERSION_ID IS NOT NULL
3778: AND CBS_ENABLE_FLAG = 'Y');
3779:

Line 3785: FROM pa_projects_all

3781: CURSOR check_same_cbs_exist(c_src_project_id NUMBER, c_trgt_project_id NUMBER) IS
3782: select 'Y' from dual where
3783: EXISTS
3784: (SELECT *
3785: FROM pa_projects_all
3786: WHERE project_id = c_src_project_id
3787: AND nvl(CBS_VERSION_ID,-1) = nvl((select CBS_VERSION_ID from pa_projects_all
3788: WHERE project_id = c_trgt_project_id),-1)); -- added nvl condition bug#16713476
3789:

Line 3787: AND nvl(CBS_VERSION_ID,-1) = nvl((select CBS_VERSION_ID from pa_projects_all

3783: EXISTS
3784: (SELECT *
3785: FROM pa_projects_all
3786: WHERE project_id = c_src_project_id
3787: AND nvl(CBS_VERSION_ID,-1) = nvl((select CBS_VERSION_ID from pa_projects_all
3788: WHERE project_id = c_trgt_project_id),-1)); -- added nvl condition bug#16713476
3789:
3790: l_src_prj_cbs_enabled VARCHAR2(1) := 'N'; --bug#16083858
3791: l_dest_prj_cbs_enabled VARCHAR2(1) := 'N'; --bug#16083858

Line 5765: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

5761: l_err_code NUMBER := 0;
5762: l_err_stack VARCHAR2(200) := NULL;
5763: l_err_stage VARCHAR2(200) := NULL;
5764:
5765: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
5766:
5767: CURSOR get_product_code ( c_project_id NUMBER ) IS
5768: SELECT pm_product_code
5769: FROM PA_PROJECTS_ALL

Line 5769: FROM PA_PROJECTS_ALL

5765: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
5766:
5767: CURSOR get_product_code ( c_project_id NUMBER ) IS
5768: SELECT pm_product_code
5769: FROM PA_PROJECTS_ALL
5770: WHERE project_id = c_project_id;
5771:
5772: l_cur_project_id NUMBER;
5773: CURSOR cur_proj_id

Line 7965: from pa_projects_all

7961:
7962: -- hsiu added for task version status
7963: CURSOR cur_proj_is_template(c_project_id NUMBER)
7964: IS select 'Y'
7965: from pa_projects_all
7966: where project_id = c_project_id
7967: and template_flag = 'Y';
7968: l_template_flag VARCHAR2(1);
7969:

Line 9637: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

9633: l_err_code NUMBER := 0;
9634: l_err_stack VARCHAR2(200) := NULL;
9635: l_err_stage VARCHAR2(200) := NULL;
9636:
9637: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
9638:
9639: CURSOR get_product_code ( c_project_id NUMBER ) IS
9640: SELECT pm_product_code
9641: FROM PA_PROJECTS_ALL

Line 9641: FROM PA_PROJECTS_ALL

9637: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
9638:
9639: CURSOR get_product_code ( c_project_id NUMBER ) IS
9640: SELECT pm_product_code
9641: FROM PA_PROJECTS_ALL
9642: WHERE project_id = c_project_id;
9643:
9644: l_cur_project_id NUMBER;
9645: CURSOR cur_proj_id

Line 11158: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

11154: l_err_code NUMBER := 0;
11155: l_err_stack VARCHAR2(200) := NULL;
11156: l_err_stage VARCHAR2(200) := NULL;
11157:
11158: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
11159:
11160: CURSOR get_product_code ( c_project_id NUMBER ) IS
11161: SELECT pm_product_code
11162: FROM PA_PROJECTS_ALL

Line 11162: FROM PA_PROJECTS_ALL

11158: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
11159:
11160: CURSOR get_product_code ( c_project_id NUMBER ) IS
11161: SELECT pm_product_code
11162: FROM PA_PROJECTS_ALL
11163: WHERE project_id = c_project_id;
11164:
11165: l_cur_project_id NUMBER;
11166: CURSOR cur_proj_id

Line 12660: l_project_id pa_projects_all.project_id%TYPE;

12656: l_element_number_tbl l_element_number_tbl_type ;
12657: j NUMBER ;
12658:
12659: -- Bug 9535723
12660: l_project_id pa_projects_all.project_id%TYPE;
12661: l_planned_effort_exists VARCHAR(1) := 'N';
12662:
12663: -- below cursors are the same as those used currently in the flow
12664: CURSOR get_project_id(c_structure_version_id IN NUMBER) IS

Line 14066: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;

14062: IF l_debug_mode = 'Y' THEN
14063: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14064: END IF;
14065: --bug 3959087
14066: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
14067:
14068: -- Bug 3856161 : This code will never excute for assignments, I don't know why has this written here
14069: -- Setting object_id for Tasks / Assignments.
14070: IF (p_object_type = 'PA_ASSIGNMENTS') THEN

Line 15240: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

15236: l_err_code NUMBER := 0;
15237: l_err_stack VARCHAR2(200) := NULL;
15238: l_err_stage VARCHAR2(200) := NULL;
15239:
15240: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
15241:
15242: CURSOR cur_proj_is_template(c_project_id NUMBER)
15243: IS select 'Y'
15244: from pa_projects_all

Line 15244: from pa_projects_all

15240: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
15241:
15242: CURSOR cur_proj_is_template(c_project_id NUMBER)
15243: IS select 'Y'
15244: from pa_projects_all
15245: where project_id = c_project_id
15246: and template_flag = 'Y';
15247:
15248: CURSOR cur_dest_proj_id

Line 15263: FROM PA_PROJECTS_ALL

15259: AND project_id = x_project_id;
15260:
15261: CURSOR get_product_code ( c_project_id NUMBER ) IS
15262: SELECT pm_product_code
15263: FROM PA_PROJECTS_ALL
15264: WHERE project_id = c_project_id;
15265: BEGIN
15266: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASKS_IN_BULK');
15267: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 15696: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

15692: l_err_code NUMBER := 0;
15693: l_err_stack VARCHAR2(200) := NULL;
15694: l_err_stage VARCHAR2(200) := NULL;
15695:
15696: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
15697:
15698: l_cur_project_id NUMBER;
15699: CURSOR cur_proj_id
15700: IS

Line 15707: FROM PA_PROJECTS_ALL

15703: WHERE element_version_id = p_structure_version_id;
15704:
15705: CURSOR get_product_code ( c_project_id NUMBER ) IS
15706: SELECT pm_product_code
15707: FROM PA_PROJECTS_ALL
15708: WHERE project_id = c_project_id;
15709:
15710: /*4269830 : Performance Enhancements : Start */
15711: CURSOR cur_struc_type( c_structure_id NUMBER )

Line 17137: AND text_value like (select segment1 from pa_projects_all

17133: SELECT /*+ NO_UNNEST */ 1
17134: FROM WF_NOTIFICATION_ATTRIBUTES
17135: WHERE notification_id = wfn.notification_id
17136: AND name = 'PROJECT_NUMBER'
17137: AND text_value like (select segment1 from pa_projects_all
17138: where project_id = c_project_id)
17139: );
17140:
17141: cursor parent_task_status(c_task_id NUMBER) is

Line 17174: from pa_projects_all

17170: fnd_msg_pub.initialize;
17171:
17172: select carrying_out_organization_id
17173: into l_org_id
17174: from pa_projects_all
17175: where project_id = l_project_id;
17176:
17177: --hsiu: 3604086
17178: x_return_status := FND_API.G_RET_STS_SUCCESS;