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 537: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

533: USING l_org_code, l_period_name, l_resolution_type, i_transaction_type;
534:
535: /* create new context */
536: l_stmt_num := 40;
537: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
538: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
539: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
540:
541: /* get XML */

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

534:
535: /* create new context */
536: l_stmt_num := 40;
537: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
538: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
539: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
540:
541: /* get XML */
542: l_stmt_num := 50;

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

535: /* create new context */
536: l_stmt_num := 40;
537: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
538: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
539: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
540:
541: /* get XML */
542: l_stmt_num := 50;
543: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

539: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
540:
541: /* get XML */
542: l_stmt_num := 50;
543: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
544:
545: /* Add the XML header as the first line of output. add data to end */
546: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
547: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,

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

542: l_stmt_num := 50;
543: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
544:
545: /* Add the XML header as the first line of output. add data to end */
546: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
547: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
548: pattern => '>',
549: offset => 1,
550: nth => 1);

Line 559: DBMS_XMLGEN.closeContext(l_ctx);

555: DBMS_LOB.append (x_xml_doc, l_xml_temp);
556: END IF;
557:
558: /* close context and free memory */
559: DBMS_XMLGEN.closeContext(l_ctx);
560: CLOSE l_ref_cur;
561: DBMS_LOB.FREETEMPORARY (l_xml_temp);
562:
563: -- Standard call to get message count and if count is 1, get message info.

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

719: USING i_org_id, i_period_end_date;
720:
721: /* create new context */
722: l_stmt_num := 20;
723: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
724: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');
725: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
726:
727: /* get XML */

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

720:
721: /* create new context */
722: l_stmt_num := 20;
723: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
724: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');
725: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
726:
727: /* get XML */
728: l_stmt_num := 30;

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

721: /* create new context */
722: l_stmt_num := 20;
723: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
724: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNPROCESSED_MTL_TRX');
725: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
726:
727: /* get XML */
728: l_stmt_num := 30;
729: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

725: DBMS_XMLGEN.setRowTag (l_ctx,'UNPROCESSED_MTL_TRANSACTION');
726:
727: /* get XML */
728: l_stmt_num := 30;
729: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
730:
731: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
732: /* remove the header and append the rest to xml output */
733: IF (x_record_count > 0) THEN

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

727: /* get XML */
728: l_stmt_num := 30;
729: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
730:
731: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
732: /* remove the header and append the rest to xml output */
733: IF (x_record_count > 0) THEN
734: /* Find the number of characters in the header and delete
735: them. Header ends with '>'. Hence find first occurrence of

Line 745: DBMS_XMLGEN.closeContext(l_ctx);

741: DBMS_LOB.erase (l_xml_temp, l_offset, 1);
742: DBMS_LOB.append (x_xml_doc, l_xml_temp);
743: END IF;
744: /* close context and free memory */
745: DBMS_XMLGEN.closeContext(l_ctx);
746: CLOSE l_ref_cur;
747: DBMS_LOB.FREETEMPORARY (l_xml_temp);
748:
749: -- Standard call to get message count and if count is 1, get message info.

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

882: USING i_org_id, i_period_end_date;
883:
884: /* create new context */
885: l_stmt_num := 20;
886: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
887: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');
888: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
889:
890: /* get XML */

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

883:
884: /* create new context */
885: l_stmt_num := 20;
886: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
887: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');
888: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
889:
890: /* get XML */
891: l_stmt_num := 30;

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

884: /* create new context */
885: l_stmt_num := 20;
886: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
887: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_MTL_TRX');
888: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
889:
890: /* get XML */
891: l_stmt_num := 30;
892: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

888: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_MTL_TRANSACTION');
889:
890: /* get XML */
891: l_stmt_num := 30;
892: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
893:
894: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
895: /* remove the header and append the rest to xml output */
896: IF (x_record_count > 0) THEN

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

890: /* get XML */
891: l_stmt_num := 30;
892: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
893:
894: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
895: /* remove the header and append the rest to xml output */
896: IF (x_record_count > 0) THEN
897: /* Find the number of characters in the header and delete
898: them. Header ends with '>'. Hence find first occurrence of

Line 909: DBMS_XMLGEN.closeContext(l_ctx);

905: DBMS_LOB.append (x_xml_doc, l_xml_temp);
906: END IF;
907:
908: /* close context and free memory */
909: DBMS_XMLGEN.closeContext(l_ctx);
910: CLOSE l_ref_cur;
911: DBMS_LOB.FREETEMPORARY (l_xml_temp);
912:
913: -- Standard call to get message count and if count is 1, get message info.

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

