PACKAGE: APPS.GMD_QM_CONC_REPLACE_PKG

Source

1 PACKAGE  GMD_QM_CONC_REPLACE_PKG AS
2 /* $Header: GMDQRPLS.pls 120.1.12010000.1 2008/07/24 09:58:41 appldev ship $ */
3 
4    p_last_update_date    DATE   := SYSDATE;
5    p_last_updated_by     NUMBER := fnd_profile.VALUE ('USER_ID');
6    p_last_update_login   NUMBER := fnd_profile.VALUE ('LOGIN_ID');
7 
8    TYPE search_result_rec IS RECORD (
9       object_id            NUMBER
10     , object_name          VARCHAR2 (240)
11     , object_vers          NUMBER
12     , object_desc          VARCHAR2 (240)
13     , object_status_desc   VARCHAR2 (240)
14     , object_select_ind    NUMBER
15     , object_status_code   VARCHAR2 (240)
16    );
17 
18    TYPE test_values IS RECORD (
19       optional_ind        gmd_spec_tests_b.optional_ind%TYPE
20     , print_spec_ind      gmd_spec_tests_b.print_spec_ind%TYPE
21     , print_result_ind    gmd_spec_tests_b.print_result_ind%TYPE
22     , target_value_num    gmd_spec_tests_b.target_value_num%TYPE
23     , target_value_char   gmd_spec_tests_b.target_value_char%TYPE
24     , min_value_num       gmd_spec_tests_b.min_value_num%TYPE
25     , min_value_char      gmd_spec_tests_b.min_value_char%TYPE
26     , max_value_num       gmd_spec_tests_b.max_value_num%TYPE
27     , max_value_char      gmd_spec_tests_b.max_value_char%TYPE
28     , report_precision    gmd_spec_tests_b.report_precision%TYPE
29     , store_precision     gmd_spec_tests_b.display_precision%TYPE
30     , test_priority       gmd_spec_tests_b.test_priority%TYPE
31    );
32 
33    TYPE search_result_tbl IS TABLE OF search_result_rec INDEX BY BINARY_INTEGER;
34 
35    PROCEDURE populate_search_table (x_search_tbl OUT NOCOPY search_result_tbl);
36 
37    PROCEDURE mass_replace_oper_spec_val (
38       err_buf             OUT NOCOPY      VARCHAR2
39     , ret_code            OUT NOCOPY      VARCHAR2
40     , pconcurrent_id      IN              VARCHAR2 DEFAULT NULL
41     , pobject_type        IN              VARCHAR2
42     , preplace_type       IN              VARCHAR2
43     , pold_name           IN              VARCHAR2
44     , pnew_name           IN              VARCHAR2
45     , poptional_ind       IN              VARCHAR2 DEFAULT NULL
46     , pprint_spec_ind     IN              VARCHAR2 DEFAULT NULL
47     , pprint_result_ind   IN              VARCHAR2 DEFAULT NULL
48     , ptarget_value       IN              VARCHAR2 DEFAULT NULL
49     , ptarget_min         IN              VARCHAR2 DEFAULT NULL
50     , ptarget_max         IN              VARCHAR2 DEFAULT NULL
51     , preport_precision   IN              VARCHAR2 DEFAULT NULL
52     , pstore_precision    IN              VARCHAR2 DEFAULT NULL
53     , ptest_priority      IN              VARCHAR2 DEFAULT NULL
54     , pcreate_vers        IN              VARCHAR2 DEFAULT 'N'
55    );
56 
57 END GMD_QM_CONC_REPLACE_PKG;