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_PROJECT_CORE2 dependencies on PA_TASKS

Line 89: from pa_tasks

85:
86: -- use min(start_date) as pseudo original project start
87: cursor c2 is
88: select min(start_date) min_start
89: from pa_tasks
90: where project_id = x_orig_project_id;
91:
92: c2_rec c2%rowtype;
93:

Line 180: INSERT INTO pa_tasks (

176:
177: l_wp_separate_from_fn := nvl ( PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN ( x_orig_project_id ), 'N' ) ;
178:
179:
180: INSERT INTO pa_tasks (
181: task_id
182: , project_id
183: , task_number
184: , task_name

Line 264: pa_tasks_s.nextval

260: -- See bug 402125 for details
261: -- Bug 5034402: If the start/end date of the source task is NULL then copied
262: -- start/end date of the target project to start/end date of target task.Added by sunkalya for porting fix from Bug#5014950 to R12
263: SELECT
264: pa_tasks_s.nextval
265: , x_new_project_id
266: , t.task_number
267: , t.task_name
268: , t.address_id /* 13373337 */

Line 360: pa_tasks t

356:
357: ,t.adj_on_std_inv
358: FROM
359:
360: pa_tasks t
361: WHERE
362: t.project_id = x_orig_project_id;
363:
364:

Line 375: Delete from pa_tasks t where

371: l_versioning_enabled = 'Y' AND
372: l_shared = 'Y' AND
373: l_sel_version_id is not NULL
374: THEN
375: Delete from pa_tasks t where
376: t.project_id = x_new_project_id
377: and not exists (select 1
378: from pa_proj_element_versions v,
379: pa_tasks old_tsk,

Line 379: pa_tasks old_tsk,

375: Delete from pa_tasks t where
376: t.project_id = x_new_project_id
377: and not exists (select 1
378: from pa_proj_element_versions v,
379: pa_tasks old_tsk,
380: pa_tasks new_tsk
381: where new_tsk.project_id = x_new_project_id
382: and old_tsk.project_id = x_orig_project_id
383: and old_tsk.task_number = new_tsk.task_number

Line 380: pa_tasks new_tsk

376: t.project_id = x_new_project_id
377: and not exists (select 1
378: from pa_proj_element_versions v,
379: pa_tasks old_tsk,
380: pa_tasks new_tsk
381: where new_tsk.project_id = x_new_project_id
382: and old_tsk.project_id = x_orig_project_id
383: and old_tsk.task_number = new_tsk.task_number
384: and v.project_id = x_orig_project_id

Line 386: and v.object_type='PA_TASKS'

382: and old_tsk.project_id = x_orig_project_id
383: and old_tsk.task_number = new_tsk.task_number
384: and v.project_id = x_orig_project_id
385: and v.PARENT_STRUCTURE_VERSION_ID = l_sel_version_id
386: and v.object_type='PA_TASKS'
387: and v.proj_element_id = old_tsk.task_id
388: and t.task_id = new_tsk.task_id);
389: END IF;
390: -- Bug 4104042 - End

Line 399: FROM pa_tasks old_tsk

395: pa_projects P
396: SET
397: P.cc_tax_task_id = (
398: SELECT new_tsk.task_id
399: FROM pa_tasks old_tsk
400: , pa_tasks new_tsk
401: WHERE new_tsk.project_id = x_new_project_id
402: AND old_tsk.project_id = x_orig_project_id
403: AND P.cc_tax_task_id = old_tsk.task_id

Line 400: , pa_tasks new_tsk

396: SET
397: P.cc_tax_task_id = (
398: SELECT new_tsk.task_id
399: FROM pa_tasks old_tsk
400: , pa_tasks new_tsk
401: WHERE new_tsk.project_id = x_new_project_id
402: AND old_tsk.project_id = x_orig_project_id
403: AND P.cc_tax_task_id = old_tsk.task_id
404: AND old_tsk.task_number = new_tsk.task_number )

Line 411: pa_tasks T

407:
408: x_err_stage := 'update parent task id';
409:
410: UPDATE
411: pa_tasks T
412: SET
413: T.parent_task_id = (
414: SELECT new_tsk.task_id
415: FROM pa_tasks old_tsk

Line 415: FROM pa_tasks old_tsk

411: pa_tasks T
412: SET
413: T.parent_task_id = (
414: SELECT new_tsk.task_id
415: FROM pa_tasks old_tsk
416: , pa_tasks new_tsk
417: WHERE new_tsk.project_id = x_new_project_id
418: AND old_tsk.project_id = x_orig_project_id
419: AND T.parent_task_id = old_tsk.task_id

Line 416: , pa_tasks new_tsk

412: SET
413: T.parent_task_id = (
414: SELECT new_tsk.task_id
415: FROM pa_tasks old_tsk
416: , pa_tasks new_tsk
417: WHERE new_tsk.project_id = x_new_project_id
418: AND old_tsk.project_id = x_orig_project_id
419: AND T.parent_task_id = old_tsk.task_id
420: AND old_tsk.task_number = new_tsk.task_number )

Line 426: pa_tasks T

422:
423: x_err_stage := 'update top task id';
424:
425: UPDATE
426: pa_tasks T
427: SET
428: T.top_task_id = (
429: SELECT new_tsk.task_id
430: FROM pa_tasks old_tsk

Line 430: FROM pa_tasks old_tsk

426: pa_tasks T
427: SET
428: T.top_task_id = (
429: SELECT new_tsk.task_id
430: FROM pa_tasks old_tsk
431: , pa_tasks new_tsk
432: WHERE new_tsk.project_id = x_new_project_id
433: AND old_tsk.project_id = x_orig_project_id
434: AND T.top_task_id = old_tsk.task_id

Line 431: , pa_tasks new_tsk

427: SET
428: T.top_task_id = (
429: SELECT new_tsk.task_id
430: FROM pa_tasks old_tsk
431: , pa_tasks new_tsk
432: WHERE new_tsk.project_id = x_new_project_id
433: AND old_tsk.project_id = x_orig_project_id
434: AND T.top_task_id = old_tsk.task_id
435: AND old_tsk.task_number = new_tsk.task_number )

Line 449: from pa_tasks orig, pa_tasks new

445: Declare
446: cursor c_attach_tasks is
447: select orig.task_id orig_task_id,
448: new.task_id new_task_id
449: from pa_tasks orig, pa_tasks new
450: where orig.project_id = x_orig_project_id
451: and new.task_number = orig.task_number
452: and new.project_id = x_new_project_id ;
453:

Line 464: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',

460: into c_atch ;
461: if c_attach_tasks%notfound then
462: exit ;
463: end if;
464: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
465: c_atch.orig_task_id,
466: null, null, null, null,
467: 'PA_TASKS',
468: c_atch.new_task_id,

Line 467: 'PA_TASKS',

463: end if;
464: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
465: c_atch.orig_task_id,
466: null, null, null, null,
467: 'PA_TASKS',
468: c_atch.new_task_id,
469: null, null, null, null,
470: FND_GLOBAL.USER_ID,
471: FND_GLOBAL.LOGIN_ID,

Line 556: , pa_tasks new_tsk

552: s.ORG_STRUCTURE_VERSION_ID,
553: s.START_ORGANIZATION_ID,
554: s.IND_RATE_SCH_USAGE --bug 3053508
555: FROM pa_ind_rate_schedules s
556: , pa_tasks new_tsk
557: , pa_tasks old_tsk
558: WHERE
559: s.project_id = x_orig_project_id
560: AND s.task_id = old_tsk.task_id

Line 557: , pa_tasks old_tsk

553: s.START_ORGANIZATION_ID,
554: s.IND_RATE_SCH_USAGE --bug 3053508
555: FROM pa_ind_rate_schedules s
556: , pa_tasks new_tsk
557: , pa_tasks old_tsk
558: WHERE
559: s.project_id = x_orig_project_id
560: AND s.task_id = old_tsk.task_id
561: AND new_tsk.project_id = x_new_project_id

Line 620: pa_tasks old_task,

616: rev.START_ORGANIZATION_ID
617: from pa_ind_rate_sch_revisions rev,
618: pa_ind_rate_schedules old_sch,
619: pa_ind_rate_schedules new_sch,
620: pa_tasks old_task,
621: pa_tasks new_task
622: where old_sch.project_id = x_orig_project_id
623: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
624: and old_sch.task_id = old_task.task_id

Line 621: pa_tasks new_task

617: from pa_ind_rate_sch_revisions rev,
618: pa_ind_rate_schedules old_sch,
619: pa_ind_rate_schedules new_sch,
620: pa_tasks old_task,
621: pa_tasks new_task
622: where old_sch.project_id = x_orig_project_id
623: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
624: and old_sch.task_id = old_task.task_id
625: and new_sch.project_id = x_new_project_id

Line 660: pa_tasks old_task,

656: pa_ind_rate_sch_revisions old_rev,
657: pa_ind_rate_sch_revisions new_rev,
658: pa_ind_rate_schedules old_sch,
659: pa_ind_rate_schedules new_sch,
660: pa_tasks old_task,
661: pa_tasks new_task
662: where old_rev.IND_RATE_SCH_REVISION_ID =
663: mult.IND_RATE_SCH_REVISION_ID
664: and old_rev.IND_RATE_SCH_REVISION =

Line 661: pa_tasks new_task

657: pa_ind_rate_sch_revisions new_rev,
658: pa_ind_rate_schedules old_sch,
659: pa_ind_rate_schedules new_sch,
660: pa_tasks old_task,
661: pa_tasks new_task
662: where old_rev.IND_RATE_SCH_REVISION_ID =
663: mult.IND_RATE_SCH_REVISION_ID
664: and old_rev.IND_RATE_SCH_REVISION =
665: new_rev.IND_RATE_SCH_REVISION

Line 794: , pa_tasks new_tsk

790: , tc.workplan_res_only_flag
791: , tc.employees_only_flag
792: FROM
793: pa_transaction_controls tc
794: , pa_tasks new_tsk
795: , pa_tasks old_tsk
796: WHERE
797: tc.project_id = x_orig_project_id
798: AND tc.task_id = old_tsk.task_id

Line 795: , pa_tasks old_tsk

791: , tc.employees_only_flag
792: FROM
793: pa_transaction_controls tc
794: , pa_tasks new_tsk
795: , pa_tasks old_tsk
796: WHERE
797: tc.project_id = x_orig_project_id
798: AND tc.task_id = old_tsk.task_id
799: AND new_tsk.project_id = x_new_project_id

Line 903: pa_tasks old_tsk,

899: a.FUNDING_EXCHANGE_RATE,
900: 1
901: from pa_billing_assignments a,
902: -- pa_projects new_proj, bug 4189010
903: pa_tasks old_tsk,
904: pa_tasks new_tsk
905: where a.project_id = x_orig_project_id
906: and a.top_task_id is not null
907: and a.top_task_id = old_tsk.task_id

Line 904: pa_tasks new_tsk

900: 1
901: from pa_billing_assignments a,
902: -- pa_projects new_proj, bug 4189010
903: pa_tasks old_tsk,
904: pa_tasks new_tsk
905: where a.project_id = x_orig_project_id
906: and a.top_task_id is not null
907: and a.top_task_id = old_tsk.task_id
908: and old_tsk.task_number = new_tsk.task_number

Line 945: pa_tasks old_tsk,

941: FND_GLOBAL.LOGIN_ID
942: from pa_project_asset_assignments assign,
943: pa_project_assets old_asset,
944: pa_project_assets new_asset,
945: pa_tasks old_tsk,
946: pa_tasks new_tsk
947: where old_asset.project_id = x_orig_project_id
948: and old_asset.project_asset_id = assign.project_asset_id
949: and assign.task_id = old_tsk.task_id

Line 946: pa_tasks new_tsk

942: from pa_project_asset_assignments assign,
943: pa_project_assets old_asset,
944: pa_project_assets new_asset,
945: pa_tasks old_tsk,
946: pa_tasks new_tsk
947: where old_asset.project_id = x_orig_project_id
948: and old_asset.project_asset_id = assign.project_asset_id
949: and assign.task_id = old_tsk.task_id
950: /* Added the following conditions for bug#2530093 */

Line 968: pa_tasks old_tsk,

964: sysdate,
965: FND_GLOBAL.USER_ID,
966: FND_GLOBAL.LOGIN_ID
967: from pa_project_asset_assignments assign,
968: pa_tasks old_tsk,
969: pa_tasks new_tsk
970: where assign.project_id = x_orig_project_id
971: and assign.task_id = old_tsk.task_id
972: and old_tsk.task_number = new_tsk.task_number

Line 969: pa_tasks new_tsk

965: FND_GLOBAL.USER_ID,
966: FND_GLOBAL.LOGIN_ID
967: from pa_project_asset_assignments assign,
968: pa_tasks old_tsk,
969: pa_tasks new_tsk
970: where assign.project_id = x_orig_project_id
971: and assign.task_id = old_tsk.task_id
972: and old_tsk.task_number = new_tsk.task_number
973: and new_tsk.project_id = x_new_project_id

Line 1036: pa_tasks old_tsk,

1032: , o.DISCOUNT_PERCENTAGE
1033: , o.RATE_DISC_REASON_CODE
1034: FROM
1035: pa_job_bill_rate_overrides o,
1036: pa_tasks old_tsk,
1037: pa_tasks new_tsk
1038: WHERE old_tsk.project_id = x_orig_project_id
1039: and o.task_id = old_tsk.task_id
1040: and old_tsk.task_number = new_tsk.task_number

Line 1037: pa_tasks new_tsk

1033: , o.RATE_DISC_REASON_CODE
1034: FROM
1035: pa_job_bill_rate_overrides o,
1036: pa_tasks old_tsk,
1037: pa_tasks new_tsk
1038: WHERE old_tsk.project_id = x_orig_project_id
1039: and o.task_id = old_tsk.task_id
1040: and old_tsk.task_number = new_tsk.task_number
1041: and new_tsk.project_id = x_new_project_id;

Line 1087: pa_tasks old_tsk,

1083: (new_tsk.start_date - old_tsk.start_date))))
1084: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1085: FROM
1086: pa_job_bill_title_overrides o,
1087: pa_tasks old_tsk,
1088: pa_tasks new_tsk
1089: WHERE old_tsk.project_id = x_orig_project_id
1090: and o.task_id = old_tsk.task_id
1091: and old_tsk.task_number = new_tsk.task_number

Line 1088: pa_tasks new_tsk

1084: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1085: FROM
1086: pa_job_bill_title_overrides o,
1087: pa_tasks old_tsk,
1088: pa_tasks new_tsk
1089: WHERE old_tsk.project_id = x_orig_project_id
1090: and o.task_id = old_tsk.task_id
1091: and old_tsk.task_number = new_tsk.task_number
1092: and new_tsk.project_id = x_new_project_id;

Line 1140: pa_tasks old_tsk,

1136: (new_tsk.start_date - old_tsk.start_date))))
1137: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491
1138: FROM
1139: pa_job_assignment_overrides o,
1140: pa_tasks old_tsk,
1141: pa_tasks new_tsk
1142: WHERE old_tsk.project_id = x_orig_project_id
1143: and o.task_id = old_tsk.task_id
1144: and old_tsk.task_number = new_tsk.task_number

Line 1141: pa_tasks new_tsk

1137: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491
1138: FROM
1139: pa_job_assignment_overrides o,
1140: pa_tasks old_tsk,
1141: pa_tasks new_tsk
1142: WHERE old_tsk.project_id = x_orig_project_id
1143: and o.task_id = old_tsk.task_id
1144: and old_tsk.task_number = new_tsk.task_number
1145: and new_tsk.project_id = x_new_project_id;

Line 1201: pa_tasks old_tsk,

1197: , o.DISCOUNT_PERCENTAGE
1198: , o.RATE_DISC_REASON_CODE
1199: FROM
1200: pa_emp_bill_rate_overrides o,
1201: pa_tasks old_tsk,
1202: pa_tasks new_tsk
1203: WHERE old_tsk.project_id = x_orig_project_id
1204: and o.task_id = old_tsk.task_id
1205: and old_tsk.task_number = new_tsk.task_number

Line 1202: pa_tasks new_tsk

1198: , o.RATE_DISC_REASON_CODE
1199: FROM
1200: pa_emp_bill_rate_overrides o,
1201: pa_tasks old_tsk,
1202: pa_tasks new_tsk
1203: WHERE old_tsk.project_id = x_orig_project_id
1204: and o.task_id = old_tsk.task_id
1205: and old_tsk.task_number = new_tsk.task_number
1206: and new_tsk.project_id = x_new_project_id;

Line 1265: pa_tasks old_tsk,

1261: , o.DISCOUNT_PERCENTAGE
1262: , o.RATE_DISC_REASON_CODE
1263: FROM
1264: pa_nl_bill_rate_overrides o,
1265: pa_tasks old_tsk,
1266: pa_tasks new_tsk
1267: WHERE old_tsk.project_id = x_orig_project_id
1268: and o.task_id = old_tsk.task_id
1269: and old_tsk.task_number = new_tsk.task_number

Line 1266: pa_tasks new_tsk

1262: , o.RATE_DISC_REASON_CODE
1263: FROM
1264: pa_nl_bill_rate_overrides o,
1265: pa_tasks old_tsk,
1266: pa_tasks new_tsk
1267: WHERE old_tsk.project_id = x_orig_project_id
1268: and o.task_id = old_tsk.task_id
1269: and old_tsk.task_number = new_tsk.task_number
1270: and new_tsk.project_id = x_new_project_id;

Line 1312: pa_tasks old_tsk,

1308: , FND_GLOBAL.USER_ID
1309: , FND_GLOBAL.LOGIN_ID
1310: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1311: FROM pa_labor_multipliers m,
1312: pa_tasks old_tsk,
1313: pa_tasks new_tsk
1314: WHERE old_tsk.project_id = x_orig_project_id
1315: and m.task_id = old_tsk.task_id
1316: and old_tsk.task_number = new_tsk.task_number

Line 1313: pa_tasks new_tsk

1309: , FND_GLOBAL.LOGIN_ID
1310: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1311: FROM pa_labor_multipliers m,
1312: pa_tasks old_tsk,
1313: pa_tasks new_tsk
1314: WHERE old_tsk.project_id = x_orig_project_id
1315: and m.task_id = old_tsk.task_id
1316: and old_tsk.task_number = new_tsk.task_number
1317: and new_tsk.project_id = x_new_project_id;

Line 1357: , 'PA_TASKS'

1353: , pc.class_code
1354: , pc.class_category
1355: , pc.code_percentage
1356: , new_tsk.task_id
1357: , 'PA_TASKS'
1358: , sysdate
1359: , FND_GLOBAL.USER_ID
1360: , sysdate
1361: , FND_GLOBAL.USER_ID

Line 1381: pa_tasks new_tsk,

1377: , pc.attribute14
1378: , pc.attribute15
1379: FROM
1380: pa_project_classes pc,
1381: pa_tasks new_tsk,
1382: pa_tasks old_tsk
1383: WHERE pc.object_id = old_tsk.task_id
1384: AND pc.object_type = 'PA_TASKS'
1385: AND new_tsk.project_id = x_new_project_id

Line 1382: pa_tasks old_tsk

1378: , pc.attribute15
1379: FROM
1380: pa_project_classes pc,
1381: pa_tasks new_tsk,
1382: pa_tasks old_tsk
1383: WHERE pc.object_id = old_tsk.task_id
1384: AND pc.object_type = 'PA_TASKS'
1385: AND new_tsk.project_id = x_new_project_id
1386: AND old_tsk.project_id = x_orig_project_id

Line 1384: AND pc.object_type = 'PA_TASKS'

1380: pa_project_classes pc,
1381: pa_tasks new_tsk,
1382: pa_tasks old_tsk
1383: WHERE pc.object_id = old_tsk.task_id
1384: AND pc.object_type = 'PA_TASKS'
1385: AND new_tsk.project_id = x_new_project_id
1386: AND old_tsk.project_id = x_orig_project_id
1387: AND new_tsk.task_number = old_tsk.task_number;
1388: