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

Line 906: WHERE USER_ID = Fnd_Global.USER_ID AND RESPONSIBILITY_ID = x_resp_id;

902: /*
903: CURSOR c_fnd_user_resp(x_resp_id IN NUMBER) IS
904: SELECT RESPONSIBILITY_ID
905: FROM FND_USER_RESP_GROUPS
906: WHERE USER_ID = Fnd_Global.USER_ID AND RESPONSIBILITY_ID = x_resp_id;
907: */
908: BEGIN
909:
910: IF (l_log_procedure >= l_log_current_level) THEN

Line 965: p_user_id => Fnd_Global.USER_ID,

961: -- Project Billing Super user
962: PA_INTERFACE_UTILS_PUB.Set_Global_Info
963: ( p_api_version_number => 1.0,
964: p_responsibility_id => l_responsibility_id,
965: p_user_id => Fnd_Global.USER_ID,
966: p_msg_count => l_msg_count,
967: p_msg_data => l_msg_data,
968: */
969:

Line 1003: p_responsibility_id => Fnd_Global.RESP_ID,

999: -- So, reintroduced the call to PA_INTERFACE_UTILS_PUB.Set_Global_Info.
1000: -- However, passing the current responsibilty id instead of the hardcoded
1001: -- Project Billing Superuser Responsibility as was done before the ADS Bug 4357001 Fix.
1002: PA_INTERFACE_UTILS_PUB.Set_Global_Info( p_api_version_number => 1.0,
1003: p_responsibility_id => Fnd_Global.RESP_ID,
1004: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
1005: p_user_id => Fnd_Global.USER_ID,
1006: p_operating_unit_id => mo_global.get_current_org_id, -- Yazhou added for MOAC changes on 05Oct2005
1007: p_msg_count => l_msg_count,

Line 1004: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,

1000: -- However, passing the current responsibilty id instead of the hardcoded
1001: -- Project Billing Superuser Responsibility as was done before the ADS Bug 4357001 Fix.
1002: PA_INTERFACE_UTILS_PUB.Set_Global_Info( p_api_version_number => 1.0,
1003: p_responsibility_id => Fnd_Global.RESP_ID,
1004: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
1005: p_user_id => Fnd_Global.USER_ID,
1006: p_operating_unit_id => mo_global.get_current_org_id, -- Yazhou added for MOAC changes on 05Oct2005
1007: p_msg_count => l_msg_count,
1008: p_msg_data => l_msg_data,

Line 1005: p_user_id => Fnd_Global.USER_ID,

1001: -- Project Billing Superuser Responsibility as was done before the ADS Bug 4357001 Fix.
1002: PA_INTERFACE_UTILS_PUB.Set_Global_Info( p_api_version_number => 1.0,
1003: p_responsibility_id => Fnd_Global.RESP_ID,
1004: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
1005: p_user_id => Fnd_Global.USER_ID,
1006: p_operating_unit_id => mo_global.get_current_org_id, -- Yazhou added for MOAC changes on 05Oct2005
1007: p_msg_count => l_msg_count,
1008: p_msg_data => l_msg_data,
1009: p_return_status => x_return_status);

Line 1456: X_CREATED_BY => Fnd_Global.USER_ID,

1452: X_DESCRIPTION => l_description, --Bug 5758813
1453: -- Added by rnahata for Issue 105
1454: X_QUANTITY => p_quantity,
1455: X_CREATION_DATE => SYSDATE,
1456: X_CREATED_BY => Fnd_Global.USER_ID,
1457: X_LAST_UPDATE_DATE => SYSDATE,
1458: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1459: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1460:

Line 1458: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,

1454: X_QUANTITY => p_quantity,
1455: X_CREATION_DATE => SYSDATE,
1456: X_CREATED_BY => Fnd_Global.USER_ID,
1457: X_LAST_UPDATE_DATE => SYSDATE,
1458: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1459: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1460:
1461: -- SKPATHAK :: Bug 13574991 :: 16-FEB-2012 :: FPed all fixes on R121 codeline
1462: CLOSE c_row_lock;

Line 1459: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);

1455: X_CREATION_DATE => SYSDATE,
1456: X_CREATED_BY => Fnd_Global.USER_ID,
1457: X_LAST_UPDATE_DATE => SYSDATE,
1458: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
1459: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
1460:
1461: -- SKPATHAK :: Bug 13574991 :: 16-FEB-2012 :: FPed all fixes on R121 codeline
1462: CLOSE c_row_lock;
1463:

Line 2093: l_TASK_LINK_ID, 1,sysdate, fnd_global.user_id, sysdate,

2089: ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,PRECEDENCE_CONSTRAINT
2090: )
2091: VALUES
2092: (
2093: l_TASK_LINK_ID, 1,sysdate, fnd_global.user_id, sysdate,
2094: fnd_global.user_id, fnd_global.user_id, l_child_task_id, l_parent_task_id,
2095: l_task_rec.ATTRIBUTE_CATEGORY, l_task_rec.ATTRIBUTE1, l_task_rec.ATTRIBUTE2,
2096: l_task_rec.ATTRIBUTE3, l_task_rec.ATTRIBUTE4, l_task_rec.ATTRIBUTE5,
2097: l_task_rec.ATTRIBUTE6, l_task_rec.ATTRIBUTE7, l_task_rec.ATTRIBUTE8,

Line 2094: fnd_global.user_id, fnd_global.user_id, l_child_task_id, l_parent_task_id,

2090: )
2091: VALUES
2092: (
2093: l_TASK_LINK_ID, 1,sysdate, fnd_global.user_id, sysdate,
2094: fnd_global.user_id, fnd_global.user_id, l_child_task_id, l_parent_task_id,
2095: l_task_rec.ATTRIBUTE_CATEGORY, l_task_rec.ATTRIBUTE1, l_task_rec.ATTRIBUTE2,
2096: l_task_rec.ATTRIBUTE3, l_task_rec.ATTRIBUTE4, l_task_rec.ATTRIBUTE5,
2097: l_task_rec.ATTRIBUTE6, l_task_rec.ATTRIBUTE7, l_task_rec.ATTRIBUTE8,
2098: l_task_rec.ATTRIBUTE9, l_task_rec.ATTRIBUTE10,l_task_rec.ATTRIBUTE11,

Line 2834: LAST_UPDATED_BY = Fnd_Global.USER_ID,

2830: UPDATE AHL_VISITS_B
2831: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2832: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
2833: LAST_UPDATE_DATE = SYSDATE,
2834: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2835: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID,
2836: ANY_TASK_CHG_FLAG = p_flag
2837: WHERE VISIT_ID = p_visit_id;
2838: END IF;

Line 2835: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID,

2831: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2832: --TCHIMIRA::BUG 9222622 ::15-DEC-2009::UPDATE WHO COLUMNS
2833: LAST_UPDATE_DATE = SYSDATE,
2834: LAST_UPDATED_BY = Fnd_Global.USER_ID,
2835: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID,
2836: ANY_TASK_CHG_FLAG = p_flag
2837: WHERE VISIT_ID = p_visit_id;
2838: END IF;
2839: IF (l_log_procedure >= l_log_current_level) THEN

Line 4950: last_updated_by = FND_GLOBAL.user_id,

4946: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4947: UPDATE AHL_VISIT_TASKS_B
4948: SET object_version_number = object_version_number + 1,
4949: last_update_date = sysdate,
4950: last_updated_by = FND_GLOBAL.user_id,
4951: last_update_login = FND_GLOBAL.login_id,
4952: return_to_supply_flag = 'Y'
4953: WHERE visit_task_id = p_task_tbl_type(i).visit_task_id
4954: AND object_version_number = p_task_tbl_type(i).object_version_number;

Line 4951: last_update_login = FND_GLOBAL.login_id,

4947: UPDATE AHL_VISIT_TASKS_B
4948: SET object_version_number = object_version_number + 1,
4949: last_update_date = sysdate,
4950: last_updated_by = FND_GLOBAL.user_id,
4951: last_update_login = FND_GLOBAL.login_id,
4952: return_to_supply_flag = 'Y'
4953: WHERE visit_task_id = p_task_tbl_type(i).visit_task_id
4954: AND object_version_number = p_task_tbl_type(i).object_version_number;
4955:

Line 5174: last_updated_by = FND_GLOBAL.user_id,

5170: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5171: UPDATE AHL_VISIT_TASKS_B
5172: SET object_version_number = object_version_number + 1,
5173: last_update_date = sysdate,
5174: last_updated_by = FND_GLOBAL.user_id,
5175: last_update_login = FND_GLOBAL.login_id,
5176: return_to_supply_flag = 'N'
5177: WHERE visit_task_id = p_task_tbl_type(i).visit_task_id
5178: AND object_version_number = p_task_tbl_type(i).object_version_number;

Line 5175: last_update_login = FND_GLOBAL.login_id,

5171: UPDATE AHL_VISIT_TASKS_B
5172: SET object_version_number = object_version_number + 1,
5173: last_update_date = sysdate,
5174: last_updated_by = FND_GLOBAL.user_id,
5175: last_update_login = FND_GLOBAL.login_id,
5176: return_to_supply_flag = 'N'
5177: WHERE visit_task_id = p_task_tbl_type(i).visit_task_id
5178: AND object_version_number = p_task_tbl_type(i).object_version_number;
5179:

Line 5622: LAST_UPDATED_BY = Fnd_Global.USER_ID ,

5618: ELSE
5619: UPDATE AHL_VISIT_TASKS_B
5620: SET TASK_TYPE_CODE = 'DUPLICATE' ,
5621: LAST_UPDATE_DATE = SYSDATE ,
5622: LAST_UPDATED_BY = Fnd_Global.USER_ID ,
5623: OBJECT_VERSION_NUMBER = p_task_rec_tbl(i).object_version_number + 1,
5624: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5625: WHERE VISIT_TASK_ID = p_task_rec_tbl(i).Visit_Task_Id;
5626: END IF;

Line 5624: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

5620: SET TASK_TYPE_CODE = 'DUPLICATE' ,
5621: LAST_UPDATE_DATE = SYSDATE ,
5622: LAST_UPDATED_BY = Fnd_Global.USER_ID ,
5623: OBJECT_VERSION_NUMBER = p_task_rec_tbl(i).object_version_number + 1,
5624: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5625: WHERE VISIT_TASK_ID = p_task_rec_tbl(i).Visit_Task_Id;
5626: END IF;
5627: END LOOP;
5628: ---------------------------End of Body-------------------------------------

Line 5790: LAST_UPDATED_BY = Fnd_Global.USER_ID ,

5786: ELSE
5787: UPDATE AHL_VISIT_TASKS_B
5788: SET TASK_TYPE_CODE = l_task_type_code ,
5789: LAST_UPDATE_DATE = SYSDATE ,
5790: LAST_UPDATED_BY = Fnd_Global.USER_ID ,
5791: OBJECT_VERSION_NUMBER = p_task_rec_tbl(i).object_version_number + 1,
5792: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5793: WHERE VISIT_TASK_ID = p_task_rec_tbl(i).Visit_Task_Id;
5794: -- END;

Line 5792: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

5788: SET TASK_TYPE_CODE = l_task_type_code ,
5789: LAST_UPDATE_DATE = SYSDATE ,
5790: LAST_UPDATED_BY = Fnd_Global.USER_ID ,
5791: OBJECT_VERSION_NUMBER = p_task_rec_tbl(i).object_version_number + 1,
5792: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5793: WHERE VISIT_TASK_ID = p_task_rec_tbl(i).Visit_Task_Id;
5794: -- END;
5795: END IF;
5796: END LOOP;

Line 5987: LAST_UPDATED_BY = Fnd_Global.USER_ID,

5983: UPDATE ahl_visits_b
5984: SET status_code = 'RELEASED',
5985: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
5986: LAST_UPDATE_DATE = SYSDATE,
5987: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5988: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5989: WHERE visit_id = l_visit_id;
5990: END IF;
5991: END IF;

Line 5988: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID

5984: SET status_code = 'RELEASED',
5985: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
5986: LAST_UPDATE_DATE = SYSDATE,
5987: LAST_UPDATED_BY = Fnd_Global.USER_ID,
5988: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
5989: WHERE visit_id = l_visit_id;
5990: END IF;
5991: END IF;
5992: