[Home] [Help]
PACKAGE BODY: APPS.PO_ASL_ATTRIBUTES_THS1
Source
1 PACKAGE BODY PO_ASL_ATTRIBUTES_THS1 as
2 /* $Header: POXA6LSB.pls 115.7 2003/08/21 09:39:53 tmanda ship $ */
3
4 /*=============================================================================
5
6 PROCEDURE NAME: update_row()
7
8 ===============================================================================*/
9 procedure update_row(
10 x_row_id VARCHAR2,
11 x_asl_id NUMBER,
12 x_using_organization_id NUMBER,
13 x_last_update_date DATE,
14 x_last_updated_by NUMBER,
15 x_creation_date DATE,
16 x_created_by NUMBER,
17 x_document_sourcing_method VARCHAR2,
18 x_release_generation_method VARCHAR2,
19 x_purchasing_unit_of_measure VARCHAR2,
20 x_enable_plan_schedule_flag VARCHAR2,
21 x_enable_ship_schedule_flag VARCHAR2,
22 x_plan_schedule_type VARCHAR2,
23 x_ship_schedule_type VARCHAR2,
24 x_plan_bucket_pattern_id NUMBER,
25 x_ship_bucket_pattern_id NUMBER,
26 x_enable_autoschedule_flag VARCHAR2,
27 x_scheduler_id NUMBER,
28 x_enable_authorizations_flag VARCHAR2,
29 x_vendor_id NUMBER,
30 x_vendor_site_id NUMBER,
31 x_item_id NUMBER,
32 x_category_id NUMBER,
33 x_attribute_category VARCHAR2,
34 x_attribute1 VARCHAR2,
35 x_attribute2 VARCHAR2,
36 x_attribute3 VARCHAR2,
37 x_attribute4 VARCHAR2,
38 x_attribute5 VARCHAR2,
39 x_attribute6 VARCHAR2,
40 x_attribute7 VARCHAR2,
41 x_attribute8 VARCHAR2,
42 x_attribute9 VARCHAR2,
43 x_attribute10 VARCHAR2,
44 x_attribute11 VARCHAR2,
45 x_attribute12 VARCHAR2,
46 x_attribute13 VARCHAR2,
47 x_attribute14 VARCHAR2,
48 x_attribute15 VARCHAR2,
49 x_last_update_login NUMBER,
50 x_price_update_tolerance NUMBER,
51 x_processing_lead_time NUMBER,
52 x_delivery_calendar VARCHAR2,
53 x_min_order_qty NUMBER,
54 x_fixed_lot_multiple NUMBER,
55 x_country_of_origin_code VARCHAR2,
56 /* VMI FPH START */
57 x_enable_vmi_flag VARCHAR2,
58 x_vmi_min_qty NUMBER,
59 x_vmi_max_qty NUMBER,
60 x_enable_vmi_auto_repl_flag VARCHAR2,
61 x_vmi_replenishment_approval VARCHAR2,
62 /* VMI FPH END */
63 /* CONSSUP FPI START */
64 x_consigned_from_supplier_flag VARCHAR2,
65 x_consigned_billing_cycle NUMBER ,
66 x_last_billing_date DATE,
67 /* CONSSUP FPI END */
68 /*FPJ START*/
69 x_replenishment_method NUMBER,
70 x_vmi_min_days NUMBER,
71 x_vmi_max_days NUMBER,
72 x_fixed_order_quantity NUMBER,
73 x_forecast_horizon NUMBER,
74 x_consume_on_aging_flag VARCHAR2,
75 x_aging_period NUMBER
76 /*FPJ END*/
77 ) is
78
79
80 begin
81
82 UPDATE PO_ASL_ATTRIBUTES
83 SET
84 asl_id = x_asl_id ,
85 using_organization_id = x_using_organization_id ,
86 last_update_date = x_last_update_date ,
87 last_updated_by = x_last_updated_by ,
88 creation_date = x_creation_date ,
89 created_by = x_created_by ,
90 document_sourcing_method = x_document_sourcing_method ,
91 release_generation_method = x_release_generation_method ,
92 purchasing_unit_of_measure = x_purchasing_unit_of_measure ,
93 enable_plan_schedule_flag = x_enable_plan_schedule_flag ,
94 enable_ship_schedule_flag = x_enable_ship_schedule_flag ,
95 plan_schedule_type = x_plan_schedule_type ,
96 ship_schedule_type = x_ship_schedule_type ,
97 plan_bucket_pattern_id = x_plan_bucket_pattern_id ,
98 ship_bucket_pattern_id = x_ship_bucket_pattern_id ,
99 enable_autoschedule_flag = x_enable_autoschedule_flag ,
100 scheduler_id = x_scheduler_id ,
101 enable_authorizations_flag = x_enable_authorizations_flag ,
102 vendor_id = x_vendor_id ,
103 vendor_site_id = x_vendor_site_id ,
104 item_id = x_item_id ,
105 category_id = x_category_id ,
106 attribute_category = x_attribute_category ,
107 attribute1 = x_attribute1 ,
108 attribute2 = x_attribute2 ,
109 attribute3 = x_attribute3 ,
110 attribute4 = x_attribute4 ,
111 attribute5 = x_attribute5 ,
112 attribute6 = x_attribute6 ,
113 attribute7 = x_attribute7 ,
114 attribute8 = x_attribute8 ,
115 attribute9 = x_attribute9 ,
116 attribute10 = x_attribute10 ,
117 attribute11 = x_attribute11 ,
118 attribute12 = x_attribute12 ,
119 attribute13 = x_attribute13 ,
120 attribute14 = x_attribute14 ,
121 attribute15 = x_attribute15 ,
122 last_update_login = x_last_update_login ,
123 price_update_tolerance = x_price_update_tolerance ,
124 processing_lead_time = x_processing_lead_time ,
125 delivery_calendar = x_delivery_calendar ,
126 min_order_qty = x_min_order_qty ,
127 fixed_lot_multiple = x_fixed_lot_multiple ,
128 country_of_origin_code = x_country_of_origin_code ,
129 /* VMI FPH START */
130 enable_vmi_flag = x_enable_vmi_flag ,
131 vmi_max_qty = x_vmi_max_qty ,
132 vmi_min_qty = x_vmi_min_qty ,
133 enable_vmi_auto_replenish_flag = x_enable_vmi_auto_repl_flag ,
134 vmi_replenishment_approval = x_vmi_replenishment_approval ,
135 /* VMI FPH END */
136 /* CONSSUP FPI START */
137 consigned_from_supplier_flag = x_consigned_from_supplier_flag ,
138 consigned_billing_cycle = x_consigned_billing_cycle ,
139 last_billing_date = x_last_billing_date ,
140 /* CONSSUP FPI END */
141 /*FPJ START*/
142 replenishment_method = x_replenishment_method ,
143 vmi_min_days = x_vmi_min_days ,
144 vmi_max_days = x_vmi_max_days ,
145 fixed_order_quantity = x_fixed_order_quantity ,
146 forecast_horizon = x_forecast_horizon ,
147 consume_on_aging_flag = x_consume_on_aging_flag ,
148 aging_period = x_aging_period
149 WHERE rowid = x_row_id;
150
151 if (sql%notfound) then
152 raise no_data_found;
153 end if;
154
155 end update_row;
156
157 END PO_ASL_ATTRIBUTES_THS1;