PACKAGE: APPS.IGS_FI_FD_SRC_RSTN_H_PKG

Source

1 package IGS_FI_FD_SRC_RSTN_H_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSSI41S.pls 115.5 2002/11/29 03:47:21 nsidana ship $*/
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_COURSE_CD in VARCHAR2,
6   X_HIST_START_DT in DATE,
7   X_VERSION_NUMBER in NUMBER,
8   X_FUNDING_SOURCE in VARCHAR2,
9   X_HIST_END_DT in DATE,
10   X_HIST_WHO in NUMBER,
11   X_DFLT_IND in VARCHAR2,
12   X_RESTRICTED_IND in VARCHAR2,
13   X_ORG_ID in NUMBER,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 procedure LOCK_ROW (
17   X_ROWID in VARCHAR2,
18   X_COURSE_CD in VARCHAR2,
19   X_HIST_START_DT in DATE,
20   X_VERSION_NUMBER in NUMBER,
21   X_FUNDING_SOURCE in VARCHAR2,
22   X_HIST_END_DT in DATE,
23   X_HIST_WHO in NUMBER,
24   X_DFLT_IND in VARCHAR2,
25   X_RESTRICTED_IND in VARCHAR2
26 );
27 procedure UPDATE_ROW (
28   X_ROWID in VARCHAR2,
29   X_COURSE_CD in VARCHAR2,
30   X_HIST_START_DT in DATE,
31   X_VERSION_NUMBER in NUMBER,
32   X_FUNDING_SOURCE in VARCHAR2,
33   X_HIST_END_DT in DATE,
34   X_HIST_WHO in NUMBER,
35   X_DFLT_IND in VARCHAR2,
36   X_RESTRICTED_IND in VARCHAR2,
37   X_MODE in VARCHAR2 default 'R'
38   );
39 procedure ADD_ROW (
40   X_ROWID in out NOCOPY VARCHAR2,
41   X_COURSE_CD in VARCHAR2,
42   X_HIST_START_DT in DATE,
43   X_VERSION_NUMBER in NUMBER,
44   X_FUNDING_SOURCE in VARCHAR2,
45   X_HIST_END_DT in DATE,
46   X_HIST_WHO in NUMBER,
47   X_DFLT_IND in VARCHAR2,
48   X_RESTRICTED_IND in VARCHAR2,
49   X_ORG_ID in NUMBER,
50   X_MODE in VARCHAR2 default 'R'
51   );
52 procedure DELETE_ROW (
53   X_ROWID in VARCHAR2
54 );
55   FUNCTION Get_PK_For_Validation (
56     x_course_cd IN VARCHAR2,
57     x_version_number IN NUMBER,
58     x_funding_source IN VARCHAR2,
59     x_hist_start_dt IN DATE
60     ) RETURN BOOLEAN;
61   PROCEDURE GET_FK_IGS_PS_VER (
62     x_course_cd IN VARCHAR2,
63     x_version_number IN NUMBER
64     );
65   PROCEDURE GET_FK_IGS_FI_FUND_SRC (
66     x_funding_source IN VARCHAR2
67     );
68  PROCEDURE Check_Constraints (
69 	 Column_Name	IN	VARCHAR2	DEFAULT NULL,
70 	 Column_Value 	IN	VARCHAR2	DEFAULT NULL
71  );
72   PROCEDURE Before_DML (
73     p_action IN VARCHAR2,
74     x_rowid IN  VARCHAR2 DEFAULT NULL,
75     x_course_cd IN VARCHAR2 DEFAULT NULL,
76     x_version_number IN NUMBER DEFAULT NULL,
77     x_funding_source IN VARCHAR2 DEFAULT NULL,
78     x_hist_start_dt IN DATE DEFAULT NULL,
79     x_hist_end_dt IN DATE DEFAULT NULL,
80     x_hist_who IN VARCHAR2 DEFAULT NULL,
81     x_dflt_ind IN VARCHAR2 DEFAULT NULL,
82     x_restricted_ind IN VARCHAR2 DEFAULT NULL,
83     x_org_id IN NUMBER DEFAULT NULL,
84     x_creation_date IN DATE DEFAULT NULL,
85     x_created_by IN NUMBER DEFAULT NULL,
86     x_last_update_date IN DATE DEFAULT NULL,
87     x_last_updated_by IN NUMBER DEFAULT NULL,
88     x_last_update_login IN NUMBER DEFAULT NULL
89   );
90 end IGS_FI_FD_SRC_RSTN_H_PKG;