PACKAGE: APPS.PO_ASL_ATTRIBUTES_THS2

Source

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