1 package IGS_RU_ITEM_PKG as
2 /* $Header: IGSUI07S.pls 120.2 2006/02/20 04:33:02 sarakshi noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_RUL_SEQUENCE_NUMBER in NUMBER,
7 X_ITEM in NUMBER,
8 X_TURIN_FUNCTION in VARCHAR2,
9 X_NAMED_RULE in NUMBER,
10 X_RULE_NUMBER in NUMBER,
11 X_SET_NUMBER in NUMBER,
12 X_VALUE in VARCHAR2,
13 X_DERIVED_RULE in NUMBER,
14 X_MODE in VARCHAR2 default 'R'
15 );
16 procedure LOCK_ROW (
17 X_ROWID in VARCHAR2,
18 X_RUL_SEQUENCE_NUMBER in NUMBER,
19 X_ITEM in NUMBER,
20 X_TURIN_FUNCTION in VARCHAR2,
21 X_NAMED_RULE in NUMBER,
22 X_RULE_NUMBER in NUMBER,
23 X_SET_NUMBER in NUMBER,
24 X_VALUE in VARCHAR2,
25 X_DERIVED_RULE in NUMBER
26 );
27 procedure UPDATE_ROW (
28 X_ROWID in VARCHAR2,
29 X_RUL_SEQUENCE_NUMBER in NUMBER,
30 X_ITEM in NUMBER,
31 X_TURIN_FUNCTION in VARCHAR2,
32 X_NAMED_RULE in NUMBER,
33 X_RULE_NUMBER in NUMBER,
34 X_SET_NUMBER in NUMBER,
35 X_VALUE in VARCHAR2,
36 X_DERIVED_RULE in NUMBER,
37 X_MODE in VARCHAR2 default 'R'
38 );
39 procedure ADD_ROW (
40 X_ROWID in out NOCOPY VARCHAR2,
41 X_RUL_SEQUENCE_NUMBER in NUMBER,
42 X_ITEM in NUMBER,
43 X_TURIN_FUNCTION in VARCHAR2,
44 X_NAMED_RULE in NUMBER,
45 X_RULE_NUMBER in NUMBER,
46 X_SET_NUMBER in NUMBER,
47 X_VALUE in VARCHAR2,
48 X_DERIVED_RULE in NUMBER,
49 X_MODE in VARCHAR2 default 'R'
50 );
51 procedure DELETE_ROW (
52 X_ROWID in VARCHAR2
53 );
54
55 FUNCTION Get_PK_For_Validation (
56 x_rul_sequence_number IN NUMBER,
57 x_item IN NUMBER
58 )
59 RETURN BOOLEAN;
60
61 PROCEDURE Check_constraints(
62 Column_Name IN VARCHAR2 DEFAULT NULL,
63 Column_Value IN VARCHAR2 DEFAULT NULL
64 );
65 PROCEDURE Before_DML (
66 p_action IN VARCHAR2,
67 x_rowid IN VARCHAR2 DEFAULT NULL,
68 x_rul_sequence_number IN NUMBER DEFAULT NULL,
69 x_item IN NUMBER DEFAULT NULL,
70 x_turin_function IN VARCHAR2 DEFAULT NULL,
71 x_named_rule IN NUMBER DEFAULT NULL,
72 x_rule_number IN NUMBER DEFAULT NULL,
73 x_set_number IN NUMBER DEFAULT NULL,
74 x_value IN VARCHAR2 DEFAULT NULL,
75 x_derived_rule IN NUMBER DEFAULT NULL,
76 x_creation_date IN DATE DEFAULT NULL,
77 x_created_by IN NUMBER DEFAULT NULL,
78 x_last_update_date IN DATE DEFAULT NULL,
79 x_last_updated_by IN NUMBER DEFAULT NULL,
80 x_last_update_login IN NUMBER DEFAULT NULL
81 );
82
83 PROCEDURE GET_FK_IGS_RU_NAMED_RULE (
84 x_rul_sequence_number IN VARCHAR2
85 );
86
87 PROCEDURE GET_FK_IGS_RU_RULE (
88 x_sequence_number IN NUMBER
89 );
90
91 PROCEDURE GET_FK_IGS_RU_SET (
92 x_sequence_number IN NUMBER
93 );
94
95 PROCEDURE GET_UFK_IGS_RU_CALL (
96 x_rud_sequence_number IN NUMBER
97 );
98
99 PROCEDURE GET_FK_IGS_RU_TURIN_FNC (
100 x_s_turin_function IN VARCHAR2
101 );
102
103 PROCEDURE LOAD_ROW (
104 x_rul_sequence_number IN NUMBER,
105 x_item IN NUMBER,
106 x_turin_function IN VARCHAR2,
107 x_named_rule IN NUMBER,
108 x_rule_number IN NUMBER,
109 x_set_number IN NUMBER,
110 x_value IN VARCHAR2,
111 x_derived_rule IN NUMBER,
112 x_owner IN VARCHAR2,
113 x_last_update_date IN VARCHAR2,
114 x_custom_mode IN VARCHAR2
115 );
116
117 PROCEDURE LOAD_SEED_ROW (
118 x_upload_mode IN VARCHAR2, -- an extra parameter to distinguish NLS and non-NLS upload
119 x_rul_sequence_number IN NUMBER,
120 x_item IN NUMBER,
121 x_turin_function IN VARCHAR2,
122 x_named_rule IN NUMBER,
123 x_rule_number IN NUMBER,
124 x_set_number IN NUMBER,
125 x_value IN VARCHAR2,
126 x_derived_rule IN NUMBER,
127 x_owner IN VARCHAR2,
128 x_last_update_date IN VARCHAR2,
129 x_custom_mode IN VARCHAR2
130 );
131
132 end IGS_RU_ITEM_PKG;