40: p_template_id IN NUMBER ,
41: p_run_id OUT NOCOPY NUMBER
42: );
43:
44: type scn_id_tbl is TABLE of okc_terms_deviations_temp.scn_id%type
45: INDEX BY BINARY_INTEGER;
46: type article_id_tbl is TABLE OF okc_terms_deviations_temp.article_id%type
47: INDEX BY BINARY_INTEGER;
48: type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_id%type
42: );
43:
44: type scn_id_tbl is TABLE of okc_terms_deviations_temp.scn_id%type
45: INDEX BY BINARY_INTEGER;
46: type article_id_tbl is TABLE OF okc_terms_deviations_temp.article_id%type
47: INDEX BY BINARY_INTEGER;
48: type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_id%type
49: INDEX BY BINARY_INTEGER;
50: type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_id%type
44: type scn_id_tbl is TABLE of okc_terms_deviations_temp.scn_id%type
45: INDEX BY BINARY_INTEGER;
46: type article_id_tbl is TABLE OF okc_terms_deviations_temp.article_id%type
47: INDEX BY BINARY_INTEGER;
48: type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_id%type
49: INDEX BY BINARY_INTEGER;
50: type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_id%type
51: INDEX BY BINARY_INTEGER;
52: type ref_article_version_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_version_id%type
46: type article_id_tbl is TABLE OF okc_terms_deviations_temp.article_id%type
47: INDEX BY BINARY_INTEGER;
48: type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_id%type
49: INDEX BY BINARY_INTEGER;
50: type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_id%type
51: INDEX BY BINARY_INTEGER;
52: type ref_article_version_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_version_id%type
53: INDEX BY BINARY_INTEGER;
54: type display_sequence_tbl is TABLE OF okc_terms_deviations_temp.display_sequence%type
48: type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_id%type
49: INDEX BY BINARY_INTEGER;
50: type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_id%type
51: INDEX BY BINARY_INTEGER;
52: type ref_article_version_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_version_id%type
53: INDEX BY BINARY_INTEGER;
54: type display_sequence_tbl is TABLE OF okc_terms_deviations_temp.display_sequence%type
55: INDEX BY BINARY_INTEGER;
56: type label_tbl is TABLE OF okc_terms_deviations_t.label%type
50: type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_id%type
51: INDEX BY BINARY_INTEGER;
52: type ref_article_version_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_version_id%type
53: INDEX BY BINARY_INTEGER;
54: type display_sequence_tbl is TABLE OF okc_terms_deviations_temp.display_sequence%type
55: INDEX BY BINARY_INTEGER;
56: type label_tbl is TABLE OF okc_terms_deviations_t.label%type
57: INDEX BY BINARY_INTEGER;
58: type mandatory_flag_tbl is TABLE OF okc_terms_deviations_temp.mandatory_flag%type
54: type display_sequence_tbl is TABLE OF okc_terms_deviations_temp.display_sequence%type
55: INDEX BY BINARY_INTEGER;
56: type label_tbl is TABLE OF okc_terms_deviations_t.label%type
57: INDEX BY BINARY_INTEGER;
58: type mandatory_flag_tbl is TABLE OF okc_terms_deviations_temp.mandatory_flag%type
59: INDEX BY BINARY_INTEGER;
60: type orig_article_id_tbl is TABLE OF okc_terms_deviations_temp.orig_article_id%type
61: INDEX BY BINARY_INTEGER;
62: type section_heading_tbl is TABLE OF okc_terms_deviations_t.section_heading%type
56: type label_tbl is TABLE OF okc_terms_deviations_t.label%type
57: INDEX BY BINARY_INTEGER;
58: type mandatory_flag_tbl is TABLE OF okc_terms_deviations_temp.mandatory_flag%type
59: INDEX BY BINARY_INTEGER;
60: type orig_article_id_tbl is TABLE OF okc_terms_deviations_temp.orig_article_id%type
61: INDEX BY BINARY_INTEGER;
62: type section_heading_tbl is TABLE OF okc_terms_deviations_t.section_heading%type
63: INDEX BY BINARY_INTEGER;
64: type article_title_tbl is TABLE OF okc_terms_deviations_t.article_title%type