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.FEM_DIMENSION_UTIL_PKG dependencies on DUAL

Line 1655: 04-AUG-06 rflippo Bug 5060702 Split single sql statement into individual

1651: Value for the ACCOUNTING_YEAR attribute (in fem_Cal_periods_attr)
1652: matches value in p_fiscal_year.
1653:
1654: HISTORY
1655: 04-AUG-06 rflippo Bug 5060702 Split single sql statement into individual
1656: statements to avoid cartesian join
1657:
1658: *************************************************************************/
1659:

Line 1793: 04-AUG-06 rflippo Bug 5060702 Split single sql statement into individual

1789:
1790: Value for the CAL_PERIOD_END_DATE attribute (in
1791: fem_Cal_periods_attr) matches value in p_cal_per_end_date.
1792:
1793: 04-AUG-06 rflippo Bug 5060702 Split single sql statement into individual
1794: statements to avoid cartesian join
1795: *************************************************************************/
1796:
1797: FUNCTION Get_Cal_Period_ID

Line 2254: INTO v_mem_id FROM dual;

2250:
2251: CASE v_source_cd
2252: WHEN 'DATASET' THEN
2253: SELECT fem_datasets_b_s.NEXTVAL
2254: INTO v_mem_id FROM dual;
2255: WHEN 'SOURCE_SYSTEM' THEN
2256: SELECT fem_source_systems_b_s.NEXTVAL
2257: INTO v_mem_id FROM dual;
2258: WHEN 'CALENDAR' THEN

Line 2257: INTO v_mem_id FROM dual;

2253: SELECT fem_datasets_b_s.NEXTVAL
2254: INTO v_mem_id FROM dual;
2255: WHEN 'SOURCE_SYSTEM' THEN
2256: SELECT fem_source_systems_b_s.NEXTVAL
2257: INTO v_mem_id FROM dual;
2258: WHEN 'CALENDAR' THEN
2259: SELECT fem_calendars_b_s.NEXTVAL
2260: INTO v_mem_id FROM dual;
2261: WHEN 'FLEX' THEN

Line 2260: INTO v_mem_id FROM dual;

2256: SELECT fem_source_systems_b_s.NEXTVAL
2257: INTO v_mem_id FROM dual;
2258: WHEN 'CALENDAR' THEN
2259: SELECT fem_calendars_b_s.NEXTVAL
2260: INTO v_mem_id FROM dual;
2261: WHEN 'FLEX' THEN
2262: SELECT fnd_flex_values_s.NEXTVAL
2263: INTO v_mem_id FROM dual;
2264: WHEN 'LEDGER' THEN

Line 2263: INTO v_mem_id FROM dual;

2259: SELECT fem_calendars_b_s.NEXTVAL
2260: INTO v_mem_id FROM dual;
2261: WHEN 'FLEX' THEN
2262: SELECT fnd_flex_values_s.NEXTVAL
2263: INTO v_mem_id FROM dual;
2264: WHEN 'LEDGER' THEN
2265: SELECT gl_sets_of_books_s.NEXTVAL
2266: INTO v_mem_id FROM dual;
2267: WHEN 'ORG' THEN

Line 2266: INTO v_mem_id FROM dual;

2262: SELECT fnd_flex_values_s.NEXTVAL
2263: INTO v_mem_id FROM dual;
2264: WHEN 'LEDGER' THEN
2265: SELECT gl_sets_of_books_s.NEXTVAL
2266: INTO v_mem_id FROM dual;
2267: WHEN 'ORG' THEN
2268: SELECT fem_cctr_orgs_b_s.NEXTVAL
2269: INTO v_mem_id FROM dual;
2270: WHEN 'BUDGET' THEN

Line 2269: INTO v_mem_id FROM dual;

