APPS.M4U_DMD_MESSAGE_PKG SQL Statements

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

Line: 313

        SELECT  payload_id, sender_gln, receiver_gln, rep_party_gln
        INTO    l_payload_id,l_datapool_gln, l_user_gln, l_retailer_gln
        FROM    m4u_dmd_messages
        WHERE   msg_id = p_cin_msg_id;

Line: 439

        l_msg_nodes := xslprocessor.selectnodes (xmldom.makenode (l_dom),
                '/*[local-name()="SyncItemPublicationConfirmationEBM"]' ||
                '/*[local-name()="DataArea"]'                           ||
                '/*[local-name()="SyncItemPublicationConfirmation"]');

Line: 464

                SELECT  receiver_gln, sender_gln, rep_party_gln
                INTO    l_user_gln, l_datapool_gln, l_retailer_gln
                FROM    m4u_dmd_messages
                WHERE   orig_msg_id = l_cin_msg_id;

Line: 508

                l_doc_nodes :=  xslprocessor.selectnodes (l_msg_node,
                        './*[local-name()="ItemPublicationLineConfirmation"]');

Line: 531

                        SELECT  top_gtin, action, info_provider_gln,
                                data_recepient_gln,target_market_country,
                                doc_id
                        INTO    l_doc_rec.top_gtin, l_doc_rec.action, l_doc_rec.info_provider_gln,
                                l_doc_rec.data_recepient_gln, l_doc_rec.target_market_country,
                                l_doc_rec.ref_doc_id
                        FROM    m4u_dmd_documents
                        WHERE   orig_doc_id =  l_doc_rec.orig_doc_id;

Line: 734

        l_doc_nodes :=  xslprocessor.selectnodes (l_node,'/*[local-name()="envelope"]/*[local-name()="catalogueItemNotification"]/*[local-name()="document"]');