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;