273: l_Org_ID NUMBER;
274: l_Party_Site_ID NUMBER;
275: l_txns_id NUMBER;
276:
277: l_msg_parameter_list WF_PARAMETER_LIST_T;
278: l_cbod_parameter_list WF_PARAMETER_LIST_T;
279: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
280:
281: CURSOR l_new_del_cur (l_trading_partner_ID NUMBER, l_name VARCHAR2)
274: l_Party_Site_ID NUMBER;
275: l_txns_id NUMBER;
276:
277: l_msg_parameter_list WF_PARAMETER_LIST_T;
278: l_cbod_parameter_list WF_PARAMETER_LIST_T;
279: l_txn_hist_record WSH_TRANSACTIONS_HISTORY_PKG.Txns_History_Record_Type;
280:
281: CURSOR l_new_del_cur (l_trading_partner_ID NUMBER, l_name VARCHAR2)
282: IS