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_RES_PUB dependencies on OKC_API

Line 19: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

15: l_msg_count NUMBER;
16: l_msg_data VARCHAR2(4000);
17: l_api_name CONSTANT VARCHAR2(30) := 'RES_TIME_EVENTS';
18: BEGIN
19: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
20: p_init_msg_list,
21: '_PUB',
22: x_return_status);
23: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 23: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

19: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
20: p_init_msg_list,
21: '_PUB',
22: x_return_status);
23: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;

Line 24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20: p_init_msg_list,
21: '_PUB',
22: x_return_status);
23: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28: OKC_TIME_RES_PVT.Res_Time_Events(

Line 25: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

21: '_PUB',
22: x_return_status);
23: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28: OKC_TIME_RES_PVT.Res_Time_Events(
29: x_return_status,

Line 26: raise OKC_API.G_EXCEPTION_ERROR;

22: x_return_status);
23: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28: OKC_TIME_RES_PVT.Res_Time_Events(
29: x_return_status,
30: p_api_version ,

Line 35: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

31: p_init_msg_list,
32: p_cnh_id ,
33: p_coe_id ,
34: p_date);
35: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
36: END Res_Time_Events ;
37:
38: PROCEDURE Res_Time_New_K(
39: p_chr_id IN NUMBER,

Line 47: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

43: l_msg_count NUMBER;
44: l_msg_data VARCHAR2(4000);
45: l_api_name CONSTANT VARCHAR2(30) := 'RES_TIME_NEW_K';
46: BEGIN
47: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
48: p_init_msg_list,
49: '_PUB',
50: x_return_status);
51: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 51: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

47: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
48: p_init_msg_list,
49: '_PUB',
50: x_return_status);
51: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
54: raise OKC_API.G_EXCEPTION_ERROR;
55: END IF;

Line 52: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

48: p_init_msg_list,
49: '_PUB',
50: x_return_status);
51: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
54: raise OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56: OKC_TIME_RES_PVT.Res_Time_New_K(

Line 53: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

49: '_PUB',
50: x_return_status);
51: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
54: raise OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56: OKC_TIME_RES_PVT.Res_Time_New_K(
57: p_chr_id ,

Line 54: raise OKC_API.G_EXCEPTION_ERROR;

50: x_return_status);
51: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
54: raise OKC_API.G_EXCEPTION_ERROR;
55: END IF;
56: OKC_TIME_RES_PVT.Res_Time_New_K(
57: p_chr_id ,
58: p_api_version ,

Line 61: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

57: p_chr_id ,
58: p_api_version ,
59: p_init_msg_list,
60: x_return_status);
61: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
62: END Res_Time_New_K;
63:
64: PROCEDURE Res_Time_Extnd_K(
65: p_chr_id IN NUMBER,

Line 76: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

72: l_msg_count NUMBER;
73: l_msg_data VARCHAR2(4000);
74: l_api_name CONSTANT VARCHAR2(30) := 'RES_TIME_EXTND_K';
75: BEGIN
76: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
77: p_init_msg_list,
78: '_PUB',
79: x_return_status);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

76: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
77: p_init_msg_list,
78: '_PUB',
79: x_return_status);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: raise OKC_API.G_EXCEPTION_ERROR;
84: END IF;

Line 81: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

77: p_init_msg_list,
78: '_PUB',
79: x_return_status);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: raise OKC_API.G_EXCEPTION_ERROR;
84: END IF;
85: OKC_TIME_RES_PVT.Res_Time_Extnd_K(

Line 82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

78: '_PUB',
79: x_return_status);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: raise OKC_API.G_EXCEPTION_ERROR;
84: END IF;
85: OKC_TIME_RES_PVT.Res_Time_Extnd_K(
86: p_chr_id ,

Line 83: raise OKC_API.G_EXCEPTION_ERROR;

79: x_return_status);
80: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
81: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
83: raise OKC_API.G_EXCEPTION_ERROR;
84: END IF;
85: OKC_TIME_RES_PVT.Res_Time_Extnd_K(
86: p_chr_id ,
87: p_cle_id ,

Line 93: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

89: p_end_date,
90: p_api_version ,
91: p_init_msg_list,
92: x_return_status);
93: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
94: END Res_Time_Extnd_K;
95:
96: PROCEDURE Res_Time_Termnt_K(
97: p_chr_id IN NUMBER,

Line 107: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

103: l_msg_count NUMBER;
104: l_msg_data VARCHAR2(4000);
105: l_api_name CONSTANT VARCHAR2(30) := 'RES_TIME_TERMNT_K';
106: BEGIN
107: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
108: p_init_msg_list,
109: '_PUB',
110: x_return_status);
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

