PACKAGE: APPS.IGS_EN_MERGE_ID_ROWS_PKG

Source

1 package IGS_EN_MERGE_ID_ROWS_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSEI29S.pls 115.4 2002/11/28 23:39:03 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_SMIR_ID in NUMBER,
6   X_TABLE_ALIAS in VARCHAR2,
7   X_OBSOLETE_PERSON_ID in NUMBER,
8   X_OBSOLETE_ID_ROW_INFO in VARCHAR2,
9   X_OBSOLETE_ID_ROWID in VARCHAR2,
10   X_OBSOLETE_UPDATE_ON in DATE,
11   X_CURRENT_PERSON_ID in NUMBER,
12   X_CURRENT_ID_ROW_INFO in VARCHAR2,
13   X_CURRENT_ID_ROWID in VARCHAR2,
14   X_CURRENT_UPDATE_ON in DATE,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ROWID in VARCHAR2,
19   X_SMIR_ID in NUMBER,
20   X_TABLE_ALIAS in VARCHAR2,
21   X_OBSOLETE_PERSON_ID in NUMBER,
22   X_OBSOLETE_ID_ROW_INFO in VARCHAR2,
23   X_OBSOLETE_ID_ROWID in VARCHAR2,
24   X_OBSOLETE_UPDATE_ON in DATE,
25   X_CURRENT_PERSON_ID in NUMBER,
26   X_CURRENT_ID_ROW_INFO in VARCHAR2,
27   X_CURRENT_ID_ROWID in VARCHAR2,
28   X_CURRENT_UPDATE_ON in DATE
29 );
30 procedure UPDATE_ROW (
31   X_ROWID in VARCHAR2,
32   X_SMIR_ID in NUMBER,
33   X_TABLE_ALIAS in VARCHAR2,
34   X_OBSOLETE_PERSON_ID in NUMBER,
35   X_OBSOLETE_ID_ROW_INFO in VARCHAR2,
36   X_OBSOLETE_ID_ROWID in VARCHAR2,
37   X_OBSOLETE_UPDATE_ON in DATE,
38   X_CURRENT_PERSON_ID in NUMBER,
39   X_CURRENT_ID_ROW_INFO in VARCHAR2,
40   X_CURRENT_ID_ROWID in VARCHAR2,
41   X_CURRENT_UPDATE_ON in DATE,
42   X_MODE in VARCHAR2 default 'R'
43   );
44 procedure ADD_ROW (
45   X_ROWID in out NOCOPY VARCHAR2,
46   X_SMIR_ID in NUMBER,
47   X_TABLE_ALIAS in VARCHAR2,
48   X_OBSOLETE_PERSON_ID in NUMBER,
49   X_OBSOLETE_ID_ROW_INFO in VARCHAR2,
50   X_OBSOLETE_ID_ROWID in VARCHAR2,
51   X_OBSOLETE_UPDATE_ON in DATE,
52   X_CURRENT_PERSON_ID in NUMBER,
53   X_CURRENT_ID_ROW_INFO in VARCHAR2,
54   X_CURRENT_ID_ROWID in VARCHAR2,
55   X_CURRENT_UPDATE_ON in DATE,
56   X_MODE in VARCHAR2 default 'R'
57   );
58 procedure DELETE_ROW (
59    X_ROWID in VARCHAR2
60 );
61 FUNCTION Get_PK_For_Validation (
62     x_smir_id IN NUMBER
63     )
64 RETURN BOOLEAN;
65 PROCEDURE GET_FK_IGS_PE_PERSON (
66     x_person_id IN NUMBER
67     );
68 PROCEDURE Before_DML (
69     p_action IN VARCHAR2,
70     x_rowid IN VARCHAR2 DEFAULT NULL,
71     x_smir_id IN NUMBER DEFAULT NULL,
72     x_table_alias IN VARCHAR2 DEFAULT NULL,
73     x_obsolete_person_id IN NUMBER DEFAULT NULL,
74     x_obsolete_id_row_info IN VARCHAR2 DEFAULT NULL,
75     x_obsolete_id_rowid IN VARCHAR2 DEFAULT NULL,
76     x_obsolete_update_on IN DATE DEFAULT NULL,
77     x_current_person_id IN NUMBER DEFAULT NULL,
78     x_current_id_row_info IN VARCHAR2 DEFAULT NULL,
79     x_current_id_rowid IN VARCHAR2 DEFAULT NULL,
80     x_current_update_on IN DATE DEFAULT NULL,
81     x_creation_date IN DATE DEFAULT NULL,
82     x_created_by IN NUMBER DEFAULT NULL,
83     x_last_update_date IN DATE DEFAULT NULL,
84     x_last_updated_by IN NUMBER DEFAULT NULL,
85     x_last_update_login IN NUMBER DEFAULT NULL
86   );
87 procedure Check_constraints(
88 	column_name IN VARCHAR2 DEFAULT NULL,
89 	column_value IN VARCHAR2 DEFAULT NULL
90    );
91 end IGS_EN_MERGE_ID_ROWS_PKG;