APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 584: from ahl_unit_config_headers

580:
581: --To check if the unit config header is valid or not.
582: CURSOR ahl_uc_header_csr(p_uc_header_id number) IS
583: select 'x'
584: from ahl_unit_config_headers
585: where unit_config_header_id = p_uc_header_id
586: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
587:
588: --To check that the operation sequence exists for the work order.

Line 1129: from ahl_unit_config_headers

1125:
1126: --to get header id if header name is provided
1127: CURSOR ahl_header_id_csr (p_uc_name in varchar2) IS
1128: select unit_config_header_id
1129: from ahl_unit_config_headers
1130: where name = p_uc_name;
1131:
1132: --to get instance_id if instance_number is provided
1133: CURSOR ahl_instance_id_csr (p_instance_num in varchar2) IS

Line 1331: l_name ahl_unit_config_headers.name%TYPE;

1327: x_unit_config_name Out NOCOPY Varchar2,
1328: x_return_status Out NOCOPY Varchar2)
1329: IS
1330: --
1331: l_name ahl_unit_config_headers.name%TYPE;
1332: l_location_type_code varchar2(30);
1333: l_location_meaning fnd_lookups.meaning%TYPE;
1334: --
1335: CURSOR ahl_uc_name_csr(p_uc_name in varchar2) IS

Line 1337: from ahl_unit_config_headers

1333: l_location_meaning fnd_lookups.meaning%TYPE;
1334: --
1335: CURSOR ahl_uc_name_csr(p_uc_name in varchar2) IS
1336: select unit_config_header_id, unit_config_status_code,active_uc_status_code
1337: from ahl_unit_config_headers
1338: where name = p_uc_name
1339: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
1340:
1341: CURSOR ahl_location_type_csr(p_item_instance_id In number,

Line 1367: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;

1363: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1364: VST.VISIT_ID = VTS.VISIT_ID AND
1365: WORKORDER_ID = p_workorder_id;
1366:
1367: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1368: l_active_uc_status_code ahl_unit_config_headers.active_uc_status_code%TYPE;
1369:
1370: l_item_instance_id NUMBER;
1371: l_uc_header_id NUMBER;

Line 1368: l_active_uc_status_code ahl_unit_config_headers.active_uc_status_code%TYPE;

1364: VST.VISIT_ID = VTS.VISIT_ID AND
1365: WORKORDER_ID = p_workorder_id;
1366:
1367: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1368: l_active_uc_status_code ahl_unit_config_headers.active_uc_status_code%TYPE;
1369:
1370: l_item_instance_id NUMBER;
1371: l_uc_header_id NUMBER;
1372: