APPS.MST_COPY_PLAN_OPTIONS dependencies on MST_PLANS

Line 44: from mst_plans

40: if (p_plan_dates_source = 1) then
41: begin
42: select plan_id
43: into l_plan_id
44: from mst_plans
45: where plan_id = -1-l_user_id;
46: exception
47: when others then
48: l_plan_id := -1;

Line 54: from mst_plans

50:
51: select (sysdate + nvl(system_date_offset, 0)) start_date_new,
52: (sysdate + nvl(nvl(system_date_offset,0) + plan_days, 1)) cutoff_date_new
53: into v_dest_start_date, v_dest_end_date
54: from mst_plans
55: where plan_id = l_plan_id;
56:
57: elsif (p_plan_dates_source = 2) then
58: select start_date, cutoff_date

Line 60: from mst_plans

56:
57: elsif (p_plan_dates_source = 2) then
58: select start_date, cutoff_date
59: into v_dest_start_date, v_dest_end_date
60: from mst_plans
61: where plan_id = p_source_plan_id;
62: elsif (p_plan_dates_source = 3) then
63: v_dest_start_date := p_dest_start_date;
64: v_dest_end_date := p_dest_end_date;

Line 71: select mst_plans_s.nextval

67: v_dest_end_date := p_dest_end_date;
68: end if;
69:
70:
71: select mst_plans_s.nextval
72: into v_dest_plan_id
73: from dual;
74:
75: v_statement :=

Line 76: 'INSERT INTO MST_PLANS(' ||

72: into v_dest_plan_id
73: from dual;
74:
75: v_statement :=
76: 'INSERT INTO MST_PLANS(' ||
77: 'plan_id, ' ||
78: 'plan_type, ' ||
79: 'compile_designator, ' ||
80: 'description, ' ||

Line 182: 'from MST_PLANS ' ||

178: ',:v_sysdate' ||
179: ',:v_login_id' ||
180: ',DIMENSION_UOM' ||
181: ',MAXIMUM_EMPTY_LEG_LENGTH ' ||
182: 'from MST_PLANS ' ||
183: 'where plan_id = :p_source_plan_id';
184:
185:
186: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, p_dest_plan_name,