1 PACKAGE msc_copy_plan_options AUTHID CURRENT_USER AS
2 /* $Header: MSCCPPOS.pls 120.5.12020000.3 2012/11/12 08:35:28 giyer ship $ */
3
4 Type Copy_Plan_Bind_Variables is Record
5 (
6 P_DESIGNATOR_ID number ,
7 P_DEST_PLAN_ID number ,
8 P_DEST_PLAN_NAME varchar2(255) ,
9 P_DEST_PLAN_TYPE number ,
10 P_DEST_PLAN_DESC varchar2(255) ,
11 P_SOURCE_PLAN_ID number ,
12 P_DESIGNATOR_TYPE number ,
13 P_ORGANIZATION_ID number ,
14 P_MPS_RELIEF number ,
15 P_INVENTORY_ATP_FLAG number ,
16 P_PRODUCTION number ,
17 P_LAUNCH_WORKFLOW_FLAG number ,
18 P_DESCRIPTION varchar2(255) ,
19 P_DISABLE_DATE date ,
20 P_COLLECTED_FLAG number ,
21 P_SR_INSTANCE_ID number ,
22 P_REFRESH_NUMBER number ,
23 P_ORGANIZATION_SELECTION number ,
24 P_COPY_PLAN number ,
25 P_LAST_UPDATE_DATE date ,
26 P_LAST_UPDATED_BY number ,
27 P_CREATION_DATE date ,
28 P_CREATED_BY number ,
29 P_LAST_UPDATE_LOGIN number
30 );
31
32 TYPE Copy_Plan_Options_Type IS TABLE OF Copy_Plan_Bind_Variables
33 INDEX BY BINARY_INTEGER;
34
35 Type Copy_Plan_Source_Tables is Record
36 (
37 P_TABLE_NAME varchar2(30)
38 );
39
40 TYPE Copy_Plan_Source_Tables_Type IS TABLE OF Copy_Plan_Source_Tables
41 INDEX BY BINARY_INTEGER;
42
43
44 PROCEDURE copy_plan_options (
45 p_source_plan_id IN number,
46 p_dest_plan_name IN varchar2,
47 p_dest_plan_desc IN varchar2,
48 p_dest_plan_type IN number,
49 p_dest_atp IN number,
50 p_dest_production IN number,
51 p_dest_notifications IN number,
52 p_dest_inactive_on IN date,
53 p_organization_id IN number,
54 p_sr_instance_id IN number);
55 PROCEDURE copy_firm_orders(
56 ERRBUF out NOCOPY varchar2,
57 RETCODE out NOCOPY number,
58 P_source_plan_id IN number,
59 P_dest_plan_id IN number);
60 PROCEDURE delete_temp_plan ( ERRBUF out NOCOPY varchar2,
61 RETCODE out NOCOPY number,
62 P_DESIG_ID IN number,
63 p_childreq IN boolean default false);
64 PROCEDURE delete_plan_options( ERRBUF out NOCOPY varchar2,
65 RETCODE out NOCOPY number,
66 P_plan_id IN number);
67 PROCEDURE link_plans(
68 ERRBUF out NOCOPY varchar2,
69 RETCODE out NOCOPY number,
70 P_Src_plan_id in number,
71 P_Src_Desg_id in number,
72 P_plan_id out NOCOPY number,
73 P_designator_id out NOCOPY number);
74
75 PROCEDURE init_plan_id(P_temp_plan in varchar2, P_Plan_id in number, P_designator_id in number) ;
76
77 PROCEDURE inti_pl_sql_table(p_source_table in out NOCOPY Copy_Plan_Source_Tables_Type );
78
79 FUNCTION get_column_name(p_bind_var_col in Copy_Plan_Options_Type
80 , p_source_table in varchar2
81 , p_column_name varchar2)
82 return varchar2 ;
83
84 PROCEDURE generate_sql_script(p_bind_var_col in Copy_Plan_Options_Type
85 , p_table_name varchar2 );
86
87 FUNCTION Convert_to_String(p_value varchar2)
88 return varchar2;
89
90 FUNCTION Get_Column_Value(p_bind_var_col1 in Copy_Plan_Options_Type ,
91 p_column_name varchar2,
92 p_data_type varchar2 ,
93 p_table_name varchar2 )
94 return varchar2;
95 end;