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.OKC_XML_PVT dependencies on OKC_AQ_MSG_TYP

Line 22: x_xml_clob OUT NOCOPY system.okc_aq_msg_typ

18:
19: PROCEDURE build_xml_clob (
20: p_corrid_rec IN okc_aq_pvt.corrid_rec_typ,
21: p_element_tbl IN okc_aq_pvt.msg_tab_typ,
22: x_xml_clob OUT NOCOPY system.okc_aq_msg_typ
23: )
24: IS
25: l_element_name varchar2(240);
26: l_element_value varchar2(240);

Line 28: l_xml_clob system.okc_aq_msg_typ;

24: IS
25: l_element_name varchar2(240);
26: l_element_value varchar2(240);
27: l_index number := 1;
28: l_xml_clob system.okc_aq_msg_typ;
29: l_constant varchar2(32767) := '';
30: l_char_msg varchar2(32767);
31: l_dest_clob system.okc_aq_msg_typ;
32: l_amount integer := 32767;

Line 31: l_dest_clob system.okc_aq_msg_typ;

27: l_index number := 1;
28: l_xml_clob system.okc_aq_msg_typ;
29: l_constant varchar2(32767) := '';
30: l_char_msg varchar2(32767);
31: l_dest_clob system.okc_aq_msg_typ;
32: l_amount integer := 32767;
33: BEGIN
34: -- create a temporary lob
35: l_xml_clob := system.okc_aq_msg_typ(empty_clob());

Line 35: l_xml_clob := system.okc_aq_msg_typ(empty_clob());

31: l_dest_clob system.okc_aq_msg_typ;
32: l_amount integer := 32767;
33: BEGIN
34: -- create a temporary lob
35: l_xml_clob := system.okc_aq_msg_typ(empty_clob());
36: x_xml_clob := system.okc_aq_msg_typ(empty_clob());
37: dbms_lob.createtemporary(l_xml_clob.body,TRUE,dbms_lob.session);
38: dbms_lob.writeappend(l_xml_clob.body,length(l_constant),l_constant);
39:

Line 36: x_xml_clob := system.okc_aq_msg_typ(empty_clob());

32: l_amount integer := 32767;
33: BEGIN
34: -- create a temporary lob
35: l_xml_clob := system.okc_aq_msg_typ(empty_clob());
36: x_xml_clob := system.okc_aq_msg_typ(empty_clob());
37: dbms_lob.createtemporary(l_xml_clob.body,TRUE,dbms_lob.session);
38: dbms_lob.writeappend(l_xml_clob.body,length(l_constant),l_constant);
39:
40: -- load message body with message

Line 100: p_msg IN system.okc_aq_msg_typ,

96: END;
97:
98:
99: PROCEDURE get_element_vals (
100: p_msg IN system.okc_aq_msg_typ,
101: x_msg_tab OUT NOCOPY okc_aq_pvt.msg_tab_typ,
102: x_corrid OUT NOCOPY okc_aq_pvt.corrid_rec_typ)
103: IS
104: search_start number(10) := 1;

Line 109: l_msg system.okc_aq_msg_typ;

105: start_bracket varchar2(1) := '<';
106: end_bracket varchar2(1) := '>';
107: end_tag varchar2(2) := ' 108: l_tag varchar2(3) := '>]>';
109: l_msg system.okc_aq_msg_typ;
110: l_temp_clob system.okc_aq_msg_typ;
111: l_temp1_clob system.okc_aq_msg_typ;
112: l_char_element_name varchar2(32767);
113: l_char_element_value varchar2(32767);

Line 110: l_temp_clob system.okc_aq_msg_typ;

106: end_bracket varchar2(1) := '>';
107: end_tag varchar2(2) := ' 108: l_tag varchar2(3) := '>]>';
109: l_msg system.okc_aq_msg_typ;
110: l_temp_clob system.okc_aq_msg_typ;
111: l_temp1_clob system.okc_aq_msg_typ;
112: l_char_element_name varchar2(32767);
113: l_char_element_value varchar2(32767);
114: l_char_corrid varchar2(32767);

Line 111: l_temp1_clob system.okc_aq_msg_typ;

107: end_tag varchar2(2) := ' 108: l_tag varchar2(3) := '>]>';
109: l_msg system.okc_aq_msg_typ;
110: l_temp_clob system.okc_aq_msg_typ;
111: l_temp1_clob system.okc_aq_msg_typ;
112: l_char_element_name varchar2(32767);
113: l_char_element_value varchar2(32767);
114: l_char_corrid varchar2(32767);
115: l_start_bracket_pos number(5);

Line 125: l_msg := system.okc_aq_msg_typ(empty_clob());

121: l_amount integer;
122:
123: BEGIN
124:
125: l_msg := system.okc_aq_msg_typ(empty_clob());
126: dbms_lob.createtemporary(l_msg.body,TRUE,dbms_lob.session);
127: l_temp_clob := system.okc_aq_msg_typ(empty_clob());
128: dbms_lob.createtemporary(l_temp_clob.body,TRUE,dbms_lob.session);
129: l_temp1_clob := system.okc_aq_msg_typ(empty_clob());

Line 127: l_temp_clob := system.okc_aq_msg_typ(empty_clob());

123: BEGIN
124:
125: l_msg := system.okc_aq_msg_typ(empty_clob());
126: dbms_lob.createtemporary(l_msg.body,TRUE,dbms_lob.session);
127: l_temp_clob := system.okc_aq_msg_typ(empty_clob());
128: dbms_lob.createtemporary(l_temp_clob.body,TRUE,dbms_lob.session);
129: l_temp1_clob := system.okc_aq_msg_typ(empty_clob());
130: dbms_lob.createtemporary(l_temp1_clob.body,TRUE,dbms_lob.session);
131: l_msg := p_msg;

Line 129: l_temp1_clob := system.okc_aq_msg_typ(empty_clob());

125: l_msg := system.okc_aq_msg_typ(empty_clob());
126: dbms_lob.createtemporary(l_msg.body,TRUE,dbms_lob.session);
127: l_temp_clob := system.okc_aq_msg_typ(empty_clob());
128: dbms_lob.createtemporary(l_temp_clob.body,TRUE,dbms_lob.session);
129: l_temp1_clob := system.okc_aq_msg_typ(empty_clob());
130: dbms_lob.createtemporary(l_temp1_clob.body,TRUE,dbms_lob.session);
131: l_msg := p_msg;
132:
133: -- fix the position to remove DTD of xml string