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.AHL_PP_MATERIALS_PVT dependencies on FND_GLOBAL

Line 2503: X_CREATED_BY => fnd_global.user_id,

2499: X_ATTRIBUTE13 => l_Req_Material_Tbl(i).attribute13,
2500: X_ATTRIBUTE14 => l_Req_Material_Tbl(i).attribute14,
2501: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
2502: X_CREATION_DATE => SYSDATE,
2503: X_CREATED_BY => fnd_global.user_id,
2504: X_LAST_UPDATE_DATE => SYSDATE,
2505: X_LAST_UPDATED_BY => fnd_global.user_id,
2506: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2507: --sukhwsin: Code changes for SB effectivity - starts

Line 2505: X_LAST_UPDATED_BY => fnd_global.user_id,

2501: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
2502: X_CREATION_DATE => SYSDATE,
2503: X_CREATED_BY => fnd_global.user_id,
2504: X_LAST_UPDATE_DATE => SYSDATE,
2505: X_LAST_UPDATED_BY => fnd_global.user_id,
2506: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2507: --sukhwsin: Code changes for SB effectivity - starts
2508: X_MC_HEADER_ID => l_Req_Material_Tbl(i).mc_header_id,
2509: X_POSITION_KEY => l_Req_Material_Tbl(i).mc_position_key,

Line 2506: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2502: X_CREATION_DATE => SYSDATE,
2503: X_CREATED_BY => fnd_global.user_id,
2504: X_LAST_UPDATE_DATE => SYSDATE,
2505: X_LAST_UPDATED_BY => fnd_global.user_id,
2506: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2507: --sukhwsin: Code changes for SB effectivity - starts
2508: X_MC_HEADER_ID => l_Req_Material_Tbl(i).mc_header_id,
2509: X_POSITION_KEY => l_Req_Material_Tbl(i).mc_position_key,
2510: X_RELATIONSHIP_ID => l_relationship_tbl(i),

Line 2576: X_CREATED_BY => fnd_global.user_id,

2572: X_ATTRIBUTE13 => l_Req_Material_Tbl(i).attribute13,
2573: X_ATTRIBUTE14 => l_Req_Material_Tbl(i).attribute14,
2574: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
2575: X_CREATION_DATE => SYSDATE,
2576: X_CREATED_BY => fnd_global.user_id,
2577: X_LAST_UPDATE_DATE => SYSDATE,
2578: X_LAST_UPDATED_BY => fnd_global.user_id,
2579: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2580: --sukhwsin: SB Effectivity Code changes - starts

Line 2578: X_LAST_UPDATED_BY => fnd_global.user_id,

2574: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
2575: X_CREATION_DATE => SYSDATE,
2576: X_CREATED_BY => fnd_global.user_id,
2577: X_LAST_UPDATE_DATE => SYSDATE,
2578: X_LAST_UPDATED_BY => fnd_global.user_id,
2579: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2580: --sukhwsin: SB Effectivity Code changes - starts
2581: X_MC_HEADER_ID => l_Req_Material_Tbl(i).mc_header_id,
2582: X_POSITION_KEY => l_Req_Material_Tbl(i).mc_position_key,

Line 2579: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2575: X_CREATION_DATE => SYSDATE,
2576: X_CREATED_BY => fnd_global.user_id,
2577: X_LAST_UPDATE_DATE => SYSDATE,
2578: X_LAST_UPDATED_BY => fnd_global.user_id,
2579: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2580: --sukhwsin: SB Effectivity Code changes - starts
2581: X_MC_HEADER_ID => l_Req_Material_Tbl(i).mc_header_id,
2582: X_POSITION_KEY => l_Req_Material_Tbl(i).mc_position_key,
2583: X_RELATIONSHIP_ID => l_relationship_tbl(i),

Line 2619: p_last_updated_by => fnd_global.user_id,

2615: Log_Transaction_Record
2616: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
2617: p_object_version_number => 1,
2618: p_last_update_date => sysdate,
2619: p_last_updated_by => fnd_global.user_id,
2620: p_creation_date => sysdate,
2621: p_created_by => fnd_global.user_id,
2622: p_last_update_login => fnd_global.login_id,
2623: p_load_type_code => 2,

