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_VERSION_PVT dependencies on OKC_K_HEADERS_B

Line 85: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

81: if p_action = 'SAVE_VERSION' then
82: --
83: -- Remove Header Level Attachment
84: --
85: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
86: l_pkey1 => p_chr_id,
87: l_pkey2 => l_minus_version) = 'Y' then
88:
89: fnd_attached_documents2_pkg.delete_attachments(

Line 90: x_entity_name => 'OKC_K_HEADERS_B',

86: l_pkey1 => p_chr_id,
87: l_pkey2 => l_minus_version) = 'Y' then
88:
89: fnd_attached_documents2_pkg.delete_attachments(
90: x_entity_name => 'OKC_K_HEADERS_B',
91: x_pk1_value => p_chr_id,
92: x_pk2_value => l_minus_version,
93: x_delete_document_flag => 'Y'); --
94:

Line 119: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

115: -- Creating Attachments for -1 level version of the contract
116: --
117: -- version Header Level Attachments
118: --
119: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
120: l_pkey1 => p_chr_id,
121: l_pkey2 => l_major_version) = 'Y' then
122:
123: fnd_attached_documents2_pkg.copy_attachments(

Line 124: x_from_entity_name => 'OKC_K_HEADERS_B',

120: l_pkey1 => p_chr_id,
121: l_pkey2 => l_major_version) = 'Y' then
122:
123: fnd_attached_documents2_pkg.copy_attachments(
124: x_from_entity_name => 'OKC_K_HEADERS_B',
125: x_from_pk1_value => p_chr_id,
126: x_from_pk2_value => l_major_version,
127: x_to_entity_name => 'OKC_K_HEADERS_B',
128: x_to_pk1_value => p_chr_id,

Line 127: x_to_entity_name => 'OKC_K_HEADERS_B',

123: fnd_attached_documents2_pkg.copy_attachments(
124: x_from_entity_name => 'OKC_K_HEADERS_B',
125: x_from_pk1_value => p_chr_id,
126: x_from_pk2_value => l_major_version,
127: x_to_entity_name => 'OKC_K_HEADERS_B',
128: x_to_pk1_value => p_chr_id,
129: x_to_pk2_value => p_major_version);
130: end if;
131: --

Line 170: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

166: -- Delete Header Level Attachments with version
167: --
168: for l_ver_num in l_rest_to_major_ver..l_curr_major_ver loop
169:
170: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
171: l_pkey1 => p_chr_id,
172: l_pkey2 => l_ver_num) = 'Y' then
173:
174: fnd_attached_documents2_pkg.delete_attachments(

Line 175: x_entity_name => 'OKC_K_HEADERS_B',

171: l_pkey1 => p_chr_id,
172: l_pkey2 => l_ver_num) = 'Y' then
173:
174: fnd_attached_documents2_pkg.delete_attachments(
175: x_entity_name => 'OKC_K_HEADERS_B',
176: x_pk1_value => p_chr_id,
177: x_pk2_value => l_ver_num,
178: x_delete_document_flag => 'Y');
179:

Line 184: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

180: end if;
181: --
182: if l_ver_num = l_rest_to_major_ver then
183: --
184: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
185: l_pkey1 => p_chr_id,
186: l_pkey2 => l_minus_version) = 'Y' then
187:
188: fnd_attached_documents2_pkg.copy_attachments(

Line 189: x_from_entity_name => 'OKC_K_HEADERS_B',

185: l_pkey1 => p_chr_id,
186: l_pkey2 => l_minus_version) = 'Y' then
187:
188: fnd_attached_documents2_pkg.copy_attachments(
189: x_from_entity_name => 'OKC_K_HEADERS_B',
190: x_from_pk1_value => p_chr_id,
191: x_from_pk2_value => l_minus_version,
192: x_to_entity_name => 'OKC_K_HEADERS_B',
193: x_to_pk1_value => p_chr_id,

Line 192: x_to_entity_name => 'OKC_K_HEADERS_B',

188: fnd_attached_documents2_pkg.copy_attachments(
189: x_from_entity_name => 'OKC_K_HEADERS_B',
190: x_from_pk1_value => p_chr_id,
191: x_from_pk2_value => l_minus_version,
192: x_to_entity_name => 'OKC_K_HEADERS_B',
193: x_to_pk1_value => p_chr_id,
194: x_to_pk2_value => l_ver_num);
195: end if;
196: --

Line 245: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',

241: --
242: --
243: -- Remove Header Level Attachment
244: --
245: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_HEADERS_B',
246: l_pkey1 => p_chr_id,
247: l_pkey2 => l_minus_version) = 'Y' then
248:
249: fnd_attached_documents2_pkg.delete_attachments(

Line 250: x_entity_name => 'OKC_K_HEADERS_B',

246: l_pkey1 => p_chr_id,
247: l_pkey2 => l_minus_version) = 'Y' then
248:
249: fnd_attached_documents2_pkg.delete_attachments(
250: x_entity_name => 'OKC_K_HEADERS_B',
251: x_pk1_value => p_chr_id,
252: x_pk2_value => l_minus_version,
253: x_delete_document_flag => 'Y'); --
254:

Line 368: FROM okc_k_headers_b, okc_subclasses_b

364:
365: -- Cursor to get the class code
366: CURSOR cur_scs(p_chr_id number) is
367: SELECT cls_code
368: FROM okc_k_headers_b, okc_subclasses_b
369: WHERE id = p_chr_id and code = scs_code;
370:
371: -- Cursor created to get the PDF_ID for a particular Class
372: CURSOR c_pdf(p_cls_code VARCHAR2) IS

Line 796: from okc_k_headers_b a,okc_subclasses_b b

792: nowait;
793:
794: cursor c_curs is
795: select b.cls_code
796: from okc_k_headers_b a,okc_subclasses_b b
797: where a.scs_code=b.code and a.id = p_chr_id;
798:
799: l_dummy varchar2(1);
800:

Line 1232: DELETE FROM OKC_K_HEADERS_BH

1228: WHERE id = p_chr_id
1229: AND (MAJOR_VERSION = -2
1230: AND p_called_from = 'ERASE_SAVED_VERSION');
1231:
1232: DELETE FROM OKC_K_HEADERS_BH
1233: WHERE id= p_chr_id
1234: AND (MAJOR_VERSION = -2
1235: AND p_called_from = 'ERASE_SAVED_VERSION');
1236:

Line 1322: delete FROM OKC_K_HEADERS_BH

1318: or (p_called_from = 'RESTORE_VERSION'
1319: and (major_version > l_major_version
1320: or major_version = -1)));
1321: --
1322: delete FROM OKC_K_HEADERS_BH
1323: WHERE id= p_chr_id
1324: and ((MAJOR_VERSION = -1
1325: and p_called_from = 'ERASE_SAVED_VERSION')
1326: or (p_called_from = 'RESTORE_VERSION'

Line 1669: FROM okc_k_headers_b, okc_subclasses_b

1665:
1666: -- Cursor to get the class code
1667: CURSOR cur_scs(p_chr_id number) is
1668: SELECT cls_code
1669: FROM okc_k_headers_b, okc_subclasses_b
1670: WHERE id = p_chr_id and code = scs_code;
1671:
1672: -- Cursor created to get the PDF_ID for a particular Class
1673: CURSOR c_pdf(p_cls_code VARCHAR2) IS

Line 1802: FROM okc_k_headers_b

1798: nowait;
1799: /*Added for Bug 5175907 */
1800: Cursor l_status_csr Is
1801: SELECT sts_code
1802: FROM okc_k_headers_b
1803: WHERE ID = p_chr_id;
1804:
1805: CURSOR version_csr(p_chr_id NUMBER) IS
1806: SELECT to_char (major_version)||'.'||to_char(minor_version)

Line 1893: delete from OKC_K_HEADERS_B where ID = p_chr_id;

1889:
1890: delete from OKC_K_HEADERS_TL
1891: WHERE id = p_chr_id;
1892:
1893: delete from OKC_K_HEADERS_B where ID = p_chr_id;
1894:
1895: delete from OKC_K_ITEMS where DNZ_CHR_ID = p_chr_id;
1896: --
1897: delete from OKC_PRICE_ATT_VALUES WHERE chr_id = p_chr_id or cle_id in (select id from okc_k_lines_b where dnz_chr_id=p_chr_id);

Line 2370: FROM okc_k_headers_b

2366: PROCEDURE Set_Attach_Session_Vars(p_chr_id NUMBER) IS
2367: l_app_id NUMBER;
2368: Cursor l_chr_csr Is
2369: SELECT application_id
2370: FROM okc_k_headers_b
2371: WHERE id = p_chr_id;
2372: BEGIN
2373: If (p_chr_id IS NOT NULL AND
2374: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL