eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OZF_OFFER_ADJ_PRODUCTS_PKG

Source


1 package body OZF_OFFER_ADJ_PRODUCTS_PKG AS
2 /* $Header: ozftoadpb.pls 120.3 2005/08/25 04:14 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 IS
24 BEGIN
25 px_object_version_number := nvl(px_object_version_number,1);
26 INSERT INTO OZF_OFFER_ADJUSTMENT_PRODUCTS
27 (
28 offer_adjustment_product_id
29 , offer_adjustment_id
30 , offer_discount_line_id
31 , off_discount_product_id
32 , product_context
33 , product_attribute
34 , product_attr_value
35 , excluder_flag
36 , apply_discount_flag
37 , include_volume_flag
38 , object_version_number
39 , creation_date
40 , created_by
41 , last_update_date
42 , last_updated_by
43 , last_update_login
44 )
45 values
46 (
47 DECODE(px_offer_adjustment_product_id , FND_API.G_MISS_NUM , NULL,  px_offer_adjustment_product_id)
48 , DECODE(p_offer_adjustment_id , FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id)
49 , DECODE(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
50 , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
51 , DECODE(p_product_context, FND_API.G_MISS_CHAR, NULL, p_product_context)
52 , DECODE(p_product_attribute, FND_API.G_MISS_CHAR, null, p_product_attribute)
53 , DECODE(p_product_attr_value, fnd_api.g_miss_char, null, p_product_attr_value)
54 , DECODE(p_excluder_flag, FND_API.g_miss_char, null, p_excluder_flag )
55 , DECODE(p_apply_discount_flag , FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
56 , DECODE(p_include_volume_flag, FND_API.G_MISS_CHAR, NULL, p_include_volume_flag)
57 , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
58 , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
59 , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_created_by)
60 , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
61 , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
62 , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
63 
64 );
65 END INSERT_ROW;
66 
67 PROCEDURE UPDATE_ROW
68 (
69 p_offer_adjustment_product_id NUMBER
70 , p_offer_adjustment_id NUMBER
71 , p_offer_discount_line_id NUMBER
72 , p_off_discount_product_id  NUMBER
73 , p_product_context VARCHAR2
74 , p_product_attribute VARCHAR2
75 , p_product_attr_value VARCHAR2
76 , p_excluder_flag VARCHAR2
77 , p_apply_discount_flag VARCHAR2
78 , p_include_volume_flag VARCHAR2
79 , p_object_version_number NUMBER
80 , p_last_update_date DATE
81 , p_last_updated_by NUMBER
82 , p_last_update_login NUMBER
83 )IS
84 BEGIN
85 
86 UPDATE OZF_OFFER_ADJUSTMENT_PRODUCTS
87 SET
88 offer_adjustment_product_id     = DECODE(p_offer_adjustment_product_id, null, offer_adjustment_product_id, FND_API.G_MISS_NUM, null,  p_offer_adjustment_product_id)
89 , offer_adjustment_id           = DECODE(P_offer_adjustment_id , null, offer_adjustment_id , FND_API.G_MISS_NUM,null, p_offer_adjustment_id)
90 , offer_discount_line_id        = DECODE(P_OFFER_DISCOUNT_LINE_ID, NULL, OFFER_DISCOUNT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
91 , off_discount_product_id       = DECODE(p_off_discount_product_id , NULL, off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
92 , product_context               = DECODE(p_product_context, null , product_context, FND_API.G_MISS_CHAR, null, p_product_context)
93 , product_attribute             = DECODE(p_product_attribute, NULL, product_attribute, FND_API.G_MISS_char, NULL , p_product_attribute)
94 , product_attr_value            = DECODE(p_product_attr_value, NULL, product_attr_value, FND_API.G_MISS_CHAR, null, p_product_attr_value)
95 , excluder_flag                 = DECODE(P_EXCLUDER_FLAG , NULL,excluder_flag , FND_API.G_MISS_CHAR, null, p_excluder_flag)
96 , apply_discount_flag           = DECODE(p_apply_discount_flag , NULL, apply_discount_flag, FND_API.G_MISS_CHAR, null, p_apply_discount_flag)
97 , include_volume_flag           = DECODE(P_INCLUDE_VOLUME_FLAG, NULL, INCLUDE_VOLUME_FLAG, fnd_api.g_miss_char, null, p_include_volume_flag)
98 , object_version_number         = NVL(p_object_version_number , 0)+1
99 , last_update_date              = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date )
100 , last_update_login             = DECODE(P_LAST_UPDATE_LOGIN, null, last_update_login, FND_API.G_MISS_NUM, fnd_global.user_id, p_last_update_login)
101 , last_updated_by               = DECODE(P_LAST_UPDATED_BY, null, last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id, p_last_update_login)
102 WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
103 AND object_version_number = p_object_version_number;
104 
105 IF SQL%NOTFOUND THEN
106 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107 END IF;
108 
109 END UPDATE_ROW;
110 
111 PROCEDURE delete_row
112 (
113 p_offer_adjustment_product_id NUMBER
114 , p_object_version_number NUMBER
115 )
116 IS
117 BEGIN
118 delete FROM ozf_offer_adjustment_products
119 WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
120 AND object_version_number = p_object_version_number;
121 
122 IF sql%notfound THEN
123 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124 END IF;
125 END delete_row;
126 
127 
128 procedure LOCK_ROW
129 (
130 p_offer_adjustment_product_id NUMBER
131 , p_object_version_number NUMBER
132 )
133 IS
134 CURSOR C is SELECT * FROM ozf_offer_adjustment_products
135 WHERE offer_adjustment_product_id = p_offer_adjustment_product_id
136 AND object_version_number = p_object_version_number
137 FOR UPDATE OF offer_adjustment_product_id NOWAIT;
138 
139 recinfo c%ROWTYPE;
140 
141 BEGIN
142 OPEN c;
143 FETCH c INTO recinfo;
144    IF (c%NOTFOUND) THEN
145       CLOSE c;
146       AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
147       RAISE FND_API.g_exc_error;
148    END IF;
149    CLOSE c;
150 
151 END LOCK_ROW;
152 
153 
154 END OZF_OFFER_ADJ_PRODUCTS_PKG;