PACKAGE: APPS.PON_AUC_INTERFACE_TABLE_PKG

Source

1 PACKAGE pon_auc_interface_table_pkg AUTHID CURRENT_USER as
2 /* $Header: PONAITS.pls 120.0.12020000.2 2013/02/09 11:27:02 hvutukur ship $ */
3 
4 TYPE ATTRIBUTES_VALUES_VALIDATION
5 IS RECORD
6   (
7     l_BATCH_ID PON_AUC_ATTRIBUTES_INTERFACE.BATCH_ID%TYPE,
8     l_INTERFACE_LINE_ID PON_AUC_ATTRIBUTES_INTERFACE.INTERFACE_LINE_ID%TYPE,
9     l_AUCTION_HEADER_ID PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_HEADER_ID%TYPE,
10     l_AUCTION_LINE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.AUCTION_LINE_NUMBER%TYPE,
11     l_SEQUENCE_NUMBER PON_AUC_ATTRIBUTES_INTERFACE.SEQUENCE_NUMBER%TYPE,
12     l_ATTRIBUTE_NAME PON_AUC_ATTRIBUTES_INTERFACE.ATTRIBUTE_NAME%TYPE,
13     l_DATATYPE PON_AUC_ATTRIBUTES_INTERFACE.DATATYPE%TYPE,
14     l_RESPONSE_TYPE PON_AUC_ATTRIBUTES_INTERFACE.RESPONSE_TYPE%TYPE,
15     l_RESPONSE_TYPE_NAME PON_AUC_ATTRIBUTES_INTERFACE.RESPONSE_TYPE_NAME%TYPE,
16     l_MANDATORY_FLAG PON_AUC_ATTRIBUTES_INTERFACE.MANDATORY_FLAG%TYPE,
17     l_DISPLAY_ONLY_FLAG PON_AUC_ATTRIBUTES_INTERFACE.DISPLAY_ONLY_FLAG%TYPE,
18     l_DISPLAY_TARGET_FLAG PON_AUC_ATTRIBUTES_INTERFACE.DISPLAY_TARGET_FLAG%TYPE,
19     l_VALUE PON_AUC_ATTRIBUTES_INTERFACE.VALUE%TYPE,
20     l_GROUP_CODE PON_AUC_ATTRIBUTES_INTERFACE.GROUP_CODE%TYPE,
21     l_GROUP_NAME PON_AUC_ATTRIBUTES_INTERFACE.GROUP_NAME%TYPE,
22     l_SCORING_TYPE PON_AUC_ATTRIBUTES_INTERFACE.SCORING_TYPE%TYPE,
23     l_ATTR_MAX_SCORE PON_AUC_ATTRIBUTES_INTERFACE.ATTR_MAX_SCORE%TYPE,
24     l_WEIGHT PON_AUC_ATTRIBUTES_INTERFACE.WEIGHT%TYPE,
25     l_INTERNAL_ATTR_FLAG PON_AUC_ATTRIBUTES_INTERFACE.INTERNAL_ATTR_FLAG%TYPE,
26     l_SCORING_METHOD PON_AUC_ATTRIBUTES_INTERFACE.SCORING_METHOD%TYPE,
27     l_KNOCKOUT_SCORE PON_AUC_ATTRIBUTES_INTERFACE.KNOCKOUT_SCORE%TYPE,
28     l_ACTION PON_AUC_ATTRIBUTES_INTERFACE.ACTION%TYPE );
29 
30 PROCEDURE validate_price_elements(
31   p_source VARCHAR2,
32   p_batch_id NUMBER,
33   p_fnd_currency_precision NUMBER,
34   p_num_price_decimals NUMBER
35 );
36 
37 PROCEDURE validate_header_attributes(
38   p_source VARCHAR2,
39   p_batch_id NUMBER,
40   p_party_id NUMBER
41 );
42 
43 PROCEDURE validate_attributes(
44   p_source VARCHAR2,
45   p_batch_id NUMBER,
46   p_party_id NUMBER,
47   p_attr_type_header BOOLEAN
48 );
49 
50 PROCEDURE validate_attributes(
51   p_source VARCHAR2,
52   p_batch_id NUMBER,
53   p_party_id NUMBER
54 );
55 
56 PROCEDURE add_template_price_elements(
57   p_batch_id NUMBER,
58   p_auction_template_id NUMBER,
59   p_auction_header_id   NUMBER
60 );
61 
62 PROCEDURE add_template_attributes(
63   p_batch_id NUMBER,
64   p_auction_template_id NUMBER
65 );
66 
67 PROCEDURE validate_price_differentials(
68    p_source VARCHAR2,
69    p_batch_id NUMBER
70 );
71 
72 PROCEDURE add_ip_descriptors(p_batch_id            IN NUMBER,
73                              p_auction_header_id   IN NUMBER);
74 
75 PROCEDURE validate_header_attributes_api(
76   p_source VARCHAR2,
77   p_batch_id NUMBER,
78   p_party_id NUMBER
79 );
80 
81 PROCEDURE validate_attributes_api(
82   p_source VARCHAR2,
83   p_batch_id NUMBER,
84   p_party_id NUMBER,
85   p_attr_type_header BOOLEAN
86 );
87 
88 PROCEDURE validate_requirement
89   (
90     p_source   VARCHAR2,
91     p_batch_id NUMBER,
92     p_party_id NUMBER,
93     p_in_rec IN ATTRIBUTES_VALUES_VALIDATION,
94     --p_in_rec.l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE,
95     x_return_status OUT NOCOPY VARCHAR );
96 
97 PROCEDURE insert_error_interface
98   (
99     l_BATCH_ID           IN PON_INTERFACE_ERRORS.BATCH_ID%TYPE,
100     l_INTERFACE_LINE_ID  IN PON_INTERFACE_ERRORS.INTERFACE_LINE_ID%TYPE,
101     l_TABLE_NAME         IN PON_INTERFACE_ERRORS.TABLE_NAME%TYPE,
102     l_COLUMN_NAME        IN PON_INTERFACE_ERRORS.COLUMN_NAME%TYPE,
103     l_ERROR_MESSAGE_NAME IN PON_INTERFACE_ERRORS.ERROR_MESSAGE_NAME%TYPE,
104     l_ERROR_VALUE        IN PON_INTERFACE_ERRORS.ERROR_VALUE%TYPE);
105 
106 
107 END pon_auc_interface_table_pkg;