DBA Data[Home] [Help]

PACKAGE: APPS.OZF_OFFER_ADJ_PRODUCTS_PKG

Source


1 package OZF_OFFER_ADJ_PRODUCTS_PKG AS
2 /* $Header: ozftoadps.pls 120.3 2005/08/25 04:15 rssharma noship $ */
3 
4 PROCEDURE INSERT_ROW
5 (
6  px_offer_adjustment_product_id   IN OUT NOCOPY NUMBER
7  , p_offer_adjustment_id         NUMBER
8  , p_offer_discount_line_id      NUMBER
9  , p_off_discount_product_id     NUMBER
10  , p_product_context             VARCHAR2
11  , p_product_attribute           VARCHAR2
12  , p_product_attr_value          VARCHAR2
13  , p_excluder_flag               VARCHAR2
14  , p_apply_discount_flag         VARCHAR2
15  , p_include_volume_flag         VARCHAR2
16  , px_object_version_number      IN OUT NOCOPY NUMBER
17  , p_last_update_date            DATE
18  , p_last_updated_by             NUMBER
19  , p_creation_date               DATE
20  , p_created_by                  NUMBER
21  , p_last_update_login           NUMBER
22  );
23 
24 PROCEDURE UPDATE_ROW
25 (
26 p_offer_adjustment_product_id NUMBER
27 , p_offer_adjustment_id NUMBER
28 , p_offer_discount_line_id NUMBER
29 , p_off_discount_product_id  NUMBER
30 , p_product_context VARCHAR2
31 , p_product_attribute VARCHAR2
32 , p_product_attr_value VARCHAR2
33 , p_excluder_flag VARCHAR2
34 , p_apply_discount_flag VARCHAR2
35 , p_include_volume_flag VARCHAR2
36 , p_object_version_number NUMBER
37 , p_last_update_date DATE
38 , p_last_updated_by NUMBER
39 , p_last_update_login NUMBER
40 );
41 
42 PROCEDURE delete_row
43 (
44 p_offer_adjustment_product_id NUMBER
45 , p_object_version_number NUMBER
46 );
47 
48 procedure LOCK_ROW
49 (
50 p_offer_adjustment_product_id NUMBER
51 , p_object_version_number NUMBER
52 );
53 
54 
55 END OZF_OFFER_ADJ_PRODUCTS_PKG;