PACKAGE: APPS.IGS_AD_UP_DETAIL_PKG

Source

1 PACKAGE igs_ad_up_detail_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSAI93S.pls 115.6 2003/10/30 13:17:22 akadam ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UP_DETAIL_ID IN OUT NOCOPY NUMBER,
6        x_UP_HEADER_ID IN NUMBER,
7        x_UNIT_CD IN VARCHAR2,
8        x_VERSION_NUMBER IN NUMBER,
9        x_CLOSED_IND IN VARCHAR2,
10       X_MODE in VARCHAR2 default 'R'
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_UP_DETAIL_ID IN NUMBER,
16        x_UP_HEADER_ID IN NUMBER,
17        x_UNIT_CD IN VARCHAR2,
18        x_VERSION_NUMBER IN NUMBER,
19        x_CLOSED_IND IN VARCHAR2  );
20  procedure UPDATE_ROW (
21       X_ROWID in  VARCHAR2,
22        x_UP_DETAIL_ID IN NUMBER,
23        x_UP_HEADER_ID IN NUMBER,
24        x_UNIT_CD IN VARCHAR2,
25        x_VERSION_NUMBER IN NUMBER,
26        x_CLOSED_IND IN VARCHAR2,
27       X_MODE in VARCHAR2 default 'R'
28   );
29 
30  procedure ADD_ROW (
31       X_ROWID in out NOCOPY VARCHAR2,
32        x_UP_DETAIL_ID IN OUT NOCOPY NUMBER,
33        x_UP_HEADER_ID IN NUMBER,
34        x_UNIT_CD IN VARCHAR2,
35        x_VERSION_NUMBER IN NUMBER,
36        x_CLOSED_IND IN VARCHAR2,
37       X_MODE in VARCHAR2 default 'R'
38   ) ;
39 
40 procedure DELETE_ROW (
41   X_ROWID in VARCHAR2
42 ) ;
43 
44   FUNCTION Get_PK_For_Validation (
45     x_up_detail_id IN NUMBER,
46     x_closed_ind IN VARCHAR2 DEFAULT NULL
47     ) RETURN BOOLEAN ;
48 
49 
50   FUNCTION Get_UK_For_Validation (
51     x_up_header_id IN NUMBER,
52     x_unit_cd IN VARCHAR2,
53     x_version_number IN NUMBER,
54     x_closed_ind IN VARCHAR2 DEFAULT NULL
55     ) RETURN BOOLEAN ;
56 
57 
58   PROCEDURE Get_FK_Igs_Ad_Up_Header (
59     x_up_header_id IN NUMBER
60     );
61 
62   PROCEDURE Get_FK_Igs_Ps_Unit_Ver (
63     x_unit_cd IN VARCHAR2,
64     x_version_number IN NUMBER
65     );
66 
67   PROCEDURE Check_Constraints (
68 		 Column_Name IN VARCHAR2  DEFAULT NULL,
69 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
70   PROCEDURE Before_DML (
71     p_action IN VARCHAR2,
72     x_rowid IN VARCHAR2 DEFAULT NULL,
73     x_up_detail_id IN NUMBER DEFAULT NULL,
74     x_up_header_id IN NUMBER DEFAULT NULL,
75     x_unit_cd IN VARCHAR2 DEFAULT NULL,
76     x_version_number IN NUMBER DEFAULT NULL,
77     x_closed_ind IN VARCHAR2 DEFAULT NULL,
78     x_creation_date IN DATE DEFAULT NULL,
79     x_created_by IN NUMBER DEFAULT NULL,
80     x_last_update_date IN DATE DEFAULT NULL,
81     x_last_updated_by IN NUMBER DEFAULT NULL,
82     x_last_update_login IN NUMBER DEFAULT NULL
83  );
84 END igs_ad_up_detail_pkg;