PACKAGE: APPS.IGS_AD_TERM_DETAILS_PKG

Source

1 PACKAGE igs_ad_term_details_pkg AS
2 /* $Header: IGSAI83S.pls 120.0 2005/06/01 22:09:22 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_TERM_DETAILS_ID IN OUT NOCOPY NUMBER,
6        x_TRANSCRIPT_ID IN NUMBER,
7        x_TERM IN VARCHAR2,
8        x_START_DATE IN DATE,
9        x_END_DATE IN DATE,
10        x_TOTAL_CP_ATTEMPTED IN NUMBER,
11        x_TOTAL_CP_EARNED IN NUMBER,
12        x_TOTAL_UNIT_GP IN NUMBER,
13        x_TOTAL_GPA_UNITS IN NUMBER,
14        x_GPA IN VARCHAR2,
15       X_MODE in VARCHAR2 default 'R'
16   );
17 
18  procedure LOCK_ROW (
19       X_ROWID in  VARCHAR2,
20        x_TERM_DETAILS_ID IN NUMBER,
21        x_TRANSCRIPT_ID IN NUMBER,
22        x_TERM IN VARCHAR2,
23        x_START_DATE IN DATE,
24        x_END_DATE IN DATE,
25        x_TOTAL_CP_ATTEMPTED IN NUMBER,
26        x_TOTAL_CP_EARNED IN NUMBER,
27        x_TOTAL_UNIT_GP IN NUMBER,
28        x_TOTAL_GPA_UNITS IN NUMBER,
29        x_GPA IN VARCHAR2  );
30  procedure UPDATE_ROW (
31       X_ROWID in  VARCHAR2,
32        x_TERM_DETAILS_ID IN NUMBER,
33        x_TRANSCRIPT_ID IN NUMBER,
34        x_TERM IN VARCHAR2,
35        x_START_DATE IN DATE,
36        x_END_DATE IN DATE,
37        x_TOTAL_CP_ATTEMPTED IN NUMBER,
38        x_TOTAL_CP_EARNED IN NUMBER,
39        x_TOTAL_UNIT_GP IN NUMBER,
40        x_TOTAL_GPA_UNITS IN NUMBER,
41        x_GPA IN VARCHAR2,
42       X_MODE in VARCHAR2 default 'R'
43   );
44 
45  procedure ADD_ROW (
46       X_ROWID in out NOCOPY VARCHAR2,
47        x_TERM_DETAILS_ID IN OUT NOCOPY NUMBER,
48        x_TRANSCRIPT_ID IN NUMBER,
49        x_TERM IN VARCHAR2,
50        x_START_DATE IN DATE,
51        x_END_DATE IN DATE,
52        x_TOTAL_CP_ATTEMPTED IN NUMBER,
53        x_TOTAL_CP_EARNED IN NUMBER,
54        x_TOTAL_UNIT_GP IN NUMBER,
55        x_TOTAL_GPA_UNITS IN NUMBER,
56        x_GPA IN VARCHAR2,
57       X_MODE in VARCHAR2 default 'R'
58   ) ;
59 
60 procedure DELETE_ROW (
61   X_ROWID in VARCHAR2,
62   x_mode IN VARCHAR2 DEFAULT 'R'
63 ) ;
64 
65   FUNCTION Get_PK_For_Validation (
66     x_term_details_id IN NUMBER
67     ) RETURN BOOLEAN ;
68 
69 
70   PROCEDURE Get_FK_Igs_Ad_Transcript (
71     x_transcript_id IN NUMBER
72     );
73 
74   PROCEDURE Check_Constraints (
75 		 Column_Name IN VARCHAR2  DEFAULT NULL,
76 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
77   PROCEDURE Before_DML (
78     p_action IN VARCHAR2,
79     x_rowid IN VARCHAR2 DEFAULT NULL,
80     x_term_details_id IN NUMBER DEFAULT NULL,
81     x_transcript_id IN NUMBER DEFAULT NULL,
82     x_term IN VARCHAR2 DEFAULT NULL,
83     x_start_date IN DATE DEFAULT NULL,
84     x_end_date IN DATE DEFAULT NULL,
85     x_total_cp_attempted IN NUMBER DEFAULT NULL,
86     x_total_cp_earned IN NUMBER DEFAULT NULL,
87     x_total_unit_gp IN NUMBER DEFAULT NULL,
88     x_total_gpa_units IN NUMBER DEFAULT NULL,
89     x_gpa IN VARCHAR2 DEFAULT NULL,
90     x_creation_date IN DATE DEFAULT NULL,
91     x_created_by IN NUMBER DEFAULT NULL,
92     x_last_update_date IN DATE DEFAULT NULL,
93     x_last_updated_by IN NUMBER DEFAULT NULL,
94     x_last_update_login IN NUMBER DEFAULT NULL
95  );
96 END igs_ad_term_details_pkg;