274: p_doc_status => l_doc_status,
275: p_coll_status => l_coll_status,
276: p_xmlg_document_id => NULL,
277: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
278: p_tr_partner_type => m4u_ucc_utils.c_party_type,
279: p_tr_partner_id => m4u_ucc_utils.g_party_id,
280: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
281: p_attribute2 => p_target_market,
282: p_attribute5 => p_supp_gln,
275: p_coll_status => l_coll_status,
276: p_xmlg_document_id => NULL,
277: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
278: p_tr_partner_type => m4u_ucc_utils.c_party_type,
279: p_tr_partner_id => m4u_ucc_utils.g_party_id,
280: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
281: p_attribute2 => p_target_market,
282: p_attribute5 => p_supp_gln,
283: p_attribute6 => p_retailer_gln,
276: p_xmlg_document_id => NULL,
277: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
278: p_tr_partner_type => m4u_ucc_utils.c_party_type,
279: p_tr_partner_id => m4u_ucc_utils.g_party_id,
280: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
281: p_attribute2 => p_target_market,
282: p_attribute5 => p_supp_gln,
283: p_attribute6 => p_retailer_gln,
284: p_attribute8 => p_ucc_doc_unique_id,
316: p_parameterlist => l_event_params );
317:
318: wf_event.AddParameterToList(
319: p_name => 'APPLICATION_ID',
320: p_value => m4u_ucc_utils.c_resp_appl_id,
321: p_parameterlist => l_event_params );
322:
323: wf_event.AddParameterToList(
324: p_name => 'NOTIFICATION_CODE',
748: p_doc_status => l_doc_status,
749: p_coll_status => l_coll_status,
750: p_xmlg_document_id => NULL,
751: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
752: p_tr_partner_type => m4u_ucc_utils.c_party_type,
753: p_tr_partner_id => m4u_ucc_utils.g_party_id,
754: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
755: p_attribute2 => p_target_market,
756: p_attribute5 => p_supp_gln,
749: p_coll_status => l_coll_status,
750: p_xmlg_document_id => NULL,
751: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
752: p_tr_partner_type => m4u_ucc_utils.c_party_type,
753: p_tr_partner_id => m4u_ucc_utils.g_party_id,
754: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
755: p_attribute2 => p_target_market,
756: p_attribute5 => p_supp_gln,
757: p_attribute8 => p_ucc_doc_unique_id,
750: p_xmlg_document_id => NULL,
751: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
752: p_tr_partner_type => m4u_ucc_utils.c_party_type,
753: p_tr_partner_id => m4u_ucc_utils.g_party_id,
754: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
755: p_attribute2 => p_target_market,
756: p_attribute5 => p_supp_gln,
757: p_attribute8 => p_ucc_doc_unique_id,
758: p_attribute9 => p_rcir_command_validation_key,
918: p_parameterlist => l_event_params );
919:
920: wf_event.AddParameterToList(
921: p_name => 'APPLICATION_ID',
922: p_value => m4u_ucc_utils.c_resp_appl_id,
923: p_parameterlist => l_event_params );
924:
925: wf_event.AddParameterToList(
926: p_name => 'NOTIFICATION_CODE',
1103: p_doc_status => l_doc_status,
1104: p_coll_status => l_coll_status,
1105: p_xmlg_document_id => NULL,
1106: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1107: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1108: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1109: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1110: p_attribute8 => p_ucc_doc_unique_id,
1111: p_dattribute1 => sysdate,
1104: p_coll_status => l_coll_status,
1105: p_xmlg_document_id => NULL,
1106: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1107: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1108: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1109: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1110: p_attribute8 => p_ucc_doc_unique_id,
1111: p_dattribute1 => sysdate,
1112: p_attribute11 => p_wlq_success_flag,
1105: p_xmlg_document_id => NULL,
1106: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1107: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1108: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1109: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1110: p_attribute8 => p_ucc_doc_unique_id,
1111: p_dattribute1 => sysdate,
1112: p_attribute11 => p_wlq_success_flag,
1113: p_rosettanet_check_required => false,
1309: p_doc_type => 'M4U_RESP_ACK',
1310: p_disposition => l_disposition,
1311: p_doc_status => l_doc_status,
1312: p_coll_status => l_coll_status,
1313: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1314: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1315: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1316: p_rosettanet_check_required => FALSE,
1317: x_dtl_coll_id => x_collab_detail_id,
1310: p_disposition => l_disposition,
1311: p_doc_status => l_doc_status,
1312: p_coll_status => l_coll_status,
1313: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1314: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1315: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1316: p_rosettanet_check_required => FALSE,
1317: x_dtl_coll_id => x_collab_detail_id,
1318: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1311: p_doc_status => l_doc_status,
1312: p_coll_status => l_coll_status,
1313: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1314: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1315: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1316: p_rosettanet_check_required => FALSE,
1317: x_dtl_coll_id => x_collab_detail_id,
1318: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1319: p_doc_creation_date => sysdate,
1353: p_parameterlist => l_event_params );
1354:
1355: wf_event.AddParameterToList(
1356: p_name => 'APPLICATION_ID',
1357: p_value => m4u_ucc_utils.c_resp_appl_id,
1358: p_parameterlist => l_event_params );
1359:
1360: wf_event.AddParameterToList(
1361: p_name => 'NOTIFICATION_CODE',
1567: p_doc_type => 'M4U_RESP_ACK',
1568: p_disposition => l_disposition,
1569: p_doc_status => l_doc_status,
1570: p_coll_status => l_coll_status,
1571: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1572: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1573: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1574: p_rosettanet_check_required => FALSE,
1575: x_dtl_coll_id => x_collab_detail_id,
1568: p_disposition => l_disposition,
1569: p_doc_status => l_doc_status,
1570: p_coll_status => l_coll_status,
1571: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1572: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1573: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1574: p_rosettanet_check_required => FALSE,
1575: x_dtl_coll_id => x_collab_detail_id,
1576: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1569: p_doc_status => l_doc_status,
1570: p_coll_status => l_coll_status,
1571: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1572: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1573: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1574: p_rosettanet_check_required => FALSE,
1575: x_dtl_coll_id => x_collab_detail_id,
1576: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1577: p_doc_creation_date => sysdate,
1633: p_parameterlist => l_event_params );
1634:
1635: wf_event.AddParameterToList(
1636: p_name => 'APPLICATION_ID',
1637: p_value => m4u_ucc_utils.c_resp_appl_id,
1638: p_parameterlist => l_event_params );
1639:
1640: wf_event.AddParameterToList(
1641: p_name => 'NOTIFICATION_CODE',
1848: p_doc_type => 'M4U_RESP_ACK',
1849: p_disposition => l_disposition,
1850: p_doc_status => l_doc_status,
1851: p_coll_status => l_coll_status,
1852: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1853: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1854: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1855: p_rosettanet_check_required => FALSE,
1856: x_dtl_coll_id => x_collab_detail_id,
1849: p_disposition => l_disposition,
1850: p_doc_status => l_doc_status,
1851: p_coll_status => l_coll_status,
1852: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1853: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1854: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1855: p_rosettanet_check_required => FALSE,
1856: x_dtl_coll_id => x_collab_detail_id,
1857: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1850: p_doc_status => l_doc_status,
1851: p_coll_status => l_coll_status,
1852: p_tr_partner_type => m4u_ucc_utils.c_party_type,
1853: p_tr_partner_id => m4u_ucc_utils.g_party_id,
1854: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
1855: p_rosettanet_check_required => FALSE,
1856: x_dtl_coll_id => x_collab_detail_id,
1857: p_xmlg_internal_control_number => p_xmlg_internal_control_no,
1858: p_doc_creation_date => sysdate,
1887: p_parameterlist => l_event_params );
1888:
1889: wf_event.AddParameterToList(
1890: p_name => 'APPLICATION_ID',
1891: p_value => m4u_ucc_utils.c_resp_appl_id,
1892: p_parameterlist => l_event_params );
1893:
1894: wf_event.AddParameterToList(
1895: p_name => 'NOTIFICATION_CODE',
2032:
2033: cln_ch_collaboration_pkg.create_collaboration (
2034: x_return_status => l_return_status,
2035: x_msg_data => l_msg_data,
2036: p_app_id => m4u_ucc_utils.c_resp_appl_id,
2037: p_ref_id => NULL,
2038: p_org_id => m4u_ucc_utils.g_org_id,
2039: p_rel_no => NULL,
2040: p_doc_no => p_rfcin_unique_id,
2034: x_return_status => l_return_status,
2035: x_msg_data => l_msg_data,
2036: p_app_id => m4u_ucc_utils.c_resp_appl_id,
2037: p_ref_id => NULL,
2038: p_org_id => m4u_ucc_utils.g_org_id,
2039: p_rel_no => NULL,
2040: p_doc_no => p_rfcin_unique_id,
2041: p_doc_owner => NULL,
2042: p_xmlg_int_transaction_type => 'M4U',
2044: p_xmlg_transaction_type => 'M4U',
2045: p_xmlg_transaction_subtype => 'RESP_RFCIN',
2046: p_xmlg_document_id => p_ucc_doc_unique_id,
2047: p_coll_type => 'M4U_RFCIN',
2048: p_tr_partner_type => m4u_ucc_utils.c_party_type,
2049: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
2050: p_doc_creation_date => sysdate,
2051: p_doc_revision_date => sysdate,
2052: p_init_date => sysdate,
2045: p_xmlg_transaction_subtype => 'RESP_RFCIN',
2046: p_xmlg_document_id => p_ucc_doc_unique_id,
2047: p_coll_type => 'M4U_RFCIN',
2048: p_tr_partner_type => m4u_ucc_utils.c_party_type,
2049: p_tr_partner_site => m4u_ucc_utils.g_party_site_id,
2050: p_doc_creation_date => sysdate,
2051: p_doc_revision_date => sysdate,
2052: p_init_date => sysdate,
2053: p_doc_type => 'M4U_RESP_RFCIN',
2060: p_xml_event_key => NULL,
2061: p_xmlg_internal_control_number=> p_xmlg_internal_control_no,
2062: p_attribute1 => p_recipient_data_pool,
2063: p_attribute2 => p_target_market_country,
2064: p_attribute5 => m4u_ucc_utils.g_supp_gln,
2065: p_attribute6 => p_rfcin_owner_gln,
2066: p_attribute8 => p_ucc_doc_unique_id,
2067: p_attribute9 => p_gtin,
2068: p_attribute10 => p_rfcin_unique_id,
2106: p_parameterlist => l_event_params );
2107:
2108: wf_event.AddParameterToList(
2109: p_name => 'APPLICATION_ID',
2110: p_value => m4u_ucc_utils.c_resp_appl_id,
2111: p_parameterlist => l_event_params );
2112:
2113: wf_event.AddParameterToList(
2114: p_name => 'NOTIFICATION_CODE',