[Home] [Help]
PACKAGE: APPS.PO_ASL_ATTRIBUTES_THS1
Source
1 PACKAGE PO_ASL_ATTRIBUTES_THS1 AUTHID CURRENT_USER as
2 /* $Header: POXA6LSS.pls 115.7 2003/08/21 09:39:39 tmanda ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: po_asl_attributes_th1
6
7 DESCRIPTION: Table handlers for PO_ASL_ATTRIBUTES - part 2
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME
12
13 OWNER: Liza Broadbent
14
15 PROCEDURE NAMES: update_row()
16
17 ===========================================================================*/
18 /*===========================================================================
19 PROCEDURE NAME: update_row
20
21
22 DESCRIPTION: Update table handler for PO_ASL_ATTRIBUTES
23
24
25 CHANGE HISTORY: 28-May-96 lbroadbe Created
26
27 ===============================================================================*/
28 procedure update_row(
29 x_row_id VARCHAR2,
30 x_asl_id NUMBER,
31 x_using_organization_id NUMBER,
32 x_last_update_date DATE,
33 x_last_updated_by NUMBER,
34 x_creation_date DATE,
35 x_created_by NUMBER,
36 x_document_sourcing_method VARCHAR2,
37 x_release_generation_method VARCHAR2,
38 x_purchasing_unit_of_measure VARCHAR2,
39 x_enable_plan_schedule_flag VARCHAR2,
40 x_enable_ship_schedule_flag VARCHAR2,
41 x_plan_schedule_type VARCHAR2,
42 x_ship_schedule_type VARCHAR2,
43 x_plan_bucket_pattern_id NUMBER,
44 x_ship_bucket_pattern_id NUMBER,
45 x_enable_autoschedule_flag VARCHAR2,
46 x_scheduler_id NUMBER,
47 x_enable_authorizations_flag VARCHAR2,
48 x_vendor_id NUMBER,
49 x_vendor_site_id NUMBER,
50 x_item_id NUMBER,
51 x_category_id NUMBER,
52 x_attribute_category VARCHAR2,
53 x_attribute1 VARCHAR2,
54 x_attribute2 VARCHAR2,
55 x_attribute3 VARCHAR2,
56 x_attribute4 VARCHAR2,
57 x_attribute5 VARCHAR2,
58 x_attribute6 VARCHAR2,
59 x_attribute7 VARCHAR2,
60 x_attribute8 VARCHAR2,
61 x_attribute9 VARCHAR2,
62 x_attribute10 VARCHAR2,
63 x_attribute11 VARCHAR2,
64 x_attribute12 VARCHAR2,
65 x_attribute13 VARCHAR2,
66 x_attribute14 VARCHAR2,
67 x_attribute15 VARCHAR2,
68 x_last_update_login NUMBER,
69 x_price_update_tolerance NUMBER,
70 x_processing_lead_time NUMBER,
71 x_delivery_calendar VARCHAR2,
72 x_min_order_qty NUMBER,
73 x_fixed_lot_multiple NUMBER,
74 x_country_of_origin_code VARCHAR2,
75 /* VMI FPH START */
76 x_enable_vmi_flag VARCHAR2,
77 x_vmi_min_qty NUMBER,
78 x_vmi_max_qty NUMBER,
79 x_enable_vmi_auto_repl_flag VARCHAR2,
80 x_vmi_replenishment_approval VARCHAR2,
81 /* VMI FPH END */
82 /* CONSSUP FPI START */
83 x_consigned_from_supplier_flag VARCHAR2,
84 x_consigned_billing_cycle NUMBER ,
85 x_last_billing_date DATE,
86 /* CONSSUP FPI END */
87 /*FPJ START*/
88 x_replenishment_method NUMBER,
89 x_vmi_min_days NUMBER,
90 x_vmi_max_days NUMBER,
91 x_fixed_order_quantity NUMBER,
92 x_forecast_horizon NUMBER,
93 x_consume_on_aging_flag VARCHAR2,
94 x_aging_period NUMBER
95 /*FPJ END*/
96 );
97
98
99
100 END PO_ASL_ATTRIBUTES_THS1;