PACKAGE: APPS.IGS_GR_CRMN_NOTE_PKG

Source

1 package IGS_GR_CRMN_NOTE_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSGI09S.pls 115.5 2002/11/29 00:36:00 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_GRD_CAL_TYPE in VARCHAR2,
6   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
7   X_CEREMONY_NUMBER in NUMBER,
8   X_REFERENCE_NUMBER in NUMBER,
9   X_GRD_NOTE_TYPE in VARCHAR2,
10   X_MODE in VARCHAR2 default 'R' ,
11   X_ORG_ID  in NUMBER
12   );
13 procedure LOCK_ROW (
14   X_ROWID in VARCHAR2,
15   X_GRD_CAL_TYPE in VARCHAR2,
16   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
17   X_CEREMONY_NUMBER in NUMBER,
18   X_REFERENCE_NUMBER in NUMBER,
19   X_GRD_NOTE_TYPE in VARCHAR2
20 
21 );
22 procedure UPDATE_ROW (
23   X_ROWID in VARCHAR2,
24   X_GRD_CAL_TYPE in VARCHAR2,
25   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
26   X_CEREMONY_NUMBER in NUMBER,
27   X_REFERENCE_NUMBER in NUMBER,
28   X_GRD_NOTE_TYPE in VARCHAR2,
29   X_MODE in VARCHAR2 default 'R'
30 
31   );
32 procedure ADD_ROW (
33   X_ROWID in out NOCOPY VARCHAR2,
34   X_GRD_CAL_TYPE in VARCHAR2,
35   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
36   X_CEREMONY_NUMBER in NUMBER,
37   X_REFERENCE_NUMBER in NUMBER,
38   X_GRD_NOTE_TYPE in VARCHAR2,
39   X_MODE in VARCHAR2 default 'R',
40   X_ORG_ID  in NUMBER
41   );
42 procedure DELETE_ROW (
43   X_ROWID in VARCHAR2
44 );
45 
46   FUNCTION Get_PK_For_Validation (
47     x_grd_cal_type IN VARCHAR2,
48     x_grd_ci_sequence_number IN NUMBER,
49     x_ceremony_number IN NUMBER,
50     x_reference_number IN NUMBER
51     ) RETURN BOOLEAN;
52 
53   PROCEDURE GET_FK_IGS_GR_CRMN (
54     x_grd_cal_type IN VARCHAR2,
55     x_grd_ci_sequence_number IN NUMBER,
56     x_ceremony_number IN NUMBER
57     );
58 
59   PROCEDURE GET_FK_IGS_GR_NOTE_TYPE (
60     x_grd_note_type IN VARCHAR2
61     );
62 
63   PROCEDURE GET_FK_IGS_GE_NOTE (
64     x_reference_number IN NUMBER
65     );
66 
67 PROCEDURE Check_Constraints(
68 	Column_Name IN VARCHAR2 DEFAULT NULL,
69 	Column_Value IN VARCHAR2 DEFAULT NULL
70 	);
71 
72   PROCEDURE Before_DML (
73     p_action IN VARCHAR2,
74     x_rowid IN VARCHAR2 DEFAULT NULL,
75     x_grd_ci_sequence_number IN NUMBER DEFAULT NULL,
76     x_ceremony_number IN NUMBER DEFAULT NULL,
77     x_reference_number IN NUMBER DEFAULT NULL,
78     x_grd_note_type IN VARCHAR2 DEFAULT NULL,
79     x_grd_cal_type IN VARCHAR2 DEFAULT NULL,
80     x_creation_date IN DATE DEFAULT NULL,
81     x_created_by IN NUMBER DEFAULT NULL,
82     x_last_update_date IN DATE DEFAULT NULL,
83     x_last_updated_by IN NUMBER DEFAULT NULL,
84     x_last_update_login IN NUMBER DEFAULT NULL,
85     X_ORG_ID  in NUMBER DEFAULT NULL
86   );
87 
88 end IGS_GR_CRMN_NOTE_PKG;