Line 2621: p_created_by => fnd_global.user_id,

2617: p_object_version_number => 1,
2618: p_last_update_date => sysdate,
2619: p_last_updated_by => fnd_global.user_id,
2620: p_creation_date => sysdate,
2621: p_created_by => fnd_global.user_id,
2622: p_last_update_login => fnd_global.login_id,
2623: p_load_type_code => 2,
2624: p_transaction_type_code => 1,
2625: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,

Line 2622: p_last_update_login => fnd_global.login_id,

2618: p_last_update_date => sysdate,
2619: p_last_updated_by => fnd_global.user_id,
2620: p_creation_date => sysdate,
2621: p_created_by => fnd_global.user_id,
2622: p_last_update_login => fnd_global.login_id,
2623: p_load_type_code => 2,
2624: p_transaction_type_code => 1,
2625: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,
2626: p_schedule_material_id => p_x_req_material_tbl(i).schedule_material_id,

Line 2683: X_CREATED_BY => fnd_global.user_id,

2679: X_ATTRIBUTE13 => l_Req_Material_Tbl(i).attribute13,
2680: X_ATTRIBUTE14 => l_Req_Material_Tbl(i).attribute14,
2681: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
2682: X_CREATION_DATE => SYSDATE,
2683: X_CREATED_BY => fnd_global.user_id,
2684: X_LAST_UPDATE_DATE => SYSDATE,
2685: X_LAST_UPDATED_BY => fnd_global.user_id,
2686: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2687: --sukhwsin: SB Effectivity Code changes - starts

Line 2685: X_LAST_UPDATED_BY => fnd_global.user_id,

2681: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
2682: X_CREATION_DATE => SYSDATE,
2683: X_CREATED_BY => fnd_global.user_id,
2684: X_LAST_UPDATE_DATE => SYSDATE,
2685: X_LAST_UPDATED_BY => fnd_global.user_id,
2686: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2687: --sukhwsin: SB Effectivity Code changes - starts
2688: X_MC_HEADER_ID => l_Req_Material_Tbl(i).mc_header_id,
2689: X_POSITION_KEY => l_Req_Material_Tbl(i).mc_position_key,

Line 2686: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

2682: X_CREATION_DATE => SYSDATE,
2683: X_CREATED_BY => fnd_global.user_id,
2684: X_LAST_UPDATE_DATE => SYSDATE,
2685: X_LAST_UPDATED_BY => fnd_global.user_id,
2686: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
2687: --sukhwsin: SB Effectivity Code changes - starts
2688: X_MC_HEADER_ID => l_Req_Material_Tbl(i).mc_header_id,
2689: X_POSITION_KEY => l_Req_Material_Tbl(i).mc_position_key,
2690: X_RELATIONSHIP_ID => l_relationship_tbl(i),

Line 3299: p_last_updated_by => fnd_global.user_id,

3295: Log_Transaction_Record
3296: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
3297: p_object_version_number => 1,
3298: p_last_update_date => sysdate,
3299: p_last_updated_by => fnd_global.user_id,
3300: p_creation_date => sysdate,
3301: p_created_by => fnd_global.user_id,
3302: p_last_update_login => fnd_global.login_id,
3303: p_load_type_code => 2,

Line 3301: p_created_by => fnd_global.user_id,

3297: p_object_version_number => 1,
3298: p_last_update_date => sysdate,
3299: p_last_updated_by => fnd_global.user_id,
3300: p_creation_date => sysdate,
3301: p_created_by => fnd_global.user_id,
3302: p_last_update_login => fnd_global.login_id,
3303: p_load_type_code => 2,
3304: p_transaction_type_code => 1,
3305: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,

Line 3302: p_last_update_login => fnd_global.login_id,

3298: p_last_update_date => sysdate,
3299: p_last_updated_by => fnd_global.user_id,
3300: p_creation_date => sysdate,
3301: p_created_by => fnd_global.user_id,
3302: p_last_update_login => fnd_global.login_id,
3303: p_load_type_code => 2,
3304: p_transaction_type_code => 1,
3305: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,
3306: p_schedule_material_id => p_x_req_material_tbl(i).schedule_material_id,

Line 3646: last_updated_by = fnd_global.user_id,

3642: attribute13 = l_req_material_rec.attribute13,
3643: attribute14 = l_req_material_rec.attribute14,
3644: attribute15 = l_req_material_rec.attribute15,
3645: last_update_date = sysdate,
3646: last_updated_by = fnd_global.user_id,
3647: last_update_login = fnd_global.login_id,
3648: --sukhwsin: SB Effectivity code changes - starts
3649: mc_header_id = l_req_material_rec.mc_header_id,
3650: position_key = l_req_material_rec.position_key,

Line 3647: last_update_login = fnd_global.login_id,

3643: attribute14 = l_req_material_rec.attribute14,
3644: attribute15 = l_req_material_rec.attribute15,
3645: last_update_date = sysdate,
3646: last_updated_by = fnd_global.user_id,
3647: last_update_login = fnd_global.login_id,
3648: --sukhwsin: SB Effectivity code changes - starts
3649: mc_header_id = l_req_material_rec.mc_header_id,
3650: position_key = l_req_material_rec.position_key,
3651: --sukhwsin: SB Effectivity code changes - ends

Line 4521: p_last_updated_by => fnd_global.user_id,

4517: Log_Transaction_Record
4518: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
4519: p_object_version_number => 1,
4520: p_last_update_date => sysdate,
4521: p_last_updated_by => fnd_global.user_id,
4522: p_creation_date => sysdate,
4523: p_created_by => fnd_global.user_id,
4524: p_last_update_login => fnd_global.login_id,
4525: p_load_type_code => 2,

Line 4523: p_created_by => fnd_global.user_id,

4519: p_object_version_number => 1,
4520: p_last_update_date => sysdate,
4521: p_last_updated_by => fnd_global.user_id,
4522: p_creation_date => sysdate,
4523: p_created_by => fnd_global.user_id,
4524: p_last_update_login => fnd_global.login_id,
4525: p_load_type_code => 2,
4526: p_transaction_type_code => 1,
4527: p_workorder_operation_id => l_material_req_rec.workorder_operation_id,

Line 4524: p_last_update_login => fnd_global.login_id,

4520: p_last_update_date => sysdate,
4521: p_last_updated_by => fnd_global.user_id,
4522: p_creation_date => sysdate,
4523: p_created_by => fnd_global.user_id,
4524: p_last_update_login => fnd_global.login_id,
4525: p_load_type_code => 2,
4526: p_transaction_type_code => 1,
4527: p_workorder_operation_id => l_material_req_rec.workorder_operation_id,
4528: p_schedule_material_id => l_schedule_material_id,

Line 4610: p_last_updated_by => fnd_global.user_id,

4606: Log_Transaction_Record
4607: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
4608: p_object_version_number => 1,
4609: p_last_update_date => sysdate,
4610: p_last_updated_by => fnd_global.user_id,
4611: p_creation_date => sysdate,
4612: p_created_by => fnd_global.user_id,
4613: p_last_update_login => fnd_global.login_id,
4614: p_load_type_code => 2,

Line 4612: p_created_by => fnd_global.user_id,

4608: p_object_version_number => 1,
4609: p_last_update_date => sysdate,
4610: p_last_updated_by => fnd_global.user_id,
4611: p_creation_date => sysdate,
4612: p_created_by => fnd_global.user_id,
4613: p_last_update_login => fnd_global.login_id,
4614: p_load_type_code => 2,
4615: p_transaction_type_code => 1,
4616: p_workorder_operation_id => l_material_req_rec.workorder_operation_id,

Line 4613: p_last_update_login => fnd_global.login_id,

