APPS.AHL_UC_UNITCONFIG_PVT dependencies on CSI_ITEM_INSTANCES

Line 392: p_instance_num IN csi_item_instances.instance_number%TYPE,

388: END validate_mc_header;
389:
390: -- Procedure to validate csi_item_instance
391: PROCEDURE validate_csi_instance(
392: p_instance_num IN csi_item_instances.instance_number%TYPE,
393: p_x_instance_id IN OUT NOCOPY NUMBER,
394: p_relationship_id IN NUMBER,
395: x_return_status OUT NOCOPY VARCHAR2)
396: IS

Line 400: CURSOR get_rec_from_value(c_instance_num csi_item_instances.instance_number%TYPE,

396: IS
397: l_instance_id number;
398: --The following cursors don't consider the profile option fnd_profile.value('AHL_VALIDATE_ALT_ITEM_ORG')
399: --That is assuming fnd_profile.value('AHL_VALIDATE_ALT_ITEM_ORG')='Y'
400: CURSOR get_rec_from_value(c_instance_num csi_item_instances.instance_number%TYPE,
401: c_relationship_id NUMBER) IS
402: --Added DISTINCT to the following two queries for fixing bug 4102152, Jerry on 01/04/2005
403: SELECT distinct C.instance_id
404: FROM csi_item_instances C,

Line 404: FROM csi_item_instances C,

400: CURSOR get_rec_from_value(c_instance_num csi_item_instances.instance_number%TYPE,
401: c_relationship_id NUMBER) IS
402: --Added DISTINCT to the following two queries for fixing bug 4102152, Jerry on 01/04/2005
403: SELECT distinct C.instance_id
404: FROM csi_item_instances C,
405: ahl_mc_relationships R,
406: ahl_item_associations_b A
407: WHERE C.instance_number = c_instance_num
408: AND R.relationship_id = c_relationship_id

Line 436: FROM csi_item_instances C,

432: WHERE H.csi_item_instance_id = C.instance_id
433: AND trunc(nvl(H.active_end_date, SYSDATE+1)) > trunc(SYSDATE));
434: CURSOR get_rec_from_id(c_instance_id NUMBER, c_relationship_id NUMBER) IS
435: SELECT distinct C.instance_id
436: FROM csi_item_instances C,
437: ahl_mc_relationships R,
438: ahl_item_associations_b A
439: WHERE C.instance_id = c_instance_id
440: AND R.relationship_id = c_relationship_id

Line 613: l_serial_number csi_item_instances.serial_number%TYPE;

609: l_return_status VARCHAR2(1);
610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(2000);
612: l_relationship_id NUMBER;
613: l_serial_number csi_item_instances.serial_number%TYPE;
614: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
615: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
616: l_object_version_number NUMBER;
617: l_return_val BOOLEAN;

Line 614: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;

610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(2000);
612: l_relationship_id NUMBER;
613: l_serial_number csi_item_instances.serial_number%TYPE;
614: l_mfg_serial_number_flag csi_item_instances.mfg_serial_number_flag%TYPE;
615: l_serial_number_tag csi_iea_values.attribute_value%TYPE;
616: l_object_version_number NUMBER;
617: l_return_val BOOLEAN;
618: l_transaction_type_id NUMBER;

Line 629: FROM csi_item_instances

625: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
626:
627: CURSOR get_serial_number(c_instance_id NUMBER) IS
628: SELECT serial_number, mfg_serial_number_flag
629: FROM csi_item_instances
630: WHERE instance_id = c_instance_id
631: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
632: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
633: BEGIN

Line 1196: FROM csi_item_instances

1192: l_object_version_number NUMBER;
1193:
1194: CURSOR get_csi_obj_ver_num(c_instance_id NUMBER) IS
1195: SELECT object_version_number
1196: FROM csi_item_instances
1197: WHERE instance_id = c_instance_id
1198: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
1199: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1200: CURSOR get_all_subunits(c_uc_header_id NUMBER) IS