1 package IGS_PR_OU_UNIT_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSQI07S.pls 115.4 2002/11/29 03:15:32 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PROGRESSION_RULE_CAT in VARCHAR2,
6 X_PRA_SEQUENCE_NUMBER in NUMBER,
7 X_PRO_SEQUENCE_NUMBER in NUMBER,
8 X_UNIT_CD in VARCHAR2,
9 X_S_UNIT_TYPE in VARCHAR2,
10 X_MODE in VARCHAR2 default 'R' ,
11 X_ORG_ID in NUMBER
12 );
13 procedure LOCK_ROW (
14 X_ROWID in VARCHAR2,
15 X_PROGRESSION_RULE_CAT in VARCHAR2,
16 X_PRA_SEQUENCE_NUMBER in NUMBER,
17 X_PRO_SEQUENCE_NUMBER in NUMBER,
18 X_UNIT_CD in VARCHAR2,
19 X_S_UNIT_TYPE in VARCHAR2
20 );
21 procedure UPDATE_ROW (
22 X_ROWID in VARCHAR2,
23 X_PROGRESSION_RULE_CAT in VARCHAR2,
24 X_PRA_SEQUENCE_NUMBER in NUMBER,
25 X_PRO_SEQUENCE_NUMBER in NUMBER,
26 X_UNIT_CD in VARCHAR2,
27 X_S_UNIT_TYPE in VARCHAR2,
28 X_MODE in VARCHAR2 default 'R'
29 );
30 procedure ADD_ROW (
31 X_ROWID in out NOCOPY VARCHAR2,
32 X_PROGRESSION_RULE_CAT in VARCHAR2,
33 X_PRA_SEQUENCE_NUMBER in NUMBER,
34 X_PRO_SEQUENCE_NUMBER in NUMBER,
35 X_UNIT_CD in VARCHAR2,
36 X_S_UNIT_TYPE in VARCHAR2,
37 X_MODE in VARCHAR2 default 'R',
38 X_ORG_ID in NUMBER
39 );
40 procedure DELETE_ROW (
41 X_ROWID in VARCHAR2
42 );
43 FUNCTION Get_PK_For_Validation (
44 x_progression_rule_cat IN VARCHAR2,
45 x_pra_sequence_number IN NUMBER,
46 x_pro_sequence_number IN NUMBER,
47 x_unit_cd IN VARCHAR2
48 )
49 RETURN BOOLEAN;
50
51 PROCEDURE GET_FK_IGS_PR_RU_OU (
52 x_progression_rule_cat IN VARCHAR2,
53 x_pra_sequence_number IN NUMBER,
54 x_sequence_number IN NUMBER
55 );
56
57 PROCEDURE GET_FK_IGS_PS_UNIT (
58 x_unit_cd IN VARCHAR2
59 );
60
61 PROCEDURE Check_Constraints (
62 Column_Name IN VARCHAR2 DEFAULT NULL,
63 Column_Value IN VARCHAR2 DEFAULT NULL
64 );
65
66 PROCEDURE Before_DML (
67 p_action IN VARCHAR2,
68 x_rowid IN VARCHAR2 DEFAULT NULL,
69 x_progression_rule_cat IN VARCHAR2 DEFAULT NULL,
70 x_pra_sequence_number IN NUMBER DEFAULT NULL,
71 x_pro_sequence_number IN NUMBER DEFAULT NULL,
72 x_unit_cd IN VARCHAR2 DEFAULT NULL,
73 x_s_unit_type IN VARCHAR2 DEFAULT NULL,
74 x_creation_date IN DATE DEFAULT NULL,
75 x_created_by IN NUMBER DEFAULT NULL,
76 x_last_update_date IN DATE DEFAULT NULL,
77 x_last_updated_by IN NUMBER DEFAULT NULL,
78 x_last_update_login IN NUMBER DEFAULT NULL,
79 X_ORG_ID in NUMBER DEFAULT NULL
80 );
81 end IGS_PR_OU_UNIT_PKG;