DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE2 dependencies on FND_GLOBAL

Line 271: , FND_GLOBAL.USER_ID

267: , t.task_name
268: , t.address_id /* 13373337 */
269: , nvl(t.long_task_name, t.task_name) /* Bug#2638968 */
270: , sysdate
271: , FND_GLOBAL.USER_ID
272: , sysdate
273: , FND_GLOBAL.USER_ID
274: , FND_GLOBAL.LOGIN_ID
275: , t.wbs_level

Line 273: , FND_GLOBAL.USER_ID

269: , nvl(t.long_task_name, t.task_name) /* Bug#2638968 */
270: , sysdate
271: , FND_GLOBAL.USER_ID
272: , sysdate
273: , FND_GLOBAL.USER_ID
274: , FND_GLOBAL.LOGIN_ID
275: , t.wbs_level
276: , t.top_task_id
277: , t.parent_task_id

Line 274: , FND_GLOBAL.LOGIN_ID

270: , sysdate
271: , FND_GLOBAL.USER_ID
272: , sysdate
273: , FND_GLOBAL.USER_ID
274: , FND_GLOBAL.LOGIN_ID
275: , t.wbs_level
276: , t.top_task_id
277: , t.parent_task_id
278: , t.ready_to_bill_flag

Line 470: FND_GLOBAL.USER_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,
472: 275, null, null);
473:
474: end loop ;

Line 471: FND_GLOBAL.LOGIN_ID,

467: 'PA_TASKS',
468: c_atch.new_task_id,
469: null, null, null, null,
470: FND_GLOBAL.USER_ID,
471: FND_GLOBAL.LOGIN_ID,
472: 275, null, null);
473:
474: end loop ;
475: close c_attach_tasks;

Line 540: FND_GLOBAL.USER_ID,

536: s.start_date_active + x_delta),
537: decode(x_delta, null, sysdate,
538: s.end_date_active + x_delta),
539: sysdate,
540: FND_GLOBAL.USER_ID,
541: FND_GLOBAL.USER_ID,
542: sysdate,
543: FND_GLOBAL.LOGIN_ID,
544: s.COST_PLUS_STRUCTURE,

Line 541: FND_GLOBAL.USER_ID,

537: decode(x_delta, null, sysdate,
538: s.end_date_active + x_delta),
539: sysdate,
540: FND_GLOBAL.USER_ID,
541: FND_GLOBAL.USER_ID,
542: sysdate,
543: FND_GLOBAL.LOGIN_ID,
544: s.COST_PLUS_STRUCTURE,
545: s.IND_RATE_SCHEDULE_TYPE,

Line 543: FND_GLOBAL.LOGIN_ID,

539: sysdate,
540: FND_GLOBAL.USER_ID,
541: FND_GLOBAL.USER_ID,
542: sysdate,
543: FND_GLOBAL.LOGIN_ID,
544: s.COST_PLUS_STRUCTURE,
545: s.IND_RATE_SCHEDULE_TYPE,
546: x_new_project_id,
547: new_tsk.task_id,

Line 604: FND_GLOBAL.USER_ID,

600: decode(x_delta, null, sysdate,
601: rev.end_date_active + x_delta),
602: null,
603: sysdate,
604: FND_GLOBAL.USER_ID,
605: FND_GLOBAL.USER_ID,
606: sysdate,
607: FND_GLOBAL.LOGIN_ID,
608: rev.REQUEST_ID,

Line 605: FND_GLOBAL.USER_ID,

601: rev.end_date_active + x_delta),
602: null,
603: sysdate,
604: FND_GLOBAL.USER_ID,
605: FND_GLOBAL.USER_ID,
606: sysdate,
607: FND_GLOBAL.LOGIN_ID,
608: rev.REQUEST_ID,
609: NULL,

Line 607: FND_GLOBAL.LOGIN_ID,

603: sysdate,
604: FND_GLOBAL.USER_ID,
605: FND_GLOBAL.USER_ID,
606: sysdate,
607: FND_GLOBAL.LOGIN_ID,
608: rev.REQUEST_ID,
609: NULL,
610: NULL,
611: NULL,

Line 651: FND_GLOBAL.USER_ID,

647: mult.ORGANIZATION_ID,
648: mult.IND_COST_CODE,
649: mult.MULTIPLIER,
650: sysdate,
651: FND_GLOBAL.USER_ID,
652: FND_GLOBAL.USER_ID,
653: sysdate,
654: FND_GLOBAL.LOGIN_ID
655: from pa_ind_cost_multipliers mult,

Line 652: FND_GLOBAL.USER_ID,

648: mult.IND_COST_CODE,
649: mult.MULTIPLIER,
650: sysdate,
651: FND_GLOBAL.USER_ID,
652: FND_GLOBAL.USER_ID,
653: sysdate,
654: FND_GLOBAL.LOGIN_ID
655: from pa_ind_cost_multipliers mult,
656: pa_ind_rate_sch_revisions old_rev,

Line 654: FND_GLOBAL.LOGIN_ID

650: sysdate,
651: FND_GLOBAL.USER_ID,
652: FND_GLOBAL.USER_ID,
653: sysdate,
654: FND_GLOBAL.LOGIN_ID
655: from pa_ind_cost_multipliers mult,
656: pa_ind_rate_sch_revisions old_rev,
657: pa_ind_rate_sch_revisions new_rev,
658: pa_ind_rate_schedules old_sch,

Line 772: , FND_GLOBAL.USER_ID

768: )
769: , tc.chargeable_flag
770: , tc.billable_indicator
771: , sysdate
772: , FND_GLOBAL.USER_ID
773: , sysdate
774: , FND_GLOBAL.USER_ID
775: , FND_GLOBAL.LOGIN_ID
776: , tc.person_id

Line 774: , FND_GLOBAL.USER_ID

770: , tc.billable_indicator
771: , sysdate
772: , FND_GLOBAL.USER_ID
773: , sysdate
774: , FND_GLOBAL.USER_ID
775: , FND_GLOBAL.LOGIN_ID
776: , tc.person_id
777: , tc.expenditure_category
778: , tc.expenditure_type

Line 775: , FND_GLOBAL.LOGIN_ID

771: , sysdate
772: , FND_GLOBAL.USER_ID
773: , sysdate
774: , FND_GLOBAL.USER_ID
775: , FND_GLOBAL.LOGIN_ID
776: , tc.person_id
777: , tc.expenditure_category
778: , tc.expenditure_type
779: , tc.non_labor_resource

Line 864: FND_GLOBAL.USER_ID,

860: a.AMOUNT,
861: a.PERCENTAGE,
862: a.ACTIVE_FLAG,
863: sysdate,
864: FND_GLOBAL.USER_ID,
865: sysdate,
866: FND_GLOBAL.USER_ID,
867: FND_GLOBAL.LOGIN_ID,
868: a.ATTRIBUTE_CATEGORY,

Line 866: FND_GLOBAL.USER_ID,

862: a.ACTIVE_FLAG,
863: sysdate,
864: FND_GLOBAL.USER_ID,
865: sysdate,
866: FND_GLOBAL.USER_ID,
867: FND_GLOBAL.LOGIN_ID,
868: a.ATTRIBUTE_CATEGORY,
869: a.ATTRIBUTE1,
870: a.ATTRIBUTE2,

Line 867: FND_GLOBAL.LOGIN_ID,

863: sysdate,
864: FND_GLOBAL.USER_ID,
865: sysdate,
866: FND_GLOBAL.USER_ID,
867: FND_GLOBAL.LOGIN_ID,
868: a.ATTRIBUTE_CATEGORY,
869: a.ATTRIBUTE1,
870: a.ATTRIBUTE2,
871: a.ATTRIBUTE3,

Line 938: FND_GLOBAL.USER_ID,

934: new_asset.PROJECT_ASSET_ID,
935: new_tsk.task_id,
936: new_asset.PROJECT_ID,
937: sysdate,
938: FND_GLOBAL.USER_ID,
939: sysdate,
940: FND_GLOBAL.USER_ID,
941: FND_GLOBAL.LOGIN_ID
942: from pa_project_asset_assignments assign,

Line 940: FND_GLOBAL.USER_ID,

936: new_asset.PROJECT_ID,
937: sysdate,
938: FND_GLOBAL.USER_ID,
939: sysdate,
940: FND_GLOBAL.USER_ID,
941: FND_GLOBAL.LOGIN_ID
942: from pa_project_asset_assignments assign,
943: pa_project_assets old_asset,
944: pa_project_assets new_asset,

Line 941: FND_GLOBAL.LOGIN_ID

937: sysdate,
938: FND_GLOBAL.USER_ID,
939: sysdate,
940: FND_GLOBAL.USER_ID,
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,

Line 963: FND_GLOBAL.USER_ID,

959: assign.PROJECT_ASSET_ID,
960: new_tsk.task_id,
961: x_new_project_id,
962: sysdate,
963: FND_GLOBAL.USER_ID,
964: sysdate,
965: FND_GLOBAL.USER_ID,
966: FND_GLOBAL.LOGIN_ID
967: from pa_project_asset_assignments assign,

Line 965: FND_GLOBAL.USER_ID,

961: x_new_project_id,
962: sysdate,
963: FND_GLOBAL.USER_ID,
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

Line 966: FND_GLOBAL.LOGIN_ID

962: sysdate,
963: FND_GLOBAL.USER_ID,
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

Line 1013: , FND_GLOBAL.USER_ID

1009: null, o.start_date_active + x_delta,
1010: o.start_date_active +
1011: (new_tsk.start_date - old_tsk.start_date))),trunc(sysdate)) -- Modified for bug# 5961484
1012: , sysdate
1013: , FND_GLOBAL.USER_ID
1014: , sysdate
1015: , FND_GLOBAL.USER_ID
1016: , FND_GLOBAL.LOGIN_ID
1017: , o.RATE

Line 1015: , FND_GLOBAL.USER_ID

1011: (new_tsk.start_date - old_tsk.start_date))),trunc(sysdate)) -- Modified for bug# 5961484
1012: , sysdate
1013: , FND_GLOBAL.USER_ID
1014: , sysdate
1015: , FND_GLOBAL.USER_ID
1016: , FND_GLOBAL.LOGIN_ID
1017: , o.RATE
1018: , o.BILL_RATE_UNIT
1019: , null

Line 1016: , FND_GLOBAL.LOGIN_ID

1012: , sysdate
1013: , FND_GLOBAL.USER_ID
1014: , sysdate
1015: , FND_GLOBAL.USER_ID
1016: , FND_GLOBAL.LOGIN_ID
1017: , o.RATE
1018: , o.BILL_RATE_UNIT
1019: , null
1020: , new_tsk.task_id

Line 1063: , FND_GLOBAL.USER_ID

