[Home] [Help]
PACKAGE: APPS.QP_LIMIT_BALANCE_CHECK_PVT
Source
1 PACKAGE QP_LIMIT_BALANCE_CHECK_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVLCKS.pls 120.0.12010000.1 2008/07/28 11:58:51 appldev ship $ */
3
4 --GLOBAL Constant holding the package name
5
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_LIMIT_BALANCE_CHECK_PVT';
7
8 --Max no.of times to recheck balance in one call of Process Limits
9 G_MAX_LOOP_COUNT CONSTANT NUMBER := 50;
10
11 --No of times balance has been rechecked in one call of Process Limits
12 G_LOOP_COUNT NUMBER;
13
14 TYPE Limit_Balance_Line_Rec IS RECORD
15 ( limit_id NUMBER,
16 limit_balance_id NUMBER,
17 line_index NUMBER,
18 list_header_id NUMBER,
19 list_line_id NUMBER,
20 basis VARCHAR2(30),
21 wanted_amount NUMBER,
22 available_amount NUMBER,
23 available_percent NUMBER,
24 given_amount NUMBER,
25 least_percent NUMBER,
26 limit_hold_flag VARCHAR2(1),
27 limit_code VARCHAR2(30),
28 hold_code VARCHAR2(30),
29 adjustment_amount NUMBER,
30 operand_value NUMBER,
31 benefit_qty NUMBER,
32 created_from_list_line_type VARCHAR2(30),
33 pricing_group_sequence NUMBER,
34 operand_calculation_code VARCHAR2(30),
35 bal_price_request_code VARCHAR2(240),
36 price_request_code VARCHAR2(240),
37 request_type_code VARCHAR2(30),
38 line_category VARCHAR2(30),
39 pricing_phase_id NUMBER,
40 transaction_amount NUMBER,
41 full_available_amount NUMBER,
42 line_detail_index NUMBER,
43 limit_level VARCHAR2(1),
44 limit_amount NUMBER,
45 limit_level_code VARCHAR2(30),
46 process_action VARCHAR2(1), --'I' for insert, 'U' for Update
47 hard_limit_exceeded BOOLEAN,
48 each_attr_exists VARCHAR2(1),
49 limit_exceed_action_code VARCHAR2(30),
50 multival_attr1_context VARCHAR2(30),
51 multival_attribute1 VARCHAR2(30),
52 multival_attr1_value VARCHAR2(240),
53 multival_attr1_type VARCHAR2(30),
54 multival_attr1_datatype VARCHAR2(10),
55 multival_attr2_context VARCHAR2(30),
56 multival_attribute2 VARCHAR2(30),
57 multival_attr2_value VARCHAR2(240),
58 multival_attr2_type VARCHAR2(30),
59 multival_attr2_datatype VARCHAR2(10),
60 organization_attr_context VARCHAR2(30),
61 organization_attribute VARCHAR2(30),
62 organization_attr_value VARCHAR2(240)
63 );
64
65 TYPE Limit_Balance_Line_Tbl IS TABLE OF Limit_Balance_Line_Rec
66 INDEX BY BINARY_INTEGER;
67
68 --Global plsql table type of variable
69 g_limit_balance_line Limit_Balance_Line_Tbl;
70
71 --Global Constants
72 g_insert CONSTANT VARCHAR2(1) := 'I';
73 g_update CONSTANT VARCHAR2(1) := 'U';
74
75 --This Record Type should always be in sync with the limits_cur%rowtype
76 TYPE Limit_Rec IS RECORD
77 (line_index NUMBER,
78 created_from_list_header_id NUMBER,
79 created_from_list_line_id NUMBER,
80 limit_level VARCHAR2(1),
81 limit_id NUMBER,
82 amount NUMBER ,
83 limit_exceed_action_code VARCHAR2(30),
84 basis VARCHAR2(30),
85 limit_hold_flag VARCHAR2(1),
86 limit_level_code VARCHAR2(30),
87 adjustment_amount NUMBER,
88 benefit_qty NUMBER,
89 created_from_list_line_type VARCHAR2(30),
90 pricing_group_sequence NUMBER,
91 operand_calculation_code VARCHAR2(30),
92 price_request_code VARCHAR2(240),
93 request_type_code VARCHAR2(30),
94 line_category VARCHAR2(30),
95 operand_value NUMBER,
96 unit_price NUMBER,
97 each_attr_exists VARCHAR2(1),
98 pricing_phase_id NUMBER,
99 non_each_attr_count NUMBER,
100 total_attr_count NUMBER,
101 line_detail_index NUMBER,
102 organization_attr_context VARCHAR2(30),
103 organization_attribute VARCHAR2(30),
104 multival_attr1_context VARCHAR2(30),
105 multival_attribute1 VARCHAR2(30),
106 multival_attr1_type VARCHAR2(30),
107 multival_attr1_datatype VARCHAR2(10),
108 multival_attr2_context VARCHAR2(30),
109 multival_attribute2 VARCHAR2(30),
110 multival_attr2_type VARCHAR2(30),
111 multival_attr2_datatype VARCHAR2(10),
112 gross_revenue_wanted NUMBER,
113 cost_wanted NUMBER,
114 accrual_wanted NUMBER,
115 quantity_wanted NUMBER
116 );
117
118 /*Procedure to Process Limits */
119 PROCEDURE Process_Limits(x_return_status OUT NOCOPY VARCHAR2,
120 x_return_text OUT NOCOPY VARCHAR2);
121
122 END QP_LIMIT_BALANCE_CHECK_PVT;