[Home] [Help]
PACKAGE: APPS.IGS_OR_ORG_ALT_IDS_PKG
Source
1 PACKAGE igs_or_org_alt_ids_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI22S.pls 115.6 2002/11/29 01:42:37 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 x_ORG_STRUCTURE_ID IN VARCHAR2,
6 x_ORG_STRUCTURE_TYPE IN VARCHAR2,
7 x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
8 x_ORG_ALTERNATE_ID IN VARCHAR2,
9 x_START_DATE IN DATE,
10 x_END_DATE IN DATE,
11 X_MODE in VARCHAR2 default 'R'
12 );
13
14 procedure LOCK_ROW (
15 X_ROWID in VARCHAR2,
16 x_ORG_STRUCTURE_ID IN VARCHAR2,
17 x_ORG_STRUCTURE_TYPE IN VARCHAR2,
18 x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
19 x_ORG_ALTERNATE_ID IN VARCHAR2,
20 x_START_DATE IN DATE,
21 x_END_DATE IN DATE );
22 procedure UPDATE_ROW (
23 X_ROWID in VARCHAR2,
24 x_ORG_STRUCTURE_ID IN VARCHAR2,
25 x_ORG_STRUCTURE_TYPE IN VARCHAR2,
26 x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
27 x_ORG_ALTERNATE_ID IN VARCHAR2,
28 x_START_DATE IN DATE,
29 x_END_DATE IN DATE,
30 X_MODE in VARCHAR2 default 'R'
31 );
32
33 procedure ADD_ROW (
34 X_ROWID in out NOCOPY VARCHAR2,
35 x_ORG_STRUCTURE_ID IN VARCHAR2,
36 x_ORG_STRUCTURE_TYPE IN VARCHAR2,
37 x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
38 x_ORG_ALTERNATE_ID IN VARCHAR2,
39 x_START_DATE IN DATE,
40 x_END_DATE IN DATE,
41 X_MODE in VARCHAR2 default 'R'
42 ) ;
43
44 procedure DELETE_ROW (
45 X_ROWID in VARCHAR2
46 ) ;
47 FUNCTION Get_PK_For_Validation (
48 x_org_alternate_id IN VARCHAR2,
49 x_org_alternate_id_type IN VARCHAR2,
50 x_org_structure_id IN VARCHAR2,
51 x_org_structure_type IN VARCHAR2,
52 x_start_date IN DATE
53 ) RETURN BOOLEAN ;
54
55 PROCEDURE Get_FK_Igs_Or_Org_Alt_Idtyp (
56 x_org_alternate_id_type IN VARCHAR2
57 );
58
59 PROCEDURE Get_FK_Igs_Or_Institution (
60 x_institution_cd IN VARCHAR2
61 );
62
63 PROCEDURE GET_FK_IGS_OR_UNIT (
64 x_org_unit_cd IN VARCHAR2
65 ) ;
66
67 PROCEDURE Check_Constraints (
68 Column_Name IN VARCHAR2 DEFAULT NULL,
69 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
70 PROCEDURE Before_DML (
71 p_action IN VARCHAR2,
72 x_rowid IN VARCHAR2 DEFAULT NULL,
73 x_org_structure_id IN VARCHAR2 DEFAULT NULL,
74 x_org_structure_type IN VARCHAR2 DEFAULT NULL,
75 x_org_alternate_id_type IN VARCHAR2 DEFAULT NULL,
76 x_org_alternate_id IN VARCHAR2 DEFAULT NULL,
77 x_start_date IN DATE DEFAULT NULL,
78 x_end_date IN DATE DEFAULT NULL,
79 x_creation_date IN DATE DEFAULT NULL,
80 x_created_by IN NUMBER DEFAULT NULL,
81 x_last_update_date IN DATE DEFAULT NULL,
82 x_last_updated_by IN NUMBER DEFAULT NULL,
83 x_last_update_login IN NUMBER DEFAULT NULL
84 );
85 END igs_or_org_alt_ids_pkg;