PACKAGE: APPS.IGS_PR_RU_CAT_PKG

Source

1 package IGS_PR_RU_CAT_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSQI11S.pls 115.4 2002/11/29 03:16:42 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PROGRESSION_RULE_CAT in VARCHAR2,
6   X_DESCRIPTION in VARCHAR2,
7   X_S_RULE_CALL_CD in VARCHAR2,
8   X_CLOSED_IND in VARCHAR2,
9   X_MESSAGE in VARCHAR2,
10   X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N',
11   X_MODE in VARCHAR2 default 'R'
12   );
13 procedure LOCK_ROW (
14   X_ROWID in VARCHAR2,
15   X_PROGRESSION_RULE_CAT in VARCHAR2,
16   X_DESCRIPTION in VARCHAR2,
17   X_S_RULE_CALL_CD in VARCHAR2,
18   X_CLOSED_IND in VARCHAR2,
19   X_MESSAGE in VARCHAR2,
20   X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N'
21 );
22 procedure UPDATE_ROW (
23   X_ROWID in VARCHAR2,
24   X_PROGRESSION_RULE_CAT in VARCHAR2,
25   X_DESCRIPTION in VARCHAR2,
26   X_S_RULE_CALL_CD in VARCHAR2,
27   X_CLOSED_IND in VARCHAR2,
28   X_MESSAGE in VARCHAR2,
29   X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N',
30   X_MODE in VARCHAR2 default 'R'
31   );
32 procedure ADD_ROW (
33   X_ROWID in out NOCOPY VARCHAR2,
34   X_PROGRESSION_RULE_CAT in VARCHAR2,
35   X_DESCRIPTION in VARCHAR2,
36   X_S_RULE_CALL_CD in VARCHAR2,
37   X_CLOSED_IND in VARCHAR2,
38   X_MESSAGE in VARCHAR2,
39   X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N',
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure DELETE_ROW (
43   X_ROWID in VARCHAR2
44 );
45 
46 FUNCTION Get_PK_For_Validation (
47     x_progression_rule_cat IN VARCHAR2
48     ) RETURN BOOLEAN;
49 
50 PROCEDURE GET_FK_IGS_RU_CALL (
51     x_s_rule_call_cd IN VARCHAR2
52  );
53 PROCEDURE Before_DML (
54     p_action IN VARCHAR2,
55     x_rowid IN VARCHAR2 DEFAULT NULL,
56     x_progression_rule_cat IN VARCHAR2 DEFAULT NULL,
57     x_description IN VARCHAR2 DEFAULT NULL,
58     x_s_rule_call_cd IN VARCHAR2 DEFAULT NULL,
59     x_closed_ind IN VARCHAR2 DEFAULT NULL,
60     x_message IN VARCHAR2 DEFAULT NULL,
61     X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N',
62     x_creation_date IN DATE DEFAULT NULL,
63     x_created_by IN NUMBER DEFAULT NULL,
64     x_last_update_date IN DATE DEFAULT NULL,
65     x_last_updated_by IN NUMBER DEFAULT NULL,
66     x_last_update_login IN NUMBER DEFAULT NULL
67   );
68 PROCEDURE Check_Constraints(
69 	Column_Name IN VARCHAR2 DEFAULT NULL,
70 	Column_Value IN VARCHAR2 DEFAULT NULL
71 	);
72 
73 end IGS_PR_RU_CAT_PKG;