PACKAGE: APPS.IGS_AD_ADM_UNIT_STAT_PKG

Source

1 package IGS_AD_ADM_UNIT_STAT_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI01S.pls 115.7 2003/10/30 13:10:08 akadam ship $ */
3 
4 PROCEDURE INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_ORG_ID in NUMBER,
7   X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
8   X_UNIT_ATTEMPT_STATUS in VARCHAR2,
9   X_DESCRIPTION in VARCHAR2,
10   X_SHOW_ON_OFFIC_NTFCTN_IND in VARCHAR2,
11   X_EFFECTIVE_PROGRESSION_IND in VARCHAR2,
12   X_EFFECTIVE_TIME_ELAPSED_IND in VARCHAR2,
13   X_CLOSED_IND in VARCHAR2,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 PROCEDURE LOCK_ROW (
17   X_ROWID   in VARCHAR2,
18   X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
19   X_UNIT_ATTEMPT_STATUS in VARCHAR2,
20   X_DESCRIPTION in VARCHAR2,
21   X_SHOW_ON_OFFIC_NTFCTN_IND in VARCHAR2,
22   X_EFFECTIVE_PROGRESSION_IND in VARCHAR2,
23   X_EFFECTIVE_TIME_ELAPSED_IND in VARCHAR2,
24   X_CLOSED_IND in VARCHAR2
25 );
26 PROCEDURE UPDATE_ROW (
27   X_ROWID in VARCHAR2,
28   X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
29   X_UNIT_ATTEMPT_STATUS in VARCHAR2,
30   X_DESCRIPTION in VARCHAR2,
31   X_SHOW_ON_OFFIC_NTFCTN_IND in VARCHAR2,
32   X_EFFECTIVE_PROGRESSION_IND in VARCHAR2,
33   X_EFFECTIVE_TIME_ELAPSED_IND in VARCHAR2,
34   X_CLOSED_IND in VARCHAR2,
35   X_MODE in VARCHAR2 default 'R'
36   );
37 PROCEDURE ADD_ROW (
38   X_ROWID in out NOCOPY VARCHAR2,
39   X_ORG_ID in NUMBER,
40   X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
41   X_UNIT_ATTEMPT_STATUS in VARCHAR2,
42   X_DESCRIPTION in VARCHAR2,
43   X_SHOW_ON_OFFIC_NTFCTN_IND in VARCHAR2,
44   X_EFFECTIVE_PROGRESSION_IND in VARCHAR2,
45   X_EFFECTIVE_TIME_ELAPSED_IND in VARCHAR2,
46   X_CLOSED_IND in VARCHAR2,
47   X_MODE in VARCHAR2 default 'R'
48   );
49 
50  FUNCTION Get_PK_For_Validation(
51     x_administrative_unit_status IN VARCHAR2,
52     x_closed_ind IN VARCHAR2 DEFAULT NULL
53     ) RETURN BOOLEAN;
54 
55  PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
56     x_unit_attempt_status IN VARCHAR2
57     );
58  PROCEDURE Check_Constraints (
59 			Column_Name IN VARCHAR2 DEFAULT NULL,
60 			Column_Value IN VARCHAR2 DEFAULT NULL
61 			);
62   PROCEDURE Before_DML (
63     p_action IN VARCHAR2,
64     x_rowid IN VARCHAR2 DEFAULT NULL,
65     x_org_id in NUMBER DEFAULT NULL,
66     x_administrative_unit_status IN VARCHAR2 DEFAULT NULL,
67     x_unit_attempt_status IN VARCHAR2 DEFAULT NULL,
68     x_description IN VARCHAR2 DEFAULT NULL,
69     x_show_on_offic_ntfctn_ind IN VARCHAR2 DEFAULT NULL,
70     x_effective_progression_ind IN VARCHAR2 DEFAULT NULL,
71     x_effective_time_elapsed_ind IN VARCHAR2 DEFAULT NULL,
72     x_closed_ind IN VARCHAR2 DEFAULT NULL,
73     x_creation_date IN DATE DEFAULT NULL,
74     x_created_by IN NUMBER DEFAULT NULL,
75     x_last_update_date IN DATE DEFAULT NULL,
76     x_last_updated_by IN NUMBER DEFAULT NULL,
77     x_last_update_login IN NUMBER DEFAULT NULL
78   ) ;
79 
80 END IGS_AD_ADM_UNIT_STAT_PKG;