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_CORE1 dependencies on FND_GLOBAL

Line 67: FND_GLOBAL.USER_ID,

63: x_err_stage := 'PA_NO_GEN_MODE';
64: return;
65: elsif proj_number_gen_mode = 'AUTOMATIC' then
66: PA_UTILS_SQNUM_PKG.get_unique_proj_num('PA_PROJECTS',
67: FND_GLOBAL.USER_ID,
68: unique_id,
69: status);
70: if status = 0 then
71: x_resu_proj_num := to_char(unique_id);

Line 139: p_user_id => FND_GLOBAL.USER_ID,

135: p_project_number IN VARCHAR2 ) IS
136: BEGIN
137: IF p_proj_number_gen_mode = 'AUTOMATIC' THEN
138: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
139: p_user_id => FND_GLOBAL.USER_ID,
140: p_unique_number => TO_NUMBER(p_project_number));
141: END IF;
142: END revert_proj_number;
143:

Line 906: X_entered_by_user_id => FND_GLOBAL.USER_ID,

902: X_task_manager_person_id => NULL,
903: X_Service_type => NULL,
904: X_task_start_date => NULL,
905: X_task_end_date => NULL,
906: X_entered_by_user_id => FND_GLOBAL.USER_ID,
907: X_attribute_category => x_attribute_category,
908: X_attribute1 => x_attribute1,
909: X_attribute2 => x_attribute2,
910: X_attribute3 => x_attribute3,

Line 1016: p_CREATED_BY => FND_GLOBAL.USER_ID,

1012: ( p_CITY => x_city,
1013: p_REGION => x_region,
1014: p_COUNTRY_CODE => x_country_code,
1015: p_CREATION_DATE => sysdate,
1016: p_CREATED_BY => FND_GLOBAL.USER_ID,
1017: p_LAST_UPDATE_DATE => sysdate,
1018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1019: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1020: X_ROWID => l_rowid,

Line 1018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1014: p_COUNTRY_CODE => x_country_code,
1015: p_CREATION_DATE => sysdate,
1016: p_CREATED_BY => FND_GLOBAL.USER_ID,
1017: p_LAST_UPDATE_DATE => sysdate,
1018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1019: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1020: X_ROWID => l_rowid,
1021: X_LOCATION_ID => l_location_id);
1022:

Line 1019: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

1015: p_CREATION_DATE => sysdate,
1016: p_CREATED_BY => FND_GLOBAL.USER_ID,
1017: p_LAST_UPDATE_DATE => sysdate,
1018: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1019: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1020: X_ROWID => l_rowid,
1021: X_LOCATION_ID => l_location_id);
1022:
1023: end if;

Line 1112: p_CREATED_BY => FND_GLOBAL.USER_ID,

1108: p_CITY => l_city,
1109: p_REGION => l_region,
1110: p_COUNTRY_CODE => l_country_code,
1111: p_CREATION_DATE => sysdate,
1112: p_CREATED_BY => FND_GLOBAL.USER_ID,
1113: p_LAST_UPDATE_DATE => sysdate,
1114: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1115: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1116: X_ROWID => l_rowid,

Line 1114: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1110: p_COUNTRY_CODE => l_country_code,
1111: p_CREATION_DATE => sysdate,
1112: p_CREATED_BY => FND_GLOBAL.USER_ID,
1113: p_LAST_UPDATE_DATE => sysdate,
1114: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1115: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1116: X_ROWID => l_rowid,
1117: X_LOCATION_ID => l_location_id);
1118: end if;

Line 1115: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

1111: p_CREATION_DATE => sysdate,
1112: p_CREATED_BY => FND_GLOBAL.USER_ID,
1113: p_LAST_UPDATE_DATE => sysdate,
1114: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1115: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1116: X_ROWID => l_rowid,
1117: X_LOCATION_ID => l_location_id);
1118: end if;
1119: end if;

Line 1447: FND_GLOBAL.USER_ID,

1443: NVL( x_long_name, x_project_name ), --long name changes
1444: x_new_project_number,
1445: t.org_id, -- Bug 4363092: MOAC Changes
1446: sysdate,
1447: FND_GLOBAL.USER_ID,
1448: sysdate,
1449: FND_GLOBAL.USER_ID,
1450: FND_GLOBAL.LOGIN_ID,
1451: t.project_type,

Line 1449: FND_GLOBAL.USER_ID,

1445: t.org_id, -- Bug 4363092: MOAC Changes
1446: sysdate,
1447: FND_GLOBAL.USER_ID,
1448: sysdate,
1449: FND_GLOBAL.USER_ID,
1450: FND_GLOBAL.LOGIN_ID,
1451: t.project_type,
1452: nvl(x_organization_id, t.carrying_out_organization_id),
1453: nvl(x_public_sector_flag, t.public_sector_flag),

Line 1450: FND_GLOBAL.LOGIN_ID,

1446: sysdate,
1447: FND_GLOBAL.USER_ID,
1448: sysdate,
1449: FND_GLOBAL.USER_ID,
1450: FND_GLOBAL.LOGIN_ID,
1451: t.project_type,
1452: nvl(x_organization_id, t.carrying_out_organization_id),
1453: nvl(x_public_sector_flag, t.public_sector_flag),
1454: p_project_status_code,

Line 1796: FND_GLOBAL.USER_ID,

1792: ) select
1793: x_new_project_id,
1794: o.option_code,
1795: sysdate,
1796: FND_GLOBAL.USER_ID,
1797: sysdate,
1798: FND_GLOBAL.USER_ID,
1799: FND_GLOBAL.LOGIN_ID
1800: from pa_project_options o

Line 1798: FND_GLOBAL.USER_ID,

1794: o.option_code,
1795: sysdate,
1796: FND_GLOBAL.USER_ID,
1797: sysdate,
1798: FND_GLOBAL.USER_ID,
1799: FND_GLOBAL.LOGIN_ID
1800: from pa_project_options o
1801: where o.project_id = x_created_from_proj_id;
1802:

Line 1799: FND_GLOBAL.LOGIN_ID

1795: sysdate,
1796: FND_GLOBAL.USER_ID,
1797: sysdate,
1798: FND_GLOBAL.USER_ID,
1799: FND_GLOBAL.LOGIN_ID
1800: from pa_project_options o
1801: where o.project_id = x_created_from_proj_id;
1802:
1803: x_err_stage := 'copying project copy overrides ';

Line 1823: FND_GLOBAL.USER_ID,

1819: x_new_project_id,
1820: c.field_name,
1821: c.display_name,
1822: sysdate,
1823: FND_GLOBAL.USER_ID,
1824: sysdate,
1825: FND_GLOBAL.USER_ID,
1826: FND_GLOBAL.LOGIN_ID,
1827: c.limiting_value,

Line 1825: FND_GLOBAL.USER_ID,

1821: c.display_name,
1822: sysdate,
1823: FND_GLOBAL.USER_ID,
1824: sysdate,
1825: FND_GLOBAL.USER_ID,
1826: FND_GLOBAL.LOGIN_ID,
1827: c.limiting_value,
1828: c.sort_order,
1829: c.mandatory_flag,

Line 1826: FND_GLOBAL.LOGIN_ID,

1822: sysdate,
1823: FND_GLOBAL.USER_ID,
1824: sysdate,
1825: FND_GLOBAL.USER_ID,
1826: FND_GLOBAL.LOGIN_ID,
1827: c.limiting_value,
1828: c.sort_order,
1829: c.mandatory_flag,
1830: 1

Line 2706: , FND_GLOBAL.USER_ID

2702: , pc.code_percentage
2703: , x_new_project_id
2704: , 'PA_PROJECTS'
2705: , sysdate
2706: , FND_GLOBAL.USER_ID
2707: , sysdate
2708: , FND_GLOBAL.USER_ID
2709: , FND_GLOBAL.LOGIN_ID
2710: , pc.attribute_category

Line 2708: , FND_GLOBAL.USER_ID

2704: , 'PA_PROJECTS'
2705: , sysdate
2706: , FND_GLOBAL.USER_ID
2707: , sysdate
2708: , FND_GLOBAL.USER_ID
2709: , FND_GLOBAL.LOGIN_ID
2710: , pc.attribute_category
2711: , pc.attribute1
2712: , pc.attribute2

Line 2709: , FND_GLOBAL.LOGIN_ID

2705: , sysdate
2706: , FND_GLOBAL.USER_ID
2707: , sysdate
2708: , FND_GLOBAL.USER_ID
2709: , FND_GLOBAL.LOGIN_ID
2710: , pc.attribute_category
2711: , pc.attribute1
2712: , pc.attribute2
2713: , pc.attribute3

Line 2777: , FND_GLOBAL.USER_ID

2773: , pc.code_percentage
2774: , x_new_project_id
2775: , 'PA_PROJECTS'
2776: , sysdate
2777: , FND_GLOBAL.USER_ID
2778: , sysdate
2779: , FND_GLOBAL.USER_ID
2780: , FND_GLOBAL.LOGIN_ID
2781: , pc.attribute_category

Line 2779: , FND_GLOBAL.USER_ID

2775: , 'PA_PROJECTS'
2776: , sysdate
2777: , FND_GLOBAL.USER_ID
2778: , sysdate
2779: , FND_GLOBAL.USER_ID
2780: , FND_GLOBAL.LOGIN_ID
2781: , pc.attribute_category
2782: , pc.attribute1
2783: , pc.attribute2

Line 2780: , FND_GLOBAL.LOGIN_ID

2776: , sysdate
2777: , FND_GLOBAL.USER_ID
2778: , sysdate
2779: , FND_GLOBAL.USER_ID
2780: , FND_GLOBAL.LOGIN_ID
2781: , pc.attribute_category
2782: , pc.attribute1
2783: , pc.attribute2
2784: , pc.attribute3

Line 2986: , FND_GLOBAL.USER_ID

2982: SELECT
2983: x_new_project_id
2984: , cust.customer_id
2985: , sysdate
2986: , FND_GLOBAL.USER_ID
2987: , sysdate
2988: , FND_GLOBAL.USER_ID
2989: , FND_GLOBAL.LOGIN_ID
2990: , cust.project_relationship_code

Line 2988: , FND_GLOBAL.USER_ID

2984: , cust.customer_id
2985: , sysdate
2986: , FND_GLOBAL.USER_ID
2987: , sysdate
2988: , FND_GLOBAL.USER_ID
2989: , FND_GLOBAL.LOGIN_ID
2990: , cust.project_relationship_code
2991: --Bug 3279981
2992: --, cust.customer_bill_split

Line 2989: , FND_GLOBAL.LOGIN_ID

2985: , sysdate
2986: , FND_GLOBAL.USER_ID
2987: , sysdate
2988: , FND_GLOBAL.USER_ID
2989: , FND_GLOBAL.LOGIN_ID
2990: , cust.project_relationship_code
2991: --Bug 3279981
2992: --, cust.customer_bill_split
2993: , decode(l_check_diff_flag, --sunkalya:federal Bug#5511353

Line 3162: , FND_GLOBAL.USER_ID

3158: SELECT
3159: x_new_project_id
3160: , cust.customer_id
3161: , sysdate
3162: , FND_GLOBAL.USER_ID
3163: , sysdate
3164: , FND_GLOBAL.USER_ID
3165: , FND_GLOBAL.LOGIN_ID
3166: , cust.project_relationship_code

Line 3164: , FND_GLOBAL.USER_ID

3160: , cust.customer_id
3161: , sysdate
3162: , FND_GLOBAL.USER_ID
3163: , sysdate
3164: , FND_GLOBAL.USER_ID
3165: , FND_GLOBAL.LOGIN_ID
3166: , cust.project_relationship_code
3167: , cust.customer_bill_split
3168: , cust.bill_to_address_id

Line 3165: , FND_GLOBAL.LOGIN_ID

3161: , sysdate
3162: , FND_GLOBAL.USER_ID
3163: , sysdate
3164: , FND_GLOBAL.USER_ID
3165: , FND_GLOBAL.LOGIN_ID
3166: , cust.project_relationship_code
3167: , cust.customer_bill_split
3168: , cust.bill_to_address_id
3169: , cust.ship_to_address_id

Line 3491: X_User => FND_GLOBAL.USER_ID,

3487: X_Allow_Inv_Rate_Type_Fg => l_cur_cust_info.allow_inv_user_rate_type_flag,
3488: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3489: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3490: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3491: X_User => FND_GLOBAL.USER_ID,
3492: X_Login => FND_GLOBAL.LOGIN_ID,
3493: X_Err_Code => x_err_code,
3494: X_Err_Stage => x_err_stage,
3495: X_Err_Stack => x_err_stack

Line 3492: X_Login => FND_GLOBAL.LOGIN_ID,

3488: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3489: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3490: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3491: X_User => FND_GLOBAL.USER_ID,
3492: X_Login => FND_GLOBAL.LOGIN_ID,
3493: X_Err_Code => x_err_code,
3494: X_Err_Stage => x_err_stage,
3495: X_Err_Stack => x_err_stack
3496: );

Line 3698: X_User => FND_GLOBAL.USER_ID,

3694: X_Allow_Inv_Rate_Type_Fg => l_cur_cust_info.allow_inv_user_rate_type_flag,
3695: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3696: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3697: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3698: X_User => FND_GLOBAL.USER_ID,
3699: X_Login => FND_GLOBAL.LOGIN_ID,
3700: X_Err_Code => x_err_code,
3701: X_Err_Stage => x_err_stage,
3702: X_Err_Stack => x_err_stack

Line 3699: X_Login => FND_GLOBAL.LOGIN_ID,

3695: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3696: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3697: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3698: X_User => FND_GLOBAL.USER_ID,
3699: X_Login => FND_GLOBAL.LOGIN_ID,
3700: X_Err_Code => x_err_code,
3701: X_Err_Stage => x_err_stage,
3702: X_Err_Stack => x_err_stack
3703: );

Line 3868: , FND_GLOBAL.USER_ID

3864: , c.customer_id
3865: , c.contact_id
3866: , c.project_contact_type_code
3867: , sysdate
3868: , FND_GLOBAL.USER_ID
3869: , sysdate
3870: , FND_GLOBAL.USER_ID
3871: , FND_GLOBAL.LOGIN_ID
3872: , 1

Line 3870: , FND_GLOBAL.USER_ID

3866: , c.project_contact_type_code
3867: , sysdate
3868: , FND_GLOBAL.USER_ID
3869: , sysdate
3870: , FND_GLOBAL.USER_ID
3871: , FND_GLOBAL.LOGIN_ID
3872: , 1
3873: -- Customer Account relationships
3874: , c.bill_ship_customer_id

Line 3871: , FND_GLOBAL.LOGIN_ID

3867: , sysdate
3868: , FND_GLOBAL.USER_ID
3869: , sysdate
3870: , FND_GLOBAL.USER_ID
3871: , FND_GLOBAL.LOGIN_ID
3872: , 1
3873: -- Customer Account relationships
3874: , c.bill_ship_customer_id
3875: FROM

Line 3912: , FND_GLOBAL.USER_ID

3908: , c.customer_id
3909: , c.contact_id
3910: , c.project_contact_type_code
3911: , sysdate
3912: , FND_GLOBAL.USER_ID
3913: , sysdate
3914: , FND_GLOBAL.USER_ID
3915: , FND_GLOBAL.LOGIN_ID
3916: , 1

Line 3914: , FND_GLOBAL.USER_ID

3910: , c.project_contact_type_code
3911: , sysdate
3912: , FND_GLOBAL.USER_ID
3913: , sysdate
3914: , FND_GLOBAL.USER_ID
3915: , FND_GLOBAL.LOGIN_ID
3916: , 1
3917: -- Customer Account relationships
3918: , c.bill_ship_customer_id

Line 3915: , FND_GLOBAL.LOGIN_ID

3911: , sysdate
3912: , FND_GLOBAL.USER_ID
3913: , sysdate
3914: , FND_GLOBAL.USER_ID
3915: , FND_GLOBAL.LOGIN_ID
3916: , 1
3917: -- Customer Account relationships
3918: , c.bill_ship_customer_id
3919:

Line 3968: , FND_GLOBAL.USER_ID

3964: , OVERRIDE_TO_ORGANIZATION_ID
3965: , decode(x_delta, null, x_start_date,
3966: start_date_active + x_delta)
3967: , sysdate
3968: , FND_GLOBAL.USER_ID
3969: , sysdate
3970: , FND_GLOBAL.USER_ID
3971: , FND_GLOBAL.LOGIN_ID
3972: , person_id

Line 3970: , FND_GLOBAL.USER_ID

3966: start_date_active + x_delta)
3967: , sysdate
3968: , FND_GLOBAL.USER_ID
3969: , sysdate
3970: , FND_GLOBAL.USER_ID
3971: , FND_GLOBAL.LOGIN_ID
3972: , person_id
3973: , EXPENDITURE_CATEGORY
3974: , OVERRIDE_FROM_ORGANIZATION_ID

Line 3971: , FND_GLOBAL.LOGIN_ID

3967: , sysdate
3968: , FND_GLOBAL.USER_ID
3969: , sysdate
3970: , FND_GLOBAL.USER_ID
3971: , FND_GLOBAL.LOGIN_ID
3972: , person_id
3973: , EXPENDITURE_CATEGORY
3974: , OVERRIDE_FROM_ORGANIZATION_ID
3975: , decode(x_delta, null, x_completion_date,

Line 4005: , FND_GLOBAL.USER_ID

4001: PERSON_ID
4002: , CREDIT_TYPE_CODE
4003: , x_new_project_id
4004: , sysdate
4005: , FND_GLOBAL.USER_ID
4006: , sysdate
4007: , FND_GLOBAL.USER_ID
4008: , FND_GLOBAL.LOGIN_ID
4009: , decode(x_delta, null, x_start_date,

Line 4007: , FND_GLOBAL.USER_ID

4003: , x_new_project_id
4004: , sysdate
4005: , FND_GLOBAL.USER_ID
4006: , sysdate
4007: , FND_GLOBAL.USER_ID
4008: , FND_GLOBAL.LOGIN_ID
4009: , decode(x_delta, null, x_start_date,
4010: start_date_active + x_delta)
4011: , CREDIT_PERCENTAGE

Line 4008: , FND_GLOBAL.LOGIN_ID

4004: , sysdate
4005: , FND_GLOBAL.USER_ID
4006: , sysdate
4007: , FND_GLOBAL.USER_ID
4008: , FND_GLOBAL.LOGIN_ID
4009: , decode(x_delta, null, x_start_date,
4010: start_date_active + x_delta)
4011: , CREDIT_PERCENTAGE
4012: , decode(x_delta, null, x_completion_date,

Line 4083: FND_GLOBAL.USER_ID,

4079: AMOUNT,
4080: PERCENTAGE,
4081: ACTIVE_FLAG,
4082: sysdate,
4083: FND_GLOBAL.USER_ID,
4084: sysdate,
4085: FND_GLOBAL.USER_ID,
4086: FND_GLOBAL.LOGIN_ID,
4087: ATTRIBUTE_CATEGORY,

Line 4085: FND_GLOBAL.USER_ID,

4081: ACTIVE_FLAG,
4082: sysdate,
4083: FND_GLOBAL.USER_ID,
4084: sysdate,
4085: FND_GLOBAL.USER_ID,
4086: FND_GLOBAL.LOGIN_ID,
4087: ATTRIBUTE_CATEGORY,
4088: ATTRIBUTE1,
4089: ATTRIBUTE2,

Line 4086: FND_GLOBAL.LOGIN_ID,

4082: sysdate,
4083: FND_GLOBAL.USER_ID,
4084: sysdate,
4085: FND_GLOBAL.USER_ID,
4086: FND_GLOBAL.LOGIN_ID,
4087: ATTRIBUTE_CATEGORY,
4088: ATTRIBUTE1,
4089: ATTRIBUTE2,
4090: ATTRIBUTE3,

Line 4169: FND_GLOBAL.USER_ID,

4165: s.start_date_active + x_delta),
4166: decode(x_delta, null, x_completion_date,
4167: s.end_date_active + x_delta),
4168: sysdate,
4169: FND_GLOBAL.USER_ID,
4170: FND_GLOBAL.USER_ID,
4171: sysdate,
4172: FND_GLOBAL.LOGIN_ID,
4173: s.COST_PLUS_STRUCTURE,

Line 4170: FND_GLOBAL.USER_ID,

4166: decode(x_delta, null, x_completion_date,
4167: s.end_date_active + x_delta),
4168: sysdate,
4169: FND_GLOBAL.USER_ID,
4170: FND_GLOBAL.USER_ID,
4171: sysdate,
4172: FND_GLOBAL.LOGIN_ID,
4173: s.COST_PLUS_STRUCTURE,
4174: s.IND_RATE_SCHEDULE_TYPE,

Line 4172: FND_GLOBAL.LOGIN_ID,

4168: sysdate,
4169: FND_GLOBAL.USER_ID,
4170: FND_GLOBAL.USER_ID,
4171: sysdate,
4172: FND_GLOBAL.LOGIN_ID,
4173: s.COST_PLUS_STRUCTURE,
4174: s.IND_RATE_SCHEDULE_TYPE,
4175: x_new_project_id,
4176: null,

Line 4229: FND_GLOBAL.USER_ID,

4225: decode(x_delta, null, x_completion_date,
4226: rev.end_date_active + x_delta),
4227: null,
4228: sysdate,
4229: FND_GLOBAL.USER_ID,
4230: FND_GLOBAL.USER_ID,
4231: sysdate,
4232: FND_GLOBAL.LOGIN_ID,
4233: rev.REQUEST_ID,

Line 4230: FND_GLOBAL.USER_ID,

4226: rev.end_date_active + x_delta),
4227: null,
4228: sysdate,
4229: FND_GLOBAL.USER_ID,
4230: FND_GLOBAL.USER_ID,
4231: sysdate,
4232: FND_GLOBAL.LOGIN_ID,
4233: rev.REQUEST_ID,
4234: NULL,

Line 4232: FND_GLOBAL.LOGIN_ID,

4228: sysdate,
4229: FND_GLOBAL.USER_ID,
4230: FND_GLOBAL.USER_ID,
4231: sysdate,
4232: FND_GLOBAL.LOGIN_ID,
4233: rev.REQUEST_ID,
4234: NULL,
4235: NULL,
4236: NULL,

Line 4279: FND_GLOBAL.USER_ID,

4275: mult.ORGANIZATION_ID,
4276: mult.IND_COST_CODE,
4277: mult.MULTIPLIER,
4278: sysdate,
4279: FND_GLOBAL.USER_ID,
4280: FND_GLOBAL.USER_ID,
4281: sysdate,
4282: FND_GLOBAL.LOGIN_ID
4283: from pa_ind_cost_multipliers mult,

Line 4280: FND_GLOBAL.USER_ID,

4276: mult.IND_COST_CODE,
4277: mult.MULTIPLIER,
4278: sysdate,
4279: FND_GLOBAL.USER_ID,
4280: FND_GLOBAL.USER_ID,
4281: sysdate,
4282: FND_GLOBAL.LOGIN_ID
4283: from pa_ind_cost_multipliers mult,
4284: pa_ind_rate_sch_revisions old_rev,

Line 4282: FND_GLOBAL.LOGIN_ID

4278: sysdate,
4279: FND_GLOBAL.USER_ID,
4280: FND_GLOBAL.USER_ID,
4281: sysdate,
4282: FND_GLOBAL.LOGIN_ID
4283: from pa_ind_cost_multipliers mult,
4284: pa_ind_rate_sch_revisions old_rev,
4285: pa_ind_rate_sch_revisions new_rev,
4286: pa_ind_rate_schedules old_sch,

Line 4346: , FND_GLOBAL.USER_ID

4342: tc.start_date_active + x_delta)
4343: , tc.chargeable_flag
4344: , tc.billable_indicator
4345: , sysdate
4346: , FND_GLOBAL.USER_ID
4347: , sysdate
4348: , FND_GLOBAL.USER_ID
4349: , FND_GLOBAL.LOGIN_ID
4350: , tc.person_id

Line 4348: , FND_GLOBAL.USER_ID

4344: , tc.billable_indicator
4345: , sysdate
4346: , FND_GLOBAL.USER_ID
4347: , sysdate
4348: , FND_GLOBAL.USER_ID
4349: , FND_GLOBAL.LOGIN_ID
4350: , tc.person_id
4351: , tc.expenditure_category
4352: , tc.expenditure_type

Line 4349: , FND_GLOBAL.LOGIN_ID

4345: , sysdate
4346: , FND_GLOBAL.USER_ID
4347: , sysdate
4348: , FND_GLOBAL.USER_ID
4349: , FND_GLOBAL.LOGIN_ID
4350: , tc.person_id
4351: , tc.expenditure_category
4352: , tc.expenditure_type
4353: , tc.non_labor_resource

Line 4468: FND_GLOBAL.USER_ID,

4464: 'N',
4465: NULL,
4466: 'N',
4467: sysdate,
4468: FND_GLOBAL.USER_ID,
4469: sysdate,
4470: FND_GLOBAL.USER_ID,
4471: FND_GLOBAL.LOGIN_ID,
4472: ATTRIBUTE_CATEGORY,

Line 4470: FND_GLOBAL.USER_ID,

4466: 'N',
4467: sysdate,
4468: FND_GLOBAL.USER_ID,
4469: sysdate,
4470: FND_GLOBAL.USER_ID,
4471: FND_GLOBAL.LOGIN_ID,
4472: ATTRIBUTE_CATEGORY,
4473: ATTRIBUTE1,
4474: ATTRIBUTE2,

Line 4471: FND_GLOBAL.LOGIN_ID,

4467: sysdate,
4468: FND_GLOBAL.USER_ID,
4469: sysdate,
4470: FND_GLOBAL.USER_ID,
4471: FND_GLOBAL.LOGIN_ID,
4472: ATTRIBUTE_CATEGORY,
4473: ATTRIBUTE1,
4474: ATTRIBUTE2,
4475: ATTRIBUTE3,

Line 4541: FND_GLOBAL.USER_ID,

4537: null, null, null, null,
4538: 'PA_PROJECT_ASSETS',
4539: c_atch.new_project_asset_id,
4540: null, null, null, null,
4541: FND_GLOBAL.USER_ID,
4542: FND_GLOBAL.LOGIN_ID,
4543: 275, null, null);
4544:
4545: end loop ;

Line 4542: FND_GLOBAL.LOGIN_ID,

4538: 'PA_PROJECT_ASSETS',
4539: c_atch.new_project_asset_id,
4540: null, null, null, null,
4541: FND_GLOBAL.USER_ID,
4542: FND_GLOBAL.LOGIN_ID,
4543: 275, null, null);
4544:
4545: end loop ;
4546: close c_attach_assets;

Line 4582: FND_GLOBAL.USER_ID,

4578: new_asset.PROJECT_ASSET_ID,
4579: 0,
4580: new_asset.PROJECT_ID,
4581: sysdate,
4582: FND_GLOBAL.USER_ID,
4583: sysdate,
4584: FND_GLOBAL.USER_ID,
4585: FND_GLOBAL.LOGIN_ID
4586: from pa_project_asset_assignments assign,

Line 4584: FND_GLOBAL.USER_ID,

4580: new_asset.PROJECT_ID,
4581: sysdate,
4582: FND_GLOBAL.USER_ID,
4583: sysdate,
4584: FND_GLOBAL.USER_ID,
4585: FND_GLOBAL.LOGIN_ID
4586: from pa_project_asset_assignments assign,
4587: pa_project_assets old_asset,
4588: pa_project_assets new_asset

Line 4585: FND_GLOBAL.LOGIN_ID

4581: sysdate,
4582: FND_GLOBAL.USER_ID,
4583: sysdate,
4584: FND_GLOBAL.USER_ID,
4585: FND_GLOBAL.LOGIN_ID
4586: from pa_project_asset_assignments assign,
4587: pa_project_assets old_asset,
4588: pa_project_assets new_asset
4589: where old_asset.project_id = x_orig_project_id

Line 4601: FND_GLOBAL.USER_ID,

4597: new_asset.PROJECT_ASSET_ID,
4598: 0,
4599: new_asset.PROJECT_ID,
4600: sysdate,
4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: FND_GLOBAL.USER_ID,
4604: FND_GLOBAL.LOGIN_ID
4605: from pa_project_asset_assignments assign,

Line 4603: FND_GLOBAL.USER_ID,

4599: new_asset.PROJECT_ID,
4600: sysdate,
4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: FND_GLOBAL.USER_ID,
4604: FND_GLOBAL.LOGIN_ID
4605: from pa_project_asset_assignments assign,
4606: pa_project_assets old_asset,
4607: pa_project_assets new_asset

Line 4604: FND_GLOBAL.LOGIN_ID

4600: sysdate,
4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: FND_GLOBAL.USER_ID,
4604: FND_GLOBAL.LOGIN_ID
4605: from pa_project_asset_assignments assign,
4606: pa_project_assets old_asset,
4607: pa_project_assets new_asset
4608: where old_asset.project_id = x_orig_project_id

Line 4620: FND_GLOBAL.USER_ID,

4616: PROJECT_ASSET_ID,
4617: 0,
4618: x_new_project_id,
4619: sysdate,
4620: FND_GLOBAL.USER_ID,
4621: sysdate,
4622: FND_GLOBAL.USER_ID,
4623: FND_GLOBAL.LOGIN_ID
4624: from pa_project_asset_assignments

Line 4622: FND_GLOBAL.USER_ID,

4618: x_new_project_id,
4619: sysdate,
4620: FND_GLOBAL.USER_ID,
4621: sysdate,
4622: FND_GLOBAL.USER_ID,
4623: FND_GLOBAL.LOGIN_ID
4624: from pa_project_asset_assignments
4625: where project_id = x_orig_project_id
4626: and task_id = 0

Line 4623: FND_GLOBAL.LOGIN_ID

4619: sysdate,
4620: FND_GLOBAL.USER_ID,
4621: sysdate,
4622: FND_GLOBAL.USER_ID,
4623: FND_GLOBAL.LOGIN_ID
4624: from pa_project_asset_assignments
4625: where project_id = x_orig_project_id
4626: and task_id = 0
4627: and project_asset_id = 0;

Line 4649: FND_GLOBAL.USER_ID,

4645: pa_resource_list_assignments_s.nextval,
4646: RESOURCE_LIST_ID,
4647: x_new_project_id,
4648: 'N',
4649: FND_GLOBAL.USER_ID,
4650: sysdate,
4651: sysdate,
4652: FND_GLOBAL.USER_ID,
4653: FND_GLOBAL.LOGIN_ID

Line 4652: FND_GLOBAL.USER_ID,

4648: 'N',
4649: FND_GLOBAL.USER_ID,
4650: sysdate,
4651: sysdate,
4652: FND_GLOBAL.USER_ID,
4653: FND_GLOBAL.LOGIN_ID
4654: from pa_resource_list_assignments a,
4655: pa_resource_list_uses u
4656: where a.project_id = x_orig_project_id

Line 4653: FND_GLOBAL.LOGIN_ID

4649: FND_GLOBAL.USER_ID,
4650: sysdate,
4651: sysdate,
4652: FND_GLOBAL.USER_ID,
4653: FND_GLOBAL.LOGIN_ID
4654: from pa_resource_list_assignments a,
4655: pa_resource_list_uses u
4656: where a.project_id = x_orig_project_id
4657: and a.resource_list_assignment_id =

Line 4677: FND_GLOBAL.USER_ID,

4673: select
4674: new_list.RESOURCE_LIST_ASSIGNMENT_ID,
4675: use.USE_CODE,
4676: use.Default_Flag,
4677: FND_GLOBAL.USER_ID,
4678: sysdate,
4679: sysdate,
4680: FND_GLOBAL.USER_ID,
4681: FND_GLOBAL.LOGIN_ID

Line 4680: FND_GLOBAL.USER_ID,

4676: use.Default_Flag,
4677: FND_GLOBAL.USER_ID,
4678: sysdate,
4679: sysdate,
4680: FND_GLOBAL.USER_ID,
4681: FND_GLOBAL.LOGIN_ID
4682: from pa_resource_list_uses use,
4683: pa_resource_list_assignments old_list,
4684: pa_resource_list_assignments new_list

Line 4681: FND_GLOBAL.LOGIN_ID

4677: FND_GLOBAL.USER_ID,
4678: sysdate,
4679: sysdate,
4680: FND_GLOBAL.USER_ID,
4681: FND_GLOBAL.LOGIN_ID
4682: from pa_resource_list_uses use,
4683: pa_resource_list_assignments old_list,
4684: pa_resource_list_assignments new_list
4685: where old_list.project_id = x_orig_project_id

Line 4722: , FND_GLOBAL.USER_ID

4718: JOB_ID
4719: , decode(x_delta, null, x_start_date,
4720: start_date_active + x_delta)
4721: , sysdate
4722: , FND_GLOBAL.USER_ID
4723: , sysdate
4724: , FND_GLOBAL.USER_ID
4725: , FND_GLOBAL.LOGIN_ID
4726: , RATE

Line 4724: , FND_GLOBAL.USER_ID

4720: start_date_active + x_delta)
4721: , sysdate
4722: , FND_GLOBAL.USER_ID
4723: , sysdate
4724: , FND_GLOBAL.USER_ID
4725: , FND_GLOBAL.LOGIN_ID
4726: , RATE
4727: , BILL_RATE_UNIT
4728: , x_new_project_id

Line 4725: , FND_GLOBAL.LOGIN_ID

4721: , sysdate
4722: , FND_GLOBAL.USER_ID
4723: , sysdate
4724: , FND_GLOBAL.USER_ID
4725: , FND_GLOBAL.LOGIN_ID
4726: , RATE
4727: , BILL_RATE_UNIT
4728: , x_new_project_id
4729: , null

Line 4767: , FND_GLOBAL.USER_ID

4763: , END_DATE_ACTIVE )
4764: SELECT
4765: JOB_ID
4766: , sysdate
4767: , FND_GLOBAL.USER_ID
4768: , sysdate
4769: , FND_GLOBAL.USER_ID
4770: , FND_GLOBAL.LOGIN_ID
4771: , decode(x_delta, null, x_start_date,

Line 4769: , FND_GLOBAL.USER_ID

4765: JOB_ID
4766: , sysdate
4767: , FND_GLOBAL.USER_ID
4768: , sysdate
4769: , FND_GLOBAL.USER_ID
4770: , FND_GLOBAL.LOGIN_ID
4771: , decode(x_delta, null, x_start_date,
4772: start_date_active + x_delta)
4773: , BILLING_TITLE

Line 4770: , FND_GLOBAL.LOGIN_ID

4766: , sysdate
4767: , FND_GLOBAL.USER_ID
4768: , sysdate
4769: , FND_GLOBAL.USER_ID
4770: , FND_GLOBAL.LOGIN_ID
4771: , decode(x_delta, null, x_start_date,
4772: start_date_active + x_delta)
4773: , BILLING_TITLE
4774: , x_new_project_id

Line 4808: , FND_GLOBAL.USER_ID

4804: , END_DATE_ACTIVE )
4805: SELECT
4806: PERSON_ID
4807: , sysdate
4808: , FND_GLOBAL.USER_ID
4809: , sysdate
4810: , FND_GLOBAL.USER_ID
4811: , FND_GLOBAL.LOGIN_ID
4812: , decode(x_delta, null, x_start_date,

Line 4810: , FND_GLOBAL.USER_ID

4806: PERSON_ID
4807: , sysdate
4808: , FND_GLOBAL.USER_ID
4809: , sysdate
4810: , FND_GLOBAL.USER_ID
4811: , FND_GLOBAL.LOGIN_ID
4812: , decode(x_delta, null, x_start_date,
4813: start_date_active + x_delta)
4814: , x_new_project_id

Line 4811: , FND_GLOBAL.LOGIN_ID

4807: , sysdate
4808: , FND_GLOBAL.USER_ID
4809: , sysdate
4810: , FND_GLOBAL.USER_ID
4811: , FND_GLOBAL.LOGIN_ID
4812: , decode(x_delta, null, x_start_date,
4813: start_date_active + x_delta)
4814: , x_new_project_id
4815: , null

Line 4855: , FND_GLOBAL.USER_ID

4851: , RATE_DISC_REASON_CODE)
4852: SELECT
4853: PERSON_ID
4854: , sysdate
4855: , FND_GLOBAL.USER_ID
4856: , sysdate
4857: , FND_GLOBAL.USER_ID
4858: , FND_GLOBAL.LOGIN_ID
4859: , RATE

Line 4857: , FND_GLOBAL.USER_ID

4853: PERSON_ID
4854: , sysdate
4855: , FND_GLOBAL.USER_ID
4856: , sysdate
4857: , FND_GLOBAL.USER_ID
4858: , FND_GLOBAL.LOGIN_ID
4859: , RATE
4860: , BILL_RATE_UNIT
4861: , decode(x_delta, null, x_start_date,

Line 4858: , FND_GLOBAL.LOGIN_ID

4854: , sysdate
4855: , FND_GLOBAL.USER_ID
4856: , sysdate
4857: , FND_GLOBAL.USER_ID
4858: , FND_GLOBAL.LOGIN_ID
4859: , RATE
4860: , BILL_RATE_UNIT
4861: , decode(x_delta, null, x_start_date,
4862: start_date_active + x_delta)

Line 4908: , FND_GLOBAL.USER_ID

4904: , RATE_DISC_REASON_CODE )
4905: SELECT
4906: EXPENDITURE_TYPE
4907: , sysdate
4908: , FND_GLOBAL.USER_ID
4909: , sysdate
4910: , FND_GLOBAL.USER_ID
4911: , FND_GLOBAL.LOGIN_ID
4912: , decode(x_delta, null, x_start_date,

Line 4910: , FND_GLOBAL.USER_ID

4906: EXPENDITURE_TYPE
4907: , sysdate
4908: , FND_GLOBAL.USER_ID
4909: , sysdate
4910: , FND_GLOBAL.USER_ID
4911: , FND_GLOBAL.LOGIN_ID
4912: , decode(x_delta, null, x_start_date,
4913: start_date_active + x_delta)
4914: , NON_LABOR_RESOURCE

Line 4911: , FND_GLOBAL.LOGIN_ID

4907: , sysdate
4908: , FND_GLOBAL.USER_ID
4909: , sysdate
4910: , FND_GLOBAL.USER_ID
4911: , FND_GLOBAL.LOGIN_ID
4912: , decode(x_delta, null, x_start_date,
4913: start_date_active + x_delta)
4914: , NON_LABOR_RESOURCE
4915: , MARKUP_PERCENTAGE

Line 4959: , FND_GLOBAL.USER_ID

4955: start_date_active + x_delta)
4956: , decode(x_delta, null, x_completion_date,
4957: end_date_active + x_delta)
4958: , sysdate
4959: , FND_GLOBAL.USER_ID
4960: , sysdate
4961: , FND_GLOBAL.USER_ID
4962: , pa_labor_multipliers_s.NEXTVAL
4963: , RECORD_VERSION_NUMBER

Line 4961: , FND_GLOBAL.USER_ID

4957: end_date_active + x_delta)
4958: , sysdate
4959: , FND_GLOBAL.USER_ID
4960: , sysdate
4961: , FND_GLOBAL.USER_ID
4962: , pa_labor_multipliers_s.NEXTVAL
4963: , RECORD_VERSION_NUMBER
4964: , FND_GLOBAL.LOGIN_ID
4965: FROM pa_labor_multipliers

Line 4964: , FND_GLOBAL.LOGIN_ID

4960: , sysdate
4961: , FND_GLOBAL.USER_ID
4962: , pa_labor_multipliers_s.NEXTVAL
4963: , RECORD_VERSION_NUMBER
4964: , FND_GLOBAL.LOGIN_ID
4965: FROM pa_labor_multipliers
4966: WHERE project_id = x_orig_project_id
4967: and task_id is null;
4968:

Line 4997: FND_GLOBAL.USER_ID,

4993: null,
4994: null,
4995: null,
4996: null,
4997: FND_GLOBAL.USER_ID,
4998: FND_GLOBAL.LOGIN_ID,
4999: 275, null, null);
5000: ELSE
5001: fnd_attached_documents2_pkg.copy_attachments('PA_PROJECTS',

Line 4998: FND_GLOBAL.LOGIN_ID,

4994: null,
4995: null,
4996: null,
4997: FND_GLOBAL.USER_ID,
4998: FND_GLOBAL.LOGIN_ID,
4999: 275, null, null);
5000: ELSE
5001: fnd_attached_documents2_pkg.copy_attachments('PA_PROJECTS',
5002: x_orig_project_id,

Line 5013: FND_GLOBAL.USER_ID,

5009: null,
5010: null,
5011: null,
5012: null,
5013: FND_GLOBAL.USER_ID,
5014: FND_GLOBAL.LOGIN_ID,
5015: 275, null, null);
5016: END IF; -- 'Y' = l_pr_frm_src_tmpl_flag
5017: END IF; --'Y' = l_pr_attachments_flag

Line 5014: FND_GLOBAL.LOGIN_ID,

5010: null,
5011: null,
5012: null,
5013: FND_GLOBAL.USER_ID,
5014: FND_GLOBAL.LOGIN_ID,
5015: 275, null, null);
5016: END IF; -- 'Y' = l_pr_frm_src_tmpl_flag
5017: END IF; --'Y' = l_pr_attachments_flag
5018:

Line 5778: FND_GLOBAL.USER_ID,

5774: null, null, null, null,
5775: 'PA_TASKS',
5776: c_atch.new_task_id,
5777: null, null, null, null,
5778: FND_GLOBAL.USER_ID,
5779: FND_GLOBAL.LOGIN_ID,
5780: 275, null, null);
5781:
5782: end loop ;

Line 5779: FND_GLOBAL.LOGIN_ID,

5775: 'PA_TASKS',
5776: c_atch.new_task_id,
5777: null, null, null, null,
5778: FND_GLOBAL.USER_ID,
5779: FND_GLOBAL.LOGIN_ID,
5780: 275, null, null);
5781:
5782: end loop ;
5783: close c_attach_tasks;