APPS.MSC_SCN_UTILS dependencies on MSC_SCENARIO_USERS

Line 2028: from msc_scenario_users

2024:
2025: FUNCTION get_scn_users (p_scn_id in number) return varchar2 is
2026: cursor c_scn_users is
2027: select msc_scn_utils.get_owner_name(user_id)
2028: from msc_scenario_users
2029: where scenario_id = p_scn_id;
2030:
2031: l_scn_users varchar2(2000) := '';
2032: l_scn_user varchar2(100);

Line 2112: -- Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;

2108: l_login_id := FND_PROFILE.VALUE('LOGIN_ID');
2109:
2110: select msc_scn_scenarios_s.nextval into l_new_scn_id from dual;
2111:
2112: -- Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2113:
2114: insert into msc_scenarios(scenario_id,
2115: scenario_name,
2116: created_by,

Line 2171: insert into msc_scenario_users (scenario_id,

2167: run_date,
2168: plan_horizon,
2169: plan_run_id from msc_scenario_plans where scenario_id = p_scn_id);
2170:
2171: insert into msc_scenario_users (scenario_id,
2172: user_id,
2173: created_by,
2174: creation_Date,
2175: last_update_date,

Line 2184: l_login_id from msc_scenario_users where scenario_id = p_scn_id);

2180: l_user_id,
2181: sysdate,
2182: sysdate,
2183: l_user_id,
2184: l_login_id from msc_scenario_users where scenario_id = p_scn_id);
2185: commit;
2186:
2187: open c_scn_plans;
2188: loop

Line 2287: delete msc_Scenario_users where scenario_id = p_scn_id;

2283: delete msc_scenarios where scenario_id = p_scn_id;
2284:
2285: delete msc_scenario_plans where scenario_id = p_scn_id;
2286:
2287: delete msc_Scenario_users where scenario_id = p_scn_id;
2288:
2289: delete msc_Scenario_set_details where scenario_id = p_scn_id;
2290:
2291: commit;

Line 2569: --l_where_clause := l_where_clause || ' 1=1 AND ( (''MSA'' = SOURCE_TABLE) AND ( scenario_id is null or (1063,scenario_id) in (select user_id,scenario_id from msc_scenario_users) ) ) OR ''MPPA'' = source_table';

2565: --dbms_output.put_line(' printing from within proc: ' || where_clause);
2566: --dbms_output.put_line(' 2');
2567: l_where_clause := l_where_clause || where_clause;
2568:
2569: --l_where_clause := l_where_clause || ' 1=1 AND ( (''MSA'' = SOURCE_TABLE) AND ( scenario_id is null or (1063,scenario_id) in (select user_id,scenario_id from msc_scenario_users) ) ) OR ''MPPA'' = source_table';
2570: -- create a summary query on top of form_query
2571: group_by := 'GROUP BY source_table, status, SIGN(finish_by -TRUNC(sysdate) + 0) ORDER BY 1, 3, 2';
2572: --dbms_output.put_line(' 3');
2573: sql_stmt := select_query || ' ' || from_query || ' ' || l_where_clause || ' ' || group_by;