8718: l_wf_err_name VARCHAR2(30);
8719: l_wf_err_msg VARCHAR2(2000);
8720: l_wf_err_stack VARCHAR2(4000);
8721:
8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8719: l_wf_err_msg VARCHAR2(2000);
8720: l_wf_err_stack VARCHAR2(4000);
8721:
8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8720: l_wf_err_stack VARCHAR2(4000);
8721:
8722: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
8723: l_user_keys WF_ENGINE_BULK.userkeytabtype;
8724: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
8725:
8726: l_contract_id_names WF_ENGINE.nametabtyp;
8727: l_contract_number_names WF_ENGINE.nametabtyp;
8728: l_contract_modifier_names WF_ENGINE.nametabtyp;
8827:
8828: IF (l_contract_id_count > 0) THEN
8829:
8830: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8831: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', 'l_contract_id_count='||l_contract_id_count||' ,calling WF_ENGINE_BULK.createprocess');
8832: END IF;
8833:
8834: WF_ENGINE_BULK.createprocess(
8835: itemtype => G_ITEM_TYPE,
8830: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8831: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', 'l_contract_id_count='||l_contract_id_count||' ,calling WF_ENGINE_BULK.createprocess');
8832: END IF;
8833:
8834: WF_ENGINE_BULK.createprocess(
8835: itemtype => G_ITEM_TYPE,
8836: itemkeys => l_item_keys,
8837: process => G_MAIN_PROCESS,
8838: user_keys => l_user_keys,
8837: process => G_MAIN_PROCESS,
8838: user_keys => l_user_keys,
8839: owner_roles => l_owner_roles);
8840:
8841: WF_ENGINE_BULK.setitemattrnumber(
8842: itemtype => G_ITEM_TYPE,
8843: itemkeys => l_item_keys,
8844: anames => l_contract_id_names,
8845: avalues => l_contract_id_values);
8843: itemkeys => l_item_keys,
8844: anames => l_contract_id_names,
8845: avalues => l_contract_id_values);
8846:
8847: WF_ENGINE_BULK.setitemattrtext(
8848: itemtype => G_ITEM_TYPE,
8849: itemkeys => l_item_keys,
8850: anames => l_contract_number_names,
8851: avalues => l_contract_number_values);
8849: itemkeys => l_item_keys,
8850: anames => l_contract_number_names,
8851: avalues => l_contract_number_values);
8852:
8853: WF_ENGINE_BULK.setitemattrtext(
8854: itemtype => G_ITEM_TYPE,
8855: itemkeys => l_item_keys,
8856: anames => l_contract_modifier_names,
8857: avalues => l_contract_modifier_values);
8855: itemkeys => l_item_keys,
8856: anames => l_contract_modifier_names,
8857: avalues => l_contract_modifier_values);
8858:
8859: WF_ENGINE_BULK.setitemattrtext(
8860: itemtype => G_ITEM_TYPE,
8861: itemkeys => l_item_keys,
8862: anames => l_process_type_names,
8863: avalues => l_process_type_values);
8861: itemkeys => l_item_keys,
8862: anames => l_process_type_names,
8863: avalues => l_process_type_values);
8864:
8865: WF_ENGINE_BULK.setitemattrtext(
8866: itemtype => G_ITEM_TYPE,
8867: itemkeys => l_item_keys,
8868: anames => l_irr_flag_names,
8869: avalues => l_irr_flag_values);
8867: itemkeys => l_item_keys,
8868: anames => l_irr_flag_names,
8869: avalues => l_irr_flag_values);
8870:
8871: WF_ENGINE_BULK.setitemattrtext(
8872: itemtype => G_ITEM_TYPE,
8873: itemkeys => l_item_keys,
8874: anames => l_neg_status_names,
8875: avalues => l_neg_status_values);
8873: itemkeys => l_item_keys,
8874: anames => l_neg_status_names,
8875: avalues => l_neg_status_values);
8876:
8877: WF_ENGINE_BULK.setitemattrnumber(
8878: itemtype => G_ITEM_TYPE,
8879: itemkeys => l_item_keys,
8880: anames => l_user_id_names,
8881: avalues => l_user_id_values);
8879: itemkeys => l_item_keys,
8880: anames => l_user_id_names,
8881: avalues => l_user_id_values);
8882:
8883: WF_ENGINE_BULK.setitemattrnumber(
8884: itemtype => G_ITEM_TYPE,
8885: itemkeys => l_item_keys,
8886: anames => l_responsibility_id_names,
8887: avalues => l_responsibility_id_values);
8885: itemkeys => l_item_keys,
8886: anames => l_responsibility_id_names,
8887: avalues => l_responsibility_id_values);
8888:
8889: WF_ENGINE_BULK.setitemattrnumber(
8890: itemtype => G_ITEM_TYPE,
8891: itemkeys => l_item_keys,
8892: anames => l_resp_appl_id_names,
8893: avalues => l_resp_appl_id_values);
8891: itemkeys => l_item_keys,
8892: anames => l_resp_appl_id_names,
8893: avalues => l_resp_appl_id_values);
8894:
8895: WF_ENGINE_BULK.setitemattrnumber(
8896: itemtype => G_ITEM_TYPE,
8897: itemkeys => l_item_keys,
8898: anames => l_security_group_id_names,
8899: avalues => l_security_group_id_values);
8898: anames => l_security_group_id_names,
8899: avalues => l_security_group_id_values);
8900:
8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
8903: END IF;
8904:
8905: WF_ENGINE_BULK.startprocess(
8906: itemtype => G_ITEM_TYPE,
8901: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8902: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
8903: END IF;
8904:
8905: WF_ENGINE_BULK.startprocess(
8906: itemtype => G_ITEM_TYPE,
8907: itemkeys => l_item_keys);
8908:
8909: IF ( nvl(p_update_item_key, 'N') = 'Y' ) THEN