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_LINES_B

Line 40: from okc_k_lines_b

36: where chr_id = p_chr_id;
37: --
38: cursor c_lines is
39: select id
40: from okc_k_lines_b
41: where dnz_chr_id = p_chr_id;
42: --
43: cursor c_rest_to_ver is
44: select object_version_number

Line 101: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

97: -- Remove Line Level Attachment
98: --
99: for c_lines_rec in c_lines loop
100: --
101: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
102: l_pkey1 => c_lines_rec.id,
103: l_pkey2 => l_minus_version) = 'Y' then
104:
105: fnd_attached_documents2_pkg.delete_attachments(

Line 106: x_entity_name => 'OKC_K_LINES_B',

102: l_pkey1 => c_lines_rec.id,
103: l_pkey2 => l_minus_version) = 'Y' then
104:
105: fnd_attached_documents2_pkg.delete_attachments(
106: x_entity_name => 'OKC_K_LINES_B',
107: x_pk1_value => c_lines_rec.id,
108: x_pk2_value => l_minus_version,
109: x_delete_document_flag => 'Y');
110:

Line 136: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

132: -- Version Line Level Attachments
133: --
134: for c_lines_rec in c_lines loop
135: --
136: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
137: l_pkey1 => c_lines_rec.id,
138: l_pkey2 => l_major_version) = 'Y' then
139:
140: fnd_attached_documents2_pkg.copy_attachments(

Line 141: x_from_entity_name => 'OKC_K_LINES_B',

137: l_pkey1 => c_lines_rec.id,
138: l_pkey2 => l_major_version) = 'Y' then
139:
140: fnd_attached_documents2_pkg.copy_attachments(
141: x_from_entity_name => 'OKC_K_LINES_B',
142: x_from_pk1_value => c_lines_rec.id,
143: x_from_pk2_value => l_major_version,
144: x_to_entity_name => 'OKC_K_LINES_B',
145: x_to_pk1_value => c_lines_rec.id,

Line 144: x_to_entity_name => 'OKC_K_LINES_B',

140: fnd_attached_documents2_pkg.copy_attachments(
141: x_from_entity_name => 'OKC_K_LINES_B',
142: x_from_pk1_value => c_lines_rec.id,
143: x_from_pk2_value => l_major_version,
144: x_to_entity_name => 'OKC_K_LINES_B',
145: x_to_pk1_value => c_lines_rec.id,
146: x_to_pk2_value => p_major_version);
147: end if;
148: --

Line 205: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

201: --
202: for c_lines_rec in c_lines loop
203: --
204: for l_ver_num in l_rest_to_major_ver..l_curr_major_ver loop
205: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
206: l_pkey1 => c_lines_rec.id,
207: l_pkey2 => l_ver_num) = 'Y' then
208:
209: fnd_attached_documents2_pkg.delete_attachments(

Line 210: x_entity_name => 'OKC_K_LINES_B',

206: l_pkey1 => c_lines_rec.id,
207: l_pkey2 => l_ver_num) = 'Y' then
208:
209: fnd_attached_documents2_pkg.delete_attachments(
210: x_entity_name => 'OKC_K_LINES_B',
211: x_pk1_value => c_lines_rec.id,
212: x_pk2_value => l_ver_num,
213: x_delete_document_flag => 'Y');
214:

Line 220: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

216: --
217: --
218: if l_ver_num = l_rest_to_major_ver then
219: --
220: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
221: l_pkey1 => c_lines_rec.id,
222: l_pkey2 => l_minus_version) = 'Y' then
223:
224: fnd_attached_documents2_pkg.copy_attachments(

Line 225: x_from_entity_name => 'OKC_K_LINES_B',

221: l_pkey1 => c_lines_rec.id,
222: l_pkey2 => l_minus_version) = 'Y' then
223:
224: fnd_attached_documents2_pkg.copy_attachments(
225: x_from_entity_name => 'OKC_K_LINES_B',
226: x_from_pk1_value => c_lines_rec.id,
227: x_from_pk2_value => l_minus_version,
228: x_to_entity_name => 'OKC_K_LINES_B',
229: x_to_pk1_value => c_lines_rec.id,

Line 228: x_to_entity_name => 'OKC_K_LINES_B',

224: fnd_attached_documents2_pkg.copy_attachments(
225: x_from_entity_name => 'OKC_K_LINES_B',
226: x_from_pk1_value => c_lines_rec.id,
227: x_from_pk2_value => l_minus_version,
228: x_to_entity_name => 'OKC_K_LINES_B',
229: x_to_pk1_value => c_lines_rec.id,
230: x_to_pk2_value => l_ver_num);
231: end if;
232: --

Line 261: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',

257: -- Remove Line Level Attachment
258: --
259: for c_lines_rec in c_lines loop
260: --
261: if fnd_attachment_util_pkg.get_atchmt_exists (l_entity_name => 'OKC_K_LINES_B',
262: l_pkey1 => c_lines_rec.id,
263: l_pkey2 => l_minus_version) = 'Y' then
264:
265: fnd_attached_documents2_pkg.delete_attachments(

Line 266: x_entity_name => 'OKC_K_LINES_B',

262: l_pkey1 => c_lines_rec.id,
263: l_pkey2 => l_minus_version) = 'Y' then
264:
265: fnd_attached_documents2_pkg.delete_attachments(
266: x_entity_name => 'OKC_K_LINES_B',
267: x_pk1_value => c_lines_rec.id,
268: x_pk2_value => l_minus_version,
269: x_delete_document_flag => 'Y');
270:

Line 1347: WHERE id in (select id from OKC_K_LINES_BH

1343: and (major_version > l_major_version
1344: or major_version = -1)));
1345: --
1346: delete FROM OKC_K_LINES_TLH
1347: WHERE id in (select id from OKC_K_LINES_BH
1348: WHERE dnz_chr_id= p_chr_id)
1349: and ((MAJOR_VERSION = -1
1350: and p_called_from = 'ERASE_SAVED_VERSION')
1351: or (p_called_from = 'RESTORE_VERSION'

Line 1355: delete FROM OKC_K_LINES_BH

1351: or (p_called_from = 'RESTORE_VERSION'
1352: and (major_version > l_major_version
1353: or major_version = -1)));
1354: --
1355: delete FROM OKC_K_LINES_BH
1356: WHERE dnz_chr_id= p_chr_id
1357: and ((MAJOR_VERSION = -1
1358: and p_called_from = 'ERASE_SAVED_VERSION')
1359: or (p_called_from = 'RESTORE_VERSION'

Line 1551: WHERE (CLE_ID IN (SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID=p_chr_id ) )

1547: and (major_version >= l_major_version
1548: or major_version = -1)));
1549:
1550: delete FROM OKC_PRICE_ATT_VALUES_H
1551: WHERE (CLE_ID IN (SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID=p_chr_id ) )
1552: and ((MAJOR_VERSION = -1
1553: and p_called_from = 'ERASE_SAVED_VERSION')
1554: or (p_called_from = 'RESTORE_VERSION'
1555: and (major_version >= l_major_version

Line 1563: FROM okc_k_lines_b

1559:
1560: delete FROM OKC_PH_LINE_BREAKS_H --price hold
1561: WHERE cle_id IN
1562: (SELECT id
1563: FROM okc_k_lines_b
1564: WHERE dnz_chr_id = p_chr_id --price hold sub-line
1565: )
1566: and ((MAJOR_VERSION = -1
1567: and p_called_from = 'ERASE_SAVED_VERSION')

Line 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);

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);
1898: --
1899:
1900: delete from OKC_PH_LINE_BREAKS WHERE cle_id IN
1901: (SELECT id

Line 1902: FROM okc_k_lines_b

1898: --
1899:
1900: delete from OKC_PH_LINE_BREAKS WHERE cle_id IN
1901: (SELECT id
1902: FROM okc_k_lines_b
1903: WHERE dnz_chr_id = p_chr_id);
1904: --price hold line breaks are for a PRICE HOLD sub-line
1905:
1906:

Line 1908: WHERE id in (select id from OKC_K_LINES_B

1904: --price hold line breaks are for a PRICE HOLD sub-line
1905:
1906:
1907: delete from OKC_K_LINES_TL
1908: WHERE id in (select id from OKC_K_LINES_B
1909: WHERE dnz_chr_id= p_chr_id);
1910:
1911: delete from OKC_K_LINES_B where DNZ_CHR_ID = p_chr_id;
1912:

Line 1911: delete from OKC_K_LINES_B where DNZ_CHR_ID = p_chr_id;

1907: delete from OKC_K_LINES_TL
1908: WHERE id in (select id from OKC_K_LINES_B
1909: WHERE dnz_chr_id= p_chr_id);
1910:
1911: delete from OKC_K_LINES_B where DNZ_CHR_ID = p_chr_id;
1912:
1913: delete from OKC_K_PARTY_ROLES_TL
1914: WHERE id in (select id from OKC_K_PARTY_ROLES_B
1915: WHERE dnz_chr_id= p_chr_id);

Line 1969: -- 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);

1965: from OKC_PRICE_ADJUSTMENTS
1966: where chr_id = p_chr_id);
1967:
1968: -- Incorrect location for this delete statement below
1969: -- 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);
1970: --
1971:
1972:
1973: delete from OKC_K_SALES_CREDITS WHERE dnz_chr_id = p_chr_id;