1 PACKAGE CN_SCA_RULES_BATCH_GEN_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvscabs.pls 120.4 2011/08/11 08:17:00 srguntur ship $
3 -- +======================================================================+
4 -- | Copyright (c) 1994 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 --
9 -- Package Name
10 -- CN_SCA_RULES_BATCH_GEN_PVT
11 -- Purpose
12 -- This package is a public API for processing Credit Rules and associated
13 -- allocation percentages.
14 -- History
15 -- 06/26/03 Rao.Chenna Created
16 --
17 --
18 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_SCA_RULES_BATCH_GEN_PVT';
19 --
20 TYPE attr_prime_rec_type IS RECORD(
21 attribute_name VARCHAR2(12),
22 prime_number NUMBER);
23 TYPE attr_prime_tbl_type IS TABLE OF attr_prime_rec_type
24 INDEX BY BINARY_INTEGER;
25 --
26 TYPE attr_operator_rec_type IS RECORD(
27 sca_rule_attribute_id NUMBER,
28 -- codeCheck: I need to check the length
29 operator_id VARCHAR2(30));
30 TYPE attr_operator_tbl_type IS TABLE OF attr_operator_rec_type
31 INDEX BY BINARY_INTEGER;
32 --
33 PROCEDURE gen_sca_rules_batch_dyn(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36 p_commit IN VARCHAR2 := FND_API.G_FALSE,
37 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
38 p_org_id IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE);
43 --
44 PROCEDURE populate_matches (
45 spec_code IN OUT NOCOPY cn_utils.code_type,
46 body_code IN OUT NOCOPY cn_utils.code_type ,
47 x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE);
48 --
49 FUNCTION create_sca_rules_batch_dyn (
50 x_transaction_source IN cn_sca_rule_attributes.transaction_source%TYPE)
51 RETURN BOOLEAN ;
52 --
53 END cn_sca_rules_batch_gen_pvt;