66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);
67: END IF;
68:
69:
70: l_procedure_name := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'PROCEDURE_NAME');
71: IF (l_Debug_Level <= 1) THEN
72: ecx_cln_debug_pub.Add('l_procedure_name - ' || l_procedure_name, 2);
73: END IF;
74:
72: ecx_cln_debug_pub.Add('l_procedure_name - ' || l_procedure_name, 2);
73: END IF;
74:
75:
76: l_application_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'APPLICATION_ID');
77: l_collaboration_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_ID');
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
73: END IF;
74:
75:
76: l_application_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'APPLICATION_ID');
77: l_collaboration_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_ID');
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
74:
75:
76: l_application_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'APPLICATION_ID');
77: l_collaboration_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_ID');
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
75:
76: l_application_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'APPLICATION_ID');
77: l_collaboration_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_ID');
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
76: l_application_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'APPLICATION_ID');
77: l_collaboration_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_ID');
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
77: l_collaboration_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_ID');
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
85:
78: l_collaboration_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'COLLABORATION_TYPE');
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
85:
86: IF (l_Debug_Level <= 1) THEN
79: l_reference_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'REFERENCE_ID');
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
85:
86: IF (l_Debug_Level <= 1) THEN
87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
80: l_trading_partner_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'TRADING_PARTNER_ID');
81: l_status := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'STATUS');
82: l_header_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'HEADER_DESC');
83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
85:
86: IF (l_Debug_Level <= 1) THEN
87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);