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 JTF_IH_PUB

Line 628: int_rec JTF_IH_PUB.INTERACTION_REC_TYPE;

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;
632: med_nl dbms_xmldom.DOMNodeList;

Line 638: act_tbl JTF_IH_PUB.ACTIVITY_TBL_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;
642: l_user_id NUMBER;

Line 769: call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs

765: a. get childNodes (they would be MLCS)
766: b. for each mlcs node, create a mlcs record and accumulate
767: c. get attributes of media node
768: d. if MEDIA_ID value is not set for the media item,
769: call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs
770: e. if MEDIA_ID is already set, call the Add_MediaLifeCycle and
771: Close_MediaItem methods
772: f. keep track of mediaitem_identifier to media_id values
773: iii.get all Activity nodes from this doc now.

Line 779: 3. call JTF_IH_PUB.Create_Interaction using attr and activity records

775: a.gather each activity's attrs, incl media_id using the mapping from
776: b.1.ii.e
777: b.create a Activity record and save
778: 2. gather all interaction attributes
779: 3. call JTF_IH_PUB.Create_Interaction using attr and activity records
780: 4. release the interaction document resource.
781: c. any errors in recording an interatn will result in logging the interactn
782: to the error table.
783: d. clean up and return.

Line 803: 3. call JTF_IH_PUB.Create_Interaction using attr and activity records

799: ...
800: iii.get all Activity nodes from this doc now.
801: ...
802: 2. gather all interaction attributes
803: 3. call JTF_IH_PUB.Create_Interaction using attr and activity records
804: */
805: FOR i IN p_int_offset..num_int-1 LOOP
806: l_error_msgLOG := '';
807: BEGIN -- dummy block

Line 933: --3. call JTF_IH_PUB.Create_Interaction using attr and activity records

929:
930: -- media nodes are done and we have gathered activities,
931: -- if there were no errors, we would be here so process the interaction now
932: --2. gather all interaction attributes
933: --3. call JTF_IH_PUB.Create_Interaction using attr and activity records
934: GATHER_INT_ATTR(int_elem, l_bulk_interaction_id, p_bulk_writer_code,
935: p_bulk_batch_type, p_bulk_batch_id, int_rec,
936: l_ret_status, l_ret_msg);
937:

Line 962: JTF_IH_PUB.Create_Interaction(p_api_version => 1.0,

958: -- and log any errors.
959:
960: g_hrt_beat := 9;
961:
962: JTF_IH_PUB.Create_Interaction(p_api_version => 1.0,
963: p_init_msg_list => FND_API.G_TRUE,
964: p_commit => FND_API.G_FALSE,
965: p_user_id => l_user_id,
966: x_return_status => l_ret_status,

Line 1255: med_rec JTF_IH_PUB.media_rec_type;

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;
1258: med_id number;
1259: l_milcs_id number;

Line 1256: mlcs_rec JTF_IH_PUB.media_lc_rec_type;

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;
1258: med_id number;
1259: l_milcs_id number;
1260:

Line 1257: mlcs_tbl JTF_IH_PUB.mlcs_tbl_type;

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;
1258: med_id number;
1259: l_milcs_id number;
1260:
1261: date_str VARCHAR2(50);

Line 1297: call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs

1293: a. get childNodes (they would be MLCS)
1294: b. for each mlcs node, create a mlcs record and accumulate
1295: c. get attributes of media node
1296: d. if MEDIA_ID value is not set for the media item,
1297: call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs
1298: e. if MEDIA_ID is already set, call the Add_MediaLifeCycle and
1299: Close_MediaItem methods
1300: f. keep track of mediaitem_identifier to media_id values
1301: */

Line 1459: -- call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs

1455:
1456: -- we have all attributes and any mlcs records of one media item, create it
1457:
1458: --d. if MEDIA_ID value is not set for the media item,
1459: -- call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs
1460: IF (l_media_id_given = FALSE) THEN
1461: JTF_IH_PUB.create_mediaitem(p_api_version => 1.0,
1462: p_init_msg_list => FND_API.G_TRUE,
1463: p_commit => FND_API.G_FALSE,

Line 1461: JTF_IH_PUB.create_mediaitem(p_api_version => 1.0,

1457:
1458: --d. if MEDIA_ID value is not set for the media item,
1459: -- call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs
1460: IF (l_media_id_given = FALSE) THEN
1461: JTF_IH_PUB.create_mediaitem(p_api_version => 1.0,
1462: p_init_msg_list => FND_API.G_TRUE,
1463: p_commit => FND_API.G_FALSE,
1464: p_user_id => p_user_id,
1465: x_return_status => l_ret_status,

Line 1487: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,

1483: ELSE -- IF (l_media_id_given = TRUE)
1484: g_hrt_beat := 13.5;
1485: -- loop through all mlcs records and create them
1486: FOR l IN 1..mlcs_tbl.COUNT LOOP
1487: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
1488: p_init_msg_list => FND_API.G_TRUE,
1489: p_commit => FND_API.G_FALSE,
1490: p_user_id => p_user_id,
1491: x_return_status => l_ret_status,

Line 1506: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,

1502: END IF;
1503: END LOOP;
1504:
1505: -- now update the media item and close it as well.
1506: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
1507: p_init_msg_list => FND_API.G_TRUE,
1508: p_commit => FND_API.G_FALSE,
1509: p_user_id => p_user_id,
1510: x_return_status => l_ret_status,

Line 1544: -- this exception is raised if any of the JTF_IH_PUB's media calls fail.

1540: 'jtf.plsql.JTF_IH_BULK.PROCESS_MEDIA_ITEMS.end', l_fnd_log_msg);
1541: END IF;
1542:
1543: EXCEPTION
1544: -- this exception is raised if any of the JTF_IH_PUB's media calls fail.
1545: WHEN media_exception THEN
1546:
1547: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1548: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_MEDIA_FAIL2');

Line 1633: x_act_tbl IN OUT NOCOPY JTF_IH_PUB.ACTIVITY_TBL_TYPE,

1629: p_bulk_writer_code IN VARCHAR2,
1630: p_bulk_batch_type IN VARCHAR2,
1631: p_bulk_batch_id IN NUMBER,
1632: med_id_tbl IN media_id_trkr_type,
1633: x_act_tbl IN OUT NOCOPY JTF_IH_PUB.ACTIVITY_TBL_TYPE,
1634: x_ret_status IN OUT NOCOPY VARCHAR2,
1635: x_ret_msg IN OUT NOCOPY VARCHAR2
1636: ) IS
1637:

Line 1641: act_rec JTF_IH_PUB.activity_rec_type;

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:
1645: date_str VARCHAR2(50);

Line 1657: ', x_act_tbl TYPE JTF_IH_PUB.ACTIVITY_TBL_TYPE' ||

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 ||
1656: ', x_med_id_tbl TYPE media_id_trkr_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER' ||
1657: ', x_act_tbl TYPE JTF_IH_PUB.ACTIVITY_TBL_TYPE' ||
1658: ', x_ret_status = '|| x_ret_status ||
1659: ', x_ret_msg = '|| x_ret_msg;
1660: --dbms_output.put_line(l_fnd_log_msg);
1661: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1750: 'x_act_tbl TYPE JTF_IH_PUB.ACTIVITY_TBL_TYPE' ||

1746: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1747:
1748: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1749: l_fnd_log_msg := 'GATHER_ACT_TBL Out parameters :'||
1750: 'x_act_tbl TYPE JTF_IH_PUB.ACTIVITY_TBL_TYPE' ||
1751: ', x_ret_status = '|| x_ret_status ||
1752: ', x_ret_msg = '|| x_ret_msg;
1753: --dbms_output.put_line(l_fnd_log_msg);
1754: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1812: x_int_rec IN OUT NOCOPY JTF_IH_PUB.INTERACTION_REC_TYPE,

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,
1812: x_int_rec IN OUT NOCOPY JTF_IH_PUB.INTERACTION_REC_TYPE,
1813: x_ret_status IN OUT NOCOPY VARCHAR2,
1814: x_ret_msg IN OUT NOCOPY VARCHAR2
1815: ) IS
1816: date_str VARCHAR2(50);

Line 1826: ', x_int_rec TYPE JTF_IH_PUB.INTERACTION_REC_TYPE'||

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 ||
1826: ', x_int_rec TYPE JTF_IH_PUB.INTERACTION_REC_TYPE'||
1827: ', x_ret_status = '|| x_ret_status ||
1828: ', x_ret_msg = '|| x_ret_msg;
1829: --dbms_output.put_line(l_fnd_log_msg);
1830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1898: 'x_int_rec TYPE JTF_IH_PUB.INTERACTION_REC_TYPE'||

1894: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1895:
1896: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1897: l_fnd_log_msg := 'GATHER_INT_ATTR Out parameters :'||
1898: 'x_int_rec TYPE JTF_IH_PUB.INTERACTION_REC_TYPE'||
1899: 'x_ret_status = '|| x_ret_status ||
1900: 'x_ret_msg = '|| x_ret_msg;
1901: --dbms_output.put_line(l_fnd_log_msg);
1902: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,