APPS.MSC_SCN_UTILS dependencies on MSC_SCENARIO_USERS

Line 2032: from msc_scenario_users

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

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

2114: l_login_id := FND_PROFILE.VALUE('LOGIN_ID');
2115:
2116: select msc_scn_scenarios_s.nextval into l_new_scn_id from dual;
2117:
2118: -- Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2119:
2120: insert into msc_scenarios(scenario_id,
2121: scenario_name,
2122: created_by,

Line 2183: insert into msc_scenario_users (scenario_id,

2179: run_date,
2180: plan_horizon,
2181: plan_run_id from msc_scenario_plans where scenario_id = p_scn_id);
2182:
2183: insert into msc_scenario_users (scenario_id,
2184: user_id,
2185: created_by,
2186: creation_Date,
2187: last_update_date,

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

2192: l_user_id,
2193: sysdate,
2194: sysdate,
2195: l_user_id,
2196: l_login_id from msc_scenario_users where scenario_id = p_scn_id);
2197: commit;
2198:
2199: open c_scn_plans;
2200: 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 2572: --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';

2568: --dbms_output.put_line(' printing from within proc: ' || where_clause);
2569: --dbms_output.put_line(' 2');
2570: l_where_clause := l_where_clause || where_clause;
2571:
2572: --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';
2573: -- create a summary query on top of form_query
2574: group_by := 'GROUP BY source_table, status, SIGN(finish_by -TRUNC(sysdate) + 0) ORDER BY 1, 3, 2';
2575: --dbms_output.put_line(' 3');
2576: sql_stmt := select_query || ' ' || from_query || ' ' || l_where_clause || ' ' || group_by;

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

2870: l_user_id := 0;
2871:
2872: select msc_scn_scenarios_s.nextval into l_scn_id from dual;
2873:
2874: --Insert rows into msc_scenarios,msc_scenario_plans,msc_scenario_users;
2875:
2876: insert into msc_scenarios (scenario_id, scenario_name,
2877: created_by, creation_date, last_update_date, last_updated_by, last_update_login,
2878: parent_scn_id, description, owner,

Line 2919: insert into msc_scenario_users (scenario_id, user_id,

2915:
2916: for i in 1..p_users_arr.count
2917: loop
2918: begin
2919: insert into msc_scenario_users (scenario_id, user_id,
2920: created_by, creation_Date, last_update_date, last_updated_by, last_update_login)
2921: values
2922: (l_scn_id, p_users_arr(i),
2923: l_user_id, sysdate, sysdate, l_user_id, l_login_id);