PACKAGE: APPS.IGS_PE_TEACH_PERIODS_PKG

Source

1 PACKAGE igs_pe_teach_periods_pkg AS
2 /* $Header: IGSNI49S.pls 120.0 2005/06/01 13:24:59 appldev noship $ */
3  procedure INSERT_ROW (
4        X_ROWID in out NOCOPY VARCHAR2,
5        x_TEACHING_PERIOD_ID IN OUT NOCOPY NUMBER,
6        x_PERSON_ID IN NUMBER,
7        x_TEACH_PERIOD_RESID_STAT_CD IN VARCHAR2,
8        x_CAL_TYPE IN VARCHAR2,
9        x_SEQUENCE_NUMBER IN NUMBER,
10        X_MODE in VARCHAR2 default 'R',
11        X_ORG_ID in NUMBER
12   );
13 
14  procedure LOCK_ROW (
15       X_ROWID in  VARCHAR2,
16        x_TEACHING_PERIOD_ID IN NUMBER,
17        x_PERSON_ID IN NUMBER,
18        x_TEACH_PERIOD_RESID_STAT_CD IN VARCHAR2,
19        x_CAL_TYPE IN VARCHAR2,
20        x_SEQUENCE_NUMBER IN NUMBER
21      );
22  procedure UPDATE_ROW (
23        X_ROWID in  VARCHAR2,
24        x_TEACHING_PERIOD_ID IN NUMBER,
25        x_PERSON_ID IN NUMBER,
26        x_TEACH_PERIOD_RESID_STAT_CD IN VARCHAR2,
27        x_CAL_TYPE IN VARCHAR2,
28        x_SEQUENCE_NUMBER IN NUMBER,
29        X_MODE in VARCHAR2 default 'R'
30   );
31 
32  procedure ADD_ROW (
33        X_ROWID in out NOCOPY VARCHAR2,
34        x_TEACHING_PERIOD_ID IN OUT NOCOPY NUMBER,
35        x_PERSON_ID IN NUMBER,
36        x_TEACH_PERIOD_RESID_STAT_CD IN VARCHAR2,
37        x_CAL_TYPE IN VARCHAR2,
38        x_SEQUENCE_NUMBER IN NUMBER,
39        X_MODE in VARCHAR2 default 'R',
40        X_ORG_ID in NUMBER
41   ) ;
42 PROCEDURE DELETE_ROW (
43    X_ROWID in VARCHAR2,
44   x_mode IN VARCHAR2 DEFAULT 'R'
45  ) ;
46 FUNCTION Get_PK_For_Validation (
47        x_teaching_period_id IN NUMBER
48 ) RETURN BOOLEAN ;
49 
50 FUNCTION Get_UK_For_Validation (
51 	  x_cal_type IN VARCHAR2,
52 	  x_sequence_number IN NUMBER,
53           x_person_id IN NUMBER
54 ) RETURN BOOLEAN;
55 
56 PROCEDURE Get_FK_Igs_Pe_Person (
57        x_person_id IN NUMBER
58 );
59 
60 PROCEDURE Check_Constraints (
61       Column_Name IN VARCHAR2  DEFAULT NULL,
62       Column_Value IN VARCHAR2  DEFAULT NULL
63 ) ;
64 
65 PROCEDURE Before_DML (
66        p_action IN VARCHAR2,
67        x_rowid IN VARCHAR2 DEFAULT NULL,
68        x_teaching_period_id IN NUMBER DEFAULT NULL,
69        x_person_id IN NUMBER DEFAULT NULL,
70        x_teach_period_resid_stat_cd IN VARCHAR2 DEFAULT NULL,
71        x_cal_type IN VARCHAR2 DEFAULT NULL,
72        x_sequence_number IN NUMBER 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        X_ORG_ID in NUMBER DEFAULT NULL
79  );
80 
81 END igs_pe_teach_periods_pkg;