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_UMP_UNITMAINT_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 4003: SELECT COPY_INIT_ACCOMPL_FLAG, COPY_DEFERRALS_FLAG FROM AHL_MR_HEADERS_APP_V

3999: l_junk varchar2(1);
4000: --l_req_id number;
4001:
4002: CURSOR get_mr_copy_dtls_csr(p_mr_header_id IN NUMBER) IS
4003: SELECT COPY_INIT_ACCOMPL_FLAG, COPY_DEFERRALS_FLAG FROM AHL_MR_HEADERS_APP_V
4004: WHERE MR_HEADER_ID = p_mr_header_id;
4005:
4006: l_COPY_FIRST_DUE_FLAG VARCHAR2(1);
4007: l_COPY_DEFERRALS_FLAG VARCHAR2(1);

Line 4842: FROM ahl_mr_headers_app_v

4838: FROM ahl_mr_headers_v
4839: WHERE title = p_title
4840: AND version_number = p_version_number;*/
4841: SELECT mr_header_id, effective_to
4842: FROM ahl_mr_headers_app_v
4843: WHERE title = p_title
4844: AND version_number = p_version_number;
4845:
4846: -- local variables.

Line 4848: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

4844: AND version_number = p_version_number;
4845:
4846: -- local variables.
4847: l_mr_id NUMBER;
4848: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4849: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4850: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4851:
4852: BEGIN

Line 4849: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;

4845:
4846: -- local variables.
4847: l_mr_id NUMBER;
4848: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4849: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4850: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4851:
4852: BEGIN
4853:

Line 4850: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;

4846: -- local variables.
4847: l_mr_id NUMBER;
4848: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4849: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4850: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4851:
4852: BEGIN
4853:
4854: IF (p_x_mr_id IS NULL OR p_x_mr_id = FND_API.G_MISS_NUM) THEN

Line 4952: FROM ahl_mr_headers_app_v

4948:
4949: -- To validate mr id.
4950: CURSOR ahl_mr_headers_csr(p_mr_header_id IN NUMBER) IS
4951: SELECT title, version_number, effective_to, effective_from
4952: FROM ahl_mr_headers_app_v
4953: WHERE mr_header_id = p_mr_header_id;
4954:
4955: -- To validate instance.
4956: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

Line 4967: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;

4963: SELECT name, active_start_date, active_end_date, csi_item_instance_id
4964: FROM ahl_unit_config_headers
4965: WHERE unit_config_header_id = p_uc_header_id;
4966:
4967: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
4968: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4969: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4970: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4971: l_csi_item_instance_id NUMBER;

Line 4968: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

4964: FROM ahl_unit_config_headers
4965: WHERE unit_config_header_id = p_uc_header_id;
4966:
4967: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
4968: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4969: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4970: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4971: l_csi_item_instance_id NUMBER;
4972: l_active_end_date DATE;

Line 4969: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;

4965: WHERE unit_config_header_id = p_uc_header_id;
4966:
4967: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
4968: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4969: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4970: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4971: l_csi_item_instance_id NUMBER;
4972: l_active_end_date DATE;
4973: l_active_start_date DATE;

Line 4970: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;

4966:
4967: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
4968: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
4969: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
4970: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
4971: l_csi_item_instance_id NUMBER;
4972: l_active_end_date DATE;
4973: l_active_start_date DATE;
4974: l_name ahl_unit_config_headers.name%TYPE;

Line 5085: FROM ahl_mr_headers_app_v

5081: IS
5082: -- To validate mr id.
5083: CURSOR ahl_mr_headers_csr(p_mr_header_id IN NUMBER) IS
5084: SELECT title, version_number, effective_to, effective_from
5085: FROM ahl_mr_headers_app_v
5086: WHERE mr_header_id = p_mr_header_id;
5087:
5088: -- To validate instance.
5089: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

Line 5104: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;

5100: from okc_k_headers_all_b
5101: where contract_number = p_contract_number
5102: and nvl(contract_number_modifier, 'X') = nvl(decode(p_contract_modifier, FND_API.G_MISS_CHAR, null, p_contract_modifier), 'X');
5103:
5104: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5105: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5106: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5107: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5108: l_csi_item_instance_id NUMBER;

Line 5105: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

5101: where contract_number = p_contract_number
5102: and nvl(contract_number_modifier, 'X') = nvl(decode(p_contract_modifier, FND_API.G_MISS_CHAR, null, p_contract_modifier), 'X');
5103:
5104: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5105: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5106: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5107: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5108: l_csi_item_instance_id NUMBER;
5109: l_active_end_date DATE;

Line 5106: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;

5102: and nvl(contract_number_modifier, 'X') = nvl(decode(p_contract_modifier, FND_API.G_MISS_CHAR, null, p_contract_modifier), 'X');
5103:
5104: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5105: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5106: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5107: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5108: l_csi_item_instance_id NUMBER;
5109: l_active_end_date DATE;
5110: l_active_start_date DATE;

Line 5107: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;

5103:
5104: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5105: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5106: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5107: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5108: l_csi_item_instance_id NUMBER;
5109: l_active_end_date DATE;
5110: l_active_start_date DATE;
5111: l_instance_number csi_item_instances.instance_number%TYPE;