[Home] [Help]
PACKAGE: APPS.CZ_PS_COPY
Source
1 PACKAGE cz_ps_copy AUTHID CURRENT_USER AS
2 /* $Header: czpscps.pls 120.0.12010000.2 2010/05/18 20:33:13 smanna ship $ */
3
4 TYPE SeqRecord IS RECORD(id INTEGER,name VARCHAR2(50));
5 TYPE SequenceArray IS TABLE OF SeqRecord INDEX BY BINARY_INTEGER;
6 TYPE FlowId IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
7 TYPE FlowId_idx_vc2 IS TABLE OF INTEGER INDEX BY VARCHAR2(15);--BINARY_INTEGER;
8
9 INCREMENT INTEGER:=20;
10 NEW_PROJECT_ID INTEGER:=0;
11 OLD_PROJECT_ID INTEGER;
12 GLOBAL_RUN_ID INTEGER;
13 NULL_ CONSTANT INTEGER:=-1;
14 NO_FLAG CONSTANT VARCHAR2(1):='0';
15 YES_FLAG CONSTANT VARCHAR2(1):='1';
16 REFRENCE_NODE_TYPE CONSTANT INTEGER:=263;
17
18 FlowId_PS_NODE FlowId;
19 FlowId_INTL_TEXT FlowId;
20 FlowId_EXPRESSION FlowId;
21 FlowId_EXPRESSION_NODE FlowId_idx_vc2;
22 FlowId_FILTER_SET FlowId;
23 FlowId_RULE FlowId;
24 FlowId_SUB_CON_SET FlowId;
25 FlowId_POPULATOR FlowId;
26 FlowId_GRID_DEF FlowId;
27 FlowId_GRID_COL FlowId;
28 FlowId_GRID_CELL FlowId;
29 FlowId_UI_DEF FlowId;
30 FlowId_UI_NODE FlowId;
31 FlowId_FUNC_COMP_SPEC FlowId;
32 FlowId_RULE_FOLDER FlowId;
33 FlowId_MODEL_REF_EXPL FlowId;
34
35 Sequences SequenceArray;
36
37 PROCEDURE Project_Copy
38 (p_old_id IN INTEGER,
39 p_new_id IN OUT NOCOPY INTEGER,
40 p_Copy_Rules IN VARCHAR2 , -- DEFAULT '1',
41 p_Copy_UI IN VARCHAR2 , -- DEFAULT '1',
42 p_name IN VARCHAR2 DEFAULT NULL,
43 p_folder_id IN INTEGER DEFAULT NULL
44 );
45
46 PROCEDURE Copy_PS_NODE_subtree
47 (p_project_id IN INTEGER,
48 p_parent_id IN INTEGER,
49 p_new_project_id IN INTEGER,
50 p_out_new_root IN OUT NOCOPY INTEGER,
51 p_new_parent_id IN INTEGER DEFAULT NULL);
52
53 PROCEDURE Copy_RULES_subschema
54 (p_rule_id IN INTEGER,
55 p_out_new_rule_id OUT NOCOPY INTEGER,
56 p_FUNC_COMP_Flag IN VARCHAR2 , -- DEFAULT '0',
57 p_rule_folder_id IN INTEGER DEFAULT NULL,
58 p_Rules_Seq_Flag IN VARCHAR2 -- DEFAULT '0'
59 );
60
61 PROCEDURE COPY_FUNC_COMPANION
62 (p_func_comp_id IN INTEGER,
63 p_project_id IN INTEGER,
64 p_new_rule_folder_id IN INTEGER DEFAULT NULL,
65 p_out_new_func_comp_id IN OUT NOCOPY INTEGER );
66
67 PROCEDURE copy_RULE_SEQ
68 (p_rule_seq_id IN INTEGER,
69 p_new_rule_seq_id IN OUT NOCOPY INTEGER);
70
71 PROCEDURE Test
72 (p_id IN INTEGER,
73 p_Rules IN VARCHAR2 , -- DEFAULT '1',
74 p_UI IN VARCHAR2 , -- DEFAULT '1',
75 p_folder_id IN INTEGER -- DEFAULT -1
76 );
77
78 END cz_ps_copy;