APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on DBMS_XMLGEN

Line 1191: qryCtx DBMS_XMLGEN.ctxHandle;

1187: END item_action_stmt;
1188:
1189: PROCEDURE generate_xml IS
1190:
1191: qryCtx DBMS_XMLGEN.ctxHandle;
1192: result CLOB;
1193: seq_stmt VARCHAR2(100);
1194: x_seq_num NUMBER;
1195: l_encoding VARCHAR2(20); /* B7481907 */

Line 1398: -- DBMS_XMLGEN.closeContext(qryctx);

1394: -- Append the rest to xml output
1395: DBMS_LOB.append (result, temp_clob);
1396:
1397: -- close context and free memory
1398: -- DBMS_XMLGEN.closeContext(qryctx);
1399: DBMS_LOB.FREETEMPORARY (temp_clob);
1400: -- B7481907 Rajesh Patangya Ends
1401:
1402: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

Line 1476: -- DBMS_XMLGEN.closeContext(qryctx);

1472: -- Append the rest to xml output
1473: DBMS_LOB.append (result, temp_clob);
1474:
1475: -- close context and free memory
1476: -- DBMS_XMLGEN.closeContext(qryctx);
1477: DBMS_LOB.FREETEMPORARY (temp_clob);
1478: -- B7481907 Rajesh Patangya Ends
1479:
1480: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

Line 1548: -- DBMS_XMLGEN.closeContext(qryctx);

1544: -- Append the rest to xml output
1545: DBMS_LOB.append (result, temp_clob);
1546:
1547: -- close context and free memory
1548: -- DBMS_XMLGEN.closeContext(qryctx);
1549: DBMS_LOB.FREETEMPORARY (temp_clob);
1550: -- B7481907 Rajesh Patangya Ends
1551:
1552: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

Line 1620: -- DBMS_XMLGEN.closeContext(qryctx);

1616: -- Append the rest to xml output
1617: DBMS_LOB.append (result, temp_clob);
1618:
1619: -- close context and free memory
1620: -- DBMS_XMLGEN.closeContext(qryctx);
1621: DBMS_LOB.FREETEMPORARY (temp_clob);
1622: -- B7481907 Rajesh Patangya Ends
1623:
1624: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';

Line 1693: -- DBMS_XMLGEN.closeContext(qryctx);

1689: -- Append the rest to xml output
1690: DBMS_LOB.append (result, temp_clob);
1691:
1692: -- close context and free memory
1693: -- DBMS_XMLGEN.closeContext(qryctx);
1694: DBMS_LOB.FREETEMPORARY (temp_clob);
1695: -- B7481907 Rajesh Patangya Ends
1696:
1697: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';