1051: USING i_org_id, i_period_end_date;
1052:
1053: /* create new context */
1054: l_stmt_num := 20;
1055: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1056: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');
1057: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1058:
1059: /* get XML */

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

1052:
1053: /* create new context */
1054: l_stmt_num := 20;
1055: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1056: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');
1057: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1058:
1059: /* get XML */
1060: l_stmt_num := 30;

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

1053: /* create new context */
1054: l_stmt_num := 20;
1055: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1056: DBMS_XMLGEN.setRowSetTag (l_ctx,'UNCOSTED_WIP_TRX');
1057: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1058:
1059: /* get XML */
1060: l_stmt_num := 30;
1061: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

1057: DBMS_XMLGEN.setRowTag (l_ctx,'UNCOSTED_WIP_TRANSACTION');
1058:
1059: /* get XML */
1060: l_stmt_num := 30;
1061: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1062:
1063: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1064: /* remove the header and append the rest to xml output */
1065: IF (x_record_count > 0) THEN

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

1059: /* get XML */
1060: l_stmt_num := 30;
1061: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1062:
1063: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1064: /* remove the header and append the rest to xml output */
1065: IF (x_record_count > 0) THEN
1066: /* Find the number of characters in the header and delete
1067: them. Header ends with '>'. Hence find first occurrence of

Line 1077: DBMS_XMLGEN.closeContext(l_ctx);

1073: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1074: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1075: END IF;
1076: /* close context and free memory */
1077: DBMS_XMLGEN.closeContext(l_ctx);
1078: CLOSE l_ref_cur;
1079: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1080:
1081: -- Standard call to get message count and if count is 1, get message info.

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

1207: USING i_org_id, i_period_end_date;
1208:
1209: /* create new context */
1210: l_stmt_num := 20;
1211: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1212: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');
1213: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1214:
1215: /* get XML */

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

1208:
1209: /* create new context */
1210: l_stmt_num := 20;
1211: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1212: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');
1213: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1214:
1215: /* get XML */
1216: l_stmt_num := 30;

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

1209: /* create new context */
1210: l_stmt_num := 20;
1211: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1212: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WSMTI_TRX');
1213: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1214:
1215: /* get XML */
1216: l_stmt_num := 30;
1217: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);

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

1213: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WSMTI_TRANSACTION');
1214:
1215: /* get XML */
1216: l_stmt_num := 30;
1217: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);
1218:
1219: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1220: /* remove the header*/
1221: IF (x_record_count > 0) THEN

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

1215: /* get XML */
1216: l_stmt_num := 30;
1217: DBMS_XMLGEN.getXML (l_ctx, l_xml_wsmti, DBMS_XMLGEN.none);
1218:
1219: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1220: /* remove the header*/
1221: IF (x_record_count > 0) THEN
1222: l_wsmti_flag := FND_API.G_TRUE;
1223: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wsmti,

Line 1230: DBMS_XMLGEN.closeContext(l_ctx);

1226: nth => 1);
1227: DBMS_LOB.erase (l_xml_wsmti, l_offset,1);
1228: END IF;
1229: /* close context */
1230: DBMS_XMLGEN.closeContext(l_ctx);
1231: CLOSE l_ref_cur;
1232:
1233: IF (l_eventLog) THEN
1234: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

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

1286: USING i_org_id, i_period_end_date;
1287:
1288: /* create new context */
1289: l_stmt_num := 50;
1290: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1291: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');
1292: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1293:
1294: /* get XML */

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

1287:
1288: /* create new context */
1289: l_stmt_num := 50;
1290: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1291: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');
1292: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1293:
1294: /* get XML */
1295: l_stmt_num := 60;

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

1288: /* create new context */
1289: l_stmt_num := 50;
1290: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1291: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLMTI_TRX');
1292: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1293:
1294: /* get XML */
1295: l_stmt_num := 60;
1296: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);

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

