eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IH_BULK dependencies on DBMS_XMLDOM

Line 627: xml_doc dbms_xmldom.DOMDocument;

623: p_bulk_interaction_request IN CLOB,
624: p_int_offset IN NUMBER DEFAULT 0
625: ) RETURN VARCHAR2 IS
626: xml_p dbms_xmlparser.parser;
627: xml_doc dbms_xmldom.DOMDocument;
628: int_rec JTF_IH_PUB.INTERACTION_REC_TYPE;
629: int_nl dbms_xmldom.DOMNodeList;
630: int_node dbms_xmldom.DOMNode;
631: int_elem dbms_xmldom.DomElement;

Line 629: int_nl dbms_xmldom.DOMNodeList;

625: ) RETURN VARCHAR2 IS
626: xml_p dbms_xmlparser.parser;
627: xml_doc dbms_xmldom.DOMDocument;
628: int_rec JTF_IH_PUB.INTERACTION_REC_TYPE;
629: int_nl dbms_xmldom.DOMNodeList;
630: int_node dbms_xmldom.DOMNode;
631: int_elem dbms_xmldom.DomElement;
632: med_nl dbms_xmldom.DOMNodeList;
633: med_id_tbl media_id_trkr_type;

Line 630: int_node dbms_xmldom.DOMNode;

626: xml_p dbms_xmlparser.parser;
627: xml_doc dbms_xmldom.DOMDocument;
628: int_rec JTF_IH_PUB.INTERACTION_REC_TYPE;
629: int_nl dbms_xmldom.DOMNodeList;
630: int_node dbms_xmldom.DOMNode;
631: int_elem dbms_xmldom.DomElement;
632: med_nl dbms_xmldom.DOMNodeList;
633: med_id_tbl media_id_trkr_type;
634: num_int NUMBER;

Line 631: int_elem dbms_xmldom.DomElement;

627: xml_doc dbms_xmldom.DOMDocument;
628: int_rec JTF_IH_PUB.INTERACTION_REC_TYPE;
629: int_nl dbms_xmldom.DOMNodeList;
630: int_node dbms_xmldom.DOMNode;
631: int_elem dbms_xmldom.DomElement;
632: med_nl dbms_xmldom.DOMNodeList;
633: med_id_tbl media_id_trkr_type;
634: num_int NUMBER;
635: num_med NUMBER;

Line 632: med_nl dbms_xmldom.DOMNodeList;

628: int_rec JTF_IH_PUB.INTERACTION_REC_TYPE;
629: int_nl dbms_xmldom.DOMNodeList;
630: int_node dbms_xmldom.DOMNode;
631: int_elem dbms_xmldom.DomElement;
632: med_nl dbms_xmldom.DOMNodeList;
633: med_id_tbl media_id_trkr_type;
634: num_int NUMBER;
635: num_med NUMBER;
636: num_act NUMBER;

Line 637: act_nl dbms_xmldom.DOMNodeList;

633: med_id_tbl media_id_trkr_type;
634: num_int NUMBER;
635: num_med NUMBER;
636: num_act NUMBER;
637: act_nl dbms_xmldom.DOMNodeList;
638: act_tbl JTF_IH_PUB.ACTIVITY_TBL_TYPE;
639:
640: -- local variables
641: l_resource_id NUMBER;

Line 787: int_nl := dbms_xmldom.getElementsByTagName(xml_doc, 'INTERACTION');

783: d. clean up and return.
784: */
785:
786: -- a. get all interaction nodes
787: int_nl := dbms_xmldom.getElementsByTagName(xml_doc, 'INTERACTION');
788: num_int := dbms_xmldom.getLength(int_nl);
789:
790: g_hrt_beat := 3;
791: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of interactions in req = ' || num_int);

Line 788: num_int := dbms_xmldom.getLength(int_nl);

784: */
785:
786: -- a. get all interaction nodes
787: int_nl := dbms_xmldom.getElementsByTagName(xml_doc, 'INTERACTION');
788: num_int := dbms_xmldom.getLength(int_nl);
789:
790: g_hrt_beat := 3;
791: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of interactions in req = ' || num_int);
792:

Line 831: int_node := dbms_xmldom.item(int_nl, i);

827: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'begin INT loop iteration # - ' || i);
828:
829: g_hrt_beat := 3.5;
830:
831: int_node := dbms_xmldom.item(int_nl, i);
832:
833: g_hrt_beat := 4;
834:
835: --1. convert interaction node to a document as well as a doc element

Line 836: int_elem := dbms_xmldom.makeElement(int_node);

832:
833: g_hrt_beat := 4;
834:
835: --1. convert interaction node to a document as well as a doc element
836: int_elem := dbms_xmldom.makeElement(int_node);
837: l_bulk_interaction_id := dbms_xmldom.getAttribute(int_elem, 'bulk_interaction_id');
838:
839: -- extract the resource id from the interaction element and get its user_id
840: -- we will use the resource's user id for all ih entities of this interaction

Line 837: l_bulk_interaction_id := dbms_xmldom.getAttribute(int_elem, 'bulk_interaction_id');

833: g_hrt_beat := 4;
834:
835: --1. convert interaction node to a document as well as a doc element
836: int_elem := dbms_xmldom.makeElement(int_node);
837: l_bulk_interaction_id := dbms_xmldom.getAttribute(int_elem, 'bulk_interaction_id');
838:
839: -- extract the resource id from the interaction element and get its user_id
840: -- we will use the resource's user id for all ih entities of this interaction
841: l_resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');

Line 841: l_resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');

837: l_bulk_interaction_id := dbms_xmldom.getAttribute(int_elem, 'bulk_interaction_id');
838:
839: -- extract the resource id from the interaction element and get its user_id
840: -- we will use the resource's user id for all ih entities of this interaction
841: l_resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
842:
843: BEGIN
844: SELECT user_id INTO l_user_id
845: FROM jtf_rs_resource_extns

Line 868: med_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'MEDIAITEM');

864: END;
865:
866:
867: --i. get all Media nodes from this doc.
868: med_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'MEDIAITEM');
869: num_med := dbms_xmldom.getLength(med_nl);
870:
871: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of media_items in int req num ' || i || ' = ' || num_med);
872:

Line 869: num_med := dbms_xmldom.getLength(med_nl);

865:
866:
867: --i. get all Media nodes from this doc.
868: med_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'MEDIAITEM');
869: num_med := dbms_xmldom.getLength(med_nl);
870:
871: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '# of media_items in int req num ' || i || ' = ' || num_med);
872:
873: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_INTERACTION_ID = ' || l_bulk_interaction_id);

Line 902: act_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'ACTIVITY');

898: -- iv. for each activity node
899: -- a.gather each activity's attributes, including media_id using the
900: -- mapping from b.1.ii.e
901: -- b.create a Activity record and save
902: act_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'ACTIVITY');
903: num_act := dbms_xmldom.getLength(act_nl);
904:
905: g_hrt_beat := 7;
906:

Line 903: num_act := dbms_xmldom.getLength(act_nl);

899: -- a.gather each activity's attributes, including media_id using the
900: -- mapping from b.1.ii.e
901: -- b.create a Activity record and save
902: act_nl := dbms_xmldom.getChildrenByTagName(int_elem, 'ACTIVITY');
903: num_act := dbms_xmldom.getLength(act_nl);
904:
905: g_hrt_beat := 7;
906:
907: -- delegate the activity processing

Line 953: -- the above routine only does a bunch of dbms_xmldom.getAttribute() calls to

949: RAISE processing_error;
950: END IF;
951:
952:
953: -- the above routine only does a bunch of dbms_xmldom.getAttribute() calls to
954: -- gather all attributes of the interaction; as such there is no error
955: -- catching or processing in the routine.
956: --
957: -- if and when it changes there will need to be some code here to check

Line 1115: dbms_xmldom.freeDocument(xml_doc);

1111:
1112: END LOOP; -- INT nodes
1113:
1114: g_hrt_beat := 12;
1115: dbms_xmldom.freeDocument(xml_doc);
1116:
1117: g_hrt_beat := 13;
1118: dbms_xmlparser.freeParser(xml_p);
1119:

Line 1225: -- med_nl - IN - dbms_xmldom.DomNodeList of media nodes

1221: -- Utility function to handle media nodes for an interaction.
1222: --
1223: -- Parameters
1224: --
1225: -- med_nl - IN - dbms_xmldom.DomNodeList of media nodes
1226: -- p_bulk_interaction_id - IN - self explanatory
1227: -- bulk_writer_code - IN - self explanatory
1228: -- bulk_batch_type - IN - self explanatory
1229: -- bulk_batch_id - IN - self explanatory

Line 1237: med_nl IN dbms_xmldom.DomNodeList,

1233: -- x_ret_msg - OUT - self explanatory
1234: --
1235: PROCEDURE PROCESS_MEDIA_ITEMS
1236: (
1237: med_nl IN dbms_xmldom.DomNodeList,
1238: p_bulk_interaction_id IN NUMBER,
1239: p_bulk_writer_code IN VARCHAR2,
1240: p_bulk_batch_type IN VARCHAR2,
1241: p_bulk_batch_id IN NUMBER,

Line 1249: med_node dbms_xmldom.DOMNode;

1245: x_ret_msg IN OUT NOCOPY VARCHAR2
1246: ) IS
1247:
1248: med_ident NUMBER;
1249: med_node dbms_xmldom.DOMNode;
1250: med_elem dbms_xmldom.DOMElement;
1251: mlcs_nl dbms_xmldom.DOMNodeList;
1252: mlcs_node dbms_xmldom.DOMNode;
1253: mlcs_elem dbms_xmldom.DOMElement;

Line 1250: med_elem dbms_xmldom.DOMElement;

1246: ) IS
1247:
1248: med_ident NUMBER;
1249: med_node dbms_xmldom.DOMNode;
1250: med_elem dbms_xmldom.DOMElement;
1251: mlcs_nl dbms_xmldom.DOMNodeList;
1252: mlcs_node dbms_xmldom.DOMNode;
1253: mlcs_elem dbms_xmldom.DOMElement;
1254: num_mlcs number;

Line 1251: mlcs_nl dbms_xmldom.DOMNodeList;

1247:
1248: med_ident NUMBER;
1249: med_node dbms_xmldom.DOMNode;
1250: med_elem dbms_xmldom.DOMElement;
1251: mlcs_nl dbms_xmldom.DOMNodeList;
1252: mlcs_node dbms_xmldom.DOMNode;
1253: mlcs_elem dbms_xmldom.DOMElement;
1254: num_mlcs number;
1255: med_rec JTF_IH_PUB.media_rec_type;

Line 1252: mlcs_node dbms_xmldom.DOMNode;

1248: med_ident NUMBER;
1249: med_node dbms_xmldom.DOMNode;
1250: med_elem dbms_xmldom.DOMElement;
1251: mlcs_nl dbms_xmldom.DOMNodeList;
1252: mlcs_node dbms_xmldom.DOMNode;
1253: mlcs_elem dbms_xmldom.DOMElement;
1254: num_mlcs number;
1255: med_rec JTF_IH_PUB.media_rec_type;
1256: mlcs_rec JTF_IH_PUB.media_lc_rec_type;

Line 1253: mlcs_elem dbms_xmldom.DOMElement;

1249: med_node dbms_xmldom.DOMNode;
1250: med_elem dbms_xmldom.DOMElement;
1251: mlcs_nl dbms_xmldom.DOMNodeList;
1252: mlcs_node dbms_xmldom.DOMNode;
1253: mlcs_elem dbms_xmldom.DOMElement;
1254: num_mlcs number;
1255: med_rec JTF_IH_PUB.media_rec_type;
1256: mlcs_rec JTF_IH_PUB.media_lc_rec_type;
1257: mlcs_tbl JTF_IH_PUB.mlcs_tbl_type;

Line 1277: 'med_nl TYPE dbms_xmldom.DomNodeList'||

1273: BEGIN
1274:
1275: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1276: l_fnd_log_msg := 'PROCESS_MEDIA_ITEMS In parameters :'||
1277: 'med_nl TYPE dbms_xmldom.DomNodeList'||
1278: ', p_bulk_interaction_id = '|| p_bulk_interaction_id ||
1279: ', p_bulk_writer_code = '|| p_bulk_writer_code||
1280: ', p_bulk_batch_type = '|| p_bulk_batch_type ||
1281: ', p_bulk_batch_id = '|| p_bulk_batch_id ||

Line 1304: num_med := dbms_xmldom.getLength(med_nl);