2265: SELECT gl_sets_of_books_s.NEXTVAL
2266: INTO v_mem_id FROM dual;
2267: WHEN 'ORG' THEN
2268: SELECT fem_cctr_orgs_b_s.NEXTVAL
2269: INTO v_mem_id FROM dual;
2270: WHEN 'BUDGET' THEN
2271: SELECT gl_budget_versions_s.NEXTVAL
2272: INTO v_mem_id FROM dual;
2273: WHEN 'ENCUMBRANCE' THEN

Line 2272: INTO v_mem_id FROM dual;

2268: SELECT fem_cctr_orgs_b_s.NEXTVAL
2269: INTO v_mem_id FROM dual;
2270: WHEN 'BUDGET' THEN
2271: SELECT gl_budget_versions_s.NEXTVAL
2272: INTO v_mem_id FROM dual;
2273: WHEN 'ENCUMBRANCE' THEN
2274: SELECT gl_encumbrance_types_s.NEXTVAL
2275: INTO v_mem_id FROM dual;
2276: ELSE

Line 2275: INTO v_mem_id FROM dual;

2271: SELECT gl_budget_versions_s.NEXTVAL
2272: INTO v_mem_id FROM dual;
2273: WHEN 'ENCUMBRANCE' THEN
2274: SELECT gl_encumbrance_types_s.NEXTVAL
2275: INTO v_mem_id FROM dual;
2276: ELSE
2277: RETURN null;
2278: END CASE;
2279:

Line 2334: INTO v_mem_id FROM dual;

2330:
2331: CASE v_source_cd
2332: WHEN 'DATASET' THEN
2333: SELECT fem_datasets_b_s.NEXTVAL
2334: INTO v_mem_id FROM dual;
2335: WHEN 'SOURCE_SYSTEM' THEN
2336: SELECT fem_source_systems_b_s.NEXTVAL
2337: INTO v_mem_id FROM dual;
2338: WHEN 'CALENDAR' THEN

Line 2337: INTO v_mem_id FROM dual;

2333: SELECT fem_datasets_b_s.NEXTVAL
2334: INTO v_mem_id FROM dual;
2335: WHEN 'SOURCE_SYSTEM' THEN
2336: SELECT fem_source_systems_b_s.NEXTVAL
2337: INTO v_mem_id FROM dual;
2338: WHEN 'CALENDAR' THEN
2339: SELECT fem_calendars_b_s.NEXTVAL
2340: INTO v_mem_id FROM dual;
2341: WHEN 'FLEX' THEN

Line 2340: INTO v_mem_id FROM dual;

2336: SELECT fem_source_systems_b_s.NEXTVAL
2337: INTO v_mem_id FROM dual;
2338: WHEN 'CALENDAR' THEN
2339: SELECT fem_calendars_b_s.NEXTVAL
2340: INTO v_mem_id FROM dual;
2341: WHEN 'FLEX' THEN
2342: SELECT fnd_flex_values_s.NEXTVAL
2343: INTO v_mem_id FROM dual;
2344: WHEN 'LEDGER' THEN

Line 2343: INTO v_mem_id FROM dual;

2339: SELECT fem_calendars_b_s.NEXTVAL
2340: INTO v_mem_id FROM dual;
2341: WHEN 'FLEX' THEN
2342: SELECT fnd_flex_values_s.NEXTVAL
2343: INTO v_mem_id FROM dual;
2344: WHEN 'LEDGER' THEN
2345: SELECT gl_sets_of_books_s.NEXTVAL
2346: INTO v_mem_id FROM dual;
2347: WHEN 'ORG' THEN

Line 2346: INTO v_mem_id FROM dual;

2342: SELECT fnd_flex_values_s.NEXTVAL
2343: INTO v_mem_id FROM dual;
2344: WHEN 'LEDGER' THEN
2345: SELECT gl_sets_of_books_s.NEXTVAL
2346: INTO v_mem_id FROM dual;
2347: WHEN 'ORG' THEN
2348: SELECT fem_cctr_orgs_b_s.NEXTVAL
2349: INTO v_mem_id FROM dual;
2350: WHEN 'BUDGET' THEN

Line 2349: INTO v_mem_id FROM dual;

2345: SELECT gl_sets_of_books_s.NEXTVAL
2346: INTO v_mem_id FROM dual;
2347: WHEN 'ORG' THEN
2348: SELECT fem_cctr_orgs_b_s.NEXTVAL
2349: INTO v_mem_id FROM dual;
2350: WHEN 'BUDGET' THEN
2351: SELECT gl_budget_versions_s.NEXTVAL
2352: INTO v_mem_id FROM dual;
2353: WHEN 'ENCUMBRANCE' THEN

Line 2352: INTO v_mem_id FROM dual;

2348: SELECT fem_cctr_orgs_b_s.NEXTVAL
2349: INTO v_mem_id FROM dual;
2350: WHEN 'BUDGET' THEN
2351: SELECT gl_budget_versions_s.NEXTVAL
2352: INTO v_mem_id FROM dual;
2353: WHEN 'ENCUMBRANCE' THEN
2354: SELECT gl_encumbrance_types_s.NEXTVAL
2355: INTO v_mem_id FROM dual;
2356: ELSE

Line 2355: INTO v_mem_id FROM dual;

2351: SELECT gl_budget_versions_s.NEXTVAL
2352: INTO v_mem_id FROM dual;
2353: WHEN 'ENCUMBRANCE' THEN
2354: SELECT gl_encumbrance_types_s.NEXTVAL
2355: INTO v_mem_id FROM dual;
2356: ELSE
2357: x_err_code := 2;
2358: x_num_msg := x_num_msg + 1;
2359: RAISE no_source_code;

Line 2460: INTO v_mem_id FROM dual;

2456:
2457: CASE v_source_cd
2458: WHEN 'DATASET' THEN
2459: SELECT fem_datasets_b_s.NEXTVAL
2460: INTO v_mem_id FROM dual;
2461: WHEN 'SOURCE_SYSTEM' THEN
2462: SELECT fem_source_systems_b_s.NEXTVAL
2463: INTO v_mem_id FROM dual;
2464: WHEN 'CALENDAR' THEN

Line 2463: INTO v_mem_id FROM dual;

2459: SELECT fem_datasets_b_s.NEXTVAL
2460: INTO v_mem_id FROM dual;
2461: WHEN 'SOURCE_SYSTEM' THEN
2462: SELECT fem_source_systems_b_s.NEXTVAL
2463: INTO v_mem_id FROM dual;
2464: WHEN 'CALENDAR' THEN
2465: SELECT fem_calendars_b_s.NEXTVAL
2466: INTO v_mem_id FROM dual;
2467: WHEN 'FLEX' THEN

Line 2466: INTO v_mem_id FROM dual;

2462: SELECT fem_source_systems_b_s.NEXTVAL
2463: INTO v_mem_id FROM dual;
2464: WHEN 'CALENDAR' THEN
2465: SELECT fem_calendars_b_s.NEXTVAL
2466: INTO v_mem_id FROM dual;
2467: WHEN 'FLEX' THEN
2468: SELECT fnd_flex_values_s.NEXTVAL
2469: INTO v_mem_id FROM dual;
2470: WHEN 'LEDGER' THEN

Line 2469: INTO v_mem_id FROM dual;

2465: SELECT fem_calendars_b_s.NEXTVAL
2466: INTO v_mem_id FROM dual;
2467: WHEN 'FLEX' THEN
2468: SELECT fnd_flex_values_s.NEXTVAL
2469: INTO v_mem_id FROM dual;
2470: WHEN 'LEDGER' THEN
2471: SELECT gl_sets_of_books_s.NEXTVAL
2472: INTO v_mem_id FROM dual;
2473: WHEN 'ORG' THEN

Line 2472: INTO v_mem_id FROM dual;

2468: SELECT fnd_flex_values_s.NEXTVAL
2469: INTO v_mem_id FROM dual;
2470: WHEN 'LEDGER' THEN
2471: SELECT gl_sets_of_books_s.NEXTVAL
2472: INTO v_mem_id FROM dual;
2473: WHEN 'ORG' THEN
2474: SELECT fem_cctr_orgs_b_s.NEXTVAL
2475: INTO v_mem_id FROM dual;
2476: WHEN 'BUDGET' THEN

Line 2475: INTO v_mem_id FROM dual;

2471: SELECT gl_sets_of_books_s.NEXTVAL
2472: INTO v_mem_id FROM dual;
2473: WHEN 'ORG' THEN
2474: SELECT fem_cctr_orgs_b_s.NEXTVAL
2475: INTO v_mem_id FROM dual;
2476: WHEN 'BUDGET' THEN
2477: SELECT gl_budget_versions_s.NEXTVAL
2478: INTO v_mem_id FROM dual;
2479: WHEN 'ENCUMBRANCE' THEN

Line 2478: INTO v_mem_id FROM dual;

2474: SELECT fem_cctr_orgs_b_s.NEXTVAL
2475: INTO v_mem_id FROM dual;
2476: WHEN 'BUDGET' THEN
2477: SELECT gl_budget_versions_s.NEXTVAL
2478: INTO v_mem_id FROM dual;
2479: WHEN 'ENCUMBRANCE' THEN
2480: SELECT gl_encumbrance_types_s.NEXTVAL
2481: INTO v_mem_id FROM dual;
2482: ELSE

Line 2481: INTO v_mem_id FROM dual;

2477: SELECT gl_budget_versions_s.NEXTVAL
2478: INTO v_mem_id FROM dual;
2479: WHEN 'ENCUMBRANCE' THEN
2480: SELECT gl_encumbrance_types_s.NEXTVAL
2481: INTO v_mem_id FROM dual;
2482: ELSE
2483: RAISE no_source_code;
2484: END CASE;
2485:

Line 2550: FROM dual;

2546: BEGIN
2547:
2548: SELECT TO_CHAR(p_end_date,'J')
2549: INTO v_julian_date
2550: FROM dual;
2551:
2552: BEGIN
2553: SELECT T.number_assign_value
2554: INTO v_num_of_periods

Line 2580: FROM dual;

2576: -- END IF;
2577:
2578: SELECT LPAD(TO_CHAR(p_period_num),15,'0')
2579: INTO v_period_chr
2580: FROM dual;
2581:
2582: BEGIN
2583: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2584: INTO v_calendar_chr

Line 2599: FROM dual;

2595: WHERE dimension_group_id = p_dim_grp_id;
2596:
2597: SELECT TO_NUMBER(v_julian_date||v_period_chr||v_calendar_chr||v_dim_grp_key)
2598: INTO v_cal_per_id
2599: FROM dual;
2600:
2601: RETURN v_cal_per_id;
2602:
2603: END Generate_Member_ID;

Line 2624: FROM dual;

2620: BEGIN
2621:
2622: SELECT TO_CHAR(p_end_date,'J')
2623: INTO v_julian_date
2624: FROM dual;
2625:
2626: BEGIN
2627: SELECT T.number_assign_value
2628: INTO v_num_of_periods

Line 2654: FROM dual;

2650: -- END IF;
2651:
2652: SELECT LPAD(TO_CHAR(p_period_num),15,'0')
2653: INTO v_period_chr
2654: FROM dual;
2655:
2656: BEGIN
2657: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2658: INTO v_calendar_chr

Line 2673: FROM dual;

2669: WHERE dimension_group_display_code = p_dim_grp_dc;
2670:
2671: SELECT TO_NUMBER(v_julian_date||v_period_chr||v_calendar_chr||v_dim_grp_key)
2672: INTO v_cal_per_id
2673: FROM dual;
2674:
2675: RETURN v_cal_per_id;
2676:
2677: END Generate_Member_ID;

Line 2752: FROM dual;

