PACKAGE: APPS.IGS_OR_ORG_ACCR_DTLS_PKG

Source

1 PACKAGE igs_or_org_accr_dtls_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI21S.pls 115.6 2002/11/29 01:42:22 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_AGENCY_ID IN VARCHAR2,
8        x_ORG_ACCR_STATUS 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_AGENCY_ID IN VARCHAR2,
19        x_ORG_ACCR_STATUS 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_AGENCY_ID IN VARCHAR2,
27        x_ORG_ACCR_STATUS 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_AGENCY_ID IN VARCHAR2,
38        x_ORG_ACCR_STATUS 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_accr_status IN VARCHAR2,
49     x_org_agency_id 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_Accr_Stat (
56     x_org_accr_status 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 
68   PROCEDURE Check_Constraints (
69 		 Column_Name IN VARCHAR2  DEFAULT NULL,
70 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
71   PROCEDURE Before_DML (
72     p_action IN VARCHAR2,
73     x_rowid IN VARCHAR2 DEFAULT NULL,
74     x_org_structure_id IN VARCHAR2 DEFAULT NULL,
75     x_org_structure_type IN VARCHAR2 DEFAULT NULL,
76     x_org_agency_id IN VARCHAR2 DEFAULT NULL,
77     x_org_accr_status IN VARCHAR2 DEFAULT NULL,
78     x_start_date IN DATE DEFAULT NULL,
79     x_end_date IN DATE DEFAULT NULL,
80     x_creation_date IN DATE DEFAULT NULL,
81     x_created_by IN NUMBER DEFAULT NULL,
82     x_last_update_date IN DATE DEFAULT NULL,
83     x_last_updated_by IN NUMBER DEFAULT NULL,
84     x_last_update_login IN NUMBER DEFAULT NULL
85  );
86 END igs_or_org_accr_dtls_pkg;