[Home] [Help]
PACKAGE: APPS.OZF_NET_ACCRUAL_ENGINE_PVT
Source
1 PACKAGE ozf_net_accrual_engine_pvt AUTHID CURRENT_USER AS
2 /* $Header: ozfvnaes.pls 120.3.12020000.2 2013/02/14 12:32:13 nepanda ship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_NET_ACCRUAL_ENGINE_PVT';
4
5 TYPE order_line_rec_type IS RECORD
6 (
7 order_header_id NUMBER
8 ,order_line_id NUMBER
9 );
10
11 TYPE order_line_tbl_type IS TABLE OF order_line_rec_type INDEX BY BINARY_INTEGER;
12
13 TYPE order_rec IS RECORD
14 (
15 header_id NUMBER,
16 line_id NUMBER,
17 -- actual_shipment_date DATE,
18 -- fulfillment_date DATE,
19 invoice_to_org_id NUMBER,
20 ship_to_org_id NUMBER,
21 sold_to_org_id NUMBER,
22 inventory_item_id NUMBER,
23 shipped_quantity NUMBER,
24 fulfilled_quantity NUMBER,
25 invoiced_quantity NUMBER,
26 pricing_quantity NUMBER,
27 pricing_quantity_uom VARCHAR2(3),
28 unit_selling_price NUMBER,
29 org_id NUMBER,
30 conv_date DATE,
31 transactional_curr_code VARCHAR2(15),
32 shipping_quantity NUMBER, -- Catch Weight ER
33 shipping_quantity_uom VARCHAR2(10), -- Catch Weight ER
34 shipping_quantity2 NUMBER, -- Catch Weight ER
35 shipping_quantity_uom2 VARCHAR2(10), -- Catch Weight ER
36 fulfillment_base VARCHAR2(1) -- Catch Weight ER
37 );
38
39 TYPE t_order_line_tbl IS TABLE OF order_rec INDEX BY BINARY_INTEGER;
40
41 TYPE return_rec IS RECORD
42 (
43 header_id NUMBER,
44 line_id NUMBER,
45 -- actual_shipment_date DATE,
46 -- fulfillment_date DATE,
47 invoice_to_org_id NUMBER,
48 ship_to_org_id NUMBER,
49 sold_to_org_id NUMBER,
50 inventory_item_id NUMBER,
51 shipped_quantity NUMBER,
52 fulfilled_quantity NUMBER,
53 invoiced_quantity NUMBER,
54 pricing_quantity NUMBER,
55 pricing_quantity_uom VARCHAR2(3),
56 unit_selling_price NUMBER,
57 org_id NUMBER,
58 conv_date DATE,
59 transactional_curr_code VARCHAR2(15) );
60
61 TYPE t_return_line_tbl IS TABLE OF return_rec INDEX BY BINARY_INTEGER;
62
63 TYPE idsm_rec IS RECORD
64 (
65 header_id NUMBER,
66 line_id NUMBER,
67 actual_shipment_date DATE,
68 fulfillment_date DATE,
69 invoice_to_org_id NUMBER,
70 ship_to_org_id NUMBER,
71 sold_to_org_id NUMBER,
72 inventory_item_id NUMBER,
73 shipped_quantity NUMBER,
74 fulfilled_quantity NUMBER,
75 invoiced_quantity NUMBER,
76 pricing_quantity NUMBER,
77 pricing_quantity_uom VARCHAR2(3),
78 unit_selling_price NUMBER,
79 org_id NUMBER,
80 conv_date DATE,
81 transactional_curr_code VARCHAR2(15) );
82
83 TYPE t_idsm_line_tbl IS TABLE OF idsm_rec INDEX BY BINARY_INTEGER;
84
85 TYPE ar_trx_rec IS RECORD
86 (
87 extended_amount NUMBER,
88 inventory_item_id NUMBER,
89 quantity_credited NUMBER,
90 quantity_invoiced NUMBER,
91 uom_code VARCHAR2(3),
92 sold_to_customer_id NUMBER,
93 bill_to_site_use_id NUMBER,
94 ship_to_site_use_id NUMBER,
95 invoice_currency_code VARCHAR2(15),
96 customer_trx_id NUMBER,
97 complete_flag VARCHAR2(1),
98 conv_date DATE,
99 customer_trx_line_id NUMBER
100 );
101
102 TYPE t_ar_trx_line_tbl IS TABLE OF ar_trx_rec INDEX BY BINARY_INTEGER;
103 TYPE terr_countries_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
104
105
106 PROCEDURE retroactive_offer_adj(
107 p_api_version IN NUMBER
108 ,p_init_msg_list IN VARCHAR2
109 ,p_commit IN VARCHAR2
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 ,p_offer_id IN NUMBER
114 ,p_start_date IN DATE
115 ,p_end_date IN DATE
116 ,x_order_line_tbl OUT NOCOPY order_line_tbl_type);
117
118 PROCEDURE offer_adj_new_product(
119 p_api_version IN NUMBER
120 ,p_init_msg_list IN VARCHAR2
121 ,p_commit IN VARCHAR2
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_msg_count OUT NOCOPY NUMBER
124 ,x_msg_data OUT NOCOPY VARCHAR2
125 ,p_offer_id IN NUMBER
126 ,p_product_id IN NUMBER
127 ,p_start_date IN DATE
128 ,p_end_date IN DATE
129 ,x_order_line_tbl OUT NOCOPY order_line_tbl_type
130 );
131
132 PROCEDURE net_accrual_engine(
133 ERRBUF OUT NOCOPY VARCHAR2,
134 RETCODE OUT NOCOPY VARCHAR2,
135 p_as_of_date IN VARCHAR2,
136 p_offer_id IN NUMBER DEFAULT NULL);
137
138 END ozf_net_accrual_engine_pvt;