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 261: pa_tasks_s.nextval

257: -- See bug 402125 for details
258: -- Bug 5034402: If the start/end date of the source task is NULL then copied
259: -- 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
260: SELECT
261: pa_tasks_s.nextval
262: , x_new_project_id
263: , t.task_number
264: , t.task_name
265: , nvl(t.long_task_name, t.task_name) /* Bug#2638968 */

Line 352: pa_tasks t

348: -- 'FINANCIAL_PLAN'
349: -- )
350: -- ) --Bug 3846768
351: FROM
352: pa_tasks t
353: WHERE
354: t.project_id = x_orig_project_id;
355:
356:

Line 367: Delete from pa_tasks t where

363: l_versioning_enabled = 'Y' AND
364: l_shared = 'Y' AND
365: l_sel_version_id is not NULL
366: THEN
367: Delete from pa_tasks t where
368: t.project_id = x_new_project_id
369: and not exists (select 1
370: from pa_proj_element_versions v,
371: pa_tasks old_tsk,

Line 371: pa_tasks old_tsk,

367: Delete from pa_tasks t where
368: t.project_id = x_new_project_id
369: and not exists (select 1
370: from pa_proj_element_versions v,
371: pa_tasks old_tsk,
372: pa_tasks new_tsk
373: where new_tsk.project_id = x_new_project_id
374: and old_tsk.project_id = x_orig_project_id
375: and old_tsk.task_number = new_tsk.task_number

Line 372: pa_tasks new_tsk

368: t.project_id = x_new_project_id
369: and not exists (select 1
370: from pa_proj_element_versions v,
371: pa_tasks old_tsk,
372: pa_tasks new_tsk
373: where new_tsk.project_id = x_new_project_id
374: and old_tsk.project_id = x_orig_project_id
375: and old_tsk.task_number = new_tsk.task_number
376: and v.project_id = x_orig_project_id

Line 378: and v.object_type='PA_TASKS'

374: and old_tsk.project_id = x_orig_project_id
375: and old_tsk.task_number = new_tsk.task_number
376: and v.project_id = x_orig_project_id
377: and v.PARENT_STRUCTURE_VERSION_ID = l_sel_version_id
378: and v.object_type='PA_TASKS'
379: and v.proj_element_id = old_tsk.task_id
380: and t.task_id = new_tsk.task_id);
381: END IF;
382: -- Bug 4104042 - End

Line 391: FROM pa_tasks old_tsk

387: pa_projects P
388: SET
389: P.cc_tax_task_id = (
390: SELECT new_tsk.task_id
391: FROM pa_tasks old_tsk
392: , pa_tasks new_tsk
393: WHERE new_tsk.project_id = x_new_project_id
394: AND old_tsk.project_id = x_orig_project_id
395: AND P.cc_tax_task_id = old_tsk.task_id

Line 392: , pa_tasks new_tsk

388: SET
389: P.cc_tax_task_id = (
390: SELECT new_tsk.task_id
391: FROM pa_tasks old_tsk
392: , pa_tasks new_tsk
393: WHERE new_tsk.project_id = x_new_project_id
394: AND old_tsk.project_id = x_orig_project_id
395: AND P.cc_tax_task_id = old_tsk.task_id
396: AND old_tsk.task_number = new_tsk.task_number )

Line 403: pa_tasks T

399:
400: x_err_stage := 'update parent task id';
401:
402: UPDATE
403: pa_tasks T
404: SET
405: T.parent_task_id = (
406: SELECT new_tsk.task_id
407: FROM pa_tasks old_tsk

Line 407: FROM pa_tasks old_tsk

403: pa_tasks T
404: SET
405: T.parent_task_id = (
406: SELECT new_tsk.task_id
407: FROM pa_tasks old_tsk
408: , pa_tasks new_tsk
409: WHERE new_tsk.project_id = x_new_project_id
410: AND old_tsk.project_id = x_orig_project_id
411: AND T.parent_task_id = old_tsk.task_id

Line 408: , pa_tasks new_tsk

404: SET
405: T.parent_task_id = (
406: SELECT new_tsk.task_id
407: FROM pa_tasks old_tsk
408: , pa_tasks new_tsk
409: WHERE new_tsk.project_id = x_new_project_id
410: AND old_tsk.project_id = x_orig_project_id
411: AND T.parent_task_id = old_tsk.task_id
412: AND old_tsk.task_number = new_tsk.task_number )

Line 418: pa_tasks T

414:
415: x_err_stage := 'update top task id';
416:
417: UPDATE
418: pa_tasks T
419: SET
420: T.top_task_id = (
421: SELECT new_tsk.task_id
422: FROM pa_tasks old_tsk

Line 422: FROM pa_tasks old_tsk

418: pa_tasks T
419: SET
420: T.top_task_id = (
421: SELECT new_tsk.task_id
422: FROM pa_tasks old_tsk
423: , pa_tasks new_tsk
424: WHERE new_tsk.project_id = x_new_project_id
425: AND old_tsk.project_id = x_orig_project_id
426: AND T.top_task_id = old_tsk.task_id

Line 423: , pa_tasks new_tsk

419: SET
420: T.top_task_id = (
421: SELECT new_tsk.task_id
422: FROM pa_tasks old_tsk
423: , pa_tasks new_tsk
424: WHERE new_tsk.project_id = x_new_project_id
425: AND old_tsk.project_id = x_orig_project_id
426: AND T.top_task_id = old_tsk.task_id
427: AND old_tsk.task_number = new_tsk.task_number )

Line 441: from pa_tasks orig, pa_tasks new

437: Declare
438: cursor c_attach_tasks is
439: select orig.task_id orig_task_id,
440: new.task_id new_task_id
441: from pa_tasks orig, pa_tasks new
442: where orig.project_id = x_orig_project_id
443: and new.task_number = orig.task_number
444: and new.project_id = x_new_project_id ;
445:

Line 456: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',

452: into c_atch ;
453: if c_attach_tasks%notfound then
454: exit ;
455: end if;
456: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
457: c_atch.orig_task_id,
458: null, null, null, null,
459: 'PA_TASKS',
460: c_atch.new_task_id,

Line 459: 'PA_TASKS',

455: end if;
456: fnd_attached_documents2_pkg.copy_attachments('PA_TASKS',
457: c_atch.orig_task_id,
458: null, null, null, null,
459: 'PA_TASKS',
460: c_atch.new_task_id,
461: null, null, null, null,
462: FND_GLOBAL.USER_ID,
463: FND_GLOBAL.LOGIN_ID,

Line 545: , pa_tasks new_tsk

541: s.ORG_STRUCTURE_VERSION_ID,
542: s.START_ORGANIZATION_ID,
543: s.IND_RATE_SCH_USAGE --bug 3053508
544: FROM pa_ind_rate_schedules s
545: , pa_tasks new_tsk
546: , pa_tasks old_tsk
547: WHERE
548: s.project_id = x_orig_project_id
549: AND s.task_id = old_tsk.task_id

Line 546: , pa_tasks old_tsk

542: s.START_ORGANIZATION_ID,
543: s.IND_RATE_SCH_USAGE --bug 3053508
544: FROM pa_ind_rate_schedules s
545: , pa_tasks new_tsk
546: , pa_tasks old_tsk
547: WHERE
548: s.project_id = x_orig_project_id
549: AND s.task_id = old_tsk.task_id
550: AND new_tsk.project_id = x_new_project_id

Line 609: pa_tasks old_task,

605: rev.START_ORGANIZATION_ID
606: from pa_ind_rate_sch_revisions rev,
607: pa_ind_rate_schedules old_sch,
608: pa_ind_rate_schedules new_sch,
609: pa_tasks old_task,
610: pa_tasks new_task
611: where old_sch.project_id = x_orig_project_id
612: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
613: and old_sch.task_id = old_task.task_id

Line 610: pa_tasks new_task

606: from pa_ind_rate_sch_revisions rev,
607: pa_ind_rate_schedules old_sch,
608: pa_ind_rate_schedules new_sch,
609: pa_tasks old_task,
610: pa_tasks new_task
611: where old_sch.project_id = x_orig_project_id
612: and old_sch.ind_rate_sch_id = rev.IND_RATE_SCH_ID
613: and old_sch.task_id = old_task.task_id
614: and new_sch.project_id = x_new_project_id

Line 649: pa_tasks old_task,

645: pa_ind_rate_sch_revisions old_rev,
646: pa_ind_rate_sch_revisions new_rev,
647: pa_ind_rate_schedules old_sch,
648: pa_ind_rate_schedules new_sch,
649: pa_tasks old_task,
650: pa_tasks new_task
651: where old_rev.IND_RATE_SCH_REVISION_ID =
652: mult.IND_RATE_SCH_REVISION_ID
653: and old_rev.IND_RATE_SCH_REVISION =

Line 650: pa_tasks new_task

646: pa_ind_rate_sch_revisions new_rev,
647: pa_ind_rate_schedules old_sch,
648: pa_ind_rate_schedules new_sch,
649: pa_tasks old_task,
650: pa_tasks new_task
651: where old_rev.IND_RATE_SCH_REVISION_ID =
652: mult.IND_RATE_SCH_REVISION_ID
653: and old_rev.IND_RATE_SCH_REVISION =
654: new_rev.IND_RATE_SCH_REVISION

Line 737: , pa_tasks new_tsk

733: , tc.workplan_res_only_flag
734: , tc.employees_only_flag
735: FROM
736: pa_transaction_controls tc
737: , pa_tasks new_tsk
738: , pa_tasks old_tsk
739: WHERE
740: tc.project_id = x_orig_project_id
741: AND tc.task_id = old_tsk.task_id

Line 738: , pa_tasks old_tsk

734: , tc.employees_only_flag
735: FROM
736: pa_transaction_controls tc
737: , pa_tasks new_tsk
738: , pa_tasks old_tsk
739: WHERE
740: tc.project_id = x_orig_project_id
741: AND tc.task_id = old_tsk.task_id
742: AND new_tsk.project_id = x_new_project_id

Line 846: pa_tasks old_tsk,

842: a.FUNDING_EXCHANGE_RATE,
843: 1
844: from pa_billing_assignments a,
845: -- pa_projects new_proj, bug 4189010
846: pa_tasks old_tsk,
847: pa_tasks new_tsk
848: where a.project_id = x_orig_project_id
849: and a.top_task_id is not null
850: and a.top_task_id = old_tsk.task_id

Line 847: pa_tasks new_tsk

843: 1
844: from pa_billing_assignments a,
845: -- pa_projects new_proj, bug 4189010
846: pa_tasks old_tsk,
847: pa_tasks new_tsk
848: where a.project_id = x_orig_project_id
849: and a.top_task_id is not null
850: and a.top_task_id = old_tsk.task_id
851: and old_tsk.task_number = new_tsk.task_number

Line 888: pa_tasks old_tsk,

884: FND_GLOBAL.LOGIN_ID
885: from pa_project_asset_assignments assign,
886: pa_project_assets old_asset,
887: pa_project_assets new_asset,
888: pa_tasks old_tsk,
889: pa_tasks new_tsk
890: where old_asset.project_id = x_orig_project_id
891: and old_asset.project_asset_id = assign.project_asset_id
892: and assign.task_id = old_tsk.task_id

Line 889: pa_tasks new_tsk

885: from pa_project_asset_assignments assign,
886: pa_project_assets old_asset,
887: pa_project_assets new_asset,
888: pa_tasks old_tsk,
889: pa_tasks new_tsk
890: where old_asset.project_id = x_orig_project_id
891: and old_asset.project_asset_id = assign.project_asset_id
892: and assign.task_id = old_tsk.task_id
893: /* Added the following conditions for bug#2530093 */

Line 911: pa_tasks old_tsk,

907: sysdate,
908: FND_GLOBAL.USER_ID,
909: FND_GLOBAL.LOGIN_ID
910: from pa_project_asset_assignments assign,
911: pa_tasks old_tsk,
912: pa_tasks new_tsk
913: where assign.project_id = x_orig_project_id
914: and assign.task_id = old_tsk.task_id
915: and old_tsk.task_number = new_tsk.task_number

Line 912: pa_tasks new_tsk

908: FND_GLOBAL.USER_ID,
909: FND_GLOBAL.LOGIN_ID
910: from pa_project_asset_assignments assign,
911: pa_tasks old_tsk,
912: pa_tasks new_tsk
913: where assign.project_id = x_orig_project_id
914: and assign.task_id = old_tsk.task_id
915: and old_tsk.task_number = new_tsk.task_number
916: and new_tsk.project_id = x_new_project_id

Line 979: pa_tasks old_tsk,

975: , o.DISCOUNT_PERCENTAGE
976: , o.RATE_DISC_REASON_CODE
977: FROM
978: pa_job_bill_rate_overrides o,
979: pa_tasks old_tsk,
980: pa_tasks new_tsk
981: WHERE old_tsk.project_id = x_orig_project_id
982: and o.task_id = old_tsk.task_id
983: and old_tsk.task_number = new_tsk.task_number

Line 980: pa_tasks new_tsk

976: , o.RATE_DISC_REASON_CODE
977: FROM
978: pa_job_bill_rate_overrides o,
979: pa_tasks old_tsk,
980: pa_tasks new_tsk
981: WHERE old_tsk.project_id = x_orig_project_id
982: and o.task_id = old_tsk.task_id
983: and old_tsk.task_number = new_tsk.task_number
984: and new_tsk.project_id = x_new_project_id;

Line 1030: pa_tasks old_tsk,

1026: (new_tsk.start_date - old_tsk.start_date))))
1027: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1028: FROM
1029: pa_job_bill_title_overrides o,
1030: pa_tasks old_tsk,
1031: pa_tasks new_tsk
1032: WHERE old_tsk.project_id = x_orig_project_id
1033: and o.task_id = old_tsk.task_id
1034: and old_tsk.task_number = new_tsk.task_number

Line 1031: pa_tasks new_tsk

1027: , pa_job_bill_title_overrides_s.NEXTVAL --Added the column for the bug 2581491
1028: FROM
1029: pa_job_bill_title_overrides o,
1030: pa_tasks old_tsk,
1031: pa_tasks new_tsk
1032: WHERE old_tsk.project_id = x_orig_project_id
1033: and o.task_id = old_tsk.task_id
1034: and old_tsk.task_number = new_tsk.task_number
1035: and new_tsk.project_id = x_new_project_id;

Line 1083: pa_tasks old_tsk,

1079: (new_tsk.start_date - old_tsk.start_date))))
1080: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491
1081: FROM
1082: pa_job_assignment_overrides o,
1083: pa_tasks old_tsk,
1084: pa_tasks new_tsk
1085: WHERE old_tsk.project_id = x_orig_project_id
1086: and o.task_id = old_tsk.task_id
1087: and old_tsk.task_number = new_tsk.task_number

Line 1084: pa_tasks new_tsk

1080: , pa_job_assignment_overrides_s.NEXTVAL --Added the column for the bug 2581491
1081: FROM
1082: pa_job_assignment_overrides o,
1083: pa_tasks old_tsk,
1084: pa_tasks new_tsk
1085: WHERE old_tsk.project_id = x_orig_project_id
1086: and o.task_id = old_tsk.task_id
1087: and old_tsk.task_number = new_tsk.task_number
1088: and new_tsk.project_id = x_new_project_id;

Line 1144: pa_tasks old_tsk,

1140: , o.DISCOUNT_PERCENTAGE
1141: , o.RATE_DISC_REASON_CODE
1142: FROM
1143: pa_emp_bill_rate_overrides o,
1144: pa_tasks old_tsk,
1145: pa_tasks new_tsk
1146: WHERE old_tsk.project_id = x_orig_project_id
1147: and o.task_id = old_tsk.task_id
1148: and old_tsk.task_number = new_tsk.task_number

Line 1145: pa_tasks new_tsk

1141: , o.RATE_DISC_REASON_CODE
1142: FROM
1143: pa_emp_bill_rate_overrides o,
1144: pa_tasks old_tsk,
1145: pa_tasks new_tsk
1146: WHERE old_tsk.project_id = x_orig_project_id
1147: and o.task_id = old_tsk.task_id
1148: and old_tsk.task_number = new_tsk.task_number
1149: and new_tsk.project_id = x_new_project_id;

Line 1208: pa_tasks old_tsk,

1204: , o.DISCOUNT_PERCENTAGE
1205: , o.RATE_DISC_REASON_CODE
1206: FROM
1207: pa_nl_bill_rate_overrides o,
1208: pa_tasks old_tsk,
1209: pa_tasks new_tsk
1210: WHERE old_tsk.project_id = x_orig_project_id
1211: and o.task_id = old_tsk.task_id
1212: and old_tsk.task_number = new_tsk.task_number

Line 1209: pa_tasks new_tsk

1205: , o.RATE_DISC_REASON_CODE
1206: FROM
1207: pa_nl_bill_rate_overrides o,
1208: pa_tasks old_tsk,
1209: pa_tasks new_tsk
1210: WHERE old_tsk.project_id = x_orig_project_id
1211: and o.task_id = old_tsk.task_id
1212: and old_tsk.task_number = new_tsk.task_number
1213: and new_tsk.project_id = x_new_project_id;

Line 1255: pa_tasks old_tsk,

1251: , FND_GLOBAL.USER_ID
1252: , FND_GLOBAL.LOGIN_ID
1253: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1254: FROM pa_labor_multipliers m,
1255: pa_tasks old_tsk,
1256: pa_tasks new_tsk
1257: WHERE old_tsk.project_id = x_orig_project_id
1258: and m.task_id = old_tsk.task_id
1259: and old_tsk.task_number = new_tsk.task_number

Line 1256: pa_tasks new_tsk

1252: , FND_GLOBAL.LOGIN_ID
1253: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1254: FROM pa_labor_multipliers m,
1255: pa_tasks old_tsk,
1256: pa_tasks new_tsk
1257: WHERE old_tsk.project_id = x_orig_project_id
1258: and m.task_id = old_tsk.task_id
1259: and old_tsk.task_number = new_tsk.task_number
1260: and new_tsk.project_id = x_new_project_id;

Line 1300: , 'PA_TASKS'

1296: , pc.class_code
1297: , pc.class_category
1298: , pc.code_percentage
1299: , new_tsk.task_id
1300: , 'PA_TASKS'
1301: , sysdate
1302: , FND_GLOBAL.USER_ID
1303: , sysdate
1304: , FND_GLOBAL.USER_ID

Line 1324: pa_tasks new_tsk,

1320: , pc.attribute14
1321: , pc.attribute15
1322: FROM
1323: pa_project_classes pc,
1324: pa_tasks new_tsk,
1325: pa_tasks old_tsk
1326: WHERE pc.object_id = old_tsk.task_id
1327: AND pc.object_type = 'PA_TASKS'
1328: AND new_tsk.project_id = x_new_project_id

Line 1325: pa_tasks old_tsk

1321: , pc.attribute15
1322: FROM
1323: pa_project_classes pc,
1324: pa_tasks new_tsk,
1325: pa_tasks old_tsk
1326: WHERE pc.object_id = old_tsk.task_id
1327: AND pc.object_type = 'PA_TASKS'
1328: AND new_tsk.project_id = x_new_project_id
1329: AND old_tsk.project_id = x_orig_project_id

Line 1327: AND pc.object_type = 'PA_TASKS'

1323: pa_project_classes pc,
1324: pa_tasks new_tsk,
1325: pa_tasks old_tsk
1326: WHERE pc.object_id = old_tsk.task_id
1327: AND pc.object_type = 'PA_TASKS'
1328: AND new_tsk.project_id = x_new_project_id
1329: AND old_tsk.project_id = x_orig_project_id
1330: AND new_tsk.task_number = old_tsk.task_number;
1331: