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

Line 1004: qryCtx DBMS_XMLGEN.ctxHandle;

1000: END item_action_stmt;
1001:
1002: PROCEDURE generate_xml IS
1003:
1004: qryCtx DBMS_XMLGEN.ctxHandle;
1005: result CLOB;
1006: seq_stmt VARCHAR2(100);
1007: x_seq_num NUMBER;
1008:

Line 1168: qryctx := dbms_xmlgen.newcontext(G_common_pdr_stmt);

1164:
1165: -- INSERT INTO ns_debug (LONGVAL) values (G_common_pdr_stmt);
1166: -- FND_FILE.PUT_LINE(FND_FILE.LOG,G_common_pdr_stmt);
1167:
1168: qryctx := dbms_xmlgen.newcontext(G_common_pdr_stmt);
1169: result := DBMS_XMLGEN.getXML(qryCtx);
1170: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1171:
1172: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

Line 1169: result := DBMS_XMLGEN.getXML(qryCtx);

1165: -- INSERT INTO ns_debug (LONGVAL) values (G_common_pdr_stmt);
1166: -- FND_FILE.PUT_LINE(FND_FILE.LOG,G_common_pdr_stmt);
1167:
1168: qryctx := dbms_xmlgen.newcontext(G_common_pdr_stmt);
1169: result := DBMS_XMLGEN.getXML(qryCtx);
1170: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1171:
1172: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1173: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,1,x_seq_num );

Line 1174: DBMS_XMLGEN.closeContext(qryCtx);

1170: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1171:
1172: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1173: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,1,x_seq_num );
1174: DBMS_XMLGEN.closeContext(qryCtx);
1175: ps_generate_output(x_seq_num,1);
1176:
1177: ELSE /* Not Combined PDR */
1178:

Line 1211: qryctx := dbms_xmlgen.newcontext(G_horiz_pdr_stmt);

1207: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' ) gpi ';
1208: END IF;
1209: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' FROM DUAL ';
1210:
1211: qryctx := dbms_xmlgen.newcontext(G_horiz_pdr_stmt);
1212: result := DBMS_XMLGEN.getXML(qryCtx);
1213: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1214:
1215: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

Line 1212: result := DBMS_XMLGEN.getXML(qryCtx);

1208: END IF;
1209: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' FROM DUAL ';
1210:
1211: qryctx := dbms_xmlgen.newcontext(G_horiz_pdr_stmt);
1212: result := DBMS_XMLGEN.getXML(qryCtx);
1213: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1214:
1215: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1216: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,2,x_seq_num );

Line 1217: DBMS_XMLGEN.closeContext(qryCtx);

1213: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1214:
1215: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1216: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,2,x_seq_num );
1217: DBMS_XMLGEN.closeContext(qryCtx);
1218: ps_generate_output(x_seq_num,2);
1219:
1220: -- INSERT INTO ns_debug (col3) values (G_horiz_pdr_stmt);
1221:

Line 1256: qryctx := dbms_xmlgen.newcontext(G_vert_pdr_stmt);

1252: G_vert_pdr_stmt := G_vert_pdr_stmt || ' ) gpi ';
1253: END IF;
1254: G_vert_pdr_stmt := G_vert_pdr_stmt || ' FROM DUAL ';
1255:
1256: qryctx := dbms_xmlgen.newcontext(G_vert_pdr_stmt);
1257: result := DBMS_XMLGEN.getXML(qryCtx);
1258: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1259:
1260: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

Line 1257: result := DBMS_XMLGEN.getXML(qryCtx);

1253: END IF;
1254: G_vert_pdr_stmt := G_vert_pdr_stmt || ' FROM DUAL ';
1255:
1256: qryctx := dbms_xmlgen.newcontext(G_vert_pdr_stmt);
1257: result := DBMS_XMLGEN.getXML(qryCtx);
1258: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1259:
1260: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1261: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,3,x_seq_num );

Line 1262: DBMS_XMLGEN.closeContext(qryCtx);

1258: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1259:
1260: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1261: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,3,x_seq_num );
1262: DBMS_XMLGEN.closeContext(qryCtx);
1263: ps_generate_output(x_seq_num,3);
1264:
1265: -- INSERT INTO ns_debug (col3) values (G_vert_pdr_stmt);
1266:

Line 1301: qryctx := dbms_xmlgen.newcontext(G_excep_pdr_stmt);

1297: G_excep_pdr_stmt := G_excep_pdr_stmt || ' ) gpi ';
1298: END IF;
1299: G_excep_pdr_stmt := G_excep_pdr_stmt || ' FROM DUAL ';
1300:
1301: qryctx := dbms_xmlgen.newcontext(G_excep_pdr_stmt);
1302: result := DBMS_XMLGEN.getXML(qryCtx);
1303: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1304:
1305: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

Line 1302: result := DBMS_XMLGEN.getXML(qryCtx);

1298: END IF;
1299: G_excep_pdr_stmt := G_excep_pdr_stmt || ' FROM DUAL ';
1300:
1301: qryctx := dbms_xmlgen.newcontext(G_excep_pdr_stmt);
1302: result := DBMS_XMLGEN.getXML(qryCtx);
1303: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1304:
1305: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1306: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );

Line 1307: DBMS_XMLGEN.closeContext(qryCtx);

1303: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1304:
1305: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1306: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );
1307: DBMS_XMLGEN.closeContext(qryCtx);
1308: ps_generate_output(x_seq_num,4);
1309:
1310: -- INSERT INTO ns_debug (col3) values (G_excep_pdr_stmt);
1311:

Line 1346: qryctx := dbms_xmlgen.newcontext(G_act_pdr_stmt);

1342: G_act_pdr_stmt := G_act_pdr_stmt || ' ) gpi ';
1343: END IF;
1344: G_act_pdr_stmt := G_act_pdr_stmt || ' FROM DUAL ';
1345:
1346: qryctx := dbms_xmlgen.newcontext(G_act_pdr_stmt);
1347: result := DBMS_XMLGEN.getXML(qryCtx);
1348: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1349:
1350: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

Line 1347: result := DBMS_XMLGEN.getXML(qryCtx);

1343: END IF;
1344: G_act_pdr_stmt := G_act_pdr_stmt || ' FROM DUAL ';
1345:
1346: qryctx := dbms_xmlgen.newcontext(G_act_pdr_stmt);
1347: result := DBMS_XMLGEN.getXML(qryCtx);
1348: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1349:
1350: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1351: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,5,x_seq_num );

Line 1352: DBMS_XMLGEN.closeContext(qryCtx);

1348: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1349:
1350: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1351: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,5,x_seq_num );
1352: DBMS_XMLGEN.closeContext(qryCtx);
1353: ps_generate_output(x_seq_num,5);
1354:
1355: -- INSERT INTO ns_debug (col3) values (G_act_pdr_stmt);
1356: