205: --Check the publish/ export status of the current item in the collaboration
206: --history for the billing app for which the items are exported.
207: ----------------------------------------------------------------------------------------------
208:
209: l_cln_stat := xnb_util_pvt.check_cln_billapp_doc_status(
210: p_doc_no => l_item_rec.item_id,
211: p_collab_type => 'XNB_ITEM',
212: p_tp_loc_code => p_bill_app_code);
213:
302: --Check the publish/export status of the current item in the collaboration
303: --history for the billing app for which the items are exported.
304: ----------------------------------------------------------------------------------------------
305:
306: l_cln_stat := xnb_util_pvt.check_cln_billapp_doc_status(
307: p_doc_no => l_item_rec.item_id,
308: p_collab_type => 'XNB_ITEM',
309: p_tp_loc_code => p_bill_app_code);
310:
703: l_wf_key varchar2(200) ;
704:
705: BEGIN
706:
707: l_pub_cnt := xnb_util_pvt.check_cln_billapp_doc_status(
708: p_doc_no => p_item_id,
709: p_collab_type => 'XNB_ITEM',
710: p_tp_loc_code => p_bill_app_code);
711: