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.

[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 4323: SELECT COPY_INIT_ACCOMPL_FLAG, COPY_DEFERRALS_FLAG FROM AHL_MR_HEADERS_APP_V

4319: l_junk varchar2(1);
4320: --l_req_id number;
4321:
4322: CURSOR get_mr_copy_dtls_csr(p_mr_header_id IN NUMBER) IS
4323: SELECT COPY_INIT_ACCOMPL_FLAG, COPY_DEFERRALS_FLAG FROM AHL_MR_HEADERS_APP_V
4324: WHERE MR_HEADER_ID = p_mr_header_id;
4325:
4326: l_COPY_FIRST_DUE_FLAG VARCHAR2(1);
4327: l_COPY_DEFERRALS_FLAG VARCHAR2(1);

Line 5180: FROM ahl_mr_headers_app_v

5176: FROM ahl_mr_headers_v
5177: WHERE title = p_title
5178: AND version_number = p_version_number;*/
5179: SELECT mr_header_id, effective_to
5180: FROM ahl_mr_headers_app_v
5181: WHERE title = p_title
5182: AND version_number = p_version_number;
5183:
5184: -- local variables.

Line 5186: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

5182: AND version_number = p_version_number;
5183:
5184: -- local variables.
5185: l_mr_id NUMBER;
5186: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5187: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5188: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5189:
5190: BEGIN

Line 5187: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;

5183:
5184: -- local variables.
5185: l_mr_id NUMBER;
5186: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5187: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5188: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5189:
5190: BEGIN
5191:

Line 5188: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;

5184: -- local variables.
5185: l_mr_id NUMBER;
5186: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5187: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5188: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5189:
5190: BEGIN
5191:
5192: IF (p_x_mr_id IS NULL OR p_x_mr_id = FND_API.G_MISS_NUM) THEN

Line 5293: FROM ahl_mr_headers_app_v

5289:
5290: -- To validate mr id.
5291: CURSOR ahl_mr_headers_csr(p_mr_header_id IN NUMBER) IS
5292: SELECT title, version_number, effective_to, effective_from
5293: FROM ahl_mr_headers_app_v
5294: WHERE mr_header_id = p_mr_header_id;
5295:
5296: -- To validate instance.
5297: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

Line 5319: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;

5315: AND ASSO.unit_config_header_id = nvl (c_unit_config_header_id,ASSO.unit_config_header_id)
5316: AND SIM.STATUS_CODE = 'ACTIVE'
5317: AND SIM.SIMULATION_TYPE = 'UMP';
5318:
5319: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5320: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5321: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5322: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5323: l_csi_item_instance_id NUMBER;

Line 5320: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

5316: AND SIM.STATUS_CODE = 'ACTIVE'
5317: AND SIM.SIMULATION_TYPE = 'UMP';
5318:
5319: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5320: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5321: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5322: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5323: l_csi_item_instance_id NUMBER;
5324: l_active_end_date DATE;

Line 5321: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;

5317: AND SIM.SIMULATION_TYPE = 'UMP';
5318:
5319: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5320: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5321: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5322: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5323: l_csi_item_instance_id NUMBER;
5324: l_active_end_date DATE;
5325: l_active_start_date DATE;

Line 5322: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;

5318:
5319: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5320: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5321: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5322: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5323: l_csi_item_instance_id NUMBER;
5324: l_active_end_date DATE;
5325: l_active_start_date DATE;
5326: l_name ahl_unit_config_headers.name%TYPE;

Line 5453: FROM ahl_mr_headers_app_v

5449: IS
5450: -- To validate mr id.
5451: CURSOR ahl_mr_headers_csr(p_mr_header_id IN NUMBER) IS
5452: SELECT title, version_number, effective_to, effective_from
5453: FROM ahl_mr_headers_app_v
5454: WHERE mr_header_id = p_mr_header_id;
5455:
5456: -- To validate instance.
5457: CURSOR csi_item_instances_csr(p_csi_item_instance_id IN NUMBER) IS

Line 5472: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;

5468: from okc_k_headers_all_b
5469: where contract_number = p_contract_number
5470: and nvl(contract_number_modifier, 'X') = nvl(decode(p_contract_modifier, FND_API.G_MISS_CHAR, null, p_contract_modifier), 'X');
5471:
5472: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5473: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5474: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5475: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5476: l_csi_item_instance_id NUMBER;

Line 5473: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;

5469: where contract_number = p_contract_number
5470: and nvl(contract_number_modifier, 'X') = nvl(decode(p_contract_modifier, FND_API.G_MISS_CHAR, null, p_contract_modifier), 'X');
5471:
5472: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5473: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5474: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5475: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5476: l_csi_item_instance_id NUMBER;
5477: --l_active_end_date DATE;

Line 5474: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;

5470: and nvl(contract_number_modifier, 'X') = nvl(decode(p_contract_modifier, FND_API.G_MISS_CHAR, null, p_contract_modifier), 'X');
5471:
5472: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5473: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5474: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5475: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5476: l_csi_item_instance_id NUMBER;
5477: --l_active_end_date DATE;
5478: l_active_start_date DATE;

Line 5475: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;

5471:
5472: l_effective_from ahl_mr_headers_app_v.EFFECTIVE_FROM%TYPE;
5473: l_effective_to ahl_mr_headers_app_v.EFFECTIVE_TO%TYPE;
5474: l_mr_title ahl_mr_headers_app_v.TITLE%TYPE;
5475: l_version_number ahl_mr_headers_app_v.VERSION_NUMBER%TYPE;
5476: l_csi_item_instance_id NUMBER;
5477: --l_active_end_date DATE;
5478: l_active_start_date DATE;
5479: l_instance_number csi_item_instances.instance_number%TYPE;