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 894: X_entered_by_user_id => FND_GLOBAL.USER_ID,

890: X_task_manager_person_id => NULL,
891: X_Service_type => NULL,
892: X_task_start_date => NULL,
893: X_task_end_date => NULL,
894: X_entered_by_user_id => FND_GLOBAL.USER_ID,
895: X_attribute_category => x_attribute_category,
896: X_attribute1 => x_attribute1,
897: X_attribute2 => x_attribute2,
898: X_attribute3 => x_attribute3,

Line 1004: p_CREATED_BY => FND_GLOBAL.USER_ID,

1000: ( p_CITY => x_city,
1001: p_REGION => x_region,
1002: p_COUNTRY_CODE => x_country_code,
1003: p_CREATION_DATE => sysdate,
1004: p_CREATED_BY => FND_GLOBAL.USER_ID,
1005: p_LAST_UPDATE_DATE => sysdate,
1006: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1007: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1008: X_ROWID => l_rowid,

Line 1006: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1002: p_COUNTRY_CODE => x_country_code,
1003: p_CREATION_DATE => sysdate,
1004: p_CREATED_BY => FND_GLOBAL.USER_ID,
1005: p_LAST_UPDATE_DATE => sysdate,
1006: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1007: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1008: X_ROWID => l_rowid,
1009: X_LOCATION_ID => l_location_id);
1010:

Line 1007: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

1003: p_CREATION_DATE => sysdate,
1004: p_CREATED_BY => FND_GLOBAL.USER_ID,
1005: p_LAST_UPDATE_DATE => sysdate,
1006: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1007: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1008: X_ROWID => l_rowid,
1009: X_LOCATION_ID => l_location_id);
1010:
1011: end if;

Line 1100: p_CREATED_BY => FND_GLOBAL.USER_ID,

1096: p_CITY => l_city,
1097: p_REGION => l_region,
1098: p_COUNTRY_CODE => l_country_code,
1099: p_CREATION_DATE => sysdate,
1100: p_CREATED_BY => FND_GLOBAL.USER_ID,
1101: p_LAST_UPDATE_DATE => sysdate,
1102: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1103: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1104: X_ROWID => l_rowid,

Line 1102: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1098: p_COUNTRY_CODE => l_country_code,
1099: p_CREATION_DATE => sysdate,
1100: p_CREATED_BY => FND_GLOBAL.USER_ID,
1101: p_LAST_UPDATE_DATE => sysdate,
1102: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1103: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1104: X_ROWID => l_rowid,
1105: X_LOCATION_ID => l_location_id);
1106: end if;

Line 1103: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,

1099: p_CREATION_DATE => sysdate,
1100: p_CREATED_BY => FND_GLOBAL.USER_ID,
1101: p_LAST_UPDATE_DATE => sysdate,
1102: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1103: p_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1104: X_ROWID => l_rowid,
1105: X_LOCATION_ID => l_location_id);
1106: end if;
1107: end if;

Line 1428: FND_GLOBAL.USER_ID,

1424: NVL( x_long_name, x_project_name ), --long name changes
1425: x_new_project_number,
1426: t.org_id, -- Bug 4363092: MOAC Changes
1427: sysdate,
1428: FND_GLOBAL.USER_ID,
1429: sysdate,
1430: FND_GLOBAL.USER_ID,
1431: FND_GLOBAL.LOGIN_ID,
1432: t.project_type,

Line 1430: FND_GLOBAL.USER_ID,

1426: t.org_id, -- Bug 4363092: MOAC Changes
1427: sysdate,
1428: FND_GLOBAL.USER_ID,
1429: sysdate,
1430: FND_GLOBAL.USER_ID,
1431: FND_GLOBAL.LOGIN_ID,
1432: t.project_type,
1433: nvl(x_organization_id, t.carrying_out_organization_id),
1434: nvl(x_public_sector_flag, t.public_sector_flag),

Line 1431: FND_GLOBAL.LOGIN_ID,

1427: sysdate,
1428: FND_GLOBAL.USER_ID,
1429: sysdate,
1430: FND_GLOBAL.USER_ID,
1431: FND_GLOBAL.LOGIN_ID,
1432: t.project_type,
1433: nvl(x_organization_id, t.carrying_out_organization_id),
1434: nvl(x_public_sector_flag, t.public_sector_flag),
1435: p_project_status_code,

Line 1760: FND_GLOBAL.USER_ID,

1756: ) select
1757: x_new_project_id,
1758: o.option_code,
1759: sysdate,
1760: FND_GLOBAL.USER_ID,
1761: sysdate,
1762: FND_GLOBAL.USER_ID,
1763: FND_GLOBAL.LOGIN_ID
1764: from pa_project_options o

Line 1762: FND_GLOBAL.USER_ID,

1758: o.option_code,
1759: sysdate,
1760: FND_GLOBAL.USER_ID,
1761: sysdate,
1762: FND_GLOBAL.USER_ID,
1763: FND_GLOBAL.LOGIN_ID
1764: from pa_project_options o
1765: where o.project_id = x_created_from_proj_id;
1766:

Line 1763: FND_GLOBAL.LOGIN_ID

1759: sysdate,
1760: FND_GLOBAL.USER_ID,
1761: sysdate,
1762: FND_GLOBAL.USER_ID,
1763: FND_GLOBAL.LOGIN_ID
1764: from pa_project_options o
1765: where o.project_id = x_created_from_proj_id;
1766:
1767: x_err_stage := 'copying project copy overrides ';

Line 1787: FND_GLOBAL.USER_ID,

1783: x_new_project_id,
1784: c.field_name,
1785: c.display_name,
1786: sysdate,
1787: FND_GLOBAL.USER_ID,
1788: sysdate,
1789: FND_GLOBAL.USER_ID,
1790: FND_GLOBAL.LOGIN_ID,
1791: c.limiting_value,

Line 1789: FND_GLOBAL.USER_ID,

1785: c.display_name,
1786: sysdate,
1787: FND_GLOBAL.USER_ID,
1788: sysdate,
1789: FND_GLOBAL.USER_ID,
1790: FND_GLOBAL.LOGIN_ID,
1791: c.limiting_value,
1792: c.sort_order,
1793: c.mandatory_flag,

Line 1790: FND_GLOBAL.LOGIN_ID,

1786: sysdate,
1787: FND_GLOBAL.USER_ID,
1788: sysdate,
1789: FND_GLOBAL.USER_ID,
1790: FND_GLOBAL.LOGIN_ID,
1791: c.limiting_value,
1792: c.sort_order,
1793: c.mandatory_flag,
1794: 1

Line 2663: , FND_GLOBAL.USER_ID

2659: , pc.code_percentage
2660: , x_new_project_id
2661: , 'PA_PROJECTS'
2662: , sysdate
2663: , FND_GLOBAL.USER_ID
2664: , sysdate
2665: , FND_GLOBAL.USER_ID
2666: , FND_GLOBAL.LOGIN_ID
2667: , pc.attribute_category

Line 2665: , FND_GLOBAL.USER_ID

2661: , 'PA_PROJECTS'
2662: , sysdate
2663: , FND_GLOBAL.USER_ID
2664: , sysdate
2665: , FND_GLOBAL.USER_ID
2666: , FND_GLOBAL.LOGIN_ID
2667: , pc.attribute_category
2668: , pc.attribute1
2669: , pc.attribute2

Line 2666: , FND_GLOBAL.LOGIN_ID

2662: , sysdate
2663: , FND_GLOBAL.USER_ID
2664: , sysdate
2665: , FND_GLOBAL.USER_ID
2666: , FND_GLOBAL.LOGIN_ID
2667: , pc.attribute_category
2668: , pc.attribute1
2669: , pc.attribute2
2670: , pc.attribute3

Line 2734: , FND_GLOBAL.USER_ID

2730: , pc.code_percentage
2731: , x_new_project_id
2732: , 'PA_PROJECTS'
2733: , sysdate
2734: , FND_GLOBAL.USER_ID
2735: , sysdate
2736: , FND_GLOBAL.USER_ID
2737: , FND_GLOBAL.LOGIN_ID
2738: , pc.attribute_category

Line 2736: , FND_GLOBAL.USER_ID

2732: , 'PA_PROJECTS'
2733: , sysdate
2734: , FND_GLOBAL.USER_ID
2735: , sysdate
2736: , FND_GLOBAL.USER_ID
2737: , FND_GLOBAL.LOGIN_ID
2738: , pc.attribute_category
2739: , pc.attribute1
2740: , pc.attribute2

Line 2737: , FND_GLOBAL.LOGIN_ID

2733: , sysdate
2734: , FND_GLOBAL.USER_ID
2735: , sysdate
2736: , FND_GLOBAL.USER_ID
2737: , FND_GLOBAL.LOGIN_ID
2738: , pc.attribute_category
2739: , pc.attribute1
2740: , pc.attribute2
2741: , pc.attribute3

Line 2943: , FND_GLOBAL.USER_ID

2939: SELECT
2940: x_new_project_id
2941: , cust.customer_id
2942: , sysdate
2943: , FND_GLOBAL.USER_ID
2944: , sysdate
2945: , FND_GLOBAL.USER_ID
2946: , FND_GLOBAL.LOGIN_ID
2947: , cust.project_relationship_code

Line 2945: , FND_GLOBAL.USER_ID

2941: , cust.customer_id
2942: , sysdate
2943: , FND_GLOBAL.USER_ID
2944: , sysdate
2945: , FND_GLOBAL.USER_ID
2946: , FND_GLOBAL.LOGIN_ID
2947: , cust.project_relationship_code
2948: --Bug 3279981
2949: --, cust.customer_bill_split

Line 2946: , FND_GLOBAL.LOGIN_ID

2942: , sysdate
2943: , FND_GLOBAL.USER_ID
2944: , sysdate
2945: , FND_GLOBAL.USER_ID
2946: , FND_GLOBAL.LOGIN_ID
2947: , cust.project_relationship_code
2948: --Bug 3279981
2949: --, cust.customer_bill_split
2950: , decode(l_check_diff_flag, --sunkalya:federal Bug#5511353

Line 3119: , FND_GLOBAL.USER_ID

3115: SELECT
3116: x_new_project_id
3117: , cust.customer_id
3118: , sysdate
3119: , FND_GLOBAL.USER_ID
3120: , sysdate
3121: , FND_GLOBAL.USER_ID
3122: , FND_GLOBAL.LOGIN_ID
3123: , cust.project_relationship_code

Line 3121: , FND_GLOBAL.USER_ID

3117: , cust.customer_id
3118: , sysdate
3119: , FND_GLOBAL.USER_ID
3120: , sysdate
3121: , FND_GLOBAL.USER_ID
3122: , FND_GLOBAL.LOGIN_ID
3123: , cust.project_relationship_code
3124: , cust.customer_bill_split
3125: , cust.bill_to_address_id

Line 3122: , FND_GLOBAL.LOGIN_ID

3118: , sysdate
3119: , FND_GLOBAL.USER_ID
3120: , sysdate
3121: , FND_GLOBAL.USER_ID
3122: , FND_GLOBAL.LOGIN_ID
3123: , cust.project_relationship_code
3124: , cust.customer_bill_split
3125: , cust.bill_to_address_id
3126: , cust.ship_to_address_id

Line 3448: X_User => FND_GLOBAL.USER_ID,

3444: X_Allow_Inv_Rate_Type_Fg => l_cur_cust_info.allow_inv_user_rate_type_flag,
3445: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3446: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3447: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3448: X_User => FND_GLOBAL.USER_ID,
3449: X_Login => FND_GLOBAL.LOGIN_ID,
3450: X_Err_Code => x_err_code,
3451: X_Err_Stage => x_err_stage,
3452: X_Err_Stack => x_err_stack

Line 3449: X_Login => FND_GLOBAL.LOGIN_ID,

3445: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3446: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3447: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3448: X_User => FND_GLOBAL.USER_ID,
3449: X_Login => FND_GLOBAL.LOGIN_ID,
3450: X_Err_Code => x_err_code,
3451: X_Err_Stage => x_err_stage,
3452: X_Err_Stack => x_err_stack
3453: );

Line 3655: X_User => FND_GLOBAL.USER_ID,

3651: X_Allow_Inv_Rate_Type_Fg => l_cur_cust_info.allow_inv_user_rate_type_flag,
3652: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3653: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3654: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3655: X_User => FND_GLOBAL.USER_ID,
3656: X_Login => FND_GLOBAL.LOGIN_ID,
3657: X_Err_Code => x_err_code,
3658: X_Err_Stage => x_err_stage,
3659: X_Err_Stack => x_err_stack

Line 3656: X_Login => FND_GLOBAL.LOGIN_ID,

3652: X_Bill_Another_Project_Fg => l_cur_cust_info.bill_another_project_flag,
3653: X_Receiver_Task_Id => l_cur_cust_info.receiver_task_id,
3654: P_default_top_task_customer => l_cur_cust_info.default_top_task_cust_flag,
3655: X_User => FND_GLOBAL.USER_ID,
3656: X_Login => FND_GLOBAL.LOGIN_ID,
3657: X_Err_Code => x_err_code,
3658: X_Err_Stage => x_err_stage,
3659: X_Err_Stack => x_err_stack
3660: );

Line 3825: , FND_GLOBAL.USER_ID

3821: , c.customer_id
3822: , c.contact_id
3823: , c.project_contact_type_code
3824: , sysdate
3825: , FND_GLOBAL.USER_ID
3826: , sysdate
3827: , FND_GLOBAL.USER_ID
3828: , FND_GLOBAL.LOGIN_ID
3829: , 1

Line 3827: , FND_GLOBAL.USER_ID

3823: , c.project_contact_type_code
3824: , sysdate
3825: , FND_GLOBAL.USER_ID
3826: , sysdate
3827: , FND_GLOBAL.USER_ID
3828: , FND_GLOBAL.LOGIN_ID
3829: , 1
3830: -- Customer Account relationships
3831: , c.bill_ship_customer_id

Line 3828: , FND_GLOBAL.LOGIN_ID

3824: , sysdate
3825: , FND_GLOBAL.USER_ID
3826: , sysdate
3827: , FND_GLOBAL.USER_ID
3828: , FND_GLOBAL.LOGIN_ID
3829: , 1
3830: -- Customer Account relationships
3831: , c.bill_ship_customer_id
3832: FROM

Line 3865: , FND_GLOBAL.USER_ID

3861: , c.customer_id
3862: , c.contact_id
3863: , c.project_contact_type_code
3864: , sysdate
3865: , FND_GLOBAL.USER_ID
3866: , sysdate
3867: , FND_GLOBAL.USER_ID
3868: , FND_GLOBAL.LOGIN_ID
3869: , 1

Line 3867: , FND_GLOBAL.USER_ID

3863: , c.project_contact_type_code
3864: , sysdate
3865: , FND_GLOBAL.USER_ID
3866: , sysdate
3867: , FND_GLOBAL.USER_ID
3868: , FND_GLOBAL.LOGIN_ID
3869: , 1
3870: -- Customer Account relationships
3871: , c.bill_ship_customer_id

Line 3868: , FND_GLOBAL.LOGIN_ID

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

Line 3920: , FND_GLOBAL.USER_ID

3916: , OVERRIDE_TO_ORGANIZATION_ID
3917: , decode(x_delta, null, x_start_date,
3918: start_date_active + x_delta)
3919: , sysdate
3920: , FND_GLOBAL.USER_ID
3921: , sysdate
3922: , FND_GLOBAL.USER_ID
3923: , FND_GLOBAL.LOGIN_ID
3924: , person_id

Line 3922: , FND_GLOBAL.USER_ID

3918: start_date_active + x_delta)
3919: , sysdate
3920: , FND_GLOBAL.USER_ID
3921: , sysdate
3922: , FND_GLOBAL.USER_ID
3923: , FND_GLOBAL.LOGIN_ID
3924: , person_id
3925: , EXPENDITURE_CATEGORY
3926: , OVERRIDE_FROM_ORGANIZATION_ID

Line 3923: , FND_GLOBAL.LOGIN_ID

3919: , sysdate
3920: , FND_GLOBAL.USER_ID
3921: , sysdate
3922: , FND_GLOBAL.USER_ID
3923: , FND_GLOBAL.LOGIN_ID
3924: , person_id
3925: , EXPENDITURE_CATEGORY
3926: , OVERRIDE_FROM_ORGANIZATION_ID
3927: , decode(x_delta, null, x_completion_date,

Line 3957: , FND_GLOBAL.USER_ID

3953: PERSON_ID
3954: , CREDIT_TYPE_CODE
3955: , x_new_project_id
3956: , sysdate
3957: , FND_GLOBAL.USER_ID
3958: , sysdate
3959: , FND_GLOBAL.USER_ID
3960: , FND_GLOBAL.LOGIN_ID
3961: , decode(x_delta, null, x_start_date,

Line 3959: , FND_GLOBAL.USER_ID

3955: , x_new_project_id
3956: , sysdate
3957: , FND_GLOBAL.USER_ID
3958: , sysdate
3959: , FND_GLOBAL.USER_ID
3960: , FND_GLOBAL.LOGIN_ID
3961: , decode(x_delta, null, x_start_date,
3962: start_date_active + x_delta)
3963: , CREDIT_PERCENTAGE

Line 3960: , FND_GLOBAL.LOGIN_ID

3956: , sysdate
3957: , FND_GLOBAL.USER_ID
3958: , sysdate
3959: , FND_GLOBAL.USER_ID
3960: , FND_GLOBAL.LOGIN_ID
3961: , decode(x_delta, null, x_start_date,
3962: start_date_active + x_delta)
3963: , CREDIT_PERCENTAGE
3964: , decode(x_delta, null, x_completion_date,

Line 4035: FND_GLOBAL.USER_ID,

4031: AMOUNT,
4032: PERCENTAGE,
4033: ACTIVE_FLAG,
4034: sysdate,
4035: FND_GLOBAL.USER_ID,
4036: sysdate,
4037: FND_GLOBAL.USER_ID,
4038: FND_GLOBAL.LOGIN_ID,
4039: ATTRIBUTE_CATEGORY,

Line 4037: FND_GLOBAL.USER_ID,

4033: ACTIVE_FLAG,
4034: sysdate,
4035: FND_GLOBAL.USER_ID,
4036: sysdate,
4037: FND_GLOBAL.USER_ID,
4038: FND_GLOBAL.LOGIN_ID,
4039: ATTRIBUTE_CATEGORY,
4040: ATTRIBUTE1,
4041: ATTRIBUTE2,

Line 4038: FND_GLOBAL.LOGIN_ID,

4034: sysdate,
4035: FND_GLOBAL.USER_ID,
4036: sysdate,
4037: FND_GLOBAL.USER_ID,
4038: FND_GLOBAL.LOGIN_ID,
4039: ATTRIBUTE_CATEGORY,
4040: ATTRIBUTE1,
4041: ATTRIBUTE2,
4042: ATTRIBUTE3,

Line 4121: FND_GLOBAL.USER_ID,

4117: s.start_date_active + x_delta),
4118: decode(x_delta, null, x_completion_date,
4119: s.end_date_active + x_delta),
4120: sysdate,
4121: FND_GLOBAL.USER_ID,
4122: FND_GLOBAL.USER_ID,
4123: sysdate,
4124: FND_GLOBAL.LOGIN_ID,
4125: s.COST_PLUS_STRUCTURE,

Line 4122: FND_GLOBAL.USER_ID,

4118: decode(x_delta, null, x_completion_date,
4119: s.end_date_active + x_delta),
4120: sysdate,
4121: FND_GLOBAL.USER_ID,
4122: FND_GLOBAL.USER_ID,
4123: sysdate,
4124: FND_GLOBAL.LOGIN_ID,
4125: s.COST_PLUS_STRUCTURE,
4126: s.IND_RATE_SCHEDULE_TYPE,

Line 4124: FND_GLOBAL.LOGIN_ID,

4120: sysdate,
4121: FND_GLOBAL.USER_ID,
4122: FND_GLOBAL.USER_ID,
4123: sysdate,
4124: FND_GLOBAL.LOGIN_ID,
4125: s.COST_PLUS_STRUCTURE,
4126: s.IND_RATE_SCHEDULE_TYPE,
4127: x_new_project_id,
4128: null,

Line 4181: FND_GLOBAL.USER_ID,

4177: decode(x_delta, null, x_completion_date,
4178: rev.end_date_active + x_delta),
4179: null,
4180: sysdate,
4181: FND_GLOBAL.USER_ID,
4182: FND_GLOBAL.USER_ID,
4183: sysdate,
4184: FND_GLOBAL.LOGIN_ID,
4185: rev.REQUEST_ID,

Line 4182: FND_GLOBAL.USER_ID,

4178: rev.end_date_active + x_delta),
4179: null,
4180: sysdate,
4181: FND_GLOBAL.USER_ID,
4182: FND_GLOBAL.USER_ID,
4183: sysdate,
4184: FND_GLOBAL.LOGIN_ID,
4185: rev.REQUEST_ID,
4186: NULL,

Line 4184: FND_GLOBAL.LOGIN_ID,

4180: sysdate,
4181: FND_GLOBAL.USER_ID,
4182: FND_GLOBAL.USER_ID,
4183: sysdate,
4184: FND_GLOBAL.LOGIN_ID,
4185: rev.REQUEST_ID,
4186: NULL,
4187: NULL,
4188: NULL,

Line 4231: FND_GLOBAL.USER_ID,

4227: mult.ORGANIZATION_ID,
4228: mult.IND_COST_CODE,
4229: mult.MULTIPLIER,
4230: sysdate,
4231: FND_GLOBAL.USER_ID,
4232: FND_GLOBAL.USER_ID,
4233: sysdate,
4234: FND_GLOBAL.LOGIN_ID
4235: from pa_ind_cost_multipliers mult,

Line 4232: FND_GLOBAL.USER_ID,

4228: mult.IND_COST_CODE,
4229: mult.MULTIPLIER,
4230: sysdate,
4231: FND_GLOBAL.USER_ID,
4232: FND_GLOBAL.USER_ID,
4233: sysdate,
4234: FND_GLOBAL.LOGIN_ID
4235: from pa_ind_cost_multipliers mult,
4236: pa_ind_rate_sch_revisions old_rev,

Line 4234: FND_GLOBAL.LOGIN_ID

4230: sysdate,
4231: FND_GLOBAL.USER_ID,
4232: FND_GLOBAL.USER_ID,
4233: sysdate,
4234: FND_GLOBAL.LOGIN_ID
4235: from pa_ind_cost_multipliers mult,
4236: pa_ind_rate_sch_revisions old_rev,
4237: pa_ind_rate_sch_revisions new_rev,
4238: pa_ind_rate_schedules old_sch,

Line 4298: , FND_GLOBAL.USER_ID

4294: tc.start_date_active + x_delta)
4295: , tc.chargeable_flag
4296: , tc.billable_indicator
4297: , sysdate
4298: , FND_GLOBAL.USER_ID
4299: , sysdate
4300: , FND_GLOBAL.USER_ID
4301: , FND_GLOBAL.LOGIN_ID
4302: , tc.person_id