107: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
108: p_init_msg_list,
109: '_PUB',
110: x_return_status);
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: raise OKC_API.G_EXCEPTION_ERROR;
115: END IF;

Line 112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

108: p_init_msg_list,
109: '_PUB',
110: x_return_status);
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: raise OKC_API.G_EXCEPTION_ERROR;
115: END IF;
116: OKC_TIME_RES_PVT.Res_Time_Termnt_K(

Line 113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

109: '_PUB',
110: x_return_status);
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: raise OKC_API.G_EXCEPTION_ERROR;
115: END IF;
116: OKC_TIME_RES_PVT.Res_Time_Termnt_K(
117: p_chr_id ,

Line 114: raise OKC_API.G_EXCEPTION_ERROR;

110: x_return_status);
111: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
112: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
114: raise OKC_API.G_EXCEPTION_ERROR;
115: END IF;
116: OKC_TIME_RES_PVT.Res_Time_Termnt_K(
117: p_chr_id ,
118: p_cle_id ,

Line 123: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

119: p_end_date,
120: p_api_version ,
121: p_init_msg_list,
122: x_return_status);
123: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
124: END Res_Time_Termnt_K;
125:
126: FUNCTION Check_Res_Time_N_tasks(
127: p_tve_id IN NUMBER,

Line 146: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

142: l_msg_count NUMBER;
143: l_msg_data VARCHAR2(4000);
144: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RES_TIME_N_TASKS';
145: BEGIN
146: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
147: p_init_msg_list,
148: '_PUB',
149: x_return_status);
150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

146: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
147: p_init_msg_list,
148: '_PUB',
149: x_return_status);
150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
151: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
153: raise OKC_API.G_EXCEPTION_ERROR;
154: END IF;

Line 151: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

147: p_init_msg_list,
148: '_PUB',
149: x_return_status);
150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
151: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
153: raise OKC_API.G_EXCEPTION_ERROR;
154: END IF;
155: OKC_TIME_RES_PVT.Delete_Res_Time_N_Tasks(

Line 152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

148: '_PUB',
149: x_return_status);
150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
151: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
153: raise OKC_API.G_EXCEPTION_ERROR;
154: END IF;
155: OKC_TIME_RES_PVT.Delete_Res_Time_N_Tasks(
156: p_tve_id ,

Line 153: raise OKC_API.G_EXCEPTION_ERROR;

149: x_return_status);
150: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
151: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
152: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
153: raise OKC_API.G_EXCEPTION_ERROR;
154: END IF;
155: OKC_TIME_RES_PVT.Delete_Res_Time_N_Tasks(
156: p_tve_id ,
157: p_date ,

Line 161: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

157: p_date ,
158: p_api_version,
159: p_init_msg_list ,
160: x_return_status);
161: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
162: END Delete_Res_Time_N_Tasks;
163:
164: PROCEDURE Create_Res_Time_N_Tasks(
165: p_tve_id IN NUMBER,

Line 175: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

171: l_msg_count NUMBER;
172: l_msg_data VARCHAR2(4000);
173: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RES_TIME_N_TASKS';
174: BEGIN
175: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
176: p_init_msg_list,
177: '_PUB',
178: x_return_status);
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

175: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
176: p_init_msg_list,
177: '_PUB',
178: x_return_status);
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;

Line 180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

176: p_init_msg_list,
177: '_PUB',
178: x_return_status);
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
184: OKC_TIME_RES_PVT.Create_Res_Time_N_Tasks(

Line 181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

177: '_PUB',
178: x_return_status);
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
184: OKC_TIME_RES_PVT.Create_Res_Time_N_Tasks(
185: p_tve_id ,

Line 182: raise OKC_API.G_EXCEPTION_ERROR;

178: x_return_status);
179: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
180: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
181: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
182: raise OKC_API.G_EXCEPTION_ERROR;
183: END IF;
184: OKC_TIME_RES_PVT.Create_Res_Time_N_Tasks(
185: p_tve_id ,
186: p_start_date ,

Line 191: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);

187: p_end_date ,
188: p_api_version,
189: p_init_msg_list ,
190: x_return_status);
191: OKC_API.END_ACTIVITY(l_msg_count, l_msg_data);
192: END Create_Res_Time_N_Tasks;
193:
194: PROCEDURE Batch_Resolve_Time_N_Tasks IS
195: BEGIN