1300: f. keep track of mediaitem_identifier to media_id values
1301: */
1302:
1303: l_ret_status := FND_API.G_RET_STS_SUCCESS;
1304: num_med := dbms_xmldom.getLength(med_nl);
1305:
1306: g_hrt_beat := 13.0;
1307:
1308: --ii.for each media node

Line 1310: med_node := dbms_xmldom.item(med_nl, j);

1306: g_hrt_beat := 13.0;
1307:
1308: --ii.for each media node
1309: FOR j IN 0..num_med-1 LOOP
1310: med_node := dbms_xmldom.item(med_nl, j);
1311:
1312: -- an element is easier to get attribute values from
1313: med_elem := dbms_xmldom.makeElement(med_node);
1314:

Line 1313: med_elem := dbms_xmldom.makeElement(med_node);

1309: FOR j IN 0..num_med-1 LOOP
1310: med_node := dbms_xmldom.item(med_nl, j);
1311:
1312: -- an element is easier to get attribute values from
1313: med_elem := dbms_xmldom.makeElement(med_node);
1314:
1315: -- get the media identifier
1316: med_ident := dbms_xmldom.getAttribute(med_elem, 'mediaitem_identifier');
1317:

Line 1316: med_ident := dbms_xmldom.getAttribute(med_elem, 'mediaitem_identifier');

1312: -- an element is easier to get attribute values from
1313: med_elem := dbms_xmldom.makeElement(med_node);
1314:
1315: -- get the media identifier
1316: med_ident := dbms_xmldom.getAttribute(med_elem, 'mediaitem_identifier');
1317:
1318: -- we need to note whether we were passed a media id or not
1319: -- generate a media_id first - if it is not passed to us (AO gives us the media_id)
1320: med_id := dbms_xmldom.getAttribute(med_elem, 'media_id');

Line 1320: med_id := dbms_xmldom.getAttribute(med_elem, 'media_id');

1316: med_ident := dbms_xmldom.getAttribute(med_elem, 'mediaitem_identifier');
1317:
1318: -- we need to note whether we were passed a media id or not
1319: -- generate a media_id first - if it is not passed to us (AO gives us the media_id)
1320: med_id := dbms_xmldom.getAttribute(med_elem, 'media_id');
1321: IF (med_id IS null) THEN
1322: g_hrt_beat := 13.11;
1323: l_media_id_given := FALSE;
1324: --dbms_output.PUT('media_id is null for media_ident ' || med_ident);

Line 1334: mlcs_nl := dbms_xmldom.getChildNodes(med_node);

1330: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id is NOT null for media_ident ' || med_ident || ', med_id = ' || med_id);
1331: END IF;
1332:
1333: --a. get childNodes (they would be MLCS)
1334: mlcs_nl := dbms_xmldom.getChildNodes(med_node);
1335: num_mlcs := dbms_xmldom.getLength(mlcs_nl);
1336:
1337: g_hrt_beat := 13.2;
1338:

Line 1335: num_mlcs := dbms_xmldom.getLength(mlcs_nl);

1331: END IF;
1332:
1333: --a. get childNodes (they would be MLCS)
1334: mlcs_nl := dbms_xmldom.getChildNodes(med_node);
1335: num_mlcs := dbms_xmldom.getLength(mlcs_nl);
1336:
1337: g_hrt_beat := 13.2;
1338:
1339: --b. for each mlcs node, create a mlcs record and accumulate

Line 1341: mlcs_node := dbms_xmldom.item(mlcs_nl, (k-1)); -- indices run from 0 here

1337: g_hrt_beat := 13.2;
1338:
1339: --b. for each mlcs node, create a mlcs record and accumulate
1340: FOR k IN 1..num_mlcs LOOP
1341: mlcs_node := dbms_xmldom.item(mlcs_nl, (k-1)); -- indices run from 0 here
1342:
1343: -- each mlcs node has only mlcs attributes, gather them and create an mlcs record
1344: -- elements are easier to get attribute values out of.
1345: mlcs_elem := dbms_xmldom.makeElement(mlcs_node);

Line 1345: mlcs_elem := dbms_xmldom.makeElement(mlcs_node);

1341: mlcs_node := dbms_xmldom.item(mlcs_nl, (k-1)); -- indices run from 0 here
1342:
1343: -- each mlcs node has only mlcs attributes, gather them and create an mlcs record
1344: -- elements are easier to get attribute values out of.
1345: mlcs_elem := dbms_xmldom.makeElement(mlcs_node);
1346:
1347: -- get all attributes of each mlcs and accumulate in the collection
1348: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'start_date_time');
1349: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1348: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'start_date_time');

1344: -- elements are easier to get attribute values out of.
1345: mlcs_elem := dbms_xmldom.makeElement(mlcs_node);
1346:
1347: -- get all attributes of each mlcs and accumulate in the collection
1348: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'start_date_time');
1349: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1350: mlcs_tbl(k).start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1351: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'end_date_time');
1352: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1351: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'end_date_time');

1347: -- get all attributes of each mlcs and accumulate in the collection
1348: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'start_date_time');
1349: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1350: mlcs_tbl(k).start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1351: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'end_date_time');
1352: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1353: mlcs_tbl(k).end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1354:
1355: mlcs_tbl(k).type_type := dbms_xmldom.getAttribute(mlcs_elem, 'type_type');

Line 1355: mlcs_tbl(k).type_type := dbms_xmldom.getAttribute(mlcs_elem, 'type_type');

1351: date_str := dbms_xmldom.getAttribute(mlcs_elem, 'end_date_time');
1352: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1353: mlcs_tbl(k).end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1354:
1355: mlcs_tbl(k).type_type := dbms_xmldom.getAttribute(mlcs_elem, 'type_type');
1356: mlcs_tbl(k).type_id := dbms_xmldom.getAttribute(mlcs_elem, 'type_id');
1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');
1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;

Line 1356: mlcs_tbl(k).type_id := dbms_xmldom.getAttribute(mlcs_elem, 'type_id');

1352: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1353: mlcs_tbl(k).end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1354:
1355: mlcs_tbl(k).type_type := dbms_xmldom.getAttribute(mlcs_elem, 'type_type');
1356: mlcs_tbl(k).type_id := dbms_xmldom.getAttribute(mlcs_elem, 'type_id');
1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');
1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;
1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');

Line 1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');

1353: mlcs_tbl(k).end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1354:
1355: mlcs_tbl(k).type_type := dbms_xmldom.getAttribute(mlcs_elem, 'type_type');
1356: mlcs_tbl(k).type_id := dbms_xmldom.getAttribute(mlcs_elem, 'type_id');
1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');
1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;
1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');
1361: mlcs_tbl(k).resource_id := dbms_xmldom.getAttribute(mlcs_elem, 'resource_id');

Line 1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');

1354:
1355: mlcs_tbl(k).type_type := dbms_xmldom.getAttribute(mlcs_elem, 'type_type');
1356: mlcs_tbl(k).type_id := dbms_xmldom.getAttribute(mlcs_elem, 'type_id');
1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');
1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;
1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');
1361: mlcs_tbl(k).resource_id := dbms_xmldom.getAttribute(mlcs_elem, 'resource_id');
1362: mlcs_tbl(k).milcs_code := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_code');

Line 1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');

1356: mlcs_tbl(k).type_id := dbms_xmldom.getAttribute(mlcs_elem, 'type_id');
1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');
1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;
1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');
1361: mlcs_tbl(k).resource_id := dbms_xmldom.getAttribute(mlcs_elem, 'resource_id');
1362: mlcs_tbl(k).milcs_code := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_code');
1363:
1364: -- bulk attributes

Line 1361: mlcs_tbl(k).resource_id := dbms_xmldom.getAttribute(mlcs_elem, 'resource_id');

1357: mlcs_tbl(k).duration := dbms_xmldom.getAttribute(mlcs_elem, 'duration');
1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;
1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');
1361: mlcs_tbl(k).resource_id := dbms_xmldom.getAttribute(mlcs_elem, 'resource_id');
1362: mlcs_tbl(k).milcs_code := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_code');
1363:
1364: -- bulk attributes
1365: mlcs_tbl(k).bulk_writer_code := p_bulk_writer_code;

Line 1362: mlcs_tbl(k).milcs_code := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_code');

1358: mlcs_tbl(k).milcs_type_id := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_type_id');
1359: mlcs_tbl(k).media_id := med_id;
1360: mlcs_tbl(k).handler_id := dbms_xmldom.getAttribute(mlcs_elem, 'handler_id');
1361: mlcs_tbl(k).resource_id := dbms_xmldom.getAttribute(mlcs_elem, 'resource_id');
1362: mlcs_tbl(k).milcs_code := dbms_xmldom.getAttribute(mlcs_elem, 'milcs_code');
1363:
1364: -- bulk attributes
1365: mlcs_tbl(k).bulk_writer_code := p_bulk_writer_code;
1366: mlcs_tbl(k).bulk_batch_type := p_bulk_batch_type;

Line 1394: date_str := dbms_xmldom.getAttribute(med_elem, 'start_date_time');

1390:
1391: g_hrt_beat := 13.3;
1392:
1393: --c. get attributes of media node
1394: date_str := dbms_xmldom.getAttribute(med_elem, 'start_date_time');
1395: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1396: med_rec.start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1397: date_str := dbms_xmldom.getAttribute(med_elem, 'end_date_time');
1398: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1397: date_str := dbms_xmldom.getAttribute(med_elem, 'end_date_time');

1393: --c. get attributes of media node
1394: date_str := dbms_xmldom.getAttribute(med_elem, 'start_date_time');
1395: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1396: med_rec.start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1397: date_str := dbms_xmldom.getAttribute(med_elem, 'end_date_time');
1398: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1399: med_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1400: med_rec.media_id := med_id;
1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');

Line 1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');

1397: date_str := dbms_xmldom.getAttribute(med_elem, 'end_date_time');
1398: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1399: med_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1400: med_rec.media_id := med_id;
1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');
1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');
1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');
1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');
1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');

Line 1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');

1398: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1399: med_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1400: med_rec.media_id := med_id;
1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');
1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');
1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');
1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');
1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');
1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');

Line 1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');

1399: med_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1400: med_rec.media_id := med_id;
1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');
1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');
1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');
1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');
1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');
1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');
1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');

1400: med_rec.media_id := med_id;
1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');
1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');
1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');
1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');
1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');
1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');
1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);

Line 1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');

1401: med_rec.source_id := dbms_xmldom.getAttribute(med_elem, 'source_id');
1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');
1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');
1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');
1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');
1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');
1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');

Line 1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');

1402: med_rec.direction := dbms_xmldom.getAttribute(med_elem, 'direction');
1403: med_rec.duration := dbms_xmldom.getAttribute(med_elem, 'duration');
1404: med_rec.interaction_performed := dbms_xmldom.getAttribute(med_elem, 'interaction_performed');
1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');
1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');
1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');
1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');

Line 1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');

1405: med_rec.media_data := dbms_xmldom.getAttribute(med_elem, 'media_data');
1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');
1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');
1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');
1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');

Line 1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');

1406: date_str := dbms_xmldom.getAttribute(med_elem, 'source_item_create_date_time');
1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');
1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');
1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');

Line 1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');

1407: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');
1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');
1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');

Line 1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');

1408: med_rec.source_item_create_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');
1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');
1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');

Line 1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');

1409: med_rec.source_item_id := dbms_xmldom.getAttribute(med_elem, 'source_item_id');
1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');
1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');
1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');

Line 1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');

1410: med_rec.media_item_type := dbms_xmldom.getAttribute(med_elem, 'media_item_type');
1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');
1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');
1418: med_rec.address := dbms_xmldom.getAttribute(med_elem, 'address');

Line 1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');

1411: med_rec.media_item_ref := dbms_xmldom.getAttribute(med_elem, 'media_item_ref');
1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');
1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');
1418: med_rec.address := dbms_xmldom.getAttribute(med_elem, 'address');
1419:

Line 1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');

1412: med_rec.media_abandon_flag := dbms_xmldom.getAttribute(med_elem, 'media_abandon_flag');
1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');
1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');
1418: med_rec.address := dbms_xmldom.getAttribute(med_elem, 'address');
1419:
1420: -- bulk attributes

Line 1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');

1413: med_rec.media_transferred_flag := dbms_xmldom.getAttribute(med_elem, 'media_transferred_flag');
1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');
1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');
1418: med_rec.address := dbms_xmldom.getAttribute(med_elem, 'address');
1419:
1420: -- bulk attributes
1421: med_rec.bulk_writer_code := p_bulk_writer_code;

Line 1418: med_rec.address := dbms_xmldom.getAttribute(med_elem, 'address');

1414: med_rec.server_group_id := dbms_xmldom.getAttribute(med_elem, 'server_group_id');
1415: med_rec.dnis := dbms_xmldom.getAttribute(med_elem, 'dnis');
1416: med_rec.ani := dbms_xmldom.getAttribute(med_elem, 'ani');
1417: med_rec.classification := dbms_xmldom.getAttribute(med_elem, 'classification');
1418: med_rec.address := dbms_xmldom.getAttribute(med_elem, 'address');
1419:
1420: -- bulk attributes
1421: med_rec.bulk_writer_code := p_bulk_writer_code;
1422: med_rec.bulk_batch_type := p_bulk_batch_type;

Line 1615: -- act_nl - IN - dbms_xmldom.DomNodeList of act nodes

1611: -- Utility function to gather activity attributes for an interaction.
1612: --
1613: -- Parameters
1614: --
1615: -- act_nl - IN - dbms_xmldom.DomNodeList of act nodes
1616: -- p_bulk_interaction_id - IN - self explanatory
1617: -- p_bulk_writer_code - IN - self explanatory
1618: -- p_bulk_batch_type - IN - self explanatory
1619: -- p_bulk_batch_id - IN - self explanatory

Line 1627: act_nl IN dbms_xmldom.DomNodeList,

1623: -- x_ret_msg - OUT - self explanatory
1624: --
1625: PROCEDURE GATHER_ACT_TBL
1626: (
1627: act_nl IN dbms_xmldom.DomNodeList,
1628: p_bulk_interaction_id IN NUMBER,
1629: p_bulk_writer_code IN VARCHAR2,
1630: p_bulk_batch_type IN VARCHAR2,
1631: p_bulk_batch_id IN NUMBER,

Line 1639: act_node dbms_xmldom.DOMNode;

1635: x_ret_msg IN OUT NOCOPY VARCHAR2
1636: ) IS
1637:
1638: med_ident NUMBER;
1639: act_node dbms_xmldom.DOMNode;
1640: act_elem dbms_xmldom.DOMElement;
1641: act_rec JTF_IH_PUB.activity_rec_type;
1642: med_id NUMBER;
1643: act_id NUMBER;

Line 1640: act_elem dbms_xmldom.DOMElement;

1636: ) IS
1637:
1638: med_ident NUMBER;
1639: act_node dbms_xmldom.DOMNode;
1640: act_elem dbms_xmldom.DOMElement;
1641: act_rec JTF_IH_PUB.activity_rec_type;
1642: med_id NUMBER;
1643: act_id NUMBER;
1644:

Line 1651: 'act_nl TYPE dbms_xmldom.DomNodeList'||

1647: BEGIN
1648:
1649: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1650: l_fnd_log_msg := 'GATHER_ACT_TBL In parameters :'||
1651: 'act_nl TYPE dbms_xmldom.DomNodeList'||
1652: ', p_bulk_interaction_id = '|| p_bulk_interaction_id ||
1653: ', p_bulk_writer_code = '|| p_bulk_writer_code||
1654: ', p_bulk_batch_type = '|| p_bulk_batch_type ||
1655: ', p_bulk_batch_id = '|| p_bulk_batch_id ||

Line 1671: num_act := dbms_xmldom.getLength(act_nl);

1667: a.gather each activity's attributes, including media_id using the mapping from b.1.ii.e
1668: b.create a Activity record and save
1669: */
1670:
1671: num_act := dbms_xmldom.getLength(act_nl);
1672:
1673: --ii.for each media node
1674: FOR j IN 1..num_act LOOP
1675: act_node := dbms_xmldom.item(act_nl, j-1);

Line 1675: act_node := dbms_xmldom.item(act_nl, j-1);

1671: num_act := dbms_xmldom.getLength(act_nl);
1672:
1673: --ii.for each media node
1674: FOR j IN 1..num_act LOOP
1675: act_node := dbms_xmldom.item(act_nl, j-1);
1676:
1677: -- an element is easier to get attribute values from
1678: act_elem := dbms_xmldom.makeElement(act_node);
1679:

Line 1678: act_elem := dbms_xmldom.makeElement(act_node);

1674: FOR j IN 1..num_act LOOP
1675: act_node := dbms_xmldom.item(act_nl, j-1);
1676:
1677: -- an element is easier to get attribute values from
1678: act_elem := dbms_xmldom.makeElement(act_node);
1679:
1680: -- get the media identifier if available
1681: med_id := NULL;
1682: med_ident := dbms_xmldom.getAttribute(act_elem, 'mediaitem_identifier');

Line 1682: med_ident := dbms_xmldom.getAttribute(act_elem, 'mediaitem_identifier');

1678: act_elem := dbms_xmldom.makeElement(act_node);
1679:
1680: -- get the media identifier if available
1681: med_id := NULL;
1682: med_ident := dbms_xmldom.getAttribute(act_elem, 'mediaitem_identifier');
1683: IF (med_ident IS NOT NULL) THEN
1684: -- get the corresponding media_id from the med_id_tbl
1685: med_id := med_id_tbl(med_ident);
1686: END IF;

Line 1692: date_str := dbms_xmldom.getAttribute(act_elem, 'start_date_time');

1688:
1689: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'media_id and media_ident values are ' || med_id || ', ' || med_ident);
1690:
1691: --a.gather each activity's attributes, including media_id using the mapping from b.1.ii.e
1692: date_str := dbms_xmldom.getAttribute(act_elem, 'start_date_time');
1693: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1694: x_act_tbl(j).start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1695: date_str := dbms_xmldom.getAttribute(act_elem, 'end_date_time');
1696: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1695: date_str := dbms_xmldom.getAttribute(act_elem, 'end_date_time');

1691: --a.gather each activity's attributes, including media_id using the mapping from b.1.ii.e
1692: date_str := dbms_xmldom.getAttribute(act_elem, 'start_date_time');
1693: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1694: x_act_tbl(j).start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1695: date_str := dbms_xmldom.getAttribute(act_elem, 'end_date_time');
1696: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1697: x_act_tbl(j).end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1698:
1699: IF (med_id IS NOT NULL) THEN

Line 1703: x_act_tbl(j).cust_account_id := dbms_xmldom.getAttribute(act_elem, 'cust_account_id');

