DBA Data[Home] [Help]

PACKAGE: APPS.IGS_FI_FUND_SRC_HIST_PKG

Source


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