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.OKE_DELIVERABLE_PVT dependencies on OKE_K_DELIVERABLES_TL

Line 2500: from oke_k_deliverables_b b, oke_k_deliverables_tl t

2496: b.rate_date,
2497: b.exchange_rate,
2498: b.requisition_line_type_id,
2499: b.po_category_id
2500: from oke_k_deliverables_b b, oke_k_deliverables_tl t
2501: where b.deliverable_id = p_id
2502: and t.deliverable_id = p_id
2503: and t.language = userenv('LANG');
2504:

Line 3934: insert into OKE_K_DELIVERABLES_TL(

3930: l_def_del_rec.po_category_id);
3931:
3932: -- insert into TL table
3933:
3934: insert into OKE_K_DELIVERABLES_TL(
3935: deliverable_id,
3936: language,
3937: creation_date,
3938: created_by,

Line 3966: from OKE_K_DELIVERABLES_TL T

3962: from FND_LANGUAGES L
3963: where L.INSTALLED_FLAG in ('I', 'B')
3964: and not exists
3965: (select NULL
3966: from OKE_K_DELIVERABLES_TL T
3967: where T.DELIVERABLE_ID = l_def_del_rec.deliverable_id
3968: and T.LANGUAGE = L.LANGUAGE_CODE);
3969:
3970:

Line 4780: update oke_k_deliverables_tl

4776: where deliverable_id = l_def_del_rec.deliverable_id;
4777:
4778: -- update the TL table
4779:
4780: update oke_k_deliverables_tl
4781: set
4782: description = l_def_del_rec.description,
4783: comments = l_def_del_rec.comments,
4784: sfwt_flag = l_def_del_rec.sfwt_flag,

Line 5224: delete from OKE_K_DELIVERABLES_TL T

5220:
5221: PROCEDURE add_language
5222: is
5223: begin
5224: delete from OKE_K_DELIVERABLES_TL T
5225: where not exists
5226: (select NULL
5227: from OKE_K_DELIVERABLES_B B
5228: where B.DELIVERABLE_ID = T.DELIVERABLE_ID

Line 5231: update OKE_K_DELIVERABLES_TL T set (

5227: from OKE_K_DELIVERABLES_B B
5228: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5229: );
5230:
5231: update OKE_K_DELIVERABLES_TL T set (
5232: DESCRIPTION,
5233: COMMENTS
5234: ) = (select
5235: B.DESCRIPTION,

Line 5237: from OKE_K_DELIVERABLES_TL B

5233: COMMENTS
5234: ) = (select
5235: B.DESCRIPTION,
5236: B.COMMENTS
5237: from OKE_K_DELIVERABLES_TL B
5238: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5239: and B.LANGUAGE = T.SOURCE_LANG)
5240: where (
5241: T.DELIVERABLE_ID,

Line 5246: from OKE_K_DELIVERABLES_TL SUBB, OKE_K_DELIVERABLES_TL SUBT

5242: T.LANGUAGE
5243: ) in (select
5244: SUBT.DELIVERABLE_ID,
5245: SUBT.LANGUAGE
5246: from OKE_K_DELIVERABLES_TL SUBB, OKE_K_DELIVERABLES_TL SUBT
5247: where SUBB.DELIVERABLE_ID = SUBT.DELIVERABLE_ID
5248: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
5249: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
5250: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 5257: insert into OKE_K_DELIVERABLES_TL (

5253: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
5254: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
5255: ));
5256:
5257: insert into OKE_K_DELIVERABLES_TL (
5258: DELIVERABLE_ID,
5259: CREATION_DATE,
5260: CREATED_BY,
5261: LAST_UPDATE_DATE,

Line 5285: from OKE_K_DELIVERABLES_TL B, FND_LANGUAGES L

5281: B.DESCRIPTION,
5282: B.COMMENTS,
5283: L.LANGUAGE_CODE,
5284: B.SOURCE_LANG
5285: from OKE_K_DELIVERABLES_TL B, FND_LANGUAGES L
5286: where L.INSTALLED_FLAG in ('I', 'B')
5287: and B.LANGUAGE = userenv('LANG')
5288: and not exists
5289: (select NULL

Line 5290: from OKE_K_DELIVERABLES_TL T

5286: where L.INSTALLED_FLAG in ('I', 'B')
5287: and B.LANGUAGE = userenv('LANG')
5288: and not exists
5289: (select NULL
5290: from OKE_K_DELIVERABLES_TL T
5291: where T.DELIVERABLE_ID = B.DELIVERABLE_ID
5292: and T.LANGUAGE = L.LANGUAGE_CODE);
5293:
5294: --

Line 5297: delete from OKE_K_DELIVERABLES_TLH T

5293:
5294: --
5295: -- History table
5296: --
5297: delete from OKE_K_DELIVERABLES_TLH T
5298: where not exists
5299: (select NULL
5300: from OKE_K_DELIVERABLES_BH B
5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID

Line 5305: update OKE_K_DELIVERABLES_TLH T set (

5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5302: and T.MAJOR_VERSION = B.MAJOR_VERSION
5303: );
5304:
5305: update OKE_K_DELIVERABLES_TLH T set (
5306: DESCRIPTION,
5307: COMMENTS
5308: ) = (select
5309: B.DESCRIPTION,

Line 5311: from OKE_K_DELIVERABLES_TLH B

5307: COMMENTS
5308: ) = (select
5309: B.DESCRIPTION,
5310: B.COMMENTS
5311: from OKE_K_DELIVERABLES_TLH B
5312: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5313: and B.LANGUAGE = T.SOURCE_LANG
5314: and T.MAJOR_VERSION = B.MAJOR_VERSION)
5315: where (

Line 5323: from OKE_K_DELIVERABLES_TLH SUBB, OKE_K_DELIVERABLES_TLH SUBT

5319: ) in (select
5320: SUBT.DELIVERABLE_ID,
5321: SUBT.MAJOR_VERSION,
5322: SUBT.LANGUAGE
5323: from OKE_K_DELIVERABLES_TLH SUBB, OKE_K_DELIVERABLES_TLH SUBT
5324: where SUBB.DELIVERABLE_ID = SUBT.DELIVERABLE_ID
5325: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
5326: and SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
5327: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 5335: insert into OKE_K_DELIVERABLES_TLH (

5331: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
5332: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
5333: ));
5334:
5335: insert into OKE_K_DELIVERABLES_TLH (
5336: DELIVERABLE_ID,
5337: MAJOR_VERSION,
5338: CREATION_DATE,
5339: CREATED_BY,

Line 5365: from OKE_K_DELIVERABLES_TLH B, FND_LANGUAGES L

5361: B.DESCRIPTION,
5362: B.COMMENTS,
5363: L.LANGUAGE_CODE,
5364: B.SOURCE_LANG
5365: from OKE_K_DELIVERABLES_TLH B, FND_LANGUAGES L
5366: where L.INSTALLED_FLAG in ('I', 'B')
5367: and B.LANGUAGE = userenv('LANG')
5368: and not exists
5369: (select NULL

Line 5370: from OKE_K_DELIVERABLES_TLH T

5366: where L.INSTALLED_FLAG in ('I', 'B')
5367: and B.LANGUAGE = userenv('LANG')
5368: and not exists
5369: (select NULL
5370: from OKE_K_DELIVERABLES_TLH T
5371: where T.DELIVERABLE_ID = B.DELIVERABLE_ID
5372: and T.LANGUAGE = L.LANGUAGE_CODE
5373: and T.MAJOR_VERSION = B.MAJOR_VERSION);
5374: