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_TERMS_DEVIATIONS_PVT dependencies on OKC_TERMS_DEVIATIONS_T

Line 44: type scn_id_tbl is TABLE of okc_terms_deviations_temp.scn_id%type

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

Line 46: type article_id_tbl is TABLE OF okc_terms_deviations_temp.article_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

Line 48: type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_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

Line 50: type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_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

Line 52: type ref_article_version_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_version_id%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

Line 54: type display_sequence_tbl is TABLE OF okc_terms_deviations_temp.display_sequence%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

Line 56: type label_tbl is TABLE OF okc_terms_deviations_t.label%type

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
59: INDEX BY BINARY_INTEGER;
60: type orig_article_id_tbl is TABLE OF okc_terms_deviations_temp.orig_article_id%type

Line 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

Line 60: type orig_article_id_tbl is TABLE OF okc_terms_deviations_temp.orig_article_id%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

Line 62: type section_heading_tbl is TABLE OF okc_terms_deviations_t.section_heading%type

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
65: INDEX BY BINARY_INTEGER;
66: type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type

Line 64: type article_title_tbl is TABLE OF okc_terms_deviations_t.article_title%type

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
65: INDEX BY BINARY_INTEGER;
66: type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type
67: INDEX BY BINARY_INTEGER;
68: type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type

Line 66: type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type

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
65: INDEX BY BINARY_INTEGER;
66: type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type
67: INDEX BY BINARY_INTEGER;
68: type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type
69: INDEX BY BINARY_INTEGER;
70: type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type

Line 68: type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type

64: type article_title_tbl is TABLE OF okc_terms_deviations_t.article_title%type
65: INDEX BY BINARY_INTEGER;
66: type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type
67: INDEX BY BINARY_INTEGER;
68: type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type
69: INDEX BY BINARY_INTEGER;
70: type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type
71: INDEX BY BINARY_INTEGER;
72: type dev_code_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_code_meaning%type

Line 70: type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type

66: type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type
67: INDEX BY BINARY_INTEGER;
68: type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type
69: INDEX BY BINARY_INTEGER;
70: type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type
71: INDEX BY BINARY_INTEGER;
72: type dev_code_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_code_meaning%type
73: INDEX BY BINARY_INTEGER;
74: type art_seq_id_tbl is TABLE OF okc_terms_deviations_t.art_seq_id%type

Line 72: type dev_code_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_code_meaning%type

68: type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type
69: INDEX BY BINARY_INTEGER;
70: type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type
71: INDEX BY BINARY_INTEGER;
72: type dev_code_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_code_meaning%type
73: INDEX BY BINARY_INTEGER;
74: type art_seq_id_tbl is TABLE OF okc_terms_deviations_t.art_seq_id%type
75: INDEX BY BINARY_INTEGER;
76:

Line 74: type art_seq_id_tbl is TABLE OF okc_terms_deviations_t.art_seq_id%type

70: type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type
71: INDEX BY BINARY_INTEGER;
72: type dev_code_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_code_meaning%type
73: INDEX BY BINARY_INTEGER;
74: type art_seq_id_tbl is TABLE OF okc_terms_deviations_t.art_seq_id%type
75: INDEX BY BINARY_INTEGER;
76:
77: -- Procedure to insert data into okc_terms_deviations_t table
78: -- this will be a BULK insert as all the parameters passed to

Line 77: -- Procedure to insert data into okc_terms_deviations_t table

73: INDEX BY BINARY_INTEGER;
74: type art_seq_id_tbl is TABLE OF okc_terms_deviations_t.art_seq_id%type
75: INDEX BY BINARY_INTEGER;
76:
77: -- Procedure to insert data into okc_terms_deviations_t table
78: -- this will be a BULK insert as all the parameters passed to
79: -- this routine are table type.
80: Procedure Insert_deviations(
81: x_return_status OUT NOCOPY VARCHAR2,