4609: p_last_update_date => sysdate,
4610: p_last_updated_by => fnd_global.user_id,
4611: p_creation_date => sysdate,
4612: p_created_by => fnd_global.user_id,
4613: p_last_update_login => fnd_global.login_id,
4614: p_load_type_code => 2,
4615: p_transaction_type_code => 1,
4616: p_workorder_operation_id => l_material_req_rec.workorder_operation_id,
4617: p_schedule_material_id => l_schedule_material_id,

Line 4739: last_updated_by = Fnd_Global.USER_ID,

4735: UPDATE ahl_schedule_materials
4736: SET inventory_item_id = p_x_req_material_tbl(i).inventory_item_id,
4737: object_version_number = p_x_req_material_tbl(i).object_version_number + 1,
4738: last_update_date = sysdate,
4739: last_updated_by = Fnd_Global.USER_ID,
4740: last_update_login = Fnd_Global.LOGIN_ID
4741: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id ;
4742: END LOOP; -- End of p_x_req_material_tbl loop
4743: END IF; -- End of l_return_status check

Line 4740: last_update_login = Fnd_Global.LOGIN_ID

4736: SET inventory_item_id = p_x_req_material_tbl(i).inventory_item_id,
4737: object_version_number = p_x_req_material_tbl(i).object_version_number + 1,
4738: last_update_date = sysdate,
4739: last_updated_by = Fnd_Global.USER_ID,
4740: last_update_login = Fnd_Global.LOGIN_ID
4741: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id ;
4742: END LOOP; -- End of p_x_req_material_tbl loop
4743: END IF; -- End of l_return_status check
4744: END IF; -- End of p_x_req_material_tbl check for records

Line 5812: last_updated_by = fnd_global.user_id,

5808: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),
5809: organization_id = l_Visit_Task_Rec.organization_id,
5810: object_version_number = object_version_number + 1,
5811: last_update_date = sysdate,
5812: last_updated_by = fnd_global.user_id,
5813: last_update_login = fnd_global.login_id,
5814: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
5815: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
5816: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,

Line 5813: last_update_login = fnd_global.login_id,

5809: organization_id = l_Visit_Task_Rec.organization_id,
5810: object_version_number = object_version_number + 1,
5811: last_update_date = sysdate,
5812: last_updated_by = fnd_global.user_id,
5813: last_update_login = fnd_global.login_id,
5814: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
5815: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
5816: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,
5817: ATTRIBUTE3 = l_req_material_tbl(l_idx).attribute3,

Line 5894: last_updated_by = fnd_global.user_id,

5890: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
5891: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),
5892: organization_id = l_Visit_Task_Rec.organization_id,
5893: last_update_date = sysdate,
5894: last_updated_by = fnd_global.user_id,
5895: last_update_login = fnd_global.login_id,
5896: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
5897: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
5898: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,

Line 5895: last_update_login = fnd_global.login_id,

5891: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),
5892: organization_id = l_Visit_Task_Rec.organization_id,
5893: last_update_date = sysdate,
5894: last_updated_by = fnd_global.user_id,
5895: last_update_login = fnd_global.login_id,
5896: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
5897: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
5898: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,
5899: ATTRIBUTE3 = l_req_material_tbl(l_idx).attribute3,

Line 5979: last_updated_by = fnd_global.user_id,

5975: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
5976: SET requested_date = trunc(l_prd_wooperation_tbl(i).actual_start_date),
5977: object_version_number = object_version_number + 1,
5978: last_update_date = sysdate,
5979: last_updated_by = fnd_global.user_id,
5980: last_update_login = fnd_global.login_id
5981: WHERE scheduled_material_id = l_scheduled_material_id;
5982: END IF;
5983: END LOOP;

Line 5980: last_update_login = fnd_global.login_id

5976: SET requested_date = trunc(l_prd_wooperation_tbl(i).actual_start_date),
5977: object_version_number = object_version_number + 1,
5978: last_update_date = sysdate,
5979: last_updated_by = fnd_global.user_id,
5980: last_update_login = fnd_global.login_id
5981: WHERE scheduled_material_id = l_scheduled_material_id;
5982: END IF;
5983: END LOOP;
5984: CLOSE Material_Detail_Cur;