1699: IF (med_id IS NOT NULL) THEN
1700: x_act_tbl(j).media_id := med_id;
1701: END IF;
1702:
1703: x_act_tbl(j).cust_account_id := dbms_xmldom.getAttribute(act_elem, 'cust_account_id');
1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');
1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');

Line 1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');

1700: x_act_tbl(j).media_id := med_id;
1701: END IF;
1702:
1703: x_act_tbl(j).cust_account_id := dbms_xmldom.getAttribute(act_elem, 'cust_account_id');
1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');
1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');

Line 1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');

1701: END IF;
1702:
1703: x_act_tbl(j).cust_account_id := dbms_xmldom.getAttribute(act_elem, 'cust_account_id');
1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');
1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');

Line 1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');

1702:
1703: x_act_tbl(j).cust_account_id := dbms_xmldom.getAttribute(act_elem, 'cust_account_id');
1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');
1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');

Line 1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');

1703: x_act_tbl(j).cust_account_id := dbms_xmldom.getAttribute(act_elem, 'cust_account_id');
1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');
1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');

Line 1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');

1704: x_act_tbl(j).cust_org_id := dbms_xmldom.getAttribute(act_elem, 'cust_org_id');
1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');

Line 1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');

1705: x_act_tbl(j).role := dbms_xmldom.getAttribute(act_elem, 'role');
1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');

Line 1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');

1706: x_act_tbl(j).task_id := dbms_xmldom.getAttribute(act_elem, 'task_id');
1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');

Line 1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');

1707: x_act_tbl(j).doc_id := dbms_xmldom.getAttribute(act_elem, 'doc_id');
1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');

Line 1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');

1708: x_act_tbl(j).doc_ref := dbms_xmldom.getAttribute(act_elem, 'doc_ref');
1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');

Line 1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');

1709: x_act_tbl(j).doc_source_object_name := dbms_xmldom.getAttribute(act_elem, 'doc_source_object_name');
1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');

Line 1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');

1710: x_act_tbl(j).action_item_id := dbms_xmldom.getAttribute(act_elem, 'action_item_id');
1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');

Line 1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');

1711: x_act_tbl(j).outcome_id := dbms_xmldom.getAttribute(act_elem, 'outcome_id');
1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');

Line 1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');

1712: x_act_tbl(j).result_id := dbms_xmldom.getAttribute(act_elem, 'result_id');
1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');

Line 1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');

1713: x_act_tbl(j).reason_id := dbms_xmldom.getAttribute(act_elem, 'reason_id');
1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');

Line 1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');

1714: x_act_tbl(j).description := dbms_xmldom.getAttribute(act_elem, 'description');
1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');

Line 1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');

1715: x_act_tbl(j).action_id := dbms_xmldom.getAttribute(act_elem, 'action_id');
1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');

Line 1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');

1716: x_act_tbl(j).interaction_action_type := dbms_xmldom.getAttribute(act_elem, 'interaction_action_type');
1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');

Line 1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');

1717: x_act_tbl(j).object_id := dbms_xmldom.getAttribute(act_elem, 'object_id');
1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');

Line 1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');

1718: x_act_tbl(j).object_type := dbms_xmldom.getAttribute(act_elem, 'object_type');
1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');

Line 1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');

1719: x_act_tbl(j).source_code_id := dbms_xmldom.getAttribute(act_elem, 'source_code_id');
1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');

Line 1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');

1720: x_act_tbl(j).source_code := dbms_xmldom.getAttribute(act_elem, 'source_code');
1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');

Line 1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');

1721: x_act_tbl(j).script_trans_id := dbms_xmldom.getAttribute(act_elem, 'script_trans_id');
1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');

Line 1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');

1722: x_act_tbl(j).attribute1 := dbms_xmldom.getAttribute(act_elem, 'attribute1');
1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');

Line 1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');

1723: x_act_tbl(j).attribute2 := dbms_xmldom.getAttribute(act_elem, 'attribute2');
1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');

Line 1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');

1724: x_act_tbl(j).attribute3 := dbms_xmldom.getAttribute(act_elem, 'attribute3');
1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');

Line 1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');

1725: x_act_tbl(j).attribute4 := dbms_xmldom.getAttribute(act_elem, 'attribute4');
1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');

Line 1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');

1726: x_act_tbl(j).attribute5 := dbms_xmldom.getAttribute(act_elem, 'attribute5');
1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');

Line 1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');

1727: x_act_tbl(j).attribute6 := dbms_xmldom.getAttribute(act_elem, 'attribute6');
1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');

Line 1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');

1728: x_act_tbl(j).attribute7 := dbms_xmldom.getAttribute(act_elem, 'attribute7');
1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');
1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');

Line 1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');

1729: x_act_tbl(j).attribute8 := dbms_xmldom.getAttribute(act_elem, 'attribute8');
1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');
1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');
1737: x_act_tbl(j).attribute_category := dbms_xmldom.getAttribute(act_elem, 'attribute_category');

Line 1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');

1730: x_act_tbl(j).attribute9 := dbms_xmldom.getAttribute(act_elem, 'attribute9');
1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');
1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');
1737: x_act_tbl(j).attribute_category := dbms_xmldom.getAttribute(act_elem, 'attribute_category');
1738:

Line 1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');

1731: x_act_tbl(j).attribute10 := dbms_xmldom.getAttribute(act_elem, 'attribute10');
1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');
1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');
1737: x_act_tbl(j).attribute_category := dbms_xmldom.getAttribute(act_elem, 'attribute_category');
1738:
1739: -- bulk attributes

Line 1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');

1732: x_act_tbl(j).attribute11 := dbms_xmldom.getAttribute(act_elem, 'attribute11');
1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');
1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');
1737: x_act_tbl(j).attribute_category := dbms_xmldom.getAttribute(act_elem, 'attribute_category');
1738:
1739: -- bulk attributes
1740: x_act_tbl(j).bulk_writer_code := p_bulk_writer_code;

Line 1737: x_act_tbl(j).attribute_category := dbms_xmldom.getAttribute(act_elem, 'attribute_category');