1292: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLMTI_TRANSACTION');
1293:
1294: /* get XML */
1295: l_stmt_num := 60;
1296: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);
1297:
1298: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1299: /* remove the header */
1300: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

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

1294: /* get XML */
1295: l_stmt_num := 60;
1296: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);
1297:
1298: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1299: /* remove the header */
1300: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1301: l_wlmti_flag := FND_API.G_TRUE;
1302: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlmti,

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

1296: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlmti, DBMS_XMLGEN.none);
1297:
1298: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1299: /* remove the header */
1300: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1301: l_wlmti_flag := FND_API.G_TRUE;
1302: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlmti,
1303: pattern => '>',
1304: offset => 1,

Line 1309: DBMS_XMLGEN.closeContext(l_ctx);

1305: nth => 1);
1306: DBMS_LOB.erase (l_xml_wlmti, l_offset,1);
1307: END IF;
1308: /* close context */
1309: DBMS_XMLGEN.closeContext(l_ctx);
1310: CLOSE l_ref_cur;
1311:
1312: IF (l_eventLog) THEN
1313: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

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

1355: USING i_org_id, i_period_end_date;
1356:
1357: /* create new context */
1358: l_stmt_num := 80;
1359: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1360: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');
1361: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1362:
1363: /* get XML */

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

1356:
1357: /* create new context */
1358: l_stmt_num := 80;
1359: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1360: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');
1361: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1362:
1363: /* get XML */
1364: l_stmt_num := 90;

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

1357: /* create new context */
1358: l_stmt_num := 80;
1359: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1360: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WLSMI_TRX');
1361: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1362:
1363: /* get XML */
1364: l_stmt_num := 90;
1365: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);

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

1361: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WLSMI_TRANSACTION');
1362:
1363: /* get XML */
1364: l_stmt_num := 90;
1365: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);
1366:
1367: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1368: /* remove the header */
1369: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

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

1363: /* get XML */
1364: l_stmt_num := 90;
1365: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);
1366:
1367: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1368: /* remove the header */
1369: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1370: l_wlsmi_flag := FND_API.G_TRUE;
1371: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlsmi,

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

1365: DBMS_XMLGEN.getXML (l_ctx, l_xml_wlsmi, DBMS_XMLGEN.none);
1366:
1367: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1368: /* remove the header */
1369: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1370: l_wlsmi_flag := FND_API.G_TRUE;
1371: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlsmi,
1372: pattern => '>',
1373: offset => 1,

Line 1378: DBMS_XMLGEN.closeContext(l_ctx);

1374: nth => 1);
1375: DBMS_LOB.erase (l_xml_wlsmi, l_offset,1);
1376: END IF;
1377: /* close context */
1378: DBMS_XMLGEN.closeContext(l_ctx);
1379: CLOSE l_ref_cur;
1380:
1381: IF (l_eventLog) THEN
1382: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

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

1579: USING i_org_id, i_period_end_date, l_min_txn_if_id, l_max_txn_if_id;
1580:
1581: /* create new context */
1582: l_stmt_num := 20;
1583: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1584: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');
1585: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1586:
1587: /* get XML */

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

1580:
1581: /* create new context */
1582: l_stmt_num := 20;
1583: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1584: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');
1585: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1586:
1587: /* get XML */
1588: l_stmt_num := 30;

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

1581: /* create new context */
1582: l_stmt_num := 20;
1583: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1584: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_MTL_INTERFACE_TRX');
1585: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1586:
1587: /* get XML */
1588: l_stmt_num := 30;
1589: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

1585: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_MTL_INTERFACE_TRANSACTION');
1586:
1587: /* get XML */
1588: l_stmt_num := 30;
1589: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1590:
1591: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1592: /* remove the header and append the rest to xml output */
1593: IF (x_record_count > 0) THEN

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

1587: /* get XML */
1588: l_stmt_num := 30;
1589: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1590:
1591: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1592: /* remove the header and append the rest to xml output */
1593: IF (x_record_count > 0) THEN
1594: /* Find the number of characters in the header and delete
1595: them. Header ends with '>'. Hence find first occurrence of

Line 1605: DBMS_XMLGEN.closeContext(l_ctx);

1601: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1602: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1603: END IF;
1604: /* close context and free memory */
1605: DBMS_XMLGEN.closeContext(l_ctx);
1606: CLOSE l_ref_cur;
1607: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1608:
1609: -- Standard call to get message count and if count is 1, get message info.

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

