PACKAGE: APPS.IGS_RU_DESCRIPTION_PKG

Source

1 package IGS_RU_DESCRIPTION_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSUI03S.pls 115.4 2002/11/29 04:25:30 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_SEQUENCE_NUMBER in NUMBER,
7   X_S_RETURN_TYPE in VARCHAR2,
8   X_RULE_DESCRIPTION in VARCHAR2,
9   X_DESCRIPTION in VARCHAR2,
10   X_S_TURIN_FUNCTION in VARCHAR2,
11   X_PARENTHESIS_IND in VARCHAR2,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_ROWID in VARCHAR2,
16   X_SEQUENCE_NUMBER in NUMBER,
17   X_S_RETURN_TYPE in VARCHAR2,
18   X_RULE_DESCRIPTION in VARCHAR2,
19   X_DESCRIPTION in VARCHAR2,
20   X_S_TURIN_FUNCTION in VARCHAR2,
21   X_PARENTHESIS_IND in VARCHAR2
22 );
23 procedure UPDATE_ROW (
24   X_ROWID in VARCHAR2,
25   X_SEQUENCE_NUMBER in NUMBER,
26   X_S_RETURN_TYPE in VARCHAR2,
27   X_RULE_DESCRIPTION in VARCHAR2,
28   X_DESCRIPTION in VARCHAR2,
29   X_S_TURIN_FUNCTION in VARCHAR2,
30   X_PARENTHESIS_IND in VARCHAR2,
31   X_MODE in VARCHAR2 default 'R'
32   );
33 procedure ADD_ROW (
34   X_ROWID in out NOCOPY VARCHAR2,
35   X_SEQUENCE_NUMBER in NUMBER,
36   X_S_RETURN_TYPE in VARCHAR2,
37   X_RULE_DESCRIPTION in VARCHAR2,
38   X_DESCRIPTION in VARCHAR2,
39   X_S_TURIN_FUNCTION in VARCHAR2,
40   X_PARENTHESIS_IND in VARCHAR2,
41   X_MODE in VARCHAR2 default 'R'
42   );
43 procedure DELETE_ROW (
44   X_ROWID in VARCHAR2
45 );
46 
47 FUNCTION Get_PK_For_Validation (
48     x_sequence_number IN NUMBER
49     ) RETURN BOOLEAN ;
50 
51 
52 PROCEDURE GET_FK_IGS_RU_RET_TYPE (
53     x_s_return_type IN VARCHAR2
54     );
55 
56 PROCEDURE GET_FK_IGS_RU_TURIN_FNC (
57     x_s_turin_function IN VARCHAR2
58     );
59 
60 FUNCTION  GET_UK1_FOR_VALIDATION ( x_s_return_type    varchar2 ,
61                                    x_rule_description  varchar2
62                                  )  RETURN BOOLEAN ;
63 
64 PROCEDURE   Check_Constraints (
65                  Column_Name     IN   VARCHAR2    DEFAULT NULL ,
66                  Column_Value    IN   VARCHAR2    DEFAULT NULL
67                                 );
68 
69   PROCEDURE Before_DML (
70     p_action IN VARCHAR2,
71     x_rowid IN VARCHAR2 DEFAULT NULL,
72     x_sequence_number IN NUMBER DEFAULT NULL,
73     x_s_return_type IN VARCHAR2 DEFAULT NULL,
74     x_rule_description IN VARCHAR2 DEFAULT NULL,
75     x_s_turin_function IN VARCHAR2 DEFAULT NULL,
76     x_parenthesis_ind IN VARCHAR2 DEFAULT NULL,
77     x_description IN VARCHAR2 DEFAULT NULL,
78     x_creation_date IN DATE DEFAULT NULL,
79     x_created_by IN NUMBER DEFAULT NULL,
80     x_last_update_date IN DATE DEFAULT NULL,
81     x_last_updated_by IN NUMBER DEFAULT NULL,
82     x_last_update_login IN NUMBER DEFAULT NULL
83   ) ;
84 
85 
86 end IGS_RU_DESCRIPTION_PKG;