[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;