DBA Data[Home] [Help]

PACKAGE: APPS.POS_ASL_CAPACITY_PKG

Source


1 PACKAGE POS_ASL_CAPACITY_PKG AUTHID CURRENT_USER AS
2 /* $Header: POSSICPS.pls 115.1 99/10/15 16:19:38 porting ship $ */
3 
4   l_language    VARCHAR2(5);
5   l_script_name VARCHAR2(240);
6   l_org_id      NUMBER;
7   l_user_id     NUMBER;
8   l_session_id  NUMBER;
9   l_responsibility_id NUMBER;
10   l_request_id NUMBER;
11   l_date_format varchar2(100);
12 
13 
14   TYPE t_text_table is table of varchar2(240) index by binary_integer;
15   g_dummy t_text_table;
16 
17   PROCEDURE capacity_frame(pos_asl_id       IN VARCHAR2 DEFAULT NULL);
18 
19   PROCEDURE submit_capacity(pos_sic_action  IN VARCHAR2 DEFAULT NULL,
20                    pos_sic_rows             IN VARCHAR2 DEFAULT NULL,
21                    p_asl_id                 IN VARCHAR2 DEFAULT NULL,
22                    pos_error_row            IN VARCHAR2 DEFAULT NULL,
23                    pos_more_rows            IN VARCHAR2 DEFAULT NULL,
24 		   pos_sic_capacity_id      IN t_text_table DEFAULT g_dummy,
25 		   pos_sic_from_date        IN t_text_table DEFAULT g_dummy,
26 		   pos_sic_to_date          IN t_text_table DEFAULT g_dummy,
27 	 	   pos_sic_capacity_per_day IN t_text_table DEFAULT g_dummy);
28 
29 
30 END POS_ASL_CAPACITY_PKG;