1733: x_act_tbl(j).attribute12 := dbms_xmldom.getAttribute(act_elem, 'attribute12');
1734: x_act_tbl(j).attribute13 := dbms_xmldom.getAttribute(act_elem, 'attribute13');
1735: x_act_tbl(j).attribute14 := dbms_xmldom.getAttribute(act_elem, 'attribute14');
1736: x_act_tbl(j).attribute15 := dbms_xmldom.getAttribute(act_elem, 'attribute15');
1737: x_act_tbl(j).attribute_category := dbms_xmldom.getAttribute(act_elem, 'attribute_category');
1738:
1739: -- bulk attributes
1740: x_act_tbl(j).bulk_writer_code := p_bulk_writer_code;
1741: x_act_tbl(j).bulk_batch_type := p_bulk_batch_type;

Line 1796: -- int_elem - IN - dbms_xmldom.DomElement, with xml data

1792: -- Utility function to gather all interaction attributes from xml.
1793: --
1794: -- Parameters
1795: --
1796: -- int_elem - IN - dbms_xmldom.DomElement, with xml data
1797: -- p_bulk_interaction_id - IN - self explanatory
1798: -- p_bulk_writer_code - IN - self explanatory
1799: -- p_bulk_batch_type - IN - self explanatory
1800: -- p_bulk_batch_id - IN - self explanatory

Line 1807: int_elem IN dbms_xmldom.DomElement,

1803: -- x_ret_msg - OUT - self explanatory
1804: --
1805: PROCEDURE GATHER_INT_ATTR
1806: (
1807: int_elem IN dbms_xmldom.DomElement,
1808: p_bulk_interaction_id IN NUMBER,
1809: p_bulk_writer_code IN VARCHAR2,
1810: p_bulk_batch_type IN VARCHAR2,
1811: p_bulk_batch_id IN NUMBER,

Line 1821: 'int_elem TYPE dbms_xmldom.DomElement'||

1817: BEGIN
1818:
1819: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1820: l_fnd_log_msg := 'GATHER_INT_ATTR In parameters :'||
1821: 'int_elem TYPE dbms_xmldom.DomElement'||
1822: ', p_bulk_interaction_id = '|| p_bulk_interaction_id ||
1823: ', p_bulk_writer_code = '|| p_bulk_writer_code||
1824: ', p_bulk_batch_type = '|| p_bulk_batch_type ||
1825: ', p_bulk_batch_id = '|| p_bulk_batch_id ||

Line 1834: date_str := dbms_xmldom.getAttribute(int_elem, 'start_date_time');

1830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1831: 'jtf.plsql.JTF_IH_BULK.GATHER_INT_ATTR.begin', l_fnd_log_msg);
1832: END IF;
1833:
1834: date_str := dbms_xmldom.getAttribute(int_elem, 'start_date_time');
1835: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1836: x_int_rec.start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1837: date_str := dbms_xmldom.getAttribute(int_elem, 'end_date_time');
1838: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date

Line 1837: date_str := dbms_xmldom.getAttribute(int_elem, 'end_date_time');

1833:
1834: date_str := dbms_xmldom.getAttribute(int_elem, 'start_date_time');
1835: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1836: x_int_rec.start_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1837: date_str := dbms_xmldom.getAttribute(int_elem, 'end_date_time');
1838: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1839: x_int_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1840:
1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');

Line 1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');

1837: date_str := dbms_xmldom.getAttribute(int_elem, 'end_date_time');
1838: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1839: x_int_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1840:
1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');
1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');
1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');

Line 1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');

1838: -- RDD - Bug 5330922 - Removed the call to convert GMT input to server date - Input now in Server Date
1839: x_int_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1840:
1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');
1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');
1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');

Line 1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');

1839: x_int_rec.end_date_time := TO_DATE(date_str, G_DATE_FORMAT);
1840:
1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');
1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');
1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');

Line 1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');

1840:
1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');
1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');
1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');

Line 1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');

1841: x_int_rec.reference_form := dbms_xmldom.getAttribute(int_elem, 'reference_form');
1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');
1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');

Line 1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');

1842: x_int_rec.follow_up_action := dbms_xmldom.getAttribute(int_elem, 'follow_up_action');
1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');

Line 1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');

1843: x_int_rec.duration := dbms_xmldom.getAttribute(int_elem, 'duration');
1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');

Line 1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');

1844: x_int_rec.inter_interaction_duration := dbms_xmldom.getAttribute(int_elem, 'inter_interaction_duration');
1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');

Line 1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');

1845: x_int_rec.non_productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'non_productive_time_amount');
1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');

Line 1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');

1846: x_int_rec.preview_time_amount := dbms_xmldom.getAttribute(int_elem, 'preview_time_amount');
1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');

Line 1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');

1847: x_int_rec.productive_time_amount := dbms_xmldom.getAttribute(int_elem, 'productive_time_amount');
1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');

Line 1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');

1848: x_int_rec.wrapup_time_amount := dbms_xmldom.getAttribute(int_elem, 'wrap_Up_time_amount');
1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');

Line 1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');

1849: x_int_rec.handler_id := dbms_xmldom.getAttribute(int_elem, 'handler_id');
1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');

Line 1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');

1850: x_int_rec.script_id := dbms_xmldom.getAttribute(int_elem, 'script_id');
1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');

Line 1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');

1851: x_int_rec.outcome_id := dbms_xmldom.getAttribute(int_elem, 'outcome_id');
1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');

Line 1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');

1852: x_int_rec.result_id := dbms_xmldom.getAttribute(int_elem, 'result_id');
1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');

Line 1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');

1853: x_int_rec.reason_id := dbms_xmldom.getAttribute(int_elem, 'reason_id');
1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');

Line 1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');

1854: x_int_rec.resource_id := dbms_xmldom.getAttribute(int_elem, 'resource_id');
1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');

Line 1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');

1855: x_int_rec.party_id := dbms_xmldom.getAttribute(int_elem, 'party_id');
1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');

Line 1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');

1856: x_int_rec.parent_id := dbms_xmldom.getAttribute(int_elem, 'parent_id');
1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');

Line 1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');

1857: x_int_rec.object_id := dbms_xmldom.getAttribute(int_elem, 'object_id');
1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');

Line 1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');

1858: x_int_rec.object_type := dbms_xmldom.getAttribute(int_elem, 'object_type');
1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');

Line 1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');

1859: x_int_rec.source_code_id := dbms_xmldom.getAttribute(int_elem, 'source_code_id');
1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');

Line 1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');

1860: x_int_rec.source_code := dbms_xmldom.getAttribute(int_elem, 'source_code');
1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');

Line 1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');

1861: x_int_rec.attribute1 := dbms_xmldom.getAttribute(int_elem, 'attribute1');
1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');

Line 1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');

1862: x_int_rec.attribute2 := dbms_xmldom.getAttribute(int_elem, 'attribute2');
1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');

Line 1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');

1863: x_int_rec.attribute3 := dbms_xmldom.getAttribute(int_elem, 'attribute3');
1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');

Line 1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');

1864: x_int_rec.attribute4 := dbms_xmldom.getAttribute(int_elem, 'attribute4');
1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');

Line 1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');

1865: x_int_rec.attribute5 := dbms_xmldom.getAttribute(int_elem, 'attribute5');
1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');

Line 1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');

1866: x_int_rec.attribute6 := dbms_xmldom.getAttribute(int_elem, 'attribute6');
1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');

Line 1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');

1867: x_int_rec.attribute7 := dbms_xmldom.getAttribute(int_elem, 'attribute7');
1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');

Line 1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');

1868: x_int_rec.attribute8 := dbms_xmldom.getAttribute(int_elem, 'attribute8');
1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');

Line 1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');

1869: x_int_rec.attribute9 := dbms_xmldom.getAttribute(int_elem, 'attribute9');
1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');

Line 1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');

1870: x_int_rec.attribute10 := dbms_xmldom.getAttribute(int_elem, 'attribute10');
1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');

Line 1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');

1871: x_int_rec.attribute11 := dbms_xmldom.getAttribute(int_elem, 'attribute11');
1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');
1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');

Line 1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');

1872: x_int_rec.attribute12 := dbms_xmldom.getAttribute(int_elem, 'attribute12');
1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');
1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');
1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');

Line 1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');

1873: x_int_rec.attribute13 := dbms_xmldom.getAttribute(int_elem, 'attribute13');
1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');
1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');
1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');
1881:

Line 1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');

1874: x_int_rec.attribute14 := dbms_xmldom.getAttribute(int_elem, 'attribute14');
1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');
1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');
1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');
1881:
1882: --

Line 1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');

1875: x_int_rec.attribute15 := dbms_xmldom.getAttribute(int_elem, 'attribute15');
1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');
1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');
1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');
1881:
1882: --
1883: -- These two are defaulted, plus they are not exposed so ignore them

Line 1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');

1876: x_int_rec.attribute_category := dbms_xmldom.getAttribute(int_elem, 'attribute_category');
1877: x_int_rec.method_code := dbms_xmldom.getAttribute(int_elem, 'method_code');
1878: x_int_rec.primary_party_id := dbms_xmldom.getAttribute(int_elem, 'primary_party_id');
1879: x_int_rec.contact_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_party_id');
1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');
1881:
1882: --
1883: -- These two are defaulted, plus they are not exposed so ignore them
1884: --x_int_rec.touchpoint1_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint1_type');

Line 1884: --x_int_rec.touchpoint1_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint1_type');

1880: x_int_rec.contact_rel_party_id := dbms_xmldom.getAttribute(int_elem, 'contact_rel_party_id');
1881:
1882: --
1883: -- These two are defaulted, plus they are not exposed so ignore them
1884: --x_int_rec.touchpoint1_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint1_type');
1885: --x_int_rec.touchpoint2_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint2_type');
1886: --
1887:
1888: -- bulk ids

Line 1885: --x_int_rec.touchpoint2_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint2_type');

1881:
1882: --
1883: -- These two are defaulted, plus they are not exposed so ignore them
1884: --x_int_rec.touchpoint1_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint1_type');
1885: --x_int_rec.touchpoint2_type := dbms_xmldom.getAttribute(int_elem, 'touchpoint2_type');
1886: --
1887:
1888: -- bulk ids
1889: x_int_rec.bulk_writer_code := p_bulk_writer_code;

Line 1912: -- int_node - IN - dbms_xmldom.DomNode, with interaction xml data

1908: -- Utility function to gather all interaction attributes from xml.
1909: --
1910: -- Parameters
1911: --
1912: -- int_node - IN - dbms_xmldom.DomNode, with interaction xml data
1913: -- p_bulk_writer_code - IN - self explanatory
1914: -- p_bulk_batch_type - IN - self explanatory
1915: -- p_bulk_batch_id - IN - self explanatory
1916: -- p_bulk_interaction_id - IN - self explanatory

Line 1920: -- N O T E - It would be simpler if we could use dbms_xmldom.WriteToClob() to convert

1916: -- p_bulk_interaction_id - IN - self explanatory
1917: -- p_error_msg - IN - message describing what failed
1918: -- p_ret_msg - IN - message describing underlying cause
1919: --
1920: -- N O T E - It would be simpler if we could use dbms_xmldom.WriteToClob() to convert
1921: -- the p_int_node into a CLOB and then call the version 2 of this
1922: -- routine. But, that does not seem possible because a CLOB locator
1923: -- has to be tied to db column.
1924: --

Line 1927: p_int_node IN dbms_xmldom.DOMNode,

1923: -- has to be tied to db column.
1924: --
1925: FUNCTION LOG_BULK_ERROR
1926: (
1927: p_int_node IN dbms_xmldom.DOMNode,
1928: p_bulk_writer_code IN VARCHAR2,
1929: p_bulk_batch_type IN VARCHAR2,
1930: p_bulk_batch_id IN NUMBER,
1931: p_bulk_interaction_id IN NUMBER,

Line 1947: 'p_int_node TYPE dbms_xmldom.DOMNode' ||

1943: BEGIN
1944:
1945: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1946: l_fnd_log_msg := 'FUNCTION LOG_BULK_ERROR In parameters :'||
1947: 'p_int_node TYPE dbms_xmldom.DOMNode' ||
1948: ', p_bulk_writer_code = '|| p_bulk_writer_code||
1949: ', p_bulk_batch_type = '|| p_bulk_batch_type ||
1950: ', p_bulk_batch_id = '|| p_bulk_batch_id ||
1951: ', p_bulk_interaction_id = '|| p_bulk_interaction_id ||

Line 1999: dbms_xmldom.writeToClob(p_int_node, bad_int_clob);

1995: WHERE bulk_error_id = rec_id;
1996:
1997: bad_int_clob := 'AAAA';
1998:
1999: dbms_xmldom.writeToClob(p_int_node, bad_int_clob);
2000:
2001: UPDATE jtf_ih_bulk_errors
2002: SET inter_req_xml_doc = bad_int_clob
2003: WHERE bulk_error_id = rec_id;