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 206: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

202: l_err_code NUMBER := 0;
203: l_err_stack VARCHAR2(200) := NULL;
204: l_err_stage VARCHAR2(200) := NULL;
205:
206: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
207:
208: CURSOR get_product_code ( c_project_id NUMBER ) IS
209: SELECT pm_product_code
210: FROM PA_PROJECTS_ALL

Line 210: FROM PA_PROJECTS_ALL

206: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
207:
208: CURSOR get_product_code ( c_project_id NUMBER ) IS
209: SELECT pm_product_code
210: FROM PA_PROJECTS_ALL
211: WHERE project_id = c_project_id;
212:
213: -- end hyau Bug 2852753
214:

Line 844: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

840: l_err_code NUMBER := 0;
841: l_err_stack VARCHAR2(200) := NULL;
842: l_err_stage VARCHAR2(200) := NULL;
843:
844: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
845:
846: CURSOR get_product_code ( c_project_id NUMBER ) IS
847: SELECT pm_product_code
848: FROM PA_PROJECTS_ALL

Line 848: FROM PA_PROJECTS_ALL

844: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
845:
846: CURSOR get_product_code ( c_project_id NUMBER ) IS
847: SELECT pm_product_code
848: FROM PA_PROJECTS_ALL
849: WHERE project_id = c_project_id;
850:
851: l_cur_project_id NUMBER;
852: CURSOR cur_proj_id IS

Line 2075: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

2071: x_err_stack VARCHAR2(200) := NULL;
2072: x_err_stage VARCHAR2(200) := NULL;
2073: l_error_occured VARCHAR2(1) := 'N' ; --Bug2929411
2074:
2075: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2076:
2077: CURSOR get_product_code ( c_project_id NUMBER ) IS
2078: SELECT pm_product_code
2079: FROM PA_PROJECTS_ALL

Line 2079: FROM PA_PROJECTS_ALL

2075: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2076:
2077: CURSOR get_product_code ( c_project_id NUMBER ) IS
2078: SELECT pm_product_code
2079: FROM PA_PROJECTS_ALL
2080: WHERE project_id = c_project_id;
2081:
2082: l_project_id NUMBER;
2083: CURSOR cur_proj_id

Line 2909: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

2905: l_err_code NUMBER := 0;
2906: l_err_stack VARCHAR2(200) := NULL;
2907: l_err_stage VARCHAR2(200) := NULL;
2908:
2909: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2910:
2911: CURSOR get_product_code ( c_project_id NUMBER ) IS
2912: SELECT pm_product_code
2913: FROM PA_PROJECTS_ALL

Line 2913: FROM PA_PROJECTS_ALL

2909: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
2910:
2911: CURSOR get_product_code ( c_project_id NUMBER ) IS
2912: SELECT pm_product_code
2913: FROM PA_PROJECTS_ALL
2914: WHERE project_id = c_project_id;
2915:
2916: l_project_id NUMBER;
2917:

Line 3347: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

3343: l_err_code NUMBER := 0;
3344: l_err_stack VARCHAR2(200) := NULL;
3345: l_err_stage VARCHAR2(200) := NULL;
3346:
3347: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
3348:
3349: ----------------------------------- FP_M changes : Begin
3350: -- Refer to tracking bug 3305199
3351: /* Bug #: 3305199 SMukka */

Line 3362: FROM PA_PROJECTS_ALL

3358: ----------------------------------- FP_M changes : End
3359:
3360: CURSOR get_product_code ( c_project_id NUMBER ) IS
3361: SELECT pm_product_code
3362: FROM PA_PROJECTS_ALL
3363: WHERE project_id = c_project_id;
3364:
3365: -- end hyau Bug 2852753
3366:

Line 3668: from pa_projects_all

3664:
3665: --hsiu added for task version status
3666: CURSOR cur_proj_is_template(c_project_id NUMBER)
3667: IS select 'Y'
3668: from pa_projects_all
3669: where project_id = c_project_id
3670: and template_flag = 'Y';
3671: l_template_flag VARCHAR2(1);
3672:

Line 5490: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

5486: l_err_code NUMBER := 0;
5487: l_err_stack VARCHAR2(200) := NULL;
5488: l_err_stage VARCHAR2(200) := NULL;
5489:
5490: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
5491:
5492: CURSOR get_product_code ( c_project_id NUMBER ) IS
5493: SELECT pm_product_code
5494: FROM PA_PROJECTS_ALL

Line 5494: FROM PA_PROJECTS_ALL

5490: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
5491:
5492: CURSOR get_product_code ( c_project_id NUMBER ) IS
5493: SELECT pm_product_code
5494: FROM PA_PROJECTS_ALL
5495: WHERE project_id = c_project_id;
5496:
5497: l_cur_project_id NUMBER;
5498: CURSOR cur_proj_id

Line 7668: from pa_projects_all

7664:
7665: -- hsiu added for task version status
7666: CURSOR cur_proj_is_template(c_project_id NUMBER)
7667: IS select 'Y'
7668: from pa_projects_all
7669: where project_id = c_project_id
7670: and template_flag = 'Y';
7671: l_template_flag VARCHAR2(1);
7672:

Line 9274: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

9270: l_err_code NUMBER := 0;
9271: l_err_stack VARCHAR2(200) := NULL;
9272: l_err_stage VARCHAR2(200) := NULL;
9273:
9274: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
9275:
9276: CURSOR get_product_code ( c_project_id NUMBER ) IS
9277: SELECT pm_product_code
9278: FROM PA_PROJECTS_ALL

Line 9278: FROM PA_PROJECTS_ALL

9274: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
9275:
9276: CURSOR get_product_code ( c_project_id NUMBER ) IS
9277: SELECT pm_product_code
9278: FROM PA_PROJECTS_ALL
9279: WHERE project_id = c_project_id;
9280:
9281: l_cur_project_id NUMBER;
9282: CURSOR cur_proj_id

Line 10778: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

10774: l_err_code NUMBER := 0;
10775: l_err_stack VARCHAR2(200) := NULL;
10776: l_err_stage VARCHAR2(200) := NULL;
10777:
10778: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
10779:
10780: CURSOR get_product_code ( c_project_id NUMBER ) IS
10781: SELECT pm_product_code
10782: FROM PA_PROJECTS_ALL

Line 10782: FROM PA_PROJECTS_ALL

10778: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
10779:
10780: CURSOR get_product_code ( c_project_id NUMBER ) IS
10781: SELECT pm_product_code
10782: FROM PA_PROJECTS_ALL
10783: WHERE project_id = c_project_id;
10784:
10785: l_cur_project_id NUMBER;
10786: CURSOR cur_proj_id

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

13538: IF l_debug_mode = 'Y' THEN
13539: 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);
13540: END IF;
13541: --bug 3959087
13542: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
13543:
13544: -- Bug 3856161 : This code will never excute for assignments, I don't know why has this written here
13545: -- Setting object_id for Tasks / Assignments.
13546: IF (p_object_type = 'PA_ASSIGNMENTS') THEN

Line 14709: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

14705: l_err_code NUMBER := 0;
14706: l_err_stack VARCHAR2(200) := NULL;
14707: l_err_stage VARCHAR2(200) := NULL;
14708:
14709: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
14710:
14711: CURSOR cur_proj_is_template(c_project_id NUMBER)
14712: IS select 'Y'
14713: from pa_projects_all

Line 14713: from pa_projects_all

14709: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
14710:
14711: CURSOR cur_proj_is_template(c_project_id NUMBER)
14712: IS select 'Y'
14713: from pa_projects_all
14714: where project_id = c_project_id
14715: and template_flag = 'Y';
14716:
14717: CURSOR cur_dest_proj_id

Line 14732: FROM PA_PROJECTS_ALL

14728: AND project_id = x_project_id;
14729:
14730: CURSOR get_product_code ( c_project_id NUMBER ) IS
14731: SELECT pm_product_code
14732: FROM PA_PROJECTS_ALL
14733: WHERE project_id = c_project_id;
14734: BEGIN
14735: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASKS_IN_BULK');
14736: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 15163: l_pm_product_code pa_projects_all.pm_product_code%TYPE;

15159: l_err_code NUMBER := 0;
15160: l_err_stack VARCHAR2(200) := NULL;
15161: l_err_stage VARCHAR2(200) := NULL;
15162:
15163: l_pm_product_code pa_projects_all.pm_product_code%TYPE;
15164:
15165: l_cur_project_id NUMBER;
15166: CURSOR cur_proj_id
15167: IS

Line 15174: FROM PA_PROJECTS_ALL

15170: WHERE element_version_id = p_structure_version_id;
15171:
15172: CURSOR get_product_code ( c_project_id NUMBER ) IS
15173: SELECT pm_product_code
15174: FROM PA_PROJECTS_ALL
15175: WHERE project_id = c_project_id;
15176:
15177: /*4269830 : Performance Enhancements : Start */
15178: CURSOR cur_struc_type( c_structure_id NUMBER )