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.CST_PENDINGTXNSREPORT_PVT dependencies on DBMS_XMLGEN

Line 551: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

547: USING l_org_code, l_period_name, l_resolution_type, i_transaction_type;
548:
549: /* create new context */
550: l_stmt_num := 40;
551: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
552: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
553: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
554:
555: /* get XML */

Line 552: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');

548:
549: /* create new context */
550: l_stmt_num := 40;
551: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
552: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
553: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
554:
555: /* get XML */
556: l_stmt_num := 50;

Line 553: DBMS_XMLGEN.setRowTag (l_ctx, NULL);

549: /* create new context */
550: l_stmt_num := 40;
551: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
552: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
553: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
554:
555: /* get XML */
556: l_stmt_num := 50;
557: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 557: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

553: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
554:
555: /* get XML */
556: l_stmt_num := 50;
557: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
558:
559: /* Add the XML header as the first line of output. add data to end */
560: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
561: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,

Line 560: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

556: l_stmt_num := 50;
557: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
558:
559: /* Add the XML header as the first line of output. add data to end */
560: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
561: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
562: pattern => '>',
563: offset => 1,
564: nth => 1);

Line 573: DBMS_XMLGEN.closeContext(l_ctx);

569: DBMS_LOB.append (x_xml_doc, l_xml_temp);
570: END IF;
571:
572: /* close context and free memory */
573: DBMS_XMLGEN.closeContext(l_ctx);
574: CLOSE l_ref_cur;
575: DBMS_LOB.FREETEMPORARY (l_xml_temp);
576:
577: -- Standard call to get message count and if count is 1, get message info.

Line 737: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

733: USING i_org_id, i_period_end_date;
734:
735: /* create new context */
736: l_stmt_num := 20;
737: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
738: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');
739: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
740:
741: /* get XML */

Line 738: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');

734:
735: /* create new context */
736: l_stmt_num := 20;
737: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
738: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');
739: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
740:
741: /* get XML */
742: l_stmt_num := 30;

Line 739: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');

735: /* create new context */
736: l_stmt_num := 20;
737: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
738: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');
739: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
740:
741: /* get XML */
742: l_stmt_num := 30;
743: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 743: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

739: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
740:
741: /* get XML */
742: l_stmt_num := 30;
743: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
744:
745: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
746: /* remove the header and append the rest to xml output */
747: IF (x_record_count > 0) THEN

Line 745: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

741: /* get XML */
742: l_stmt_num := 30;
743: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
744:
745: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
746: /* remove the header and append the rest to xml output */
747: IF (x_record_count > 0) THEN
748: /* Find the number of characters in the header and delete
749: them. Header ends with '>'. Hence find first occurrence of

Line 759: DBMS_XMLGEN.closeContext(l_ctx);

755: DBMS_LOB.erase (l_xml_temp, l_offset, 1);
756: DBMS_LOB.append (x_xml_doc, l_xml_temp);
757: END IF;
758: /* close context and free memory */
759: DBMS_XMLGEN.closeContext(l_ctx);
760: CLOSE l_ref_cur;
761: DBMS_LOB.FREETEMPORARY (l_xml_temp);
762:
763: -- Standard call to get message count and if count is 1, get message info.

Line 900: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

896: USING i_org_id, i_period_end_date;
897:
898: /* create new context */
899: l_stmt_num := 20;
900: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
901: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');
902: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
903:
904: /* get XML */

Line 901: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');

897:
898: /* create new context */
899: l_stmt_num := 20;
900: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
901: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');
902: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
903:
904: /* get XML */
905: l_stmt_num := 30;

Line 902: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');

898: /* create new context */
899: l_stmt_num := 20;
900: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
901: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');
902: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
903:
904: /* get XML */
905: l_stmt_num := 30;
906: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 906: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

902: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
903:
904: /* get XML */
905: l_stmt_num := 30;
906: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
907:
908: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
909: /* remove the header and append the rest to xml output */
910: IF (x_record_count > 0) THEN

Line 908: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

