PACKAGE: APPS.IGS_RU_CALL_RULE_PKG

Source

1 package IGS_RU_CALL_RULE_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSUI02S.pls 115.3 2002/11/29 04:25:08 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_CALLED_RULE_CD in VARCHAR2,
6   X_NR_RUL_SEQUENCE_NUMBER in NUMBER,
7   X_MODE in VARCHAR2 default 'R'
8   );
9 procedure LOCK_ROW (
10   X_ROWID in VARCHAR2,
11   X_CALLED_RULE_CD in VARCHAR2,
12   X_NR_RUL_SEQUENCE_NUMBER in NUMBER
13 );
14 procedure UPDATE_ROW (
15   X_ROWID in VARCHAR2,
16   X_CALLED_RULE_CD in VARCHAR2,
17   X_NR_RUL_SEQUENCE_NUMBER in NUMBER,
18   X_MODE in VARCHAR2 default 'R'
19   );
20 procedure ADD_ROW (
21   X_ROWID in out NOCOPY VARCHAR2,
22   X_CALLED_RULE_CD in VARCHAR2,
23   X_NR_RUL_SEQUENCE_NUMBER in NUMBER,
24   X_MODE in VARCHAR2 default 'R'
25   );
26 procedure DELETE_ROW (
27   X_ROWID in VARCHAR2
28 );
29 
30 FUNCTION Get_PK_For_Validation (
31     x_called_rule_cd IN VARCHAR2
32     )
33 RETURN BOOLEAN;
34 
35 FUNCTION GET_UK1_FOR_VALIDATION(
36 	x_nr_rul_sequence_number IN NUMBER
37 	) RETURN BOOLEAN;
38 
39 
40   PROCEDURE GET_FK_IGS_RU_NAMED_RULE (
41     x_rul_sequence_number IN NUMBER
42     );
43 
44 -- added to take care of check constraints
45 PROCEDURE CHECK_CONSTRAINTS(
46      column_name IN VARCHAR2 DEFAULT NULL,
47      column_value IN VARCHAR2 DEFAULT NULL
48 );
49 
50 PROCEDURE Before_DML (
51     p_action IN VARCHAR2,
52     x_rowid IN VARCHAR2 DEFAULT NULL,
53     x_called_rule_cd IN VARCHAR2 DEFAULT NULL,
54     x_nr_rul_sequence_number IN NUMBER DEFAULT NULL,
55     x_creation_date IN DATE DEFAULT NULL,
56     x_created_by IN NUMBER DEFAULT NULL,
57     x_last_update_date IN DATE DEFAULT NULL,
58     x_last_updated_by IN NUMBER DEFAULT NULL,
59     x_last_update_login IN NUMBER DEFAULT NULL
60   );
61 
62 end IGS_RU_CALL_RULE_PKG;