APPS.FUN_REPORT_PVT dependencies on DBMS_LOB

Line 1479: IF DBMS_LOB.getlength(p_outbound_trxs) IS NULL THEN

1475: l_progress := '030';
1476: IF (p_para_rec.batch_type = 'BOTH') THEN
1477: FUN_UTIL.log_conc_stmt(
1478: g_pkg_name, l_api_name, l_progress, 'construct both', '');
1479: IF DBMS_LOB.getlength(p_outbound_trxs) IS NULL THEN
1480: l_progress := '030.a';
1481: FND_FILE.put_line(FND_FILE.output, ' ');
1482: ELSE
1483: -- trim header of outbound trxs

Line 1486: l_offset := DBMS_LOB.instr (

1482: ELSE
1483: -- trim header of outbound trxs
1484: -- save outbound trxs
1485: l_progress := '030.b';
1486: l_offset := DBMS_LOB.instr (
1487: lob_loc => p_outbound_trxs,
1488: pattern => '?>',
1489: offset => 1,
1490: nth => 1);

Line 1507: IF DBMS_LOB.getlength(p_inbound_trxs) IS NULL THEN

1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505:
1506:
1507: IF DBMS_LOB.getlength(p_inbound_trxs) IS NULL THEN
1508: l_progress := '030.c';
1509: FND_FILE.put_line(FND_FILE.output, ' ');
1510: ELSE
1511: -- trim header of inbound trxs

Line 1514: l_offset := DBMS_LOB.instr (

1510: ELSE
1511: -- trim header of inbound trxs
1512: -- save inbound trxs
1513: l_progress := '030.d';
1514: l_offset := DBMS_LOB.instr (
1515: lob_loc => p_inbound_trxs,
1516: pattern => '?>',
1517: offset => 1,
1518: nth => 1);

Line 1533: IF DBMS_LOB.getlength(p_inbound_trxs) IS NULL THEN

1529:
1530: ELSIF (p_para_rec.batch_type = 'IN') THEN
1531: FND_FILE.put_line(FND_FILE.output, ' ');
1532:
1533: IF DBMS_LOB.getlength(p_inbound_trxs) IS NULL THEN
1534: l_progress := '030.e';
1535: FND_FILE.put_line(FND_FILE.output, ' ');
1536: ELSE
1537: -- trim header of inbound trxs

Line 1540: l_offset := DBMS_LOB.instr (

1536: ELSE
1537: -- trim header of inbound trxs
1538: -- append inbound trxs to outbound trxs
1539: l_progress := '030.f';
1540: l_offset := DBMS_LOB.instr (
1541: lob_loc => p_inbound_trxs,
1542: pattern => '?>',
1543: offset => 1,
1544: nth => 1);

Line 1555: IF DBMS_LOB.getlength(p_outbound_trxs) IS NULL THEN

1551: p_offset => l_offset+2);
1552: END IF;
1553:
1554: ELSE -- (p_para_rec.batch_type = 'OUT')
1555: IF DBMS_LOB.getlength(p_outbound_trxs) IS NULL THEN
1556: l_progress := '030.g';
1557: FND_FILE.put_line(FND_FILE.output, ' ');
1558: ELSE
1559: -- trim header of outbound trxs

Line 1562: l_offset := DBMS_LOB.instr (

1558: ELSE
1559: -- trim header of outbound trxs
1560: -- append outbound trxs to outbound trxs
1561: l_progress := '030.h';
1562: l_offset := DBMS_LOB.instr (
1563: lob_loc => p_outbound_trxs,
1564: pattern => '?>',
1565: offset => 1,
1566: nth => 1);

Line 1764: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN

1760:
1761:
1762: FUN_UTIL.log_conc_stmt(
1763: g_pkg_name, l_api_name, l_progress, 'construct both', '');
1764: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN
1765: l_progress := '030.a';
1766: ELSE
1767: -- trim header of trxs
1768: -- save trxs

Line 1770: l_offset := DBMS_LOB.instr (

1766: ELSE
1767: -- trim header of trxs
1768: -- save trxs
1769: l_progress := '030.b';
1770: l_offset := DBMS_LOB.instr (
1771: lob_loc => p_trxs,
1772: pattern => '?>',
1773: offset => 1,
1774: nth => 1);

Line 1859: l_length := DBMS_LOB.getlength(p_trxs);

1855: -- Initialize API return status to success
1856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1857:
1858: l_progress := '010';
1859: l_length := DBMS_LOB.getlength(p_trxs);
1860: FUN_UTIL.log_conc_stmt(
1861: g_pkg_name, l_api_name, l_progress, 'l_length', l_length);
1862:
1863: WHILE (l_pos <= l_length)

Line 1865: DBMS_LOB.read(p_trxs, l_amount, l_pos, l_buffer);

1861: g_pkg_name, l_api_name, l_progress, 'l_length', l_length);
1862:
1863: WHILE (l_pos <= l_length)
1864: LOOP
1865: DBMS_LOB.read(p_trxs, l_amount, l_pos, l_buffer);
1866: FND_FILE.put(FND_FILE.output, l_buffer);
1867:
1868: -- FUN_UTIL.log_conc_stmt(g_pkg_name, l_api_name, l_progress, 'xml_date',l_buffer);
1869: -- l_buffer:=NULL;