APPS.CSM_SR_EVENT_PKG dependencies on CSI_II_RELATIONSHIPS

Line 419: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;

415: l_sqlerrmsg VARCHAR2(4000);
416: l_error_msg VARCHAR2(4000);
417: l_return_status VARCHAR2(2000);
418: l_transaction_date DATE;
419: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;
420: l_organization_id NUMBER;
421:
422: -- get all the child intances of the parent and the parent instance
423: -- also check these instances do not exist for the user

Line 430: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo

426: IS
427: SELECT cir.relationship_id AS relationship_id ,
428: cir.subject_id AS instance_id ,
429: cii.inventory_item_id
430: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo
431: START WITH CIRo.OBJECT_ID = p_instance_id
432: AND CIRo.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
433: AND p_transaction_date BETWEEN NVL(CIRo.active_start_date, p_transaction_date)
434: AND NVL(CIRo.active_end_date, p_transaction_date)

Line 454: FROM CSI_II_RELATIONSHIPS cir,

450: UNION
451: SELECT cir.relationship_id AS relationship_id,
452: cir.object_id AS instance_id,
453: cii.inventory_item_id
454: FROM CSI_II_RELATIONSHIPS cir,
455: csi_item_instances cii
456: WHERE cir.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
457: AND cir.SUBJECT_ID = p_instance_id
458: AND cii.instance_id = cir.object_id

Line 685: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;

681: l_sqlerrmsg VARCHAR2(4000);
682: l_error_msg VARCHAR2(4000);
683: l_return_status VARCHAR2(2000);
684: l_transaction_date DATE;
685: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;
686: l_organization_id NUMBER;
687:
688: -- get all the child instances of the parent instance as well as the parent
689: CURSOR l_parent_child_instance_csr (p_instance_id csi_item_instances.instance_id%type,

Line 695: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo

691: IS
692: SELECT cir.relationship_id AS relationship_id ,
693: cir.subject_id AS instance_id ,
694: cii.inventory_item_id
695: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo
696: START WITH CIRo.OBJECT_ID = p_instance_id
697: AND CIRo.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
698: AND p_transaction_date BETWEEN NVL(CIRo.active_start_date, p_transaction_date)
699: AND NVL(CIRo.active_end_date, p_transaction_date)

Line 719: FROM CSI_II_RELATIONSHIPS cir,

715: UNION
716: SELECT cir.relationship_id as relationship_id,
717: cir.object_id AS instance_id,
718: cii.inventory_item_id
719: FROM CSI_II_RELATIONSHIPS cir,
720: csi_item_instances cii
721: WHERE cir.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
722: AND cir.SUBJECT_ID = p_instance_id
723: AND cii.instance_id = cir.object_id