APPS.OKS_TIME_MEASURES_PUB dependencies on OKC_TIME_CODE_UNITS_B

Line 226: -- Changed to get relationship from okc_time_code_units_b bug no:4255530

222: ELSIF upper(p_target_uom) = l_month
223: THEN
224: l_target_qty := p_source_qty*12;
225: ELSE
226: -- Changed to get relationship from okc_time_code_units_b bug no:4255530
227: l_multiplier := get_con_factor(p_source_uom, p_target_uom);
228: IF l_multiplier is NULL THEN
229: l_target_qty := GET_QTY_FOR_DAYS(l_no_days,p_target_uom);
230: ELSE

Line 244: -- Changed to get relationship from okc_time_code_units_b bug no:4255530

240: ELSIF upper(p_target_uom) = l_quarter
241: THEN
242: l_target_qty := p_source_qty/3;
243: ELSE
244: -- Changed to get relationship from okc_time_code_units_b bug no:4255530
245: l_multiplier := get_con_factor(p_source_uom, p_target_uom);
246: IF l_multiplier is NULL THEN
247: l_target_qty := GET_QTY_FOR_DAYS(l_no_days,p_target_uom);
248: ELSE

Line 262: -- Changed to get relationship from okc_time_code_units_b bug no:4255530

258: ELSIF upper(p_target_uom) = l_month
259: THEN
260: l_target_qty := p_source_qty*3;
261: ELSE
262: -- Changed to get relationship from okc_time_code_units_b bug no:4255530
263: l_multiplier := get_con_factor(p_source_uom, p_target_uom);
264: IF l_multiplier is NULL THEN
265: l_target_qty := GET_QTY_FOR_DAYS(l_no_days,p_target_uom);
266: ELSE

Line 283: -- Changed to get relationship from okc_time_code_units_b bug no:4255530

279: ELSIF upper(p_target_uom) = l_quarter
280: THEN
281: l_target_qty := (months_between(l_end_date+1,l_start_date))/3;
282: ELSE
283: -- Changed to get relationship from okc_time_code_units_b bug no:4255530
284: l_multiplier := get_con_factor(p_source_uom, p_target_uom);
285: IF l_multiplier is NULL THEN
286: l_target_qty := GET_QTY_FOR_DAYS(l_no_days,p_target_uom);
287: ELSE

Line 304: -- Changed to get relationship from okc_time_code_units_b bug no:4255530

300: ELSIF upper(p_target_uom) = l_month
301: THEN
302: l_target_qty := months_between(l_end_date+1,l_start_date);
303: ELSE
304: -- Changed to get relationship from okc_time_code_units_b bug no:4255530
305: l_multiplier := get_con_factor(p_source_uom, p_target_uom);
306: IF l_multiplier is NULL THEN
307: l_target_qty := GET_QTY_FOR_DAYS(l_no_days,p_target_uom);
308: ELSE

Line 528: FROM OKC_TIME_CODE_UNITS_B

524: --------------------------------------------------
525: CURSOR get_tce_code(p_uom_code IN VARCHAR2)
526: is
527: SELECT tce_code
528: FROM OKC_TIME_CODE_UNITS_B
529: WHERE uom_code=p_uom_code;
530:
531: ----------------------------------------------------
532:

Line 1308: for a common tce_code for both in okc_time_code_units_b. If it finds common tce_code

1304: END get_full_periods;
1305:
1306: ------------------------------------------------------------------------
1307: /* This function takes source_uom and target_uom as input parameters and searches
1308: for a common tce_code for both in okc_time_code_units_b. If it finds common tce_code
1309: it calculates source_uom in terms of the target_uom and returns the value. Else
1310: it returns null
1311: */
1312:

Line 1320: FROM okc_time_code_units_b

1316: as
1317: CURSOR get_common_uom(p_source_uom IN VARCHAR2,p_target_uom IN VARCHAR2)
1318: is
1319: SELECT tce_code,quantity
1320: FROM okc_time_code_units_b
1321: WHERE uom_code = p_source_uom
1322: AND tce_code in (SELECT tce_code FROM okc_time_code_units_b WHERE uom_code=p_target_uom)
1323: ORDER BY quantity ASC;
1324:

Line 1322: AND tce_code in (SELECT tce_code FROM okc_time_code_units_b WHERE uom_code=p_target_uom)

1318: is
1319: SELECT tce_code,quantity
1320: FROM okc_time_code_units_b
1321: WHERE uom_code = p_source_uom
1322: AND tce_code in (SELECT tce_code FROM okc_time_code_units_b WHERE uom_code=p_target_uom)
1323: ORDER BY quantity ASC;
1324:
1325: CURSOR time_code_unit(p_source_uom IN varchar2, p_target_uom IN VARCHAR2)
1326: is

Line 1328: FROM okc_time_code_units_b

1324:
1325: CURSOR time_code_unit(p_source_uom IN varchar2, p_target_uom IN VARCHAR2)
1326: is
1327: SELECT quantity
1328: FROM okc_time_code_units_b
1329: WHERE tce_code = p_source_uom
1330: AND active_flag = 'Y'
1331: AND uom_code = p_target_uom;
1332: