DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on FND_GLOBAL

Line 267: , FND_GLOBAL.USER_ID

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

Line 269: , FND_GLOBAL.USER_ID

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

Line 270: , FND_GLOBAL.LOGIN_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

Line 462: FND_GLOBAL.USER_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,
464: 275, null, null);
465:
466: end loop ;

Line 463: FND_GLOBAL.LOGIN_ID,

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;

Line 529: FND_GLOBAL.USER_ID,

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,

Line 530: FND_GLOBAL.USER_ID,

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,

Line 532: FND_GLOBAL.LOGIN_ID,

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,

Line 593: FND_GLOBAL.USER_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,

Line 594: FND_GLOBAL.USER_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,

Line 596: FND_GLOBAL.LOGIN_ID,

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,

Line 640: FND_GLOBAL.USER_ID,

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,

Line 641: FND_GLOBAL.USER_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,
645: pa_ind_rate_sch_revisions old_rev,

Line 643: FND_GLOBAL.LOGIN_ID

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,

Line 715: , FND_GLOBAL.USER_ID

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

Line 717: , FND_GLOBAL.USER_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

Line 718: , FND_GLOBAL.LOGIN_ID

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

Line 807: FND_GLOBAL.USER_ID,

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,

Line 809: FND_GLOBAL.USER_ID,

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,

Line 810: FND_GLOBAL.LOGIN_ID,

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,

Line 881: FND_GLOBAL.USER_ID,

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,

Line 883: FND_GLOBAL.USER_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,
886: pa_project_assets old_asset,
887: pa_project_assets new_asset,

Line 884: FND_GLOBAL.LOGIN_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,
888: pa_tasks old_tsk,

Line 906: FND_GLOBAL.USER_ID,

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,

Line 908: FND_GLOBAL.USER_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,
911: pa_tasks old_tsk,
912: pa_tasks new_tsk

Line 909: FND_GLOBAL.LOGIN_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
913: where assign.project_id = x_orig_project_id

Line 956: , FND_GLOBAL.USER_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

Line 958: , FND_GLOBAL.USER_ID

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

Line 959: , FND_GLOBAL.LOGIN_ID

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

Line 1006: , FND_GLOBAL.USER_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,

Line 1008: , FND_GLOBAL.USER_ID

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,

Line 1009: , FND_GLOBAL.LOGIN_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,
1013: null, o.start_date_active + x_delta,

Line 1058: , FND_GLOBAL.USER_ID

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,

Line 1060: , FND_GLOBAL.USER_ID

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,

Line 1061: , FND_GLOBAL.LOGIN_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,
1065: null, o.start_date_active + x_delta,

Line 1115: , FND_GLOBAL.USER_ID

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

Line 1117: , FND_GLOBAL.USER_ID

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,

Line 1118: , FND_GLOBAL.LOGIN_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,
1122: null, x_new_proj_start,

Line 1177: , FND_GLOBAL.USER_ID

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,

Line 1179: , FND_GLOBAL.USER_ID

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,

Line 1180: , FND_GLOBAL.LOGIN_ID

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,

Line 1249: , FND_GLOBAL.USER_ID

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

Line 1251: , FND_GLOBAL.USER_ID

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,

Line 1252: , FND_GLOBAL.LOGIN_ID

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

Line 1302: , FND_GLOBAL.USER_ID

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

Line 1304: , FND_GLOBAL.USER_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
1307: , pc.attribute1
1308: , pc.attribute2

Line 1305: , FND_GLOBAL.LOGIN_ID

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

Line 1413: FND_GLOBAL.User_ID,

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,

Line 1415: FND_GLOBAL.User_ID,

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

Line 1416: FND_GLOBAL.Login_ID,

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