[Home] [Help]
1544: 3, 3,
1545: 2, 2,
1546: 1, 2,
1547: 4)
1548: from dual;
1549:
1550: x_cal_type number := 0;
1551: x_count number := 0;
1552: x_stream_defined number := 0;
2102: '11', 'MONTH_END_DATE ',
2103: '12', 'QUARTER_END_DATE ',
2104: '13', 'YEAR_END_DATE ',
2105: 'DAY ')
2106: from dual;
2107:
2108: /* Map the Time Level Id to the calendar type */
2109: /* If day then any calendar is fine */
2110: /* This is handled with the last case. we return column name */
2123: 11, '4',
2124: 12, '4',
2125: 13, '4',
2126: 'tim.calendar_type')
2127: from dual;
2128:
2129: time_level_id number;
2130: time_level_column varchar2(100);
2131: time_cal_type varchar2(100);
2575: '11', ' MONTH_END_DATE ',
2576: '12', ' QUARTER_END_DATE ',
2577: '13', ' YEAR_END_DATE ',
2578: ' DAY ')
2579: from dual;
2580:
2581: CURSOR get_meaning_1 (p_lookup_type in varchar2, p_lookup_code in varchar2) IS
2582: select meaning
2583: from fnd_lookup_values_vl
3303: BEGIN
3304:
3305: SELECT 1
3306: INTO x_price_list_data_found
3307: FROM dual
3308: WHERE EXISTS (SELECT 1
3309: FROM msd_price_list_v
3310: WHERE price_list_name = c_price_list_rec.price_list_name
3311: AND ( ( nvl(start_date, X_MIN_DATE) <= l_dp_min_date
3348: BEGIN
3349:
3350: SELECT 1
3351: INTO x_price_list_data_found
3352: FROM dual
3353: WHERE EXISTS (SELECT 1
3354: FROM msd_price_list_v
3355: WHERE price_list_name = c_scn_with_pls.price_list_name
3356: AND ( ( nvl(start_date, X_MIN_DATE) <= c_scn_with_pls.horizon_start_date
3393: BEGIN
3394:
3395: SELECT 1
3396: INTO x_price_list_data_found
3397: FROM dual
3398: WHERE EXISTS (SELECT 1
3399: FROM msd_price_list_v
3400: WHERE price_list_name = c_param_with_pls.price_list_name
3401: AND ( ( nvl(start_date, X_MIN_DATE) <= c_param_with_pls.start_date