904: /* get XML */
905: l_stmt_num := 30;
906: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
907:
908: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
909: /* remove the header and append the rest to xml output */
910: IF (x_record_count > 0) THEN
911: /* Find the number of characters in the header and delete
912: them. Header ends with '>'. Hence find first occurrence of

Line 923: DBMS_XMLGEN.closeContext(l_ctx);

919: DBMS_LOB.append (x_xml_doc, l_xml_temp);
920: END IF;
921:
922: /* close context and free memory */
923: DBMS_XMLGEN.closeContext(l_ctx);
924: CLOSE l_ref_cur;
925: DBMS_LOB.FREETEMPORARY (l_xml_temp);
926:
927: -- Standard call to get message count and if count is 1, get message info.

Line 1069: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1065: USING i_org_id, i_period_end_date;
1066:
1067: /* create new context */
1068: l_stmt_num := 20;
1069: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1070: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');
1071: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1072:
1073: /* get XML */

Line 1070: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');

1066:
1067: /* create new context */
1068: l_stmt_num := 20;
1069: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1070: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');
1071: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1072:
1073: /* get XML */
1074: l_stmt_num := 30;

Line 1071: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');

1067: /* create new context */
1068: l_stmt_num := 20;
1069: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1070: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');
1071: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1072:
1073: /* get XML */
1074: l_stmt_num := 30;
1075: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 1075: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

1071: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1072:
1073: /* get XML */
1074: l_stmt_num := 30;
1075: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1076:
1077: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1078: /* remove the header and append the rest to xml output */
1079: IF (x_record_count > 0) THEN

Line 1077: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1073: /* get XML */
1074: l_stmt_num := 30;
1075: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1076:
1077: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1078: /* remove the header and append the rest to xml output */
1079: IF (x_record_count > 0) THEN
1080: /* Find the number of characters in the header and delete
1081: them. Header ends with '>'. Hence find first occurrence of

Line 1091: DBMS_XMLGEN.closeContext(l_ctx);

1087: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1088: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1089: END IF;
1090: /* close context and free memory */
1091: DBMS_XMLGEN.closeContext(l_ctx);
1092: CLOSE l_ref_cur;
1093: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1094:
1095: -- Standard call to get message count and if count is 1, get message info.

Line 1225: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1221: USING i_org_id, i_period_end_date;
1222:
1223: /* create new context */
1224: l_stmt_num := 20;
1225: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1226: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');
1227: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1228:
1229: /* get XML */

Line 1226: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');

1222:
1223: /* create new context */
1224: l_stmt_num := 20;
1225: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1226: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');
1227: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1228:
1229: /* get XML */
1230: l_stmt_num := 30;

Line 1227: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');

1223: /* create new context */
1224: l_stmt_num := 20;
1225: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1226: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');
1227: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1228:
1229: /* get XML */
1230: l_stmt_num := 30;
1231: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);

Line 1231: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);

1227: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1228:
1229: /* get XML */
1230: l_stmt_num := 30;
1231: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);
1232:
1233: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1234: /* remove the header*/
1235: IF (x_record_count > 0) THEN

Line 1233: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1229: /* get XML */
1230: l_stmt_num := 30;
1231: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);
1232:
1233: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1234: /* remove the header*/
1235: IF (x_record_count > 0) THEN
1236: l_wsmti_flag := FND_API.G_TRUE;
1237: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wsmti,

Line 1244: DBMS_XMLGEN.closeContext(l_ctx);

1240: nth => 1);
1241: DBMS_LOB.erase (l_xml_wsmti, l_offset,1);
1242: END IF;
1243: /* close context */
1244: DBMS_XMLGEN.closeContext(l_ctx);
1245: CLOSE l_ref_cur;
1246:
1247: IF (l_eventLog) THEN
1248: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

Line 1304: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1300: USING i_org_id, i_period_end_date;
1301:
1302: /* create new context */
1303: l_stmt_num := 50;
1304: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1305: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');
1306: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1307:
1308: /* get XML */

Line 1305: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');

1301:
1302: /* create new context */
1303: l_stmt_num := 50;
1304: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1305: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');
1306: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1307:
1308: /* get XML */
1309: l_stmt_num := 60;

Line 1306: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');

1302: /* create new context */
1303: l_stmt_num := 50;
1304: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1305: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');
1306: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1307:
1308: /* get XML */
1309: l_stmt_num := 60;
1310: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);

Line 1310: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);

1306: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1307:
1308: /* get XML */
1309: l_stmt_num := 60;
1310: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);
1311:
1312: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1313: /* remove the header */
1314: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

Line 1312: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1308: /* get XML */
1309: l_stmt_num := 60;
1310: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);
1311:
1312: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1313: /* remove the header */
1314: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1315: l_wlmti_flag := FND_API.G_TRUE;
1316: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlmti,

Line 1314: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

1310: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);
1311:
1312: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1313: /* remove the header */
1314: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1315: l_wlmti_flag := FND_API.G_TRUE;
1316: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlmti,
1317: pattern => '>',
1318: offset => 1,

Line 1323: DBMS_XMLGEN.closeContext(l_ctx);

1319: nth => 1);
1320: DBMS_LOB.erase (l_xml_wlmti, l_offset,1);
1321: END IF;
1322: /* close context */
1323: DBMS_XMLGEN.closeContext(l_ctx);
1324: CLOSE l_ref_cur;
1325:
1326: IF (l_eventLog) THEN
1327: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

Line 1373: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1369: USING i_org_id, i_period_end_date;
1370:
1371: /* create new context */
1372: l_stmt_num := 80;
1373: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1374: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');
1375: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1376:
1377: /* get XML */

Line 1374: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');

1370:
1371: /* create new context */
1372: l_stmt_num := 80;
1373: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1374: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');
1375: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1376:
1377: /* get XML */
1378: l_stmt_num := 90;

Line 1375: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');

1371: /* create new context */
1372: l_stmt_num := 80;
1373: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1374: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');
1375: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1376:
1377: /* get XML */
1378: l_stmt_num := 90;
1379: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);

Line 1379: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);

1375: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1376:
1377: /* get XML */
1378: l_stmt_num := 90;
1379: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);
1380:
1381: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1382: /* remove the header */
1383: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

Line 1381: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1377: /* get XML */
1378: l_stmt_num := 90;
1379: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);
1380:
1381: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1382: /* remove the header */
1383: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1384: l_wlsmi_flag := FND_API.G_TRUE;
1385: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlsmi,

Line 1383: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

1379: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);
1380:
1381: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1382: /* remove the header */
1383: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1384: l_wlsmi_flag := FND_API.G_TRUE;
1385: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlsmi,
1386: pattern => '>',
1387: offset => 1,

Line 1392: DBMS_XMLGEN.closeContext(l_ctx);

1388: nth => 1);
1389: DBMS_LOB.erase (l_xml_wlsmi, l_offset,1);
1390: END IF;
1391: /* close context */
1392: DBMS_XMLGEN.closeContext(l_ctx);
1393: CLOSE l_ref_cur;
1394:
1395: IF (l_eventLog) THEN
1396: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

Line 1597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1593: USING i_org_id, i_period_end_date, l_min_txn_if_id, l_max_txn_if_id;
1594:
1595: /* create new context */
1596: l_stmt_num := 20;
1597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1598: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');
1599: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1600:
1601: /* get XML */

Line 1598: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');

1594:
1595: /* create new context */
1596: l_stmt_num := 20;
1597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1598: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');
1599: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1600:
1601: /* get XML */
1602: l_stmt_num := 30;

Line 1599: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');

1595: /* create new context */
1596: l_stmt_num := 20;
1597: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1598: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');
1599: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1600:
1601: /* get XML */
1602: l_stmt_num := 30;
1603: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 1603: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

1599: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1600:
1601: /* get XML */
1602: l_stmt_num := 30;
1603: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1604:
1605: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1606: /* remove the header and append the rest to xml output */
1607: IF (x_record_count > 0) THEN

Line 1605: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1601: /* get XML */
1602: l_stmt_num := 30;
1603: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1604:
1605: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1606: /* remove the header and append the rest to xml output */
1607: IF (x_record_count > 0) THEN
1608: /* Find the number of characters in the header and delete
1609: them. Header ends with '>'. Hence find first occurrence of

Line 1619: DBMS_XMLGEN.closeContext(l_ctx);

1615: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1616: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1617: END IF;
1618: /* close context and free memory */
1619: DBMS_XMLGEN.closeContext(l_ctx);
1620: CLOSE l_ref_cur;
1621: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1622:
1623: -- Standard call to get message count and if count is 1, get message info.

Line 1767: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1763: USING i_org_id, i_period_end_date;
1764:
1765: /* create new context */
1766: l_stmt_num := 20;
1767: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1768: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');
1769: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1770:
1771: /* get XML */

Line 1768: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');

1764:
1765: /* create new context */
1766: l_stmt_num := 20;
1767: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1768: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');
1769: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1770:
1771: /* get XML */
1772: l_stmt_num := 30;

Line 1769: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');

1765: /* create new context */
1766: l_stmt_num := 20;
1767: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1768: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');
1769: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1770:
1771: /* get XML */
1772: l_stmt_num := 30;
1773: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 1773: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

1769: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1770:
1771: /* get XML */
1772: l_stmt_num := 30;
1773: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1774:
1775: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1776: /* remove the header and append the rest to xml output */
1777: IF (x_record_count > 0) THEN

Line 1775: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1771: /* get XML */
1772: l_stmt_num := 30;
1773: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1774:
1775: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1776: /* remove the header and append the rest to xml output */
1777: IF (x_record_count > 0) THEN
1778: /* Find the number of characters in the header and delete
1779: them. Header ends with '>'. Hence find first occurrence of

Line 1790: DBMS_XMLGEN.closeContext(l_ctx);

1786: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1787: END IF;
1788:
1789: /* close context and free memory */
1790: DBMS_XMLGEN.closeContext(l_ctx);
1791: CLOSE l_ref_cur;
1792: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1793:
1794: -- Standard call to get message count and if count is 1, get message info.

Line 1923: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

1919: USING i_org_id, i_period_end_date;
1920:
1921: /* create new context */
1922: l_stmt_num := 20;
1923: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1924: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');
1925: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1926:
1927: /* get XML */

Line 1924: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');

1920:
1921: /* create new context */
1922: l_stmt_num := 20;
1923: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1924: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');
1925: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1926:
1927: /* get XML */
1928: l_stmt_num := 30;

Line 1925: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');

1921: /* create new context */
1922: l_stmt_num := 20;
1923: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1924: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');
1925: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1926:
1927: /* get XML */
1928: l_stmt_num := 30;
1929: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 1929: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

1925: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1926:
1927: /* get XML */
1928: l_stmt_num := 30;
1929: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1930:
1931: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1932: /* remove the header and append the rest to xml output */
1933: IF (x_record_count > 0) THEN

Line 1931: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

1927: /* get XML */
1928: l_stmt_num := 30;
1929: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1930:
1931: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1932: /* remove the header and append the rest to xml output */
1933: IF (x_record_count > 0) THEN
1934: /* Find the number of characters in the header and delete
1935: them. Header ends with '>'. Hence find first occurrence of

Line 1945: DBMS_XMLGEN.closeContext(l_ctx);

1941: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1942: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1943: END IF;
1944: /* close context and free memory */
1945: DBMS_XMLGEN.closeContext(l_ctx);
1946: CLOSE l_ref_cur;
1947: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1948:
1949: -- Standard call to get message count and if count is 1, get message info.

Line 2161: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

2157: i_period_start_date, i_period_end_date, i_org_id;
2158:
2159: /* create new context */
2160: l_stmt_num := 20;
2161: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2162: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');
2163: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2164:
2165: /* get XML */

Line 2162: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');

2158:
2159: /* create new context */
2160: l_stmt_num := 20;
2161: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2162: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');
2163: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2164:
2165: /* get XML */
2166: l_stmt_num := 30;

Line 2163: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');

2159: /* create new context */
2160: l_stmt_num := 20;
2161: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2162: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');
2163: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2164:
2165: /* get XML */
2166: l_stmt_num := 30;
2167: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 2167: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

2163: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2164:
2165: /* get XML */
2166: l_stmt_num := 30;
2167: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2168:
2169: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2170: /* remove the header and append the rest to xml output */
2171: IF (x_record_count > 0) THEN

Line 2169: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

2165: /* get XML */
2166: l_stmt_num := 30;
2167: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2168:
2169: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2170: /* remove the header and append the rest to xml output */
2171: IF (x_record_count > 0) THEN
2172: /* Find the number of characters in the header and delete
2173: them. Header ends with '>'. Hence find first occurrence of

Line 2183: DBMS_XMLGEN.closeContext(l_ctx);

2179: DBMS_LOB.erase (l_xml_temp, l_offset,1);
2180: DBMS_LOB.append (x_xml_doc, l_xml_temp);
2181: END IF;
2182: /* close context and free memory */
2183: DBMS_XMLGEN.closeContext(l_ctx);
2184: CLOSE l_ref_cur;
2185: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2186:
2187: -- Standard call to get message count and if count is 1, get message info.

Line 2353: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

2349: USING i_org_id, i_period_end_date;
2350:
2351: /* create new context */
2352: l_stmt_num := 20;
2353: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2354: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');
2355: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2356:
2357: /* get XML */

Line 2354: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');

2350:
2351: /* create new context */
2352: l_stmt_num := 20;
2353: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2354: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');
2355: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2356:
2357: /* get XML */
2358: l_stmt_num := 30;

Line 2355: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');

2351: /* create new context */
2352: l_stmt_num := 20;
2353: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2354: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');
2355: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2356:
2357: /* get XML */
2358: l_stmt_num := 30;
2359: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 2359: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

2355: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2356:
2357: /* get XML */
2358: l_stmt_num := 30;
2359: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2360:
2361: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2362:
2363: /* remove the header and append the rest to xml output */

Line 2361: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

2357: /* get XML */
2358: l_stmt_num := 30;
2359: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2360:
2361: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2362:
2363: /* remove the header and append the rest to xml output */
2364: IF (x_record_count > 0) THEN
2365: /* Find the number of characters in the header and delete

Line 2376: DBMS_XMLGEN.closeContext(l_ctx);

2372: DBMS_LOB.erase (l_xml_temp, l_offset,1);
2373: DBMS_LOB.append (x_xml_doc, l_xml_temp);
2374: END IF;
2375: /* close context and free memory */
2376: DBMS_XMLGEN.closeContext(l_ctx);
2377: CLOSE l_ref_cur;
2378: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2379:
2380: -- Standard call to get message count and if count is 1, get message info.

Line 2496: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

2492: USING i_org_id, i_period_end_date;
2493:
2494: /* create new context */
2495: l_stmt_num := 20;
2496: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2497: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');
2498: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2499:
2500: /* get XML */

Line 2497: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');

2493:
2494: /* create new context */
2495: l_stmt_num := 20;
2496: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2497: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');
2498: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2499:
2500: /* get XML */
2501: l_stmt_num := 30;

Line 2498: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');

2494: /* create new context */
2495: l_stmt_num := 20;
2496: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2497: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');
2498: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2499:
2500: /* get XML */
2501: l_stmt_num := 30;
2502: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 2502: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

2498: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2499:
2500: /* get XML */
2501: l_stmt_num := 30;
2502: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2503:
2504: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2505: /* remove the header and append the rest to xml output */
2506: IF (x_record_count > 0) THEN

Line 2504: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);

2500: /* get XML */
2501: l_stmt_num := 30;
2502: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2503:
2504: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2505: /* remove the header and append the rest to xml output */
2506: IF (x_record_count > 0) THEN
2507: /* Find the number of characters in the header and delete
2508: them. Header ends with '>'. Hence find first occurrence of

Line 2518: DBMS_XMLGEN.closeContext(l_ctx);

2514: DBMS_LOB.erase (l_xml_temp, l_offset,1);
2515: DBMS_LOB.append (x_xml_doc, l_xml_temp);
2516: END IF;
2517: /* close context and free memory */
2518: DBMS_XMLGEN.closeContext(l_ctx);
2519: CLOSE l_ref_cur;
2520: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2521:
2522: -- Standard call to get message count and if count is 1, get message info.