263: , t.task_number
264: , t.task_name
265: , nvl(t.long_task_name, t.task_name) /* Bug#2638968 */
266: , sysdate
267: , FND_GLOBAL.USER_ID
268: , sysdate
269: , FND_GLOBAL.USER_ID
270: , FND_GLOBAL.LOGIN_ID
271: , t.wbs_level
265: , nvl(t.long_task_name, t.task_name) /* Bug#2638968 */
266: , sysdate
267: , FND_GLOBAL.USER_ID
268: , sysdate
269: , FND_GLOBAL.USER_ID
270: , FND_GLOBAL.LOGIN_ID
271: , t.wbs_level
272: , t.top_task_id
273: , t.parent_task_id
266: , sysdate
267: , FND_GLOBAL.USER_ID
268: , sysdate
269: , FND_GLOBAL.USER_ID
270: , FND_GLOBAL.LOGIN_ID
271: , t.wbs_level
272: , t.top_task_id
273: , t.parent_task_id
274: , t.ready_to_bill_flag
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,
464: 275, null, null);
465:
466: end loop ;
459: 'PA_TASKS',
460: c_atch.new_task_id,
461: null, null, null, null,
462: FND_GLOBAL.USER_ID,
463: FND_GLOBAL.LOGIN_ID,
464: 275, null, null);
465:
466: end loop ;
467: close c_attach_tasks;
525: s.start_date_active + x_delta),
526: decode(x_delta, null, sysdate,
527: s.end_date_active + x_delta),
528: sysdate,
529: FND_GLOBAL.USER_ID,
530: FND_GLOBAL.USER_ID,
531: sysdate,
532: FND_GLOBAL.LOGIN_ID,
533: s.COST_PLUS_STRUCTURE,
526: decode(x_delta, null, sysdate,
527: s.end_date_active + x_delta),
528: sysdate,
529: FND_GLOBAL.USER_ID,
530: FND_GLOBAL.USER_ID,
531: sysdate,
532: FND_GLOBAL.LOGIN_ID,
533: s.COST_PLUS_STRUCTURE,
534: s.IND_RATE_SCHEDULE_TYPE,
528: sysdate,
529: FND_GLOBAL.USER_ID,
530: FND_GLOBAL.USER_ID,
531: sysdate,
532: FND_GLOBAL.LOGIN_ID,
533: s.COST_PLUS_STRUCTURE,
534: s.IND_RATE_SCHEDULE_TYPE,
535: x_new_project_id,
536: new_tsk.task_id,
589: decode(x_delta, null, sysdate,
590: rev.end_date_active + x_delta),
591: null,
592: sysdate,
593: FND_GLOBAL.USER_ID,
594: FND_GLOBAL.USER_ID,
595: sysdate,
596: FND_GLOBAL.LOGIN_ID,
597: rev.REQUEST_ID,
590: rev.end_date_active + x_delta),
591: null,
592: sysdate,
593: FND_GLOBAL.USER_ID,
594: FND_GLOBAL.USER_ID,
595: sysdate,
596: FND_GLOBAL.LOGIN_ID,
597: rev.REQUEST_ID,
598: NULL,
592: sysdate,
593: FND_GLOBAL.USER_ID,
594: FND_GLOBAL.USER_ID,
595: sysdate,
596: FND_GLOBAL.LOGIN_ID,
597: rev.REQUEST_ID,
598: NULL,
599: NULL,
600: NULL,
636: mult.ORGANIZATION_ID,
637: mult.IND_COST_CODE,
638: mult.MULTIPLIER,
639: sysdate,
640: FND_GLOBAL.USER_ID,
641: FND_GLOBAL.USER_ID,
642: sysdate,
643: FND_GLOBAL.LOGIN_ID
644: from pa_ind_cost_multipliers mult,
637: mult.IND_COST_CODE,
638: mult.MULTIPLIER,
639: sysdate,
640: FND_GLOBAL.USER_ID,
641: FND_GLOBAL.USER_ID,
642: sysdate,
643: FND_GLOBAL.LOGIN_ID
644: from pa_ind_cost_multipliers mult,
645: pa_ind_rate_sch_revisions old_rev,
639: sysdate,
640: FND_GLOBAL.USER_ID,
641: FND_GLOBAL.USER_ID,
642: sysdate,
643: FND_GLOBAL.LOGIN_ID
644: from pa_ind_cost_multipliers mult,
645: pa_ind_rate_sch_revisions old_rev,
646: pa_ind_rate_sch_revisions new_rev,
647: pa_ind_rate_schedules old_sch,
711: nvl(nvl(new_tsk.completion_date,x_new_proj_completion),trunc(SYSDATE)))),trunc(SYSDATE)) --Bug#6880617
712: , tc.chargeable_flag
713: , tc.billable_indicator
714: , sysdate
715: , FND_GLOBAL.USER_ID
716: , sysdate
717: , FND_GLOBAL.USER_ID
718: , FND_GLOBAL.LOGIN_ID
719: , tc.person_id
713: , tc.billable_indicator
714: , sysdate
715: , FND_GLOBAL.USER_ID
716: , sysdate
717: , FND_GLOBAL.USER_ID
718: , FND_GLOBAL.LOGIN_ID
719: , tc.person_id
720: , tc.expenditure_category
721: , tc.expenditure_type
714: , sysdate
715: , FND_GLOBAL.USER_ID
716: , sysdate
717: , FND_GLOBAL.USER_ID
718: , FND_GLOBAL.LOGIN_ID
719: , tc.person_id
720: , tc.expenditure_category
721: , tc.expenditure_type
722: , tc.non_labor_resource
803: a.AMOUNT,
804: a.PERCENTAGE,
805: a.ACTIVE_FLAG,
806: sysdate,
807: FND_GLOBAL.USER_ID,
808: sysdate,
809: FND_GLOBAL.USER_ID,
810: FND_GLOBAL.LOGIN_ID,
811: a.ATTRIBUTE_CATEGORY,
805: a.ACTIVE_FLAG,
806: sysdate,
807: FND_GLOBAL.USER_ID,
808: sysdate,
809: FND_GLOBAL.USER_ID,
810: FND_GLOBAL.LOGIN_ID,
811: a.ATTRIBUTE_CATEGORY,
812: a.ATTRIBUTE1,
813: a.ATTRIBUTE2,
806: sysdate,
807: FND_GLOBAL.USER_ID,
808: sysdate,
809: FND_GLOBAL.USER_ID,
810: FND_GLOBAL.LOGIN_ID,
811: a.ATTRIBUTE_CATEGORY,
812: a.ATTRIBUTE1,
813: a.ATTRIBUTE2,
814: a.ATTRIBUTE3,
877: new_asset.PROJECT_ASSET_ID,
878: new_tsk.task_id,
879: new_asset.PROJECT_ID,
880: sysdate,
881: FND_GLOBAL.USER_ID,
882: sysdate,
883: FND_GLOBAL.USER_ID,
884: FND_GLOBAL.LOGIN_ID
885: from pa_project_asset_assignments assign,
879: new_asset.PROJECT_ID,
880: sysdate,
881: FND_GLOBAL.USER_ID,
882: sysdate,
883: FND_GLOBAL.USER_ID,
884: FND_GLOBAL.LOGIN_ID
885: from pa_project_asset_assignments assign,
886: pa_project_assets old_asset,
887: pa_project_assets new_asset,
880: sysdate,
881: FND_GLOBAL.USER_ID,
882: sysdate,
883: FND_GLOBAL.USER_ID,
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,
902: assign.PROJECT_ASSET_ID,
903: new_tsk.task_id,
904: x_new_project_id,
905: sysdate,
906: FND_GLOBAL.USER_ID,
907: sysdate,
908: FND_GLOBAL.USER_ID,
909: FND_GLOBAL.LOGIN_ID
910: from pa_project_asset_assignments assign,
904: x_new_project_id,
905: sysdate,
906: FND_GLOBAL.USER_ID,
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
905: sysdate,
906: FND_GLOBAL.USER_ID,
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
952: null, o.start_date_active + x_delta,
953: o.start_date_active +
954: (new_tsk.start_date - old_tsk.start_date))),trunc(sysdate)) -- Modified for bug# 5961484
955: , sysdate
956: , FND_GLOBAL.USER_ID
957: , sysdate
958: , FND_GLOBAL.USER_ID
959: , FND_GLOBAL.LOGIN_ID
960: , o.RATE
954: (new_tsk.start_date - old_tsk.start_date))),trunc(sysdate)) -- Modified for bug# 5961484
955: , sysdate
956: , FND_GLOBAL.USER_ID
957: , sysdate
958: , FND_GLOBAL.USER_ID
959: , FND_GLOBAL.LOGIN_ID
960: , o.RATE
961: , o.BILL_RATE_UNIT
962: , null
955: , sysdate
956: , FND_GLOBAL.USER_ID
957: , sysdate
958: , FND_GLOBAL.USER_ID
959: , FND_GLOBAL.LOGIN_ID
960: , o.RATE
961: , o.BILL_RATE_UNIT
962: , null
963: , new_tsk.task_id
1002: , JOB_BILL_TITLE_OVERRIDE_ID) --Added the column for the bug 2581491
1003: SELECT
1004: o.JOB_ID
1005: , sysdate
1006: , FND_GLOBAL.USER_ID
1007: , sysdate
1008: , FND_GLOBAL.USER_ID
1009: , FND_GLOBAL.LOGIN_ID
1010: , nvl(decode(x_delta,
1004: o.JOB_ID
1005: , sysdate
1006: , FND_GLOBAL.USER_ID
1007: , sysdate
1008: , FND_GLOBAL.USER_ID
1009: , FND_GLOBAL.LOGIN_ID
1010: , nvl(decode(x_delta,
1011: null, x_new_proj_start,
1012: decode(new_tsk.start_date,
1005: , sysdate
1006: , FND_GLOBAL.USER_ID
1007: , sysdate
1008: , FND_GLOBAL.USER_ID
1009: , FND_GLOBAL.LOGIN_ID
1010: , nvl(decode(x_delta,
1011: null, x_new_proj_start,
1012: decode(new_tsk.start_date,
1013: null, o.start_date_active + x_delta,
1054: , JOB_ASSIGNMENT_OVERRIDE_ID) --Added the column for the bug 2581491
1055: SELECT
1056: o.PERSON_ID
1057: , sysdate
1058: , FND_GLOBAL.USER_ID
1059: , sysdate
1060: , FND_GLOBAL.USER_ID
1061: , FND_GLOBAL.LOGIN_ID
1062: , nvl(decode(x_delta,
1056: o.PERSON_ID
1057: , sysdate
1058: , FND_GLOBAL.USER_ID
1059: , sysdate
1060: , FND_GLOBAL.USER_ID
1061: , FND_GLOBAL.LOGIN_ID
1062: , nvl(decode(x_delta,
1063: null, x_new_proj_start,
1064: decode(new_tsk.start_date,
1057: , sysdate
1058: , FND_GLOBAL.USER_ID
1059: , sysdate
1060: , FND_GLOBAL.USER_ID
1061: , FND_GLOBAL.LOGIN_ID
1062: , nvl(decode(x_delta,
1063: null, x_new_proj_start,
1064: decode(new_tsk.start_date,
1065: null, o.start_date_active + x_delta,
1111: , RATE_DISC_REASON_CODE)
1112: SELECT
1113: o.PERSON_ID
1114: , sysdate
1115: , FND_GLOBAL.USER_ID
1116: , sysdate
1117: , FND_GLOBAL.USER_ID
1118: , FND_GLOBAL.LOGIN_ID
1119: , o.RATE
1113: o.PERSON_ID
1114: , sysdate
1115: , FND_GLOBAL.USER_ID
1116: , sysdate
1117: , FND_GLOBAL.USER_ID
1118: , FND_GLOBAL.LOGIN_ID
1119: , o.RATE
1120: , o.BILL_RATE_UNIT
1121: , nvl(decode(x_delta,
1114: , sysdate
1115: , FND_GLOBAL.USER_ID
1116: , sysdate
1117: , FND_GLOBAL.USER_ID
1118: , FND_GLOBAL.LOGIN_ID
1119: , o.RATE
1120: , o.BILL_RATE_UNIT
1121: , nvl(decode(x_delta,
1122: null, x_new_proj_start,
1173: , RATE_DISC_REASON_CODE )
1174: SELECT
1175: o.EXPENDITURE_TYPE
1176: , sysdate
1177: , FND_GLOBAL.USER_ID
1178: , sysdate
1179: , FND_GLOBAL.USER_ID
1180: , FND_GLOBAL.LOGIN_ID
1181: , nvl(decode(x_delta,
1175: o.EXPENDITURE_TYPE
1176: , sysdate
1177: , FND_GLOBAL.USER_ID
1178: , sysdate
1179: , FND_GLOBAL.USER_ID
1180: , FND_GLOBAL.LOGIN_ID
1181: , nvl(decode(x_delta,
1182: null, x_new_proj_start,
1183: decode(new_tsk.start_date,
1176: , sysdate
1177: , FND_GLOBAL.USER_ID
1178: , sysdate
1179: , FND_GLOBAL.USER_ID
1180: , FND_GLOBAL.LOGIN_ID
1181: , nvl(decode(x_delta,
1182: null, x_new_proj_start,
1183: decode(new_tsk.start_date,
1184: null, o.start_date_active + x_delta,
1245: null, m.end_date_active + x_delta,
1246: m.end_date_active +
1247: (new_tsk.start_date - old_tsk.start_date))))
1248: , sysdate
1249: , FND_GLOBAL.USER_ID
1250: , sysdate
1251: , FND_GLOBAL.USER_ID
1252: , FND_GLOBAL.LOGIN_ID
1253: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491
1247: (new_tsk.start_date - old_tsk.start_date))))
1248: , sysdate
1249: , FND_GLOBAL.USER_ID
1250: , sysdate
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,
1248: , sysdate
1249: , FND_GLOBAL.USER_ID
1250: , sysdate
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
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
1305: , FND_GLOBAL.LOGIN_ID
1306: , pc.attribute_category
1300: , 'PA_TASKS'
1301: , sysdate
1302: , FND_GLOBAL.USER_ID
1303: , sysdate
1304: , FND_GLOBAL.USER_ID
1305: , FND_GLOBAL.LOGIN_ID
1306: , pc.attribute_category
1307: , pc.attribute1
1308: , pc.attribute2
1301: , sysdate
1302: , FND_GLOBAL.USER_ID
1303: , sysdate
1304: , FND_GLOBAL.USER_ID
1305: , FND_GLOBAL.LOGIN_ID
1306: , pc.attribute_category
1307: , pc.attribute1
1308: , pc.attribute2
1309: , pc.attribute3
1409: enabled_flag,
1410: trunc(sysdate),
1411: NULL,
1412: sysdate,
1413: FND_GLOBAL.User_ID,
1414: sysdate,
1415: FND_GLOBAL.User_ID,
1416: FND_GLOBAL.Login_ID,
1417: x_status_type,
1411: NULL,
1412: sysdate,
1413: FND_GLOBAL.User_ID,
1414: sysdate,
1415: FND_GLOBAL.User_ID,
1416: FND_GLOBAL.Login_ID,
1417: x_status_type,
1418: COPY_TO_USER_STATUS_FLAG
1419: FROM pa_project_status_controls pas1
1412: sysdate,
1413: FND_GLOBAL.User_ID,
1414: sysdate,
1415: FND_GLOBAL.User_ID,
1416: FND_GLOBAL.Login_ID,
1417: x_status_type,
1418: COPY_TO_USER_STATUS_FLAG
1419: FROM pa_project_status_controls pas1
1420: WHERE pas1.project_system_status_code = X_Project_System_Status_Code