Line 4300: , FND_GLOBAL.USER_ID

4296: , tc.billable_indicator
4297: , sysdate
4298: , FND_GLOBAL.USER_ID
4299: , sysdate
4300: , FND_GLOBAL.USER_ID
4301: , FND_GLOBAL.LOGIN_ID
4302: , tc.person_id
4303: , tc.expenditure_category
4304: , tc.expenditure_type

Line 4301: , FND_GLOBAL.LOGIN_ID

4297: , sysdate
4298: , FND_GLOBAL.USER_ID
4299: , sysdate
4300: , FND_GLOBAL.USER_ID
4301: , FND_GLOBAL.LOGIN_ID
4302: , tc.person_id
4303: , tc.expenditure_category
4304: , tc.expenditure_type
4305: , tc.non_labor_resource

Line 4420: FND_GLOBAL.USER_ID,

4416: 'N',
4417: NULL,
4418: 'N',
4419: sysdate,
4420: FND_GLOBAL.USER_ID,
4421: sysdate,
4422: FND_GLOBAL.USER_ID,
4423: FND_GLOBAL.LOGIN_ID,
4424: ATTRIBUTE_CATEGORY,

Line 4422: FND_GLOBAL.USER_ID,

4418: 'N',
4419: sysdate,
4420: FND_GLOBAL.USER_ID,
4421: sysdate,
4422: FND_GLOBAL.USER_ID,
4423: FND_GLOBAL.LOGIN_ID,
4424: ATTRIBUTE_CATEGORY,
4425: ATTRIBUTE1,
4426: ATTRIBUTE2,

Line 4423: FND_GLOBAL.LOGIN_ID,

4419: sysdate,
4420: FND_GLOBAL.USER_ID,
4421: sysdate,
4422: FND_GLOBAL.USER_ID,
4423: FND_GLOBAL.LOGIN_ID,
4424: ATTRIBUTE_CATEGORY,
4425: ATTRIBUTE1,
4426: ATTRIBUTE2,
4427: ATTRIBUTE3,

Line 4493: FND_GLOBAL.USER_ID,

4489: null, null, null, null,
4490: 'PA_PROJECT_ASSETS',
4491: c_atch.new_project_asset_id,
4492: null, null, null, null,
4493: FND_GLOBAL.USER_ID,
4494: FND_GLOBAL.LOGIN_ID,
4495: 275, null, null);
4496:
4497: end loop ;

Line 4494: FND_GLOBAL.LOGIN_ID,

4490: 'PA_PROJECT_ASSETS',
4491: c_atch.new_project_asset_id,
4492: null, null, null, null,
4493: FND_GLOBAL.USER_ID,
4494: FND_GLOBAL.LOGIN_ID,
4495: 275, null, null);
4496:
4497: end loop ;
4498: close c_attach_assets;

Line 4534: FND_GLOBAL.USER_ID,

4530: new_asset.PROJECT_ASSET_ID,
4531: 0,
4532: new_asset.PROJECT_ID,
4533: sysdate,
4534: FND_GLOBAL.USER_ID,
4535: sysdate,
4536: FND_GLOBAL.USER_ID,
4537: FND_GLOBAL.LOGIN_ID
4538: from pa_project_asset_assignments assign,

Line 4536: FND_GLOBAL.USER_ID,

4532: new_asset.PROJECT_ID,
4533: sysdate,
4534: FND_GLOBAL.USER_ID,
4535: sysdate,
4536: FND_GLOBAL.USER_ID,
4537: FND_GLOBAL.LOGIN_ID
4538: from pa_project_asset_assignments assign,
4539: pa_project_assets old_asset,
4540: pa_project_assets new_asset

Line 4537: FND_GLOBAL.LOGIN_ID

4533: sysdate,
4534: FND_GLOBAL.USER_ID,
4535: sysdate,
4536: FND_GLOBAL.USER_ID,
4537: FND_GLOBAL.LOGIN_ID
4538: from pa_project_asset_assignments assign,
4539: pa_project_assets old_asset,
4540: pa_project_assets new_asset
4541: where old_asset.project_id = x_orig_project_id

Line 4553: FND_GLOBAL.USER_ID,

4549: new_asset.PROJECT_ASSET_ID,
4550: 0,
4551: new_asset.PROJECT_ID,
4552: sysdate,
4553: FND_GLOBAL.USER_ID,
4554: sysdate,
4555: FND_GLOBAL.USER_ID,
4556: FND_GLOBAL.LOGIN_ID
4557: from pa_project_asset_assignments assign,

Line 4555: FND_GLOBAL.USER_ID,

4551: new_asset.PROJECT_ID,
4552: sysdate,
4553: FND_GLOBAL.USER_ID,
4554: sysdate,
4555: FND_GLOBAL.USER_ID,
4556: FND_GLOBAL.LOGIN_ID
4557: from pa_project_asset_assignments assign,
4558: pa_project_assets old_asset,
4559: pa_project_assets new_asset

Line 4556: FND_GLOBAL.LOGIN_ID

4552: sysdate,
4553: FND_GLOBAL.USER_ID,
4554: sysdate,
4555: FND_GLOBAL.USER_ID,
4556: FND_GLOBAL.LOGIN_ID
4557: from pa_project_asset_assignments assign,
4558: pa_project_assets old_asset,
4559: pa_project_assets new_asset
4560: where old_asset.project_id = x_orig_project_id

Line 4572: FND_GLOBAL.USER_ID,

4568: PROJECT_ASSET_ID,
4569: 0,
4570: x_new_project_id,
4571: sysdate,
4572: FND_GLOBAL.USER_ID,
4573: sysdate,
4574: FND_GLOBAL.USER_ID,
4575: FND_GLOBAL.LOGIN_ID
4576: from pa_project_asset_assignments

Line 4574: FND_GLOBAL.USER_ID,

4570: x_new_project_id,
4571: sysdate,
4572: FND_GLOBAL.USER_ID,
4573: sysdate,
4574: FND_GLOBAL.USER_ID,
4575: FND_GLOBAL.LOGIN_ID
4576: from pa_project_asset_assignments
4577: where project_id = x_orig_project_id
4578: and task_id = 0

Line 4575: FND_GLOBAL.LOGIN_ID

4571: sysdate,
4572: FND_GLOBAL.USER_ID,
4573: sysdate,
4574: FND_GLOBAL.USER_ID,
4575: FND_GLOBAL.LOGIN_ID
4576: from pa_project_asset_assignments
4577: where project_id = x_orig_project_id
4578: and task_id = 0
4579: and project_asset_id = 0;

Line 4601: FND_GLOBAL.USER_ID,

4597: pa_resource_list_assignments_s.nextval,
4598: RESOURCE_LIST_ID,
4599: x_new_project_id,
4600: 'N',
4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: sysdate,
4604: FND_GLOBAL.USER_ID,
4605: FND_GLOBAL.LOGIN_ID

Line 4604: FND_GLOBAL.USER_ID,

4600: 'N',
4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: sysdate,
4604: FND_GLOBAL.USER_ID,
4605: FND_GLOBAL.LOGIN_ID
4606: from pa_resource_list_assignments a,
4607: pa_resource_list_uses u
4608: where a.project_id = x_orig_project_id

Line 4605: FND_GLOBAL.LOGIN_ID

4601: FND_GLOBAL.USER_ID,
4602: sysdate,
4603: sysdate,
4604: FND_GLOBAL.USER_ID,
4605: FND_GLOBAL.LOGIN_ID
4606: from pa_resource_list_assignments a,
4607: pa_resource_list_uses u
4608: where a.project_id = x_orig_project_id
4609: and a.resource_list_assignment_id =

Line 4629: FND_GLOBAL.USER_ID,

4625: select
4626: new_list.RESOURCE_LIST_ASSIGNMENT_ID,
4627: use.USE_CODE,
4628: use.Default_Flag,
4629: FND_GLOBAL.USER_ID,
4630: sysdate,
4631: sysdate,
4632: FND_GLOBAL.USER_ID,
4633: FND_GLOBAL.LOGIN_ID

Line 4632: FND_GLOBAL.USER_ID,

4628: use.Default_Flag,
4629: FND_GLOBAL.USER_ID,
4630: sysdate,
4631: sysdate,
4632: FND_GLOBAL.USER_ID,
4633: FND_GLOBAL.LOGIN_ID
4634: from pa_resource_list_uses use,
4635: pa_resource_list_assignments old_list,
4636: pa_resource_list_assignments new_list

Line 4633: FND_GLOBAL.LOGIN_ID

4629: FND_GLOBAL.USER_ID,
4630: sysdate,
4631: sysdate,
4632: FND_GLOBAL.USER_ID,
4633: FND_GLOBAL.LOGIN_ID
4634: from pa_resource_list_uses use,
4635: pa_resource_list_assignments old_list,
4636: pa_resource_list_assignments new_list
4637: where old_list.project_id = x_orig_project_id

Line 4674: , FND_GLOBAL.USER_ID

4670: JOB_ID
4671: , decode(x_delta, null, x_start_date,
4672: start_date_active + x_delta)
4673: , sysdate
4674: , FND_GLOBAL.USER_ID
4675: , sysdate
4676: , FND_GLOBAL.USER_ID
4677: , FND_GLOBAL.LOGIN_ID
4678: , RATE

Line 4676: , FND_GLOBAL.USER_ID

4672: start_date_active + x_delta)
4673: , sysdate
4674: , FND_GLOBAL.USER_ID
4675: , sysdate
4676: , FND_GLOBAL.USER_ID
4677: , FND_GLOBAL.LOGIN_ID
4678: , RATE
4679: , BILL_RATE_UNIT
4680: , x_new_project_id

Line 4677: , FND_GLOBAL.LOGIN_ID

4673: , sysdate
4674: , FND_GLOBAL.USER_ID
4675: , sysdate
4676: , FND_GLOBAL.USER_ID
4677: , FND_GLOBAL.LOGIN_ID
4678: , RATE
4679: , BILL_RATE_UNIT
4680: , x_new_project_id
4681: , null

Line 4719: , FND_GLOBAL.USER_ID

4715: , END_DATE_ACTIVE )
4716: SELECT
4717: JOB_ID
4718: , sysdate
4719: , FND_GLOBAL.USER_ID
4720: , sysdate
4721: , FND_GLOBAL.USER_ID
4722: , FND_GLOBAL.LOGIN_ID
4723: , decode(x_delta, null, x_start_date,

Line 4721: , FND_GLOBAL.USER_ID

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

Line 4722: , FND_GLOBAL.LOGIN_ID

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

Line 4760: , FND_GLOBAL.USER_ID

4756: , END_DATE_ACTIVE )
4757: SELECT
4758: PERSON_ID
4759: , sysdate
4760: , FND_GLOBAL.USER_ID
4761: , sysdate
4762: , FND_GLOBAL.USER_ID
4763: , FND_GLOBAL.LOGIN_ID
4764: , decode(x_delta, null, x_start_date,

Line 4762: , FND_GLOBAL.USER_ID

4758: PERSON_ID
4759: , sysdate
4760: , FND_GLOBAL.USER_ID
4761: , sysdate
4762: , FND_GLOBAL.USER_ID
4763: , FND_GLOBAL.LOGIN_ID
4764: , decode(x_delta, null, x_start_date,
4765: start_date_active + x_delta)
4766: , x_new_project_id

Line 4763: , FND_GLOBAL.LOGIN_ID

4759: , sysdate
4760: , FND_GLOBAL.USER_ID
4761: , sysdate
4762: , FND_GLOBAL.USER_ID
4763: , FND_GLOBAL.LOGIN_ID
4764: , decode(x_delta, null, x_start_date,
4765: start_date_active + x_delta)
4766: , x_new_project_id
4767: , null

Line 4807: , FND_GLOBAL.USER_ID

4803: , RATE_DISC_REASON_CODE)
4804: SELECT
4805: PERSON_ID
4806: , sysdate
4807: , FND_GLOBAL.USER_ID
4808: , sysdate
4809: , FND_GLOBAL.USER_ID
4810: , FND_GLOBAL.LOGIN_ID
4811: , RATE

Line 4809: , FND_GLOBAL.USER_ID

4805: PERSON_ID
4806: , sysdate
4807: , FND_GLOBAL.USER_ID
4808: , sysdate
4809: , FND_GLOBAL.USER_ID
4810: , FND_GLOBAL.LOGIN_ID
4811: , RATE
4812: , BILL_RATE_UNIT
4813: , decode(x_delta, null, x_start_date,

Line 4810: , FND_GLOBAL.LOGIN_ID

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

Line 4860: , FND_GLOBAL.USER_ID

4856: , RATE_DISC_REASON_CODE )
4857: SELECT
4858: EXPENDITURE_TYPE
4859: , sysdate
4860: , FND_GLOBAL.USER_ID
4861: , sysdate
4862: , FND_GLOBAL.USER_ID
4863: , FND_GLOBAL.LOGIN_ID
4864: , decode(x_delta, null, x_start_date,

Line 4862: , FND_GLOBAL.USER_ID

4858: EXPENDITURE_TYPE
4859: , sysdate
4860: , FND_GLOBAL.USER_ID
4861: , sysdate
4862: , FND_GLOBAL.USER_ID
4863: , FND_GLOBAL.LOGIN_ID
4864: , decode(x_delta, null, x_start_date,
4865: start_date_active + x_delta)
4866: , NON_LABOR_RESOURCE

Line 4863: , FND_GLOBAL.LOGIN_ID

4859: , sysdate
4860: , FND_GLOBAL.USER_ID
4861: , sysdate
4862: , FND_GLOBAL.USER_ID
4863: , FND_GLOBAL.LOGIN_ID
4864: , decode(x_delta, null, x_start_date,
4865: start_date_active + x_delta)
4866: , NON_LABOR_RESOURCE
4867: , MARKUP_PERCENTAGE

Line 4911: , FND_GLOBAL.USER_ID

4907: start_date_active + x_delta)
4908: , decode(x_delta, null, x_completion_date,
4909: end_date_active + x_delta)
4910: , sysdate
4911: , FND_GLOBAL.USER_ID
4912: , sysdate
4913: , FND_GLOBAL.USER_ID
4914: , pa_labor_multipliers_s.NEXTVAL
4915: , RECORD_VERSION_NUMBER

Line 4913: , FND_GLOBAL.USER_ID

4909: end_date_active + x_delta)
4910: , sysdate
4911: , FND_GLOBAL.USER_ID
4912: , sysdate
4913: , FND_GLOBAL.USER_ID
4914: , pa_labor_multipliers_s.NEXTVAL
4915: , RECORD_VERSION_NUMBER
4916: , FND_GLOBAL.LOGIN_ID
4917: FROM pa_labor_multipliers

Line 4916: , FND_GLOBAL.LOGIN_ID

4912: , sysdate
4913: , FND_GLOBAL.USER_ID
4914: , pa_labor_multipliers_s.NEXTVAL
4915: , RECORD_VERSION_NUMBER
4916: , FND_GLOBAL.LOGIN_ID
4917: FROM pa_labor_multipliers
4918: WHERE project_id = x_orig_project_id
4919: and task_id is null;
4920:

Line 4949: FND_GLOBAL.USER_ID,

4945: null,
4946: null,
4947: null,
4948: null,
4949: FND_GLOBAL.USER_ID,
4950: FND_GLOBAL.LOGIN_ID,
4951: 275, null, null);
4952: ELSE
4953: fnd_attached_documents2_pkg.copy_attachments('PA_PROJECTS',

Line 4950: FND_GLOBAL.LOGIN_ID,

4946: null,
4947: null,
4948: null,
4949: FND_GLOBAL.USER_ID,
4950: FND_GLOBAL.LOGIN_ID,
4951: 275, null, null);
4952: ELSE
4953: fnd_attached_documents2_pkg.copy_attachments('PA_PROJECTS',
4954: x_orig_project_id,

Line 4965: FND_GLOBAL.USER_ID,

4961: null,
4962: null,
4963: null,
4964: null,
4965: FND_GLOBAL.USER_ID,
4966: FND_GLOBAL.LOGIN_ID,
4967: 275, null, null);
4968: END IF; -- 'Y' = l_pr_frm_src_tmpl_flag
4969: END IF; --'Y' = l_pr_attachments_flag

Line 4966: FND_GLOBAL.LOGIN_ID,

4962: null,
4963: null,
4964: null,
4965: FND_GLOBAL.USER_ID,
4966: FND_GLOBAL.LOGIN_ID,
4967: 275, null, null);
4968: END IF; -- 'Y' = l_pr_frm_src_tmpl_flag
4969: END IF; --'Y' = l_pr_attachments_flag
4970:

Line 5710: FND_GLOBAL.USER_ID,

5706: null, null, null, null,
5707: 'PA_TASKS',
5708: c_atch.new_task_id,
5709: null, null, null, null,
5710: FND_GLOBAL.USER_ID,
5711: FND_GLOBAL.LOGIN_ID,
5712: 275, null, null);
5713:
5714: end loop ;

Line 5711: FND_GLOBAL.LOGIN_ID,

5707: 'PA_TASKS',
5708: c_atch.new_task_id,
5709: null, null, null, null,
5710: FND_GLOBAL.USER_ID,
5711: FND_GLOBAL.LOGIN_ID,
5712: 275, null, null);
5713:
5714: end loop ;
5715: close c_attach_tasks;