2748: x_num_msg := 0;
2749:
2750: SELECT TO_CHAR(p_end_date,'J')
2751: INTO v_julian_date
2752: FROM dual;
2753:
2754: BEGIN
2755: SELECT T.number_assign_value
2756: INTO v_num_of_periods

Line 2792: FROM dual;

2788: -- END IF;
2789:
2790: SELECT LPAD(TO_CHAR(p_period_num),15,'0')
2791: INTO v_period_chr
2792: FROM dual;
2793:
2794: BEGIN
2795: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2796: INTO v_calendar_chr

Line 2814: FROM dual;

2810: WHERE dimension_group_id = p_dim_grp_id;
2811:
2812: SELECT TO_NUMBER(v_julian_date||v_period_chr||v_calendar_chr||v_dim_grp_key)
2813: INTO v_cal_per_id
2814: FROM dual;
2815: RETURN v_cal_per_id;
2816:
2817: EXCEPTION
2818: WHEN e_bad_param_value THEN

Line 2897: FROM dual;

2893: END IF;
2894:
2895: SELECT TO_CHAR(p_end_date,'J')
2896: INTO v_julian_date
2897: FROM dual;
2898:
2899: BEGIN
2900: SELECT T.number_assign_value
2901: INTO v_num_of_periods

Line 2937: FROM dual;

2933: -- END IF;
2934:
2935: SELECT LPAD(TO_CHAR(p_period_num),15,'0')
2936: INTO v_period_chr
2937: FROM dual;
2938:
2939: BEGIN
2940: SELECT LPAD(TO_CHAR(calendar_id),5,'0')
2941: INTO v_calendar_chr

Line 2959: FROM dual;

2955: WHERE dimension_group_id = p_dim_grp_id;
2956:
2957: SELECT TO_NUMBER(v_julian_date||v_period_chr||v_calendar_chr||v_dim_grp_key)
2958: INTO v_cal_per_id
2959: FROM dual;
2960:
2961: RETURN v_cal_per_id;
2962:
2963: EXCEPTION

Line 3492: ','||'''N'' from dual';

3488: ','||c_user_id||
3489: ',sysdate'||
3490: ','||c_login_id||
3491: ','||1||
3492: ','||'''N'' from dual';
3493:
3494: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3495: FEM_ENGINES_PKG.TECH_MESSAGE(
3496: p_severity => FND_LOG.level_statement,

Line 4103: INTO v_ver_id FROM dual;

4099: RAISE e_no_version_name;
4100: END IF;
4101:
4102: SELECT fem_dim_attr_versions_b_s.NEXTVAL
4103: INTO v_ver_id FROM dual;
4104:
4105: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
4106: x_rowid => v_row_id,
4107: x_version_id => v_ver_id,

Line 4577: INTO v_ver_id FROM dual;

4573: RAISE e_no_version_name;
4574: END IF;
4575:
4576: SELECT fem_dim_attr_versions_b_s.NEXTVAL
4577: INTO v_ver_id FROM dual;
4578:
4579: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
4580: x_rowid => v_row_id,
4581: x_version_id => v_ver_id,

Line 5067: INTO v_ver_id FROM dual;

5063: RAISE e_no_version_name;
5064: END IF;
5065:
5066: SELECT fem_dim_attr_versions_b_s.NEXTVAL
5067: INTO v_ver_id FROM dual;
5068:
5069: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
5070: x_rowid => v_row_id,
5071: x_version_id => v_ver_id,

Line 5607: INTO v_ver_id FROM dual;

5603: RAISE e_no_version_name;
5604: END IF;
5605:
5606: SELECT fem_dim_attr_versions_b_s.NEXTVAL
5607: INTO v_ver_id FROM dual;
5608:
5609: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
5610: x_rowid => v_row_id,
5611: x_version_id => v_ver_id,

Line 6173: INTO v_version_id FROM dual;

6169: RAISE e_no_version_name;
6170: END IF;
6171:
6172: SELECT fem_dim_attr_versions_b_s.NEXTVAL
6173: INTO v_version_id FROM dual;
6174:
6175: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
6176: x_rowid => v_row_id,
6177: x_version_id => v_version_id,

Line 6242: from dual;

6238: LPAD(TO_CHAR(p_first_period_number),15,'0')||
6239: LPAD(to_char(v_first_period_calendar_id),5,'0')||
6240: LPAD(to_char(v_first_period_time_dimgrp_key),5,'0')
6241: into v_attr_assign_value
6242: from dual;
6243:
6244: v_param_req := TRUE;
6245: WHEN 'BUDGET_LAST_PERIOD' THEN
6246: -- for this attribute we have to identify the CAL_PERIOD_ID

Line 6275: from dual;

6271: LPAD(TO_CHAR(p_last_period_number),15,'0')||
6272: LPAD(to_char(v_last_period_calendar_id),5,'0')||
6273: LPAD(to_char(v_last_period_time_dimgrp_key),5,'0')
6274: into v_attr_assign_value
6275: from dual;
6276:
6277: v_param_req := TRUE;
6278: ELSE
6279: FEM_ENGINES_PKG.Tech_Message(

Line 6660: INTO v_version_id FROM dual;

6656: RAISE e_no_version_name;
6657: END IF;
6658:
6659: SELECT fem_dim_attr_versions_b_s.NEXTVAL
6660: INTO v_version_id FROM dual;
6661:
6662: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
6663: x_rowid => v_row_id,
6664: x_version_id => v_version_id,

Line 6729: from dual;

6725: LPAD(TO_CHAR(p_first_period_number),15,'0')||
6726: LPAD(to_char(v_first_period_calendar_id),5,'0')||
6727: LPAD(to_char(v_first_period_time_dimgrp_key),5,'0')
6728: into v_attr_assign_value
6729: from dual;
6730:
6731: v_param_req := TRUE;
6732: WHEN 'BUDGET_LAST_PERIOD' THEN
6733: -- for this attribute we have to identify the CAL_PERIOD_ID

Line 6762: from dual;

6758: LPAD(TO_CHAR(p_last_period_number),15,'0')||
6759: LPAD(to_char(v_last_period_calendar_id),5,'0')||
6760: LPAD(to_char(v_last_period_time_dimgrp_key),5,'0')
6761: into v_attr_assign_value
6762: from dual;
6763:
6764: v_param_req := TRUE;
6765: ELSE
6766: FEM_ENGINES_PKG.Tech_Message(

Line 7166: INTO v_ver_id FROM dual;

7162: RAISE e_no_version_name;
7163: END IF;
7164:
7165: SELECT fem_dim_attr_versions_b_s.NEXTVAL
7166: INTO v_ver_id FROM dual;
7167:
7168: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
7169: x_rowid => v_row_id,
7170: x_version_id => v_ver_id,

Line 7716: INTO v_ver_id FROM dual;

7712: RAISE e_no_version_name;
7713: END IF;
7714:
7715: SELECT fem_dim_attr_versions_b_s.NEXTVAL
7716: INTO v_ver_id FROM dual;
7717:
7718: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
7719: x_rowid => v_row_id,
7720: x_version_id => v_ver_id,

Line 8194: INTO v_ver_id FROM dual;

8190: RAISE e_no_version_name;
8191: END IF;
8192:
8193: SELECT fem_dim_attr_versions_b_s.NEXTVAL
8194: INTO v_ver_id FROM dual;
8195:
8196: FEM_DIM_ATTR_VERSIONS_PKG.INSERT_ROW(
8197: x_rowid => v_row_id,
8198: x_version_id => v_ver_id,

Line 8599: FROM dual;

8595: -- Get New Global VS Combo ID --
8596: --------------------------------
8597: SELECT fem_global_vs_combos_b_s.NEXTVAL
8598: INTO v_gvsc_id
8599: FROM dual;
8600: ---------------------------------------
8601: -- Validate the Global VS Combo Display Code --
8602: ---------------------------------------
8603: IF p_global_vs_combo_dc IS NULL THEN