1749: USING i_org_id, i_period_end_date;
1750:
1751: /* create new context */
1752: l_stmt_num := 20;
1753: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1754: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');
1755: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1756:
1757: /* get XML */

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

1750:
1751: /* create new context */
1752: l_stmt_num := 20;
1753: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1754: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');
1755: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1756:
1757: /* get XML */
1758: l_stmt_num := 30;

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

1751: /* create new context */
1752: l_stmt_num := 20;
1753: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1754: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_RCV_TRX');
1755: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1756:
1757: /* get XML */
1758: l_stmt_num := 30;
1759: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

1755: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_RCV_TRANSACTION');
1756:
1757: /* get XML */
1758: l_stmt_num := 30;
1759: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1760:
1761: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1762: /* remove the header and append the rest to xml output */
1763: IF (x_record_count > 0) THEN

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

1757: /* get XML */
1758: l_stmt_num := 30;
1759: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1760:
1761: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1762: /* remove the header and append the rest to xml output */
1763: IF (x_record_count > 0) THEN
1764: /* Find the number of characters in the header and delete
1765: them. Header ends with '>'. Hence find first occurrence of

Line 1776: DBMS_XMLGEN.closeContext(l_ctx);

1772: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1773: END IF;
1774:
1775: /* close context and free memory */
1776: DBMS_XMLGEN.closeContext(l_ctx);
1777: CLOSE l_ref_cur;
1778: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1779:
1780: -- Standard call to get message count and if count is 1, get message info.

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

1905: USING i_org_id, i_period_end_date;
1906:
1907: /* create new context */
1908: l_stmt_num := 20;
1909: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1910: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');
1911: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1912:
1913: /* get XML */

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

1906:
1907: /* create new context */
1908: l_stmt_num := 20;
1909: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1910: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');
1911: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1912:
1913: /* get XML */
1914: l_stmt_num := 30;

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

1907: /* create new context */
1908: l_stmt_num := 20;
1909: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
1910: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_WIP_MOVE_TRX');
1911: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1912:
1913: /* get XML */
1914: l_stmt_num := 30;
1915: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

1911: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_WIP_MOVE_TRANSACTION');
1912:
1913: /* get XML */
1914: l_stmt_num := 30;
1915: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1916:
1917: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1918: /* remove the header and append the rest to xml output */
1919: IF (x_record_count > 0) THEN

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

1913: /* get XML */
1914: l_stmt_num := 30;
1915: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
1916:
1917: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1918: /* remove the header and append the rest to xml output */
1919: IF (x_record_count > 0) THEN
1920: /* Find the number of characters in the header and delete
1921: them. Header ends with '>'. Hence find first occurrence of

Line 1931: DBMS_XMLGEN.closeContext(l_ctx);

1927: DBMS_LOB.erase (l_xml_temp, l_offset,1);
1928: DBMS_LOB.append (x_xml_doc, l_xml_temp);
1929: END IF;
1930: /* close context and free memory */
1931: DBMS_XMLGEN.closeContext(l_ctx);
1932: CLOSE l_ref_cur;
1933: DBMS_LOB.FREETEMPORARY (l_xml_temp);
1934:
1935: -- Standard call to get message count and if count is 1, get message info.

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

2143: i_period_start_date, i_period_end_date, i_org_id;
2144:
2145: /* create new context */
2146: l_stmt_num := 20;
2147: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2148: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');
2149: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2150:
2151: /* get XML */

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

2144:
2145: /* create new context */
2146: l_stmt_num := 20;
2147: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2148: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');
2149: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2150:
2151: /* get XML */
2152: l_stmt_num := 30;

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

2145: /* create new context */
2146: l_stmt_num := 20;
2147: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2148: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_SHIPPING_TRX');
2149: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2150:
2151: /* get XML */
2152: l_stmt_num := 30;
2153: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

2149: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_SHIPPING_TRANSACTION');
2150:
2151: /* get XML */
2152: l_stmt_num := 30;
2153: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2154:
2155: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2156: /* remove the header and append the rest to xml output */
2157: IF (x_record_count > 0) THEN

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

2151: /* get XML */
2152: l_stmt_num := 30;
2153: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2154:
2155: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2156: /* remove the header and append the rest to xml output */
2157: IF (x_record_count > 0) THEN
2158: /* Find the number of characters in the header and delete
2159: them. Header ends with '>'. Hence find first occurrence of

Line 2169: DBMS_XMLGEN.closeContext(l_ctx);

2165: DBMS_LOB.erase (l_xml_temp, l_offset,1);
2166: DBMS_LOB.append (x_xml_doc, l_xml_temp);
2167: END IF;
2168: /* close context and free memory */
2169: DBMS_XMLGEN.closeContext(l_ctx);
2170: CLOSE l_ref_cur;
2171: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2172:
2173: -- Standard call to get message count and if count is 1, get message info.

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

2335: USING i_org_id, i_period_end_date;
2336:
2337: /* create new context */
2338: l_stmt_num := 20;
2339: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2340: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');
2341: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2342:
2343: /* get XML */

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

2336:
2337: /* create new context */
2338: l_stmt_num := 20;
2339: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2340: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');
2341: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2342:
2343: /* get XML */
2344: l_stmt_num := 30;

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

2337: /* create new context */
2338: l_stmt_num := 20;
2339: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2340: DBMS_XMLGEN.setRowSetTag (l_ctx,'INCOMPLETE_EAM_WO');
2341: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2342:
2343: /* get XML */
2344: l_stmt_num := 30;
2345: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

2341: DBMS_XMLGEN.setRowTag (l_ctx,'EAM_WORKORDER');
2342:
2343: /* get XML */
2344: l_stmt_num := 30;
2345: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2346:
2347: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2348:
2349: /* remove the header and append the rest to xml output */

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

2343: /* get XML */
2344: l_stmt_num := 30;
2345: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2346:
2347: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2348:
2349: /* remove the header and append the rest to xml output */
2350: IF (x_record_count > 0) THEN
2351: /* Find the number of characters in the header and delete

Line 2362: DBMS_XMLGEN.closeContext(l_ctx);

2358: DBMS_LOB.erase (l_xml_temp, l_offset,1);
2359: DBMS_LOB.append (x_xml_doc, l_xml_temp);
2360: END IF;
2361: /* close context and free memory */
2362: DBMS_XMLGEN.closeContext(l_ctx);
2363: CLOSE l_ref_cur;
2364: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2365:
2366: -- Standard call to get message count and if count is 1, get message info.

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

2478: USING i_org_id, i_period_end_date;
2479:
2480: /* create new context */
2481: l_stmt_num := 20;
2482: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2483: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');
2484: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2485:
2486: /* get XML */

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

2479:
2480: /* create new context */
2481: l_stmt_num := 20;
2482: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2483: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');
2484: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2485:
2486: /* get XML */
2487: l_stmt_num := 30;

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

2480: /* create new context */
2481: l_stmt_num := 20;
2482: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
2483: DBMS_XMLGEN.setRowSetTag (l_ctx,'PENDING_LCM_TRX');
2484: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2485:
2486: /* get XML */
2487: l_stmt_num := 30;
2488: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

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

2484: DBMS_XMLGEN.setRowTag (l_ctx,'PENDING_LCM_TRANSACTION');
2485:
2486: /* get XML */
2487: l_stmt_num := 30;
2488: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2489:
2490: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2491: /* remove the header and append the rest to xml output */
2492: IF (x_record_count > 0) THEN

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

2486: /* get XML */
2487: l_stmt_num := 30;
2488: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
2489:
2490: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
2491: /* remove the header and append the rest to xml output */
2492: IF (x_record_count > 0) THEN
2493: /* Find the number of characters in the header and delete
2494: them. Header ends with '>'. Hence find first occurrence of

Line 2504: DBMS_XMLGEN.closeContext(l_ctx);

2500: DBMS_LOB.erase (l_xml_temp, l_offset,1);
2501: DBMS_LOB.append (x_xml_doc, l_xml_temp);
2502: END IF;
2503: /* close context and free memory */
2504: DBMS_XMLGEN.closeContext(l_ctx);
2505: CLOSE l_ref_cur;
2506: DBMS_LOB.FREETEMPORARY (l_xml_temp);
2507:
2508: -- Standard call to get message count and if count is 1, get message info.