APPS.OKC_TIME_UTIL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

         SELECT tce_code, quantity
         FROM okc_time_code_units_v
         WHERE uom_code = p_uom_code
         ORDER BY decode(active_flag,'Y',1,2);

Line: 28

	select tce_code, quantity
	 from okc_time_code_units_v
	 where uom_code = p_uom_code; */

Line: 73

	 SELECT uom_code, quantity
	 FROM   okc_time_code_units_b
	 WHERE  tce_code = p_timeunit
         AND    active_flag = 'Y'
	 AND    quantity = 1
*/
/* The following SQL clause was changed by msengupt to handle displaying in a higher User's Unit instead of the Standard Seeded Base Units.
e.g.  If the user has defined Quarter  as 3 Month (Seeded) and also Month as 1 Month (Seeded) in the Time Code Units,
the period and duration between 1/1/2000 and 6/30/2001 will be returned as 18 Months by the earlier approach. Now with the
query being modified to add an OR clause with Mod, The user's entry of Quarter will be considered and the query will return 6 Quarter - Bug#1821715
*/
   CURSOR time_code_unit_csr (p_timeunit IN varchar2, p_duration IN NUMBER) is
	 SELECT TCU.uom_code, TCU.quantity
--Bug 3262128  FROM   okc_time_code_units_b
         FROM   okc_time_code_units_b TCU,okx_units_of_measure_v UOM
	 WHERE  TCU.tce_code = p_timeunit
         AND    TCU.active_flag = 'Y'
--Bug 3262128 added condition to check for disable_date of UOM
         and nvl(UOM.disable_date,trunc(sysdate)) >= trunc(sysdate)
         AND TCU.UOM_CODE = UOM.UOM_CODE
	 AND    (TCU.quantity = 1   OR  mod(p_duration,TCU.quantity) = 0)
      ORDER BY TCU.quantity desc;

Line: 98

	select uom_code
	 from okc_time_code_units_v
	 where tce_code = p_timeunit
	 and quantity = 1; */

Line: 373

  SELECT application_id FROM fnd_application WHERE application_short_name = 'OKC';

Line: 414

  SELECT
    dff.form_left_prompt    prompt,
    dff.required_flag,
    dff.display_size,
    fvs.flex_value_set_name,
    dff.descriptive_flex_context_code  rdf_code
  FROM
    fnd_descr_flex_col_usage_vl  dff,
    fnd_flex_value_sets   fvs
  WHERE
    fvs.flex_value_set_id = dff.flex_value_set_id and
    --- need to select based on application id and descriptive flexfield name
    dff.application_id                = p_app_id and
    dff.descriptive_flexfield_name    = p_dff_name and
    fvs.flex_value_set_name           = p_fvs_name;

Line: 461

  l_select_string  varchar2(2000);

Line: 472

  SELECT
    dff.form_left_prompt    prompt,
    dff.required_flag,
    dff.display_size,
    fvs.flex_value_set_name,
    dff.application_column_name
  FROM
    fnd_descr_flex_col_usage_vl  dff,
    fnd_flex_value_sets   fvs
  WHERE
    fvs.flex_value_set_id = dff.flex_value_set_id and
    --- need to select based on application id and descriptive flexfield name
    dff.descriptive_flex_context_code = p_rdf_code and
    dff.application_id                = p_app_id and
    dff.descriptive_flexfield_name    = p_dff_name and
    fvs.flex_value_set_name           = p_fvs_name
  ORDER BY
    dff.column_seq_num;

Line: 498

    if l_select_string is null then
        l_select_string := v_rule_dff.application_column_name;

Line: 503

      if instr(l_select_string,v_rule_dff.application_column_name) = 0 then
        l_select_string := l_select_string ||
            ' ||'',''|| ' || v_rule_dff.application_column_name;

Line: 514

  if l_select_string is not null and l_number_of_columns > 0 then
    l_select_string := 'SELECT ' || l_select_string || ' FROM OKC_RULES_B WHERE ID = :ID';

Line: 518

     for l_select_string
   using p_rule_id;

Line: 575

  l_select_string  varchar2(2000);

Line: 582

  SELECT
    dff.form_left_prompt    prompt,
    dff.required_flag,
    dff.display_size,
    fvs.flex_value_set_name,
    dff.application_column_name
  FROM
    fnd_descr_flex_col_usage_vl  dff,
    fnd_flex_value_sets   fvs
  WHERE
    fvs.flex_value_set_id = dff.flex_value_set_id and
    --- need to select based on application id and descriptive flexfield name
    dff.descriptive_flex_context_code = p_rdf_code and
    dff.application_id                = p_app_id and
    dff.descriptive_flexfield_name    = p_dff_name and
    fvs.flex_value_set_name           = p_fvs_name
  ORDER BY
    dff.column_seq_num;

Line: 608

    if l_select_string is null then
        l_select_string :=  v_rule_dff.application_column_name ;

Line: 611

      if instr(l_select_string,v_rule_dff.application_column_name) = 0 then
        l_select_string := l_select_string ||
            ' || ' || v_rule_dff.application_column_name;

Line: 620

  if l_select_string is not null then
    l_select_string := 'SELECT ' || l_select_string || ' FROM OKC_RULES_B WHERE ID = :ID';

Line: 624

     for l_select_string
   using p_rule_id;

Line: 645

	 SELECT uom_code
	 FROM   okc_time_code_units_b
	 WHERE  tce_code = p_timeunit
         AND    active_flag = 'Y'
	 AND    quantity = 1;