1 package IGS_OR_UNIT_REL_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSOI14S.pls 115.4 2002/11/29 01:40:46 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PARENT_ORG_UNIT_CD in VARCHAR2,
6 X_PARENT_START_DT in DATE,
7 X_CHILD_ORG_UNIT_CD in VARCHAR2,
8 X_CHILD_START_DT in DATE,
9 X_CREATE_DT in out NOCOPY DATE,
10 X_LOGICAL_DELETE_DT in DATE,
11 X_MODE in VARCHAR2 default 'R'
12 );
13 procedure LOCK_ROW (
14 X_ROWID in VARCHAR2,
15 X_PARENT_ORG_UNIT_CD in VARCHAR2,
16 X_PARENT_START_DT in DATE,
17 X_CHILD_ORG_UNIT_CD in VARCHAR2,
18 X_CHILD_START_DT in DATE,
19 X_CREATE_DT in DATE,
20 X_LOGICAL_DELETE_DT in DATE
21 );
22 procedure UPDATE_ROW (
23 X_ROWID in VARCHAR2,
24 X_PARENT_ORG_UNIT_CD in VARCHAR2,
25 X_PARENT_START_DT in DATE,
26 X_CHILD_ORG_UNIT_CD in VARCHAR2,
27 X_CHILD_START_DT in DATE,
28 X_CREATE_DT in DATE,
29 X_LOGICAL_DELETE_DT in DATE,
30 X_MODE in VARCHAR2 default 'R'
31 );
32 procedure ADD_ROW (
33 X_ROWID in out NOCOPY VARCHAR2,
34 X_PARENT_ORG_UNIT_CD in VARCHAR2,
35 X_PARENT_START_DT in DATE,
36 X_CHILD_ORG_UNIT_CD in VARCHAR2,
37 X_CHILD_START_DT in DATE,
38 X_CREATE_DT in out NOCOPY DATE,
39 X_LOGICAL_DELETE_DT in DATE,
40 X_MODE in VARCHAR2 default 'R'
41 );
42 procedure DELETE_ROW (
43 X_ROWID in VARCHAR2
44 );
45
46
47 FUNCTION Get_PK_For_Validation (
48 x_parent_org_unit_cd IN VARCHAR2,
49 x_parent_start_dt IN DATE,
50 x_child_org_unit_cd IN VARCHAR2,
51 x_child_start_dt IN DATE,
52 x_create_dt IN DATE
53 ) RETURN BOOLEAN ;
54
55 PROCEDURE GET_FK_IGS_OR_UNIT (
56 x_org_unit_cd IN VARCHAR2,
57 x_start_dt IN DATE
58 );
59
60 procedure Check_Constraints (
61 Column_Name in VARCHAR2 DEFAULT NULL ,
62 Column_Value in VARCHAR2 DEFAULT NULL
63 ) ;
64
65 PROCEDURE Before_DML (
66 p_action IN VARCHAR2,
67 x_rowid IN VARCHAR2 DEFAULT NULL,
68 x_parent_org_unit_cd IN VARCHAR2 DEFAULT NULL,
69 x_parent_start_dt IN DATE DEFAULT NULL,
70 x_child_org_unit_cd IN VARCHAR2 DEFAULT NULL,
71 x_child_start_dt IN DATE DEFAULT NULL,
72 x_create_dt IN DATE DEFAULT NULL,
73 x_logical_delete_dt IN DATE 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 ) ;
80
81 end IGS_OR_UNIT_REL_PKG;