1 PACKAGE ozf_net_accrual_engine_pvt AS
2 /* $Header: ozfvnaes.pls 120.2 2006/08/03 12:27:46 mgudivak noship $ */
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
33 TYPE t_order_line_tbl IS TABLE OF order_rec INDEX BY BINARY_INTEGER;
34
35 TYPE ar_trx_rec IS RECORD
36 (
37 extended_amount NUMBER,
38 inventory_item_id NUMBER,
39 quantity_credited NUMBER,
40 quantity_invoiced NUMBER,
41 uom_code VARCHAR2(3),
42 sold_to_customer_id NUMBER,
43 bill_to_site_use_id NUMBER,
44 ship_to_site_use_id NUMBER,
45 invoice_currency_code VARCHAR2(15),
46 customer_trx_id NUMBER,
47 complete_flag VARCHAR2(1),
48 conv_date DATE,
49 customer_trx_line_id NUMBER
50 );
51
52 TYPE t_ar_trx_line_tbl IS TABLE OF ar_trx_rec INDEX BY BINARY_INTEGER;
53 TYPE terr_countries_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
54
55
56 PROCEDURE retroactive_offer_adj(
57 p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2
59 ,p_commit IN VARCHAR2
60 ,x_return_status OUT NOCOPY VARCHAR2
61 ,x_msg_count OUT NOCOPY NUMBER
62 ,x_msg_data OUT NOCOPY VARCHAR2
63 ,p_offer_id IN NUMBER
64 ,p_start_date IN DATE
65 ,p_end_date IN DATE
66 ,x_order_line_tbl OUT NOCOPY order_line_tbl_type);
67
68 PROCEDURE offer_adj_new_product(
69 p_api_version IN NUMBER
70 ,p_init_msg_list IN VARCHAR2
71 ,p_commit IN VARCHAR2
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_msg_count OUT NOCOPY NUMBER
74 ,x_msg_data OUT NOCOPY VARCHAR2
75 ,p_offer_id IN NUMBER
76 ,p_product_id IN NUMBER
77 ,p_start_date IN DATE
78 ,p_end_date IN DATE
79 ,x_order_line_tbl OUT NOCOPY order_line_tbl_type
80 );
81
82 PROCEDURE net_accrual_engine(
83 ERRBUF OUT NOCOPY VARCHAR2,
84 RETCODE OUT NOCOPY VARCHAR2,
85 p_as_of_date IN VARCHAR2,
86 p_offer_id IN NUMBER DEFAULT NULL);
87
88 END ozf_net_accrual_engine_pvt;