1320: Select Oe_Xml_Message_Seq_S.nextval
1321: Into l_itemkey
1322: From dual;
1323:
1324: wf_event.AddParameterToList(p_name=> 'TRANSACTION_TYPE',
1325: p_value=> p_transaction_type,
1326: p_parameterlist=> l_parameter_list);
1327:
1328: wf_event.AddParameterToList(p_name=> 'TRANSACTION_SUBTYPE',
1324: wf_event.AddParameterToList(p_name=> 'TRANSACTION_TYPE',
1325: p_value=> p_transaction_type,
1326: p_parameterlist=> l_parameter_list);
1327:
1328: wf_event.AddParameterToList(p_name=> 'TRANSACTION_SUBTYPE',
1329: p_value=> p_transaction_subtype,
1330: p_parameterlist=> l_parameter_list);
1331:
1332: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
1328: wf_event.AddParameterToList(p_name=> 'TRANSACTION_SUBTYPE',
1329: p_value=> p_transaction_subtype,
1330: p_parameterlist=> l_parameter_list);
1331:
1332: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
1333: p_value=> p_header_id,
1334: p_parameterlist=> l_parameter_list);
1335:
1336: wf_event.AddParameterToList(p_name=> 'ORG_ID',
1332: wf_event.AddParameterToList(p_name=> 'HEADER_ID',
1333: p_value=> p_header_id,
1334: p_parameterlist=> l_parameter_list);
1335:
1336: wf_event.AddParameterToList(p_name=> 'ORG_ID',
1337: p_value=> p_org_id,
1338: p_parameterlist=> l_parameter_list);
1339:
1340: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
1336: wf_event.AddParameterToList(p_name=> 'ORG_ID',
1337: p_value=> p_org_id,
1338: p_parameterlist=> l_parameter_list);
1339:
1340: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
1341: p_value=> p_orig_sys_document_ref,
1342: p_parameterlist=> l_parameter_list);
1343:
1344: wf_event.AddParameterToList(p_name=> 'CHANGE_SEQUENCE',
1340: wf_event.AddParameterToList(p_name=> 'ORIG_SYS_DOCUMENT_REF',
1341: p_value=> p_orig_sys_document_ref,
1342: p_parameterlist=> l_parameter_list);
1343:
1344: wf_event.AddParameterToList(p_name=> 'CHANGE_SEQUENCE',
1345: p_value=> p_change_sequence,
1346: p_parameterlist=> l_parameter_list);
1347:
1348: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
1344: wf_event.AddParameterToList(p_name=> 'CHANGE_SEQUENCE',
1345: p_value=> p_change_sequence,
1346: p_parameterlist=> l_parameter_list);
1347:
1348: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
1349: p_value=> p_sold_to_org_id,
1350: p_parameterlist=> l_parameter_list);
1351:
1352: wf_event.AddParameterToList(p_name=> 'ORDER_NUMBER',
1348: wf_event.AddParameterToList(p_name=> 'SOLD_TO_ORG_ID',
1349: p_value=> p_sold_to_org_id,
1350: p_parameterlist=> l_parameter_list);
1351:
1352: wf_event.AddParameterToList(p_name=> 'ORDER_NUMBER',
1353: p_value=> p_order_number,
1354: p_parameterlist=> l_parameter_list);
1355:
1356: wf_event.AddParameterToList(p_name=> 'XML_MESSAGE_ID',
1352: wf_event.AddParameterToList(p_name=> 'ORDER_NUMBER',
1353: p_value=> p_order_number,
1354: p_parameterlist=> l_parameter_list);
1355:
1356: wf_event.AddParameterToList(p_name=> 'XML_MESSAGE_ID',
1357: p_value=> p_xml_msg_id,
1358: p_parameterlist=> l_parameter_list);
1359:
1360: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
1356: wf_event.AddParameterToList(p_name=> 'XML_MESSAGE_ID',
1357: p_value=> p_xml_msg_id,
1358: p_parameterlist=> l_parameter_list);
1359:
1360: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
1361: p_value=> p_order_type_id,
1362: p_parameterlist=> l_parameter_list);
1363:
1364: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
1360: wf_event.AddParameterToList(p_name=> 'ORDER_TYPE_ID',
1361: p_value=> p_order_type_id,
1362: p_parameterlist=> l_parameter_list);
1363:
1364: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
1365: p_value=> p_order_source_id,
1366: p_parameterlist=> l_parameter_list);
1367:
1368: wf_event.raise( p_event_name => l_event_name,
1364: wf_event.AddParameterToList(p_name=> 'ORDER_SOURCE_ID',
1365: p_value=> p_order_source_id,
1366: p_parameterlist=> l_parameter_list);
1367:
1368: wf_event.raise( p_event_name => l_event_name,
1369: p_event_key => l_itemkey,
1370: p_parameters => l_parameter_list);
1371:
1372: