DBA Data[Home] [Help]

APPS.OKC_XML_PVT dependencies on OKC_AQ_PVT

Line 20: p_corrid_rec IN okc_aq_pvt.corrid_rec_typ,

16: -- Procedures and Functions
17: ---------------------------------------------------------------------------
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

Line 21: p_element_tbl IN okc_aq_pvt.msg_tab_typ,

17: ---------------------------------------------------------------------------
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);

Line 101: x_msg_tab OUT NOCOPY okc_aq_pvt.msg_tab_typ,

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;
105: start_bracket varchar2(1) := '<';

Line 102: x_corrid OUT NOCOPY okc_aq_pvt.corrid_rec_typ)

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;
105: start_bracket varchar2(1) := '<';
106: end_bracket varchar2(1) := '>';

Line 119: l_msg_tab okc_aq_pvt.msg_tab_typ:=okc_aq_pvt.msg_tab_typ();

115: l_start_bracket_pos number(5);
116: l_start_pos integer ;
117: l_end_pos integer;
118: l_length integer;
119: l_msg_tab okc_aq_pvt.msg_tab_typ:=okc_aq_pvt.msg_tab_typ();
120: l_index integer := 1;
121: l_amount integer;
122:
123: BEGIN