DBA Data[Home] [Help]

APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on DBMS_XMLQUERY

Line 1380: temp_clob := DBMS_XMLQUERY.getXML (G_common_pdr_stmt ); -- Bug: 9265463

1376: DBMS_LOB.createtemporary(temp_clob, TRUE);
1377: DBMS_LOB.createtemporary(result, TRUE);
1378:
1379: -- generate XML data
1380: temp_clob := DBMS_XMLQUERY.getXML (G_common_pdr_stmt ); -- Bug: 9265463
1381: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1382: pattern => '>',
1383: offset => 1,
1384: nth => 1);

Line 1458: temp_clob := DBMS_XMLQUERY.getXML (G_horiz_pdr_stmt ); -- Bug: 9265463

1454: DBMS_LOB.createtemporary(temp_clob, TRUE);
1455: DBMS_LOB.createtemporary(result, TRUE);
1456:
1457: -- generate XML data
1458: temp_clob := DBMS_XMLQUERY.getXML (G_horiz_pdr_stmt ); -- Bug: 9265463
1459: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1460: pattern => '>',
1461: offset => 1,
1462: nth => 1);

Line 1530: temp_clob := DBMS_XMLQUERY.getXML (G_vert_pdr_stmt ); -- Bug: 9265463

1526: DBMS_LOB.createtemporary(temp_clob, TRUE);
1527: DBMS_LOB.createtemporary(result, TRUE);
1528:
1529: -- generate XML data
1530: temp_clob := DBMS_XMLQUERY.getXML (G_vert_pdr_stmt ); -- Bug: 9265463
1531: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1532: pattern => '>',
1533: offset => 1,
1534: nth => 1);

Line 1602: temp_clob := DBMS_XMLQUERY.getXML (G_excep_pdr_stmt ); -- Bug: 9265463

1598: DBMS_LOB.createtemporary(temp_clob, TRUE);
1599: DBMS_LOB.createtemporary(result, TRUE);
1600:
1601: -- generate XML data
1602: temp_clob := DBMS_XMLQUERY.getXML (G_excep_pdr_stmt ); -- Bug: 9265463
1603: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1604: pattern => '>',
1605: offset => 1,
1606: nth => 1);

Line 1675: temp_clob := DBMS_XMLQUERY.getXML (G_act_pdr_stmt ); -- Bug: 9265463

1671: DBMS_LOB.createtemporary(temp_clob, TRUE);
1672: DBMS_LOB.createtemporary(result, TRUE);
1673:
1674: -- generate XML data
1675: temp_clob := DBMS_XMLQUERY.getXML (G_act_pdr_stmt ); -- Bug: 9265463
1676: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1677: pattern => '>',
1678: offset => 1,
1679: nth => 1);