PACKAGE: APPS.IGS_OR_ORG_ALT_IDTYP_PKG

Source

1 PACKAGE igs_or_org_alt_idtyp_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSOI16S.pls 115.7 2002/11/29 01:41:19 nsidana ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
6        x_ID_TYPE_DESCRIPTION IN VARCHAR2,
7        x_INST_FLAG IN VARCHAR2,
8        x_UNIT_FLAG IN VARCHAR2,
9        x_CLOSE_IND IN VARCHAR2,
10 	   x_SYSTEM_ID_TYPE IN VARCHAR2 DEFAULT NULL,
11        x_PREF_INST_IND IN VARCHAR2 DEFAULT NULL,
12 	   x_PREF_UNIT_IND IN VARCHAR2 DEFAULT NULL,
13       X_MODE in VARCHAR2 default 'R'
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
19        x_ID_TYPE_DESCRIPTION IN VARCHAR2,
20        x_INST_FLAG IN VARCHAR2,
21        x_UNIT_FLAG IN VARCHAR2,
22        x_CLOSE_IND IN VARCHAR2,
23    	   x_SYSTEM_ID_TYPE IN VARCHAR2 DEFAULT NULL,
24        x_PREF_INST_IND IN VARCHAR2 DEFAULT NULL,
25 	   x_PREF_UNIT_IND IN VARCHAR2 DEFAULT NULL);
26 
27  procedure UPDATE_ROW (
28       X_ROWID in  VARCHAR2,
29        x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
30        x_ID_TYPE_DESCRIPTION IN VARCHAR2,
31        x_INST_FLAG IN VARCHAR2,
32        x_UNIT_FLAG IN VARCHAR2,
33        x_CLOSE_IND IN VARCHAR2,
34 	   x_SYSTEM_ID_TYPE IN VARCHAR2 DEFAULT NULL,
35        x_PREF_INST_IND IN VARCHAR2 DEFAULT NULL,
36 	   x_PREF_UNIT_IND IN VARCHAR2 DEFAULT NULL,
37       X_MODE in VARCHAR2 default 'R'
38   );
39 
40  procedure ADD_ROW (
41       X_ROWID in out NOCOPY VARCHAR2,
42        x_ORG_ALTERNATE_ID_TYPE IN VARCHAR2,
43        x_ID_TYPE_DESCRIPTION IN VARCHAR2,
44        x_INST_FLAG IN VARCHAR2,
45        x_UNIT_FLAG IN VARCHAR2,
46        x_CLOSE_IND IN VARCHAR2,
47 	   x_SYSTEM_ID_TYPE IN VARCHAR2 DEFAULT NULL,
48        x_PREF_INST_IND IN VARCHAR2 DEFAULT NULL,
49 	   x_PREF_UNIT_IND IN VARCHAR2 DEFAULT NULL,
50       X_MODE in VARCHAR2 default 'R'
51   ) ;
52 
53 procedure DELETE_ROW (
54   X_ROWID in VARCHAR2
55 ) ;
56   FUNCTION Get_PK_For_Validation (
57     x_org_alternate_id_type IN VARCHAR2
58     ) RETURN BOOLEAN ;
59 
60   PROCEDURE Check_Constraints (
61 		 Column_Name IN VARCHAR2  DEFAULT NULL,
62 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
63   PROCEDURE Before_DML (
64     p_action IN VARCHAR2,
65     x_rowid IN VARCHAR2 DEFAULT NULL,
66     x_org_alternate_id_type IN VARCHAR2 DEFAULT NULL,
67     x_id_type_description IN VARCHAR2 DEFAULT NULL,
68     x_inst_flag IN VARCHAR2 DEFAULT NULL,
69     x_unit_flag IN VARCHAR2 DEFAULT NULL,
70     x_close_ind IN VARCHAR2 DEFAULT NULL,
71     x_SYSTEM_ID_TYPE IN VARCHAR2 DEFAULT NULL,
72     x_PREF_INST_IND IN VARCHAR2 DEFAULT NULL,
73     x_PREF_UNIT_IND 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  );
80 END igs_or_org_alt_idtyp_pkg;