1059: , JOB_BILL_TITLE_OVERRIDE_ID) --Added the column for the bug 2581491
1060: SELECT
1061: o.JOB_ID
1062: , sysdate
1063: , FND_GLOBAL.USER_ID
1064: , sysdate
1065: , FND_GLOBAL.USER_ID
1066: , FND_GLOBAL.LOGIN_ID
1067: , nvl(decode(x_delta,

Line 1065: , FND_GLOBAL.USER_ID

1061: o.JOB_ID
1062: , sysdate
1063: , FND_GLOBAL.USER_ID
1064: , sysdate
1065: , FND_GLOBAL.USER_ID
1066: , FND_GLOBAL.LOGIN_ID
1067: , nvl(decode(x_delta,
1068: null, x_new_proj_start,
1069: decode(new_tsk.start_date,

Line 1066: , FND_GLOBAL.LOGIN_ID

1062: , sysdate
1063: , FND_GLOBAL.USER_ID
1064: , sysdate
1065: , FND_GLOBAL.USER_ID
1066: , FND_GLOBAL.LOGIN_ID
1067: , nvl(decode(x_delta,
1068: null, x_new_proj_start,
1069: decode(new_tsk.start_date,
1070: null, o.start_date_active + x_delta,

Line 1115: , FND_GLOBAL.USER_ID

1111: , JOB_ASSIGNMENT_OVERRIDE_ID) --Added the column for the bug 2581491
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: , nvl(decode(x_delta,

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: , nvl(decode(x_delta,
1120: null, x_new_proj_start,
1121: decode(new_tsk.start_date,

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: , nvl(decode(x_delta,
1120: null, x_new_proj_start,
1121: decode(new_tsk.start_date,
1122: null, o.start_date_active + x_delta,

Line 1172: , FND_GLOBAL.USER_ID

1168: , RATE_DISC_REASON_CODE)
1169: SELECT
1170: o.PERSON_ID
1171: , sysdate
1172: , FND_GLOBAL.USER_ID
1173: , sysdate
1174: , FND_GLOBAL.USER_ID
1175: , FND_GLOBAL.LOGIN_ID
1176: , o.RATE

Line 1174: , FND_GLOBAL.USER_ID

1170: o.PERSON_ID
1171: , sysdate
1172: , FND_GLOBAL.USER_ID
1173: , sysdate
1174: , FND_GLOBAL.USER_ID
1175: , FND_GLOBAL.LOGIN_ID
1176: , o.RATE
1177: , o.BILL_RATE_UNIT
1178: , nvl(decode(x_delta,

Line 1175: , FND_GLOBAL.LOGIN_ID

1171: , sysdate
1172: , FND_GLOBAL.USER_ID
1173: , sysdate
1174: , FND_GLOBAL.USER_ID
1175: , FND_GLOBAL.LOGIN_ID
1176: , o.RATE
1177: , o.BILL_RATE_UNIT
1178: , nvl(decode(x_delta,
1179: null, x_new_proj_start,

Line 1234: , FND_GLOBAL.USER_ID

1230: , RATE_DISC_REASON_CODE )
1231: SELECT
1232: o.EXPENDITURE_TYPE
1233: , sysdate
1234: , FND_GLOBAL.USER_ID
1235: , sysdate
1236: , FND_GLOBAL.USER_ID
1237: , FND_GLOBAL.LOGIN_ID
1238: , nvl(decode(x_delta,

Line 1236: , FND_GLOBAL.USER_ID

1232: o.EXPENDITURE_TYPE
1233: , sysdate
1234: , FND_GLOBAL.USER_ID
1235: , sysdate
1236: , FND_GLOBAL.USER_ID
1237: , FND_GLOBAL.LOGIN_ID
1238: , nvl(decode(x_delta,
1239: null, x_new_proj_start,
1240: decode(new_tsk.start_date,

Line 1237: , FND_GLOBAL.LOGIN_ID

1233: , sysdate
1234: , FND_GLOBAL.USER_ID
1235: , sysdate
1236: , FND_GLOBAL.USER_ID
1237: , FND_GLOBAL.LOGIN_ID
1238: , nvl(decode(x_delta,
1239: null, x_new_proj_start,
1240: decode(new_tsk.start_date,
1241: null, o.start_date_active + x_delta,

Line 1306: , FND_GLOBAL.USER_ID

1302: null, m.end_date_active + x_delta,
1303: m.end_date_active +
1304: (new_tsk.start_date - old_tsk.start_date))))
1305: , sysdate
1306: , FND_GLOBAL.USER_ID
1307: , sysdate
1308: , FND_GLOBAL.USER_ID
1309: , FND_GLOBAL.LOGIN_ID
1310: , pa_labor_multipliers_s.NEXTVAL --Added this column for the bug 2581491

Line 1308: , FND_GLOBAL.USER_ID

1304: (new_tsk.start_date - old_tsk.start_date))))
1305: , sysdate
1306: , FND_GLOBAL.USER_ID
1307: , sysdate
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,

Line 1309: , FND_GLOBAL.LOGIN_ID

1305: , sysdate
1306: , FND_GLOBAL.USER_ID
1307: , sysdate
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

Line 1359: , FND_GLOBAL.USER_ID

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
1362: , FND_GLOBAL.LOGIN_ID
1363: , pc.attribute_category

Line 1361: , FND_GLOBAL.USER_ID

1357: , 'PA_TASKS'
1358: , sysdate
1359: , FND_GLOBAL.USER_ID
1360: , sysdate
1361: , FND_GLOBAL.USER_ID
1362: , FND_GLOBAL.LOGIN_ID
1363: , pc.attribute_category
1364: , pc.attribute1
1365: , pc.attribute2

Line 1362: , FND_GLOBAL.LOGIN_ID

1358: , sysdate
1359: , FND_GLOBAL.USER_ID
1360: , sysdate
1361: , FND_GLOBAL.USER_ID
1362: , FND_GLOBAL.LOGIN_ID
1363: , pc.attribute_category
1364: , pc.attribute1
1365: , pc.attribute2
1366: , pc.attribute3

Line 1470: FND_GLOBAL.User_ID,

1466: enabled_flag,
1467: trunc(sysdate),
1468: NULL,
1469: sysdate,
1470: FND_GLOBAL.User_ID,
1471: sysdate,
1472: FND_GLOBAL.User_ID,
1473: FND_GLOBAL.Login_ID,
1474: x_status_type,

Line 1472: FND_GLOBAL.User_ID,

1468: NULL,
1469: sysdate,
1470: FND_GLOBAL.User_ID,
1471: sysdate,
1472: FND_GLOBAL.User_ID,
1473: FND_GLOBAL.Login_ID,
1474: x_status_type,
1475: COPY_TO_USER_STATUS_FLAG
1476: FROM pa_project_status_controls pas1

Line 1473: FND_GLOBAL.Login_ID,

1469: sysdate,
1470: FND_GLOBAL.User_ID,
1471: sysdate,
1472: FND_GLOBAL.User_ID,
1473: FND_GLOBAL.Login_ID,
1474: x_status_type,
1475: COPY_TO_USER_STATUS_FLAG
1476: FROM pa_project_status_controls pas1
1477: WHERE pas1.project_system_status_code = X_Project_System_Status_Code