APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 551: from ahl_unit_config_headers

547:
548: --To check if the unit config header is valid or not.
549: CURSOR ahl_uc_header_csr(p_uc_header_id number) IS
550: select 'x'
551: from ahl_unit_config_headers
552: where unit_config_header_id = p_uc_header_id
553: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
554:
555: --To check that the operation sequence exists for the work order.

Line 1096: from ahl_unit_config_headers

1092:
1093: --to get header id if header name is provided
1094: CURSOR ahl_header_id_csr (p_uc_name in varchar2) IS
1095: select unit_config_header_id
1096: from ahl_unit_config_headers
1097: where name = p_uc_name;
1098:
1099: --to get instance_id if instance_number is provided
1100: CURSOR ahl_instance_id_csr (p_instance_num in varchar2) IS

Line 1298: l_name ahl_unit_config_headers.name%TYPE;

1294: x_unit_config_name Out NOCOPY Varchar2,
1295: x_return_status Out NOCOPY Varchar2)
1296: IS
1297: --
1298: l_name ahl_unit_config_headers.name%TYPE;
1299: l_location_type_code varchar2(30);
1300: l_location_meaning fnd_lookups.meaning%TYPE;
1301: --
1302: CURSOR ahl_uc_name_csr(p_uc_name in varchar2) IS

Line 1304: from ahl_unit_config_headers

1300: l_location_meaning fnd_lookups.meaning%TYPE;
1301: --
1302: CURSOR ahl_uc_name_csr(p_uc_name in varchar2) IS
1303: select unit_config_header_id, unit_config_status_code,active_uc_status_code
1304: from ahl_unit_config_headers
1305: where name = p_uc_name
1306: and trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
1307:
1308: CURSOR ahl_location_type_csr(p_item_instance_id In number,

Line 1334: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;

1330: AWOS.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
1331: VST.VISIT_ID = VTS.VISIT_ID AND
1332: WORKORDER_ID = p_workorder_id;
1333:
1334: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1335: l_active_uc_status_code ahl_unit_config_headers.active_uc_status_code%TYPE;
1336:
1337: l_item_instance_id NUMBER;
1338: l_uc_header_id NUMBER;

Line 1335: l_active_uc_status_code ahl_unit_config_headers.active_uc_status_code%TYPE;

1331: VST.VISIT_ID = VTS.VISIT_ID AND
1332: WORKORDER_ID = p_workorder_id;
1333:
1334: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1335: l_active_uc_status_code ahl_unit_config_headers.active_uc_status_code%TYPE;
1336:
1337: l_item_instance_id NUMBER;
1338: l_uc_header_id NUMBER;
1339: