DBA Data[Home] [Help]

APPS.M4U_CLN_PKG dependencies on STANDARD

Line 76: i_message_standard => m4u_cln_pkg.c_xmlg_std,

72: o_retcode => l_ret_sts,
73: o_retmsg => l_ret_msg,
74: i_msgid => SYS_GUID,
75: i_message_type => 'XML',
76: i_message_standard => m4u_cln_pkg.c_xmlg_std,
77: i_transaction_type => m4u_cln_pkg.c_xmlg_type,
78: i_transaction_subtype => l_txn_styp,
79: i_document_number => l_ecx_doc_num,
80: i_partyid => m4u_cln_pkg.g_party_id,

Line 628: p_collaboration_standard => c_xmlg_std,

624: p_unique5 => null,
625: p_sender_component => null,
626: p_rosettanet_check_required => false,
627: p_xmlg_internal_control_number => null,
628: p_collaboration_standard => c_xmlg_std,
629: p_attribute1 => l_m4u_doc_rec.msg_id,
630: p_attribute2 => l_m4u_doc_rec.doc_id,
631: p_attribute3 => l_m4u_doc_rec.ref_doc_id,
632: p_attribute4 => l_m4u_doc_rec.orig_doc_id,

Line 772: l_standard_code VARCHAR2(30);

768: l_ret_sts VARCHAR2(10);
769: l_record_found BOOLEAN;
770:
771: l_party_type VARCHAR2(30);
772: l_standard_code VARCHAR2(30);
773:
774: l_ext_type VARCHAR2(30);
775: l_txn_type VARCHAR2(30);
776: l_doc_conf VARCHAR2(30);

Line 801: l_standard_code := m4u_cln_pkg.c_xmlg_std;

797:
798: --------------------------------------------------------------------------
799: --Set ECX api input params
800: l_ext_type := m4u_cln_pkg.c_xmlg_type;
801: l_standard_code := m4u_cln_pkg.c_xmlg_std;
802: l_txn_type := m4u_cln_pkg.c_xmlg_type;
803: l_party_type := m4u_cln_pkg.c_party_type;
804: l_doc_conf := '2';
805: l_map := 'm4u_230_cin_out';

Line 841: ecx_standards svl

837: ecx_tp_details tpd,
838: ecx_tp_headers tph,
839: ecx_ext_processes extp,
840: ecx_transactions txn,
841: ecx_standards svl
842: WHERE 1=1
843: AND tph.tp_header_id = tpd.tp_header_id
844: AND tpd.ext_process_id = extp.ext_process_id
845: AND extp.transaction_id = txn.transaction_id

Line 846: AND extp.standard_id = svl.standard_id

842: WHERE 1=1
843: AND tph.tp_header_id = tpd.tp_header_id
844: AND tpd.ext_process_id = extp.ext_process_id
845: AND extp.transaction_id = txn.transaction_id
846: AND extp.standard_id = svl.standard_id
847: AND svl.standard_code = l_standard_code
848: AND extp.ext_type = l_ext_type
849: AND extp.ext_subtype = l_ext_subtype
850: AND extp.direction = p_direction

Line 847: AND svl.standard_code = l_standard_code

843: AND tph.tp_header_id = tpd.tp_header_id
844: AND tpd.ext_process_id = extp.ext_process_id
845: AND extp.transaction_id = txn.transaction_id
846: AND extp.standard_id = svl.standard_id
847: AND svl.standard_code = l_standard_code
848: AND extp.ext_type = l_ext_type
849: AND extp.ext_subtype = l_ext_subtype
850: AND extp.direction = p_direction
851: AND txn.transaction_type = l_txn_type

Line 874: ecx_standards svl

870: SELECT extp.ext_process_id
871: INTO l_ext_process_id
872: FROM ecx_ext_processes extp,
873: ecx_transactions txn,
874: ecx_standards svl
875: WHERE 1=1
876: AND extp.transaction_id = txn.transaction_id
877: AND extp.standard_id = svl.standard_id
878: AND svl.standard_code = l_standard_code

Line 877: AND extp.standard_id = svl.standard_id

873: ecx_transactions txn,
874: ecx_standards svl
875: WHERE 1=1
876: AND extp.transaction_id = txn.transaction_id
877: AND extp.standard_id = svl.standard_id
878: AND svl.standard_code = l_standard_code
879: AND extp.ext_type = l_ext_type
880: AND extp.ext_subtype = l_ext_subtype
881: AND extp.direction = p_direction

Line 878: AND svl.standard_code = l_standard_code

874: ecx_standards svl
875: WHERE 1=1
876: AND extp.transaction_id = txn.transaction_id
877: AND extp.standard_id = svl.standard_id
878: AND svl.standard_code = l_standard_code
879: AND extp.ext_type = l_ext_type
880: AND extp.ext_subtype = l_ext_subtype
881: AND extp.direction = p_direction
882: AND txn.party_type = l_party_type