DBA Data[Home] [Help]

PACKAGE: APPS.IGS_SS_TST_RSLT_DTLS_PKG

Source


1 PACKAGE IGS_SS_TST_RSLT_DTLS_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSSS07S.pls 115.4 2002/11/29 04:08:53 nsidana noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_TST_RSLT_DTLS_ID IN OUT NOCOPY NUMBER,
6        x_TEST_RESULTS_ID IN NUMBER,
7        x_TEST_SEGMENT_ID IN NUMBER,
8        x_TEST_SCORE IN NUMBER,
9        X_MODE in VARCHAR2 default 'I'
10   );
11 
12  procedure LOCK_ROW (
13       X_ROWID in  VARCHAR2,
14        x_TST_RSLT_DTLS_ID IN NUMBER,
15        x_TEST_RESULTS_ID IN NUMBER,
16        x_TEST_SEGMENT_ID IN NUMBER,
17        x_TEST_SCORE IN NUMBER
18  );
19  procedure UPDATE_ROW (
20       X_ROWID in  VARCHAR2,
21        x_TST_RSLT_DTLS_ID IN NUMBER,
22        x_TEST_RESULTS_ID IN NUMBER,
23        x_TEST_SEGMENT_ID IN NUMBER,
24        x_TEST_SCORE IN NUMBER,
25        X_MODE in VARCHAR2 default 'I'
26   );
27 
28  procedure ADD_ROW (
29        x_ROWID          IN OUT NOCOPY VARCHAR2,
30        x_TST_RSLT_DTLS_ID IN OUT NOCOPY NUMBER,
31        x_TEST_RESULTS_ID IN NUMBER,
32        x_TEST_SEGMENT_ID IN NUMBER,
33        x_TEST_SCORE IN NUMBER,
34        X_MODE in VARCHAR2 default 'I',
35        x_return_status		OUT NOCOPY     VARCHAR2,
36        x_msg_count			OUT NOCOPY     NUMBER,
37        x_msg_data			OUT NOCOPY     VARCHAR2
38   ) ;
39 
40 
41   FUNCTION Get_PK_For_Validation (
42     x_tst_rslt_dtls_id IN NUMBER
43     ) RETURN BOOLEAN ;
44 
45   FUNCTION Get_UK_For_Validation (
46     x_test_results_id IN NUMBER,
47     x_test_segment_id IN NUMBER
48     ) RETURN BOOLEAN;
49 
50   PROCEDURE Get_FK_Igs_Ad_Test_Results (
51     x_test_results_id IN NUMBER
52     );
53 
54   PROCEDURE Get_FK_Igs_Ad_Test_Segments (
55     x_test_segment_id IN NUMBER
56     );
57 
58   PROCEDURE Check_Constraints (
59 		 Column_Name IN VARCHAR2  DEFAULT NULL,
60 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
61   PROCEDURE Before_DML (
62     p_action IN VARCHAR2,
63     x_rowid IN VARCHAR2 DEFAULT NULL,
64     x_tst_rslt_dtls_id IN NUMBER DEFAULT NULL,
65     x_test_results_id IN NUMBER DEFAULT NULL,
66     x_test_segment_id IN NUMBER DEFAULT NULL,
67     x_test_score IN NUMBER DEFAULT NULL,
68     x_creation_date IN DATE DEFAULT NULL,
69     x_created_by IN NUMBER DEFAULT NULL,
70     x_last_update_date IN DATE DEFAULT NULL,
71     x_last_updated_by IN NUMBER DEFAULT NULL,
72     x_last_update_login IN NUMBER DEFAULT NULL
73  );
74 END IGS_SS_TST_RSLT_DTLS_PKG;