9022: l_wf_err_name VARCHAR2(30);
9023: l_wf_err_msg VARCHAR2(2000);
9024: l_wf_err_stack VARCHAR2(4000);
9025:
9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9023: l_wf_err_msg VARCHAR2(2000);
9024: l_wf_err_stack VARCHAR2(4000);
9025:
9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9024: l_wf_err_stack VARCHAR2(4000);
9025:
9026: l_item_keys WF_ENGINE_BULK.itemkeytabtype;
9027: l_user_keys WF_ENGINE_BULK.userkeytabtype;
9028: l_owner_roles WF_ENGINE_BULK.ownerroletabtype;
9029:
9030: l_contract_id_names WF_ENGINE.nametabtyp;
9031: l_contract_number_names WF_ENGINE.nametabtyp;
9032: l_contract_modifier_names WF_ENGINE.nametabtyp;
9131:
9132: IF (l_contract_id_count > 0) THEN
9133:
9134: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9135: 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');
9136: END IF;
9137:
9138: WF_ENGINE_BULK.createprocess(
9139: itemtype => G_ITEM_TYPE,
9134: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9135: 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');
9136: END IF;
9137:
9138: WF_ENGINE_BULK.createprocess(
9139: itemtype => G_ITEM_TYPE,
9140: itemkeys => l_item_keys,
9141: process => G_MAIN_PROCESS,
9142: user_keys => l_user_keys,
9141: process => G_MAIN_PROCESS,
9142: user_keys => l_user_keys,
9143: owner_roles => l_owner_roles);
9144:
9145: WF_ENGINE_BULK.setitemattrnumber(
9146: itemtype => G_ITEM_TYPE,
9147: itemkeys => l_item_keys,
9148: anames => l_contract_id_names,
9149: avalues => l_contract_id_values);
9147: itemkeys => l_item_keys,
9148: anames => l_contract_id_names,
9149: avalues => l_contract_id_values);
9150:
9151: WF_ENGINE_BULK.setitemattrtext(
9152: itemtype => G_ITEM_TYPE,
9153: itemkeys => l_item_keys,
9154: anames => l_contract_number_names,
9155: avalues => l_contract_number_values);
9153: itemkeys => l_item_keys,
9154: anames => l_contract_number_names,
9155: avalues => l_contract_number_values);
9156:
9157: WF_ENGINE_BULK.setitemattrtext(
9158: itemtype => G_ITEM_TYPE,
9159: itemkeys => l_item_keys,
9160: anames => l_contract_modifier_names,
9161: avalues => l_contract_modifier_values);
9159: itemkeys => l_item_keys,
9160: anames => l_contract_modifier_names,
9161: avalues => l_contract_modifier_values);
9162:
9163: WF_ENGINE_BULK.setitemattrtext(
9164: itemtype => G_ITEM_TYPE,
9165: itemkeys => l_item_keys,
9166: anames => l_process_type_names,
9167: avalues => l_process_type_values);
9165: itemkeys => l_item_keys,
9166: anames => l_process_type_names,
9167: avalues => l_process_type_values);
9168:
9169: WF_ENGINE_BULK.setitemattrtext(
9170: itemtype => G_ITEM_TYPE,
9171: itemkeys => l_item_keys,
9172: anames => l_irr_flag_names,
9173: avalues => l_irr_flag_values);
9171: itemkeys => l_item_keys,
9172: anames => l_irr_flag_names,
9173: avalues => l_irr_flag_values);
9174:
9175: WF_ENGINE_BULK.setitemattrtext(
9176: itemtype => G_ITEM_TYPE,
9177: itemkeys => l_item_keys,
9178: anames => l_neg_status_names,
9179: avalues => l_neg_status_values);
9177: itemkeys => l_item_keys,
9178: anames => l_neg_status_names,
9179: avalues => l_neg_status_values);
9180:
9181: WF_ENGINE_BULK.setitemattrnumber(
9182: itemtype => G_ITEM_TYPE,
9183: itemkeys => l_item_keys,
9184: anames => l_user_id_names,
9185: avalues => l_user_id_values);
9183: itemkeys => l_item_keys,
9184: anames => l_user_id_names,
9185: avalues => l_user_id_values);
9186:
9187: WF_ENGINE_BULK.setitemattrnumber(
9188: itemtype => G_ITEM_TYPE,
9189: itemkeys => l_item_keys,
9190: anames => l_responsibility_id_names,
9191: avalues => l_responsibility_id_values);
9189: itemkeys => l_item_keys,
9190: anames => l_responsibility_id_names,
9191: avalues => l_responsibility_id_values);
9192:
9193: WF_ENGINE_BULK.setitemattrnumber(
9194: itemtype => G_ITEM_TYPE,
9195: itemkeys => l_item_keys,
9196: anames => l_resp_appl_id_names,
9197: avalues => l_resp_appl_id_values);
9195: itemkeys => l_item_keys,
9196: anames => l_resp_appl_id_names,
9197: avalues => l_resp_appl_id_values);
9198:
9199: WF_ENGINE_BULK.setitemattrnumber(
9200: itemtype => G_ITEM_TYPE,
9201: itemkeys => l_item_keys,
9202: anames => l_security_group_id_names,
9203: avalues => l_security_group_id_values);
9202: anames => l_security_group_id_names,
9203: avalues => l_security_group_id_values);
9204:
9205: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9206: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
9207: END IF;
9208:
9209: WF_ENGINE_BULK.startprocess(
9210: itemtype => G_ITEM_TYPE,
9205: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9206: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.bulk_wf', ',calling WF_ENGINE_BULK.startprocess');
9207: END IF;
9208:
9209: WF_ENGINE_BULK.startprocess(
9210: itemtype => G_ITEM_TYPE,
9211: itemkeys => l_item_keys);
9212:
9213: IF ( nvl(p_update_item_key, 'N') = 'Y' ) THEN