APPS.CSM_SR_EVENT_PKG dependencies on CSI_II_RELATIONSHIPS

Line 423: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;

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

Line 433: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo

429: IS
430: SELECT cir.relationship_id AS relationship_id ,
431: cir.subject_id AS instance_id ,
432: cii.inventory_item_id
433: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo
434: WHERE CIRo.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
435: AND p_transaction_date BETWEEN NVL(CIRo.active_start_date, p_transaction_date) AND NVL(CIRo.active_end_date, p_transaction_date)
436: AND (b_htm5='N' OR LEVEL <=2) --for htm5 functionality
437: START WITH CIRo.OBJECT_ID = p_instance_id

Line 457: FROM CSI_II_RELATIONSHIPS cir,

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

Line 695: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;

691: l_sqlerrmsg VARCHAR2(4000);
692: l_error_msg VARCHAR2(4000);
693: l_return_status VARCHAR2(2000);
694: l_transaction_date DATE;
695: l_null_relationship_id csi_ii_relationships.relationship_id%TYPE;
696: l_organization_id NUMBER;
697:
698: -- get all the child instances of the parent instance as well as the parent
699: CURSOR l_parent_child_instance_csr (p_transaction_date date,b_htm5 VARCHAR2)

Line 704: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo

700: IS
701: SELECT cir.relationship_id AS relationship_id ,
702: cir.subject_id AS instance_id ,
703: cii.inventory_item_id
704: FROM (SELECT * FROM CSI_II_RELATIONSHIPS CIRo
705: WHERE CIRo.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
706: AND (b_htm5='N' OR LEVEL <=2) --for htm5 functionality SR1(A-B , B-C) & SR2(B-C,C-D) are downloaded. if no level for htm5, then SR1 will remove C-D as well
707: START WITH CIRo.OBJECT_ID = p_instance_id
708: CONNECT BY NOCYCLE CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID

Line 729: FROM CSI_II_RELATIONSHIPS cir,

725: UNION
726: SELECT cir.relationship_id as relationship_id,
727: cir.object_id AS instance_id,
728: cii.inventory_item_id
729: FROM CSI_II_RELATIONSHIPS cir,
730: csi_item_instances cii
731: WHERE cir.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
732: AND cir.SUBJECT_ID = p_instance_id
733: AND cii.instance_id = cir.object_id