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_TIME_PVT dependencies on OKC_TIMEVALUES

Line 21: DELETE FROM OKC_TIMEVALUES_TL T

17: /* as a quick workaround to fix the time-consuming table handler issue */
18: /* Eventually we'll need to turn them into a separate fix_language procedure */
19: /*
20:
21: DELETE FROM OKC_TIMEVALUES_TL T
22: WHERE NOT EXISTS (
23: SELECT NULL
24: FROM OKC_TIMEVALUES_B B
25: WHERE B.ID = T.ID

Line 24: FROM OKC_TIMEVALUES_B B

20:
21: DELETE FROM OKC_TIMEVALUES_TL T
22: WHERE NOT EXISTS (
23: SELECT NULL
24: FROM OKC_TIMEVALUES_B B
25: WHERE B.ID = T.ID
26: );
27: */
28:

Line 31: /* UPDATE OKC_TIMEVALUES_TL T SET (

27: */
28:
29: /* commented out smallya 03/04/2003 for bug 2831959 as this does not make any sense.*/
30: /* Also it takes a lot of time doing this redundant update*/
31: /* UPDATE OKC_TIMEVALUES_TL T SET (
32: DESCRIPTION,
33: SHORT_DESCRIPTION,
34: COMMENTS,
35: NAME) = (SELECT

Line 40: FROM OKC_TIMEVALUES_TL B

36: B.DESCRIPTION,
37: B.SHORT_DESCRIPTION,
38: B.COMMENTS,
39: B.NAME
40: FROM OKC_TIMEVALUES_TL B
41: WHERE B.ID = T.ID
42: AND B.LANGUAGE = T.SOURCE_LANG)
43: WHERE (
44: T.ID,

Line 49: FROM OKC_TIMEVALUES_TL SUBB, OKC_TIMEVALUES_TL SUBT

45: T.LANGUAGE)
46: IN (SELECT
47: SUBT.ID,
48: SUBT.LANGUAGE
49: FROM OKC_TIMEVALUES_TL SUBB, OKC_TIMEVALUES_TL SUBT
50: WHERE SUBB.ID = SUBT.ID
51: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
52: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
53: OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 68: INSERT INTO OKC_TIMEVALUES_TL (

64: )); */
65:
66: --Bug 3122962
67: /*
68: INSERT INTO OKC_TIMEVALUES_TL (
69: ID,
70: LANGUAGE,
71: SOURCE_LANG,
72: SFWT_FLAG,

Line 96: FROM OKC_TIMEVALUES_TL B, FND_LANGUAGES L

92: B.CREATION_DATE,
93: B.LAST_UPDATED_BY,
94: B.LAST_UPDATE_DATE,
95: B.LAST_UPDATE_LOGIN
96: FROM OKC_TIMEVALUES_TL B, FND_LANGUAGES L
97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND B.LANGUAGE = USERENV('LANG')
99: AND NOT EXISTS(
100: SELECT NULL

Line 101: FROM OKC_TIMEVALUES_TL T

97: WHERE L.INSTALLED_FLAG IN ('I', 'B')
98: AND B.LANGUAGE = USERENV('LANG')
99: AND NOT EXISTS(
100: SELECT NULL
101: FROM OKC_TIMEVALUES_TL T
102: WHERE T.ID = B.ID
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105: okc_tcu_pvt.add_language;

Line 106: DELETE FROM OKC_TIMEVALUES_TLH T

102: WHERE T.ID = B.ID
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105: okc_tcu_pvt.add_language;
106: DELETE FROM OKC_TIMEVALUES_TLH T
107: WHERE NOT EXISTS (
108: SELECT NULL
109: FROM OKC_TIMEVALUES_BH B
110: WHERE B.ID = T.ID

Line 109: FROM OKC_TIMEVALUES_BH B

105: okc_tcu_pvt.add_language;
106: DELETE FROM OKC_TIMEVALUES_TLH T
107: WHERE NOT EXISTS (
108: SELECT NULL
109: FROM OKC_TIMEVALUES_BH B
110: WHERE B.ID = T.ID
111: AND B.MAJOR_VERSION = T.MAJOR_VERSION
112: );
113:

Line 114: UPDATE OKC_TIMEVALUES_TLH T SET (

110: WHERE B.ID = T.ID
111: AND B.MAJOR_VERSION = T.MAJOR_VERSION
112: );
113:
114: UPDATE OKC_TIMEVALUES_TLH T SET (
115: DESCRIPTION,
116: SHORT_DESCRIPTION,
117: COMMENTS,
118: NAME) = (SELECT

Line 123: FROM OKC_TIMEVALUES_TLH B

119: B.DESCRIPTION,
120: B.SHORT_DESCRIPTION,
121: B.COMMENTS,
122: B.NAME
123: FROM OKC_TIMEVALUES_TLH B
124: WHERE B.ID = T.ID
125: AND B.MAJOR_VERSION = T.MAJOR_VERSION
126: AND B.LANGUAGE = T.SOURCE_LANG)
127: WHERE (

Line 135: FROM OKC_TIMEVALUES_TLH SUBB, OKC_TIMEVALUES_TLH SUBT

131: IN (SELECT
132: SUBT.ID,
133: SUBT.MAJOR_VERSION,
134: SUBT.LANGUAGE
135: FROM OKC_TIMEVALUES_TLH SUBB, OKC_TIMEVALUES_TLH SUBT
136: WHERE SUBB.ID = SUBT.ID
137: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
138: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
139: AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 153: INSERT INTO OKC_TIMEVALUES_TLH (

149: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
150: OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
151: ));
152:
153: INSERT INTO OKC_TIMEVALUES_TLH (
154: ID,
155: LANGUAGE,
156: MAJOR_VERSION,
157: SOURCE_LANG,

Line 183: FROM OKC_TIMEVALUES_TLH B, FND_LANGUAGES L

179: B.CREATION_DATE,
180: B.LAST_UPDATED_BY,
181: B.LAST_UPDATE_DATE,
182: B.LAST_UPDATE_LOGIN
183: FROM OKC_TIMEVALUES_TLH B, FND_LANGUAGES L
184: WHERE L.INSTALLED_FLAG IN ('I', 'B')
185: AND B.LANGUAGE = USERENV('LANG')
186: AND NOT EXISTS(
187: SELECT NULL

Line 188: FROM OKC_TIMEVALUES_TLH T

184: WHERE L.INSTALLED_FLAG IN ('I', 'B')
185: AND B.LANGUAGE = USERENV('LANG')
186: AND NOT EXISTS(
187: SELECT NULL
188: FROM OKC_TIMEVALUES_TLH T
189: WHERE T.ID = B.ID
190: AND T.MAJOR_VERSION = B.MAJOR_VERSION
191: AND T.LANGUAGE = L.LANGUAGE_CODE
192: );

Line 207: SELECT TVE_TYPE, TVE_ID_OFFSET,TVE_ID_STARTED,TVE_ID_ENDED FROM OKC_TIMEVALUES

203: p_chr_id IN NUMBER ,
204: p_tve_id IN NUMBER) IS
205: CURSOR tve_csr(p_tve_id IN NUMBER) is
206: --Bug 3122962
207: SELECT TVE_TYPE, TVE_ID_OFFSET,TVE_ID_STARTED,TVE_ID_ENDED FROM OKC_TIMEVALUES
208: WHERE id = p_tve_id;
209: l_tve_rec tve_csr%ROWTYPE;
210: l_not_found BOOLEAN := TRUE;
211: item_not_found_error EXCEPTION;

Line 931: FROM okc_timevalues

927: p_isev_ext_rec isev_extended_rec_type;
928: x_isev_ext_rec isev_extended_rec_type;
929: CURSOR okc_tve_csr (p_id IN NUMBER) IS
930: SELECT tve_id_limited, dnz_chr_id
931: FROM okc_timevalues
932: WHERE id = p_id
933: and tve_type = 'TGD';
934: CURSOR okc_limited_csr (p_id IN NUMBER) IS
935: SELECT id, start_date, end_date

Line 1056: FROM okc_timevalues

1052: x_isev_ext_rec isev_extended_rec_type;
1053: l_row_notfound BOOLEAN := TRUE;
1054: CURSOR okc_limited_csr (p_id IN NUMBER) IS
1055: SELECT id, tve_id_limited
1056: FROM okc_timevalues
1057: WHERE id = p_id
1058: AND tve_type = 'TGD';
1059: l_okc_limited okc_limited_csr%ROWTYPE;
1060: BEGIN

Line 1584: FROM okc_timevalues

1580: p_tavv_rec tavv_rec_type;
1581: x_tavv_rec tavv_rec_type;
1582: CURSOR okc_tve_csr (p_id IN NUMBER) IS
1583: SELECT tve_id_started
1584: FROM okc_timevalues
1585: WHERE id = p_id
1586: AND tve_type = 'ISE';
1587: l_okc_tve okc_tve_csr%ROWTYPE;
1588: l_api_name CONSTANT VARCHAR2(30) := 'delete_ia_startend';

Line 1835: FROM okc_timevalues

1831: p_talv_rec talv_rec_type;
1832: x_talv_rec talv_rec_type;
1833: CURSOR okc_tve_csr (p_id IN NUMBER) IS
1834: SELECT tve_id_started
1835: FROM okc_timevalues
1836: WHERE id = p_id
1837: AND tve_type = 'ISE';
1838: l_okc_tve okc_tve_csr%ROWTYPE;
1839: l_api_name CONSTANT VARCHAR2(30) := 'delete_ia_startend';

Line 2654: UPDATE OKC_TIMEVALUES

2650: x_cylv_ext_rec.active_yn := x_spnv_rec.active_yn;
2651: x_cylv_ext_rec.spn_id := x_spnv_rec.id;
2652: p_cylv_rec.spn_id := x_spnv_rec.id;
2653: p_cylv_rec.id := x_cylv_ext_rec.id;
2654: UPDATE OKC_TIMEVALUES
2655: SET SPN_ID = x_cylv_ext_rec.spn_id
2656: WHERE TVE_TYPE = 'CYL'
2657: AND id = x_cylv_ext_rec.id;
2658: END CREATE_CYCLE;

Line 2678: FROM okc_timevalues

2674: l_row_notfound BOOLEAN := TRUE;
2675: l_api_name CONSTANT VARCHAR2(30) := 'update_cycle';
2676: CURSOR okc_tve_csr (p_id IN NUMBER) IS
2677: SELECT tve_id_limited, dnz_chr_id
2678: FROM okc_timevalues
2679: WHERE id = p_id
2680: AND tve_type = 'CYL';
2681: CURSOR okc_limited_csr (p_id IN NUMBER) IS
2682: SELECT id, start_date, end_date

Line 2805: FROM okc_timevalues

2801: x_isev_ext_rec isev_extended_rec_type;
2802: l_row_notfound BOOLEAN := TRUE;
2803: CURSOR okc_limited_csr (p_id IN NUMBER) IS
2804: SELECT id, tve_id_limited, spn_id
2805: FROM okc_timevalues
2806: WHERE id = p_id
2807: AND tve_type = 'CYL';
2808: l_okc_limited okc_limited_csr%ROWTYPE;
2809: BEGIN

Line 2912: -- Procedure for mass insert in OKC_TIMEVALUES _B and TL tables

2908: p_spnv_rec);
2909: END VALID_CYCLE;
2910:
2911: ---------------------------------------------------------------
2912: -- Procedure for mass insert in OKC_TIMEVALUES _B and TL tables
2913: ---------------------------------------------------------------
2914: PROCEDURE INSERT_IGS_ROW_UPG(p_igsv_ext_tbl IN igsv_ext_tbl_type) IS
2915: l_tabsize NUMBER := p_igsv_ext_tbl.COUNT;
2916: l_source_lang VARCHAR2(12) := okc_util.get_userenv_lang;

Line 3142: INTO OKC_TIMEVALUES

3138: END LOOP;
3139: --Bug 3122962
3140: FORALL i in 1..j
3141: INSERT
3142: INTO OKC_TIMEVALUES
3143: (
3144: id,
3145: spn_id,
3146: tve_id_offset,

Line 3254: INSERT INTO OKC_TIMEVALUES_TL(

3250: --Bug 3122962
3251: /*
3252: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3253: FORALL i in 1..j
3254: INSERT INTO OKC_TIMEVALUES_TL(
3255: id,
3256: language,
3257: source_lang,
3258: sfwt_flag,

Line 3408: INTO OKC_TIMEVALUES

3404: END LOOP;
3405: --Bug 3122962
3406: FORALL i in 1..j
3407: INSERT
3408: INTO OKC_TIMEVALUES
3409: (
3410: id,
3411: spn_id,
3412: tve_id_offset,

Line 3519: INSERT INTO OKC_TIMEVALUES_TL(

3515: --Bug 3122962
3516: /*
3517: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3518: FORALL i in 1..j
3519: INSERT INTO OKC_TIMEVALUES_TL(
3520: id,
3521: language,
3522: source_lang,
3523: sfwt_flag,

Line 3745: INTO OKC_TIMEVALUES

3741: END LOOP;
3742:
3743: FORALL i in 1..j
3744: INSERT
3745: INTO OKC_TIMEVALUES
3746: (
3747: id,
3748: spn_id,
3749: tve_id_offset,

Line 3856: INSERT INTO OKC_TIMEVALUES_TL(

3852: --Bug 3122962
3853: /*
3854: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
3855: FORALL i in 1..j
3856: INSERT INTO OKC_TIMEVALUES_TL(
3857: id,
3858: language,
3859: source_lang,
3860: sfwt_flag,

Line 4087: INTO OKC_TIMEVALUES

4083: END LOOP;
4084:
4085: FORALL i in 1..j
4086: INSERT
4087: INTO OKC_TIMEVALUES
4088: (
4089: id,
4090: spn_id,
4091: tve_id_offset,

Line 4198: INSERT INTO OKC_TIMEVALUES_TL(

4194: --Bug 3122962
4195: /*
4196: FOR lang_i IN OKC_UTIL.g_language_code.FIRST..OKC_UTIL.g_language_code.LAST LOOP
4197: FORALL i in 1..j
4198: INSERT INTO OKC_TIMEVALUES_TL(
4199: id,
4200: language,
4201: source_lang,
4202: sfwt_flag,