APPS.M4U_DMD_MESSAGE_PKG dependencies on M4U_DMD_DOCUMENTS

Line 385: l_doc_rec m4u_dmd_documents%ROWTYPE;

381: l_err_api VARCHAR2(30) := 'm4u_dmd_message_pkg.send_cic';
382: l_msg_id VARCHAR2(30);
383: l_doc_id VARCHAR2(30);
384: l_payload_id VARCHAR2(30);
385: l_doc_rec m4u_dmd_documents%ROWTYPE;
386: l_dom xmldom.domdocument;
387:
388: l_doc_node xmldom.domnode;
389: l_doc_count NUMBER;

Line 462: m4u_dmd_utils.log('Query m4u_dmd_documents for CIN info' ,1);

458: || '/*[local-name()="AlternateIdentification"]'
459: || '/*[local-name()="ID"]');
460:
461: m4u_dmd_utils.log('CIN l_cin_msg_id -|' ||l_cin_msg_id || ' |',1);
462: m4u_dmd_utils.log('Query m4u_dmd_documents for CIN info' ,1);
463:
464: SELECT receiver_gln, sender_gln, rep_party_gln
465: INTO l_user_gln, l_datapool_gln, l_retailer_gln
466: FROM m4u_dmd_messages

Line 530: m4u_dmd_utils.log('Query m4u_dmd_documents for ref_doc_id',1);

526:
527: l_doc_rec.parameter1 := xslprocessor.valueof (l_doc_node,
528: './*[local-name()="ProcessingStatus"]/*[local-name()="Code"]');
529:
530: m4u_dmd_utils.log('Query m4u_dmd_documents for ref_doc_id',1);
531: SELECT top_gtin, action, info_provider_gln,
532: data_recepient_gln,target_market_country,
533: doc_id
534: INTO l_doc_rec.top_gtin, l_doc_rec.action, l_doc_rec.info_provider_gln,

Line 537: FROM m4u_dmd_documents

533: doc_id
534: INTO l_doc_rec.top_gtin, l_doc_rec.action, l_doc_rec.info_provider_gln,
535: l_doc_rec.data_recepient_gln, l_doc_rec.target_market_country,
536: l_doc_rec.ref_doc_id
537: FROM m4u_dmd_documents
538: WHERE orig_doc_id = l_doc_rec.orig_doc_id;
539:
540: m4u_dmd_utils.log('top_gtin -|' ||l_doc_rec.top_gtin || '|',1);
541: m4u_dmd_utils.log('sub_type -|' ||l_doc_rec.action || '|',1);