1 PACKAGE cz_api_pub AUTHID CURRENT_USER AS
2 /* $Header: czapis.pls 120.0 2005/05/25 05:29:48 appldev noship $ */
3
4 --- publication mode
5 G_PRODUCTION_PUB_MODE CONSTANT VARCHAR2(1) := 'P';
6 G_TEST_PUB_MODE CONSTANT VARCHAR2(1) := 'T';
7
8 --- publication usage
9 G_ANY_USAGE_NAME CONSTANT VARCHAR2(20) := 'Any Usage';
10
11
12 --- config tree copy mode
13 --- Creates a new config header and copies all config items
14 --- (save_config_behavior = "new_config")
15 --- Used in re-order case
16 G_NEW_HEADER_COPY_MODE CONSTANT VARCHAR2(1) := 'H';
17
18
19 -- Creates a new revision and copies all config items
20 -- (save_config_behavior = "new_revision")
21 -- Used for reconfiguring or repricing process
22 G_NEW_REVISION_COPY_MODE CONSTANT VARCHAR2(1) := 'R';
23
24
25 -- validation context
26 -- Always checks pending IB instances first, looks at the installed only if not found
27 -- in pending look up.
28 G_PENDING_OR_INSTALLED CONSTANT VARCHAR2(1) := 'P';
29
30 -- Only uses installed IB instances
31 G_INSTALLED CONSTANT VARCHAR2(1) := 'I';
32
33 ---- validation types for CZ_CF_API.VALIDATE
34 VALIDATE_ORDER CONSTANT VARCHAR2(1) := 'O';
35 VALIDATE_FULFILLMENT CONSTANT VARCHAR2(1) := 'F';
36 VALIDATE_RETURN CONSTANT VARCHAR2(1) := 'R';
37 INTERACTIVE CONSTANT VARCHAR2(1) := 'I';
38
39 ------number tbl declaration
40 -----TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
41 TYPE number_tbl_type IS TABLE OF NUMBER;
42
43 ----varchar tbl declaration
44 TYPE varchar_tbl_type IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
45
46 -- publication applicability parameters
47 -- config_creation_date (optional)
48 -- config_model_lookup_date (optional)
49 -- config_effective_date (optional)
50 -- calling_application_id (required)
51 -- usage_name (optional): if usage_name is not supplied: the value of profile option 'CZ_PUBLICATION_USAGE'
52 -- will be used if it is set; G_ANY_USAGE_NAME will be used otherwise.
53 -- publication_mode (optional): if publication_mode is not provided: the value of profile option
54 -- 'CZ_PUBLICATION_MODE' will be used if it is set; G_PRODUCTION_PUB_MODE will be used otherwise.
55 -- language (optional): default value is session language
56
57 TYPE appl_param_rec_type IS RECORD
58 (
59 config_creation_date DATE,
60 config_model_lookup_date DATE,
61 config_effective_date DATE,
62 calling_application_id NUMBER,
63 usage_name VARCHAR2(255),
64 publication_mode VARCHAR2(1),
65 language VARCHAR2(4)
66 );
67
68 -- config header record
69 TYPE config_rec_type IS RECORD
70 (
71 config_hdr_id cz_config_hdrs.config_hdr_id%TYPE,
72 config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE
73 );
74 TYPE config_tbl_type IS TABLE OF config_rec_type INDEX BY BINARY_INTEGER;
75
76
77 -- used for outputing in generate_config_trees and add_to_config_tree procedures
78 TYPE config_model_rec_type IS RECORD
79 (
80 inventory_item_id NUMBER,
81 organization_id NUMBER,
82 config_hdr_id NUMBER,
83 config_rev_nbr NUMBER,
84 config_item_id NUMBER
85 );
86 TYPE config_model_tbl_type IS TABLE OF config_model_rec_type INDEX BY BINARY_INTEGER;
87
88 -------------------------------------------------------------------------
89 END cz_api_pub ;