APPS.JTF_USR_HKS dependencies on DBMS_XMLQUERY

Line 865: queryCtx DBMS_XMLquery.ctxType;

861:
862: amount number := 240;
863: position number := 1;
864: charstr varchar2(255);
865: queryCtx DBMS_XMLquery.ctxType;
866:
867: Cursor SQL_BIND_DATA(v_bind_data_id Number) is
868: Select bind_name, bind_value
869: From JTF_BIND_DATA

Line 896: queryCtx := DBMS_XMLQuery.newContext(l_msg_SQL);

892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: End;
894: -- dbms_output.put_line(' Got message sql');
895: -- set up the query context...!
896: queryCtx := DBMS_XMLQuery.newContext(l_msg_SQL);
897: Begin
898: select HEADER_DTD into l_hdr_DTD
899: from JTF_HEADER_DTD
900: where

Line 934: --DBMS_XMLQUERY.clearBindValues;

930:
931: /* Set bind variables */
932:
933:
934: --DBMS_XMLQUERY.clearBindValues;
935:
936: FOR sql_bind IN sql_bind_data(p_bind_data_id) LOOP
937: DBMS_XMLQUERY.setBindValue( queryCtx,sql_bind.bind_name, sql_bind.bind_value );
938: END LOOP;

Line 937: DBMS_XMLQUERY.setBindValue( queryCtx,sql_bind.bind_name, sql_bind.bind_value );

933:
934: --DBMS_XMLQUERY.clearBindValues;
935:
936: FOR sql_bind IN sql_bind_data(p_bind_data_id) LOOP
937: DBMS_XMLQUERY.setBindValue( queryCtx,sql_bind.bind_name, sql_bind.bind_value );
938: END LOOP;
939:
940: DBMS_XMLQUERY.setRowSetTag( ctxHdl => queryCtx, Tag => 'DATAAREA');
941: DBMS_XMLQUERY.setMetaHeader( ctxHdl => queryCtx, Header => l_hdr_DTD);

Line 940: DBMS_XMLQUERY.setRowSetTag( ctxHdl => queryCtx, Tag => 'DATAAREA');

936: FOR sql_bind IN sql_bind_data(p_bind_data_id) LOOP
937: DBMS_XMLQUERY.setBindValue( queryCtx,sql_bind.bind_name, sql_bind.bind_value );
938: END LOOP;
939:
940: DBMS_XMLQUERY.setRowSetTag( ctxHdl => queryCtx, Tag => 'DATAAREA');
941: DBMS_XMLQUERY.setMetaHeader( ctxHdl => queryCtx, Header => l_hdr_DTD);
942: DBMS_XMLQUERY.setDataHeader( ctxHdl => queryCtx, Header => l_hdr_XML,
943: Tag => 'BUS_OBJ');
944:

Line 941: DBMS_XMLQUERY.setMetaHeader( ctxHdl => queryCtx, Header => l_hdr_DTD);

937: DBMS_XMLQUERY.setBindValue( queryCtx,sql_bind.bind_name, sql_bind.bind_value );
938: END LOOP;
939:
940: DBMS_XMLQUERY.setRowSetTag( ctxHdl => queryCtx, Tag => 'DATAAREA');
941: DBMS_XMLQUERY.setMetaHeader( ctxHdl => queryCtx, Header => l_hdr_DTD);
942: DBMS_XMLQUERY.setDataHeader( ctxHdl => queryCtx, Header => l_hdr_XML,
943: Tag => 'BUS_OBJ');
944:
945:

Line 942: DBMS_XMLQUERY.setDataHeader( ctxHdl => queryCtx, Header => l_hdr_XML,

938: END LOOP;
939:
940: DBMS_XMLQUERY.setRowSetTag( ctxHdl => queryCtx, Tag => 'DATAAREA');
941: DBMS_XMLQUERY.setMetaHeader( ctxHdl => queryCtx, Header => l_hdr_DTD);
942: DBMS_XMLQUERY.setDataHeader( ctxHdl => queryCtx, Header => l_hdr_XML,
943: Tag => 'BUS_OBJ');
944:
945:
946: /*

Line 964: l_msg_XML := DBMS_XMLQUERY.getXML ( ctxHdl => queryCtx,

960: dbms_lob.copy( l_msg_SQL_lob, l_msg_SQL, l_msg_SQL_len, 1, 1);
961: */
962:
963:
964: l_msg_XML := DBMS_XMLQUERY.getXML ( ctxHdl => queryCtx,
965: metatype => DBMS_XMLQUERY.DTD);
966:
967:
968: /*

Line 965: metatype => DBMS_XMLQUERY.DTD);

961: */
962:
963:
964: l_msg_XML := DBMS_XMLQUERY.getXML ( ctxHdl => queryCtx,
965: metatype => DBMS_XMLQUERY.DTD);
966:
967:
968: /*
969: position := 1;