eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DOM_ASSOCIATIONS_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7


Procedure Insert_Row(
        p_association_id        IN NUMBER,
        p_from_entity_name      IN VARCHAR2,
        p_from_pk1_value        IN VARCHAR2,
        p_from_pk2_value        IN VARCHAR2,
        p_from_pk3_value        IN VARCHAR2,
        p_from_pk4_value        IN VARCHAR2,
        p_from_pk5_value        IN VARCHAR2,
        p_to_entity_name        IN VARCHAR2,
        p_to_pk1_value          IN VARCHAR2,
        p_to_pk2_value          IN VARCHAR2,
        p_to_pk3_value          IN VARCHAR2,
        p_to_pk4_value          IN VARCHAR2,
        p_to_pk5_value          IN VARCHAR2,
        p_relationship_code     IN VARCHAR2,
        p_created_by            IN NUMBER,
        p_last_update_login     IN NUMBER,
        x_return_status       OUT  NOCOPY  VARCHAR2,
        x_msg_count           OUT  NOCOPY  NUMBER,
        x_msg_data            OUT  NOCOPY  VARCHAR2 )
IS
l_doc_number    VARCHAR2(30);

Line: 35


        SELECT doc_number INTO l_doc_number
        FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD
        WHERE
            from_entity_name =  p_from_entity_name
        AND	from_pk1_value   =  p_from_pk1_value
        AND	from_pk2_value   =  p_from_pk2_value
        AND	((p_from_entity_name = 'EGO_ITEM_REVISION' AND from_pk3_value   =  p_from_pk3_value ) OR
             (p_from_entity_name = 'DOM_DOCUMENT_REVISION' AND from_pk3_value   IS NULL ) OR p_from_entity_name = 'EGO_ITEM' AND from_pk3_value   IS NULL )
        AND	to_entity_name   =  p_to_entity_name
        AND	to_pk1_value     =  p_to_pk1_value
        AND	relationship_code=  p_relationship_code
        AND to_pk1_value = TO_CHAR(dd.document_id);

Line: 59


        INSERT INTO DOM_RELATIONSHIPS (
            association_id      ,
            from_entity_name      ,
            from_pk1_value        ,
            from_pk2_value        ,
            from_pk3_value        ,
            from_pk4_value        ,
            from_pk5_value        ,
            to_entity_name        ,
            to_pk1_value          ,
            to_pk2_value          ,
            to_pk3_value          ,
            to_pk4_value          ,
            to_pk5_value          ,
            relationship_code     ,
            created_by            ,
            last_update_login     ,
            creation_date	      ,
            last_update_date
        )
        VALUES
        (
            p_association_id        ,
            p_from_entity_name      ,
            p_from_pk1_value        ,
            p_from_pk2_value        ,
            p_from_pk3_value        ,
            p_from_pk4_value        ,
            p_from_pk5_value        ,
            p_to_entity_name        ,
            p_to_pk1_value          ,
            p_to_pk2_value          ,
            p_to_pk3_value          ,
            p_to_pk4_value          ,
            p_to_pk5_value          ,
            p_relationship_code     ,
            p_created_by            ,
            p_last_update_login     ,
            sysdate                 ,
            sysdate
        );

Line: 103


END Insert_Row;

Line: 105


Procedure Delete_Row(
        p_from_entity_name      IN VARCHAR2,
        p_from_pk1_value        IN VARCHAR2,
        p_from_pk2_value        IN VARCHAR2,
        p_from_pk3_value        IN VARCHAR2,
        p_from_pk4_value        IN VARCHAR2,
        p_from_pk5_value        IN VARCHAR2,
        p_to_entity_name        IN VARCHAR2,
        p_to_pk1_value          IN VARCHAR2,
        p_to_pk2_value          IN VARCHAR2,
        p_to_pk3_value          IN VARCHAR2,
        p_to_pk4_value          IN VARCHAR2,
        p_to_pk5_value          IN VARCHAR2,
	p_current_value         IN VARCHAR2,
        p_relationship_code     IN VARCHAR2,
        x_return_status       OUT  NOCOPY  VARCHAR2,
        x_msg_count           OUT  NOCOPY  NUMBER,
        x_msg_data            OUT  NOCOPY  VARCHAR2 )
IS
l_doc_number    VARCHAR2(30);

Line: 131


        SELECT doc_number INTO l_doc_number
        FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD
        WHERE
            from_entity_name =  p_from_entity_name
        AND	from_pk1_value   =  p_from_pk1_value
        AND	from_pk2_value   =  p_from_pk2_value
        AND	((p_from_entity_name = 'EGO_ITEM_REVISION' AND from_pk3_value   =  p_from_pk3_value ) OR
             (p_from_entity_name = 'DOM_DOCUMENT_REVISION' AND from_pk3_value   IS NULL ) OR (p_from_entity_name = 'EGO_ITEM' AND from_pk3_value   IS NULL) )
        AND	to_entity_name   =  p_to_entity_name
        AND	to_pk1_value     =  p_to_pk1_value
        AND	relationship_code=  p_relationship_code
        AND to_pk1_value = TO_CHAR(dd.document_id);

Line: 152


           l_message := 'DOM_DELETE_IMP_ERROR';

Line: 160


        DELETE FROM DOM_RELATIONSHIPS
        WHERE
            from_entity_name =  p_from_entity_name
        AND	from_pk1_value   =  p_from_pk1_value
        AND	from_pk2_value   =  p_from_pk2_value
        AND	((p_from_entity_name = 'EGO_ITEM_REVISION' AND from_pk3_value   =  p_from_pk3_value ) OR
             (p_from_entity_name = 'DOM_DOCUMENT_REVISION' AND from_pk3_value   IS NULL ) OR
             (p_from_entity_name = 'EGO_ITEM' AND from_pk3_value   IS NULL ))
        AND	to_entity_name   =  p_to_entity_name
        AND	to_pk1_value     =  p_to_pk1_value
        --AND	to_pk2_value     =  p_current_value
        AND	relationship_code=  p_relationship_code;

Line: 174


END Delete_Row;

Line: 202


        SELECT doc_number INTO l_doc_number
        FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD
        WHERE
            from_entity_name =  p_from_entity_name
        AND	from_pk1_value   =  p_from_pk1_value
        AND	from_pk2_value   =  p_from_pk2_value
        AND	((p_from_entity_name = 'EGO_ITEM_REVISION' AND from_pk3_value   =  p_from_pk3_value ) OR
             (p_from_entity_name = 'DOM_DOCUMENT_REVISION' AND from_pk3_value   IS NULL ) OR (p_from_entity_name = 'EGO_ITEM' AND from_pk3_value   IS NULL) )
        AND	to_entity_name   =  p_to_entity_name
        AND	to_pk1_value     =  p_to_pk1_value
        AND	relationship_code=  p_relationship_code
        AND to_pk1_value = TO_CHAR(dd.document_id);

Line: 233


        UPDATE DOM_RELATIONSHIPS
        SET
            to_pk2_value = p_to_pk2_value
        WHERE
            from_entity_name =  decode(p_from_entity_name,'MTL_ITEM_REVISIONS','EGO_ITEM_REVISION',decode(p_from_entity_name,'MTL__SYSTEM_ITEMS','EGO_ITEM',p_from_entity_name))
        AND	from_pk1_value   =  p_from_pk1_value
        AND	from_pk2_value   =  p_from_pk2_value
        AND	((decode(p_from_entity_name,'MTL_ITEM_REVISIONS','EGO_ITEM_REVISION',decode(p_from_entity_name,'MTL__SYSTEM_ITEMS','EGO_ITEM',p_from_entity_name)) = 'EGO_ITEM_REVISION' AND from_pk3_value   =  p_from_pk3_value ) OR
             (p_from_entity_name = 'DOM_DOCUMENT_REVISION' AND from_pk3_value   IS NULL ) OR
             (p_from_entity_name = 'EGO_ITEM' AND from_pk3_value   IS NULL ))
        AND	to_entity_name   =  p_to_entity_name
        AND	to_pk1_value     =  p_to_pk1_value
        --AND	to_pk2_value     =  p_current_value
        AND	relationship_code=  p_relationship_code;

Line: 269


        p_last_update_login     IN NUMBER,
        x_return_status       OUT  NOCOPY  VARCHAR2,
        x_msg_count           OUT  NOCOPY  NUMBER,
        x_msg_data            OUT  NOCOPY  VARCHAR2 )
IS

l_action        VARCHAR2(20);

Line: 292


        Insert_Row (    p_association_id     => p_association_id,
                        p_from_entity_name   => p_from_entity_name,
                        p_from_pk1_value     => p_from_pk1_value,
                        p_from_pk2_value     => p_from_pk2_value,
                        p_from_pk3_value     => p_from_pk3_value,
                        p_from_pk4_value     => p_from_pk4_value,
                        p_from_pk5_value     => p_from_pk5_value,
                        p_to_entity_name     => p_to_entity_name,
                        p_to_pk1_value       => p_to_pk1_value,
                        p_to_pk2_value       => p_to_pk2_value,
                        p_to_pk3_value       => p_to_pk3_value,
                        p_to_pk4_value       => p_to_pk4_value,
                        p_to_pk5_value       => p_to_pk5_value,
                        p_relationship_code  => p_relationship_code,
                        p_created_by         => p_created_by,
                        p_last_update_login  => p_last_update_login,
                        x_return_status      => x_return_status,
                        x_msg_count          => x_msg_count,
                        x_msg_data           => x_msg_data );

Line: 312


    ELSIF l_action = 'DELETE' THEN

        Delete_Row (
                        p_from_entity_name   => p_from_entity_name,
                        p_from_pk1_value     => p_from_pk1_value,
                        p_from_pk2_value     => p_from_pk2_value,
                        p_from_pk3_value     => p_from_pk3_value,
                        p_from_pk4_value     => p_from_pk4_value,
                        p_from_pk5_value     => p_from_pk5_value,
                        p_to_entity_name     => p_to_entity_name,
                        p_to_pk1_value       => p_to_pk1_value,
                        p_to_pk2_value       => p_to_pk2_value,
                        p_to_pk3_value       => p_to_pk3_value,
                        p_to_pk4_value       => p_to_pk4_value,
                        p_to_pk5_value       => p_to_pk5_value,
                        p_relationship_code  => p_relationship_code,
			            p_current_value      => p_current_value,
                        x_return_status      => x_return_status,
                        x_msg_count          => x_msg_count,
                        x_msg_data           => x_msg_data );