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_IMP_TERMS_TEMPLATES_PUB dependencies on OKC_IMP_TERMS_TEMPLATES_PVT

Line 5: p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,

1: PACKAGE BODY okc_imp_terms_templates_pub
2: /*$Header: OKCPITTB.pls 120.1.12020000.2 2012/07/16 16:13:21 harchand ship $*/
3: AS
4: PROCEDURE create_template (
5: p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
6: p_commit IN VARCHAR2 := fnd_api.g_false
7: )
8: IS
9: BEGIN

Line 10: okc_imp_terms_templates_pvt.create_template

6: p_commit IN VARCHAR2 := fnd_api.g_false
7: )
8: IS
9: BEGIN
10: okc_imp_terms_templates_pvt.create_template
11: (p_template_tbl => p_template_tbl,
12: p_commit => p_commit
13: );
14: END create_template;

Line 17: p_article_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.k_article_tbl_type,

13: );
14: END create_template;
15:
16: PROCEDURE create_article (
17: p_article_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.k_article_tbl_type,
18: p_commit IN VARCHAR2 := fnd_api.g_false
19: )
20: IS
21: BEGIN

Line 22: okc_imp_terms_templates_pvt.create_article

18: p_commit IN VARCHAR2 := fnd_api.g_false
19: )
20: IS
21: BEGIN
22: okc_imp_terms_templates_pvt.create_article
23: (p_article_tbl => p_article_tbl,
24: p_commit => p_commit
25: );
26: END create_article;

Line 29: p_section_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.section_tbl_type,

25: );
26: END create_article;
27:
28: PROCEDURE create_section (
29: p_section_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.section_tbl_type,
30: p_commit IN VARCHAR2 := fnd_api.g_false
31: )
32: IS
33: BEGIN

Line 34: okc_imp_terms_templates_pvt.create_section

30: p_commit IN VARCHAR2 := fnd_api.g_false
31: )
32: IS
33: BEGIN
34: okc_imp_terms_templates_pvt.create_section
35: (p_section_tbl => p_section_tbl,
36: p_commit => p_commit
37: );
38: END create_section;

Line 41: p_deliverable_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_tbl_type,

37: );
38: END create_section;
39:
40: PROCEDURE create_deliverable (
41: p_deliverable_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_tbl_type,
42: p_commit IN VARCHAR2 := fnd_api.g_false
43: )
44: IS
45: BEGIN

Line 46: okc_imp_terms_templates_pvt.create_deliverable

42: p_commit IN VARCHAR2 := fnd_api.g_false
43: )
44: IS
45: BEGIN
46: okc_imp_terms_templates_pvt.create_deliverable
47: (p_deliverable_tbl => p_deliverable_tbl,
48: p_commit => p_commit
49: );
50: END create_deliverable;

Line 52: PROCEDURE update_template( p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,

48: p_commit => p_commit
49: );
50: END create_deliverable;
51:
52: PROCEDURE update_template( p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
53: p_commit IN VARCHAR2 := fnd_api.g_false
54: )
55: IS
56: BEGIN

Line 57: okc_imp_terms_templates_pvt.update_template(p_template_tbl => p_template_tbl,

53: p_commit IN VARCHAR2 := fnd_api.g_false
54: )
55: IS
56: BEGIN
57: okc_imp_terms_templates_pvt.update_template(p_template_tbl => p_template_tbl,
58: p_commit => p_commit
59: );
60: END update_template;
61:

Line 74: okc_imp_terms_templates_pvt.create_template_revision

70: x_msg_count OUT NOCOPY NUMBER
71: )
72: IS
73: BEGIN
74: okc_imp_terms_templates_pvt.create_template_revision
75: (p_template_id => p_template_id,
76: p_copy_deliverables => p_copy_deliverables,
77: p_commit => p_commit,
78: x_new_template_id => x_new_template_id,

Line 87: p_k_article_id_tbl IN okc_imp_terms_templates_pvt.k_article_id_tbl_type,

83: END create_template_revision;
84:
85: PROCEDURE delete_articles (
86: p_template_id IN NUMBER,
87: p_k_article_id_tbl IN okc_imp_terms_templates_pvt.k_article_id_tbl_type,
88: p_commit IN VARCHAR2 := fnd_api.g_false,
89: x_k_article_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.k_article_id_tbl_type,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_data OUT NOCOPY VARCHAR2

Line 89: x_k_article_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.k_article_id_tbl_type,

85: PROCEDURE delete_articles (
86: p_template_id IN NUMBER,
87: p_k_article_id_tbl IN okc_imp_terms_templates_pvt.k_article_id_tbl_type,
88: p_commit IN VARCHAR2 := fnd_api.g_false,
89: x_k_article_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.k_article_id_tbl_type,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_data OUT NOCOPY VARCHAR2
92: )
93: IS

Line 95: okc_imp_terms_templates_pvt.delete_articles

91: x_msg_data OUT NOCOPY VARCHAR2
92: )
93: IS
94: BEGIN
95: okc_imp_terms_templates_pvt.delete_articles
96: (p_template_id => p_template_id,
97: p_k_article_id_tbl => p_k_article_id_tbl,
98: p_commit => p_commit,
99: x_k_article_id_tbl => x_k_article_id_tbl,

Line 107: p_section_id_tbl IN okc_imp_terms_templates_pvt.section_id_tbl_type,

103: END delete_articles;
104:
105: PROCEDURE delete_sections (
106: p_template_id IN NUMBER,
107: p_section_id_tbl IN okc_imp_terms_templates_pvt.section_id_tbl_type,
108: p_commit IN VARCHAR2 := fnd_api.g_false,
109: x_section_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.section_id_tbl_type,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_data OUT NOCOPY VARCHAR2

Line 109: x_section_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.section_id_tbl_type,

105: PROCEDURE delete_sections (
106: p_template_id IN NUMBER,
107: p_section_id_tbl IN okc_imp_terms_templates_pvt.section_id_tbl_type,
108: p_commit IN VARCHAR2 := fnd_api.g_false,
109: x_section_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.section_id_tbl_type,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_data OUT NOCOPY VARCHAR2
112: )
113: IS

Line 115: okc_imp_terms_templates_pvt.delete_sections

111: x_msg_data OUT NOCOPY VARCHAR2
112: )
113: IS
114: BEGIN
115: okc_imp_terms_templates_pvt.delete_sections
116: (p_template_id => p_template_id,
117: p_section_id_tbl => p_section_id_tbl,
118: p_commit => p_commit,
119: x_section_id_tbl => x_section_id_tbl,

Line 127: p_deliverable_id_tbl IN okc_imp_terms_templates_pvt.deliverable_id_tbl_type,

123: END delete_sections;
124:
125: PROCEDURE delete_deliverables (
126: p_template_id IN NUMBER,
127: p_deliverable_id_tbl IN okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
128: p_commit IN VARCHAR2 := fnd_api.g_false,
129: x_deliverable_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_data OUT NOCOPY VARCHAR2

Line 129: x_deliverable_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_id_tbl_type,

125: PROCEDURE delete_deliverables (
126: p_template_id IN NUMBER,
127: p_deliverable_id_tbl IN okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
128: p_commit IN VARCHAR2 := fnd_api.g_false,
129: x_deliverable_id_tbl OUT NOCOPY okc_imp_terms_templates_pvt.deliverable_id_tbl_type,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_data OUT NOCOPY VARCHAR2
132: )
133: IS

Line 135: okc_imp_terms_templates_pvt.delete_deliverables

131: x_msg_data OUT NOCOPY VARCHAR2
132: )
133: IS
134: BEGIN
135: okc_imp_terms_templates_pvt.delete_deliverables
136: (p_template_id => p_template_id,
137: p_deliverable_id_tbl => p_deliverable_id_tbl,
138: p_commit => p_commit,
139: x_deliverable_id_tbl => x_deliverable_id_tbl,

Line 147: p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,

143: END delete_deliverables;
144: -- Template Usages --
145: PROCEDURE create_tmpl_usage (
146: p_template_id IN NUMBER,
147: p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
148: p_commit IN VARCHAR2 := fnd_api.g_false
149: )
150: IS
151: BEGIN

Line 152: okc_imp_terms_templates_pvt.create_tmpl_usage( p_template_id => p_template_id,

148: p_commit IN VARCHAR2 := fnd_api.g_false
149: )
150: IS
151: BEGIN
152: okc_imp_terms_templates_pvt.create_tmpl_usage( p_template_id => p_template_id,
153: p_tmpl_usage_tbl => p_tmpl_usage_tbl,
154: p_commit => p_commit
155: );
156: END create_tmpl_usage;

Line 160: p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,

156: END create_tmpl_usage;
157:
158: PROCEDURE update_tmpl_usage(
159: p_template_id IN NUMBER ,
160: p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
161: p_commit IN VARCHAR2 := fnd_api.g_false
162: )
163: IS
164: BEGIN

Line 165: okc_imp_terms_templates_pvt.update_tmpl_usage( p_template_id => p_template_id,

161: p_commit IN VARCHAR2 := fnd_api.g_false
162: )
163: IS
164: BEGIN
165: okc_imp_terms_templates_pvt.update_tmpl_usage( p_template_id => p_template_id,
166: p_tmpl_usage_tbl => p_tmpl_usage_tbl,
167: p_commit => p_commit
168: );
169: END update_tmpl_usage;

Line 173: p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,

169: END update_tmpl_usage;
170:
171: PROCEDURE delete_tmpl_usage (
172: p_template_id IN NUMBER ,
173: p_tmpl_usage_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.tmpl_usage_tbl_type,
174: p_commit IN VARCHAR2 := fnd_api.g_false
175: )
176: IS
177: BEGIN

Line 178: okc_imp_terms_templates_pvt.delete_tmpl_usage( p_template_id => p_template_id,

174: p_commit IN VARCHAR2 := fnd_api.g_false
175: )
176: IS
177: BEGIN
178: okc_imp_terms_templates_pvt.delete_tmpl_usage( p_template_id => p_template_id,
179: p_tmpl_usage_tbl => p_tmpl_usage_tbl,
180: p_commit => p_commit
181: );
182: