[Home] [Help]
PACKAGE: APPS.JL_ZZ_INVOICE_CREATE
Source
1 PACKAGE JL_ZZ_INVOICE_CREATE AUTHID CURRENT_USER as
2 /* $Header: jlzzrics.pls 120.0 2004/01/31 01:57:42 appradha ship $ */
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC FUNCTIONS/PROCEDURES |
6 *----------------------------------------------------------------------------*/
7
8 /*----------------------------------------------------------------------------*
9 | FUNCTION |
10 | validate_gdf_inv_api |
11 | |
12 | DESCRIPTION |
13 | |
14 | PARAMETERS |
15 | INPUT |
16 | p_request_id Number -- Concurrent Request id |
17 | |
18 | RETURNS |
19 | 0 Number -- Validations Failed |
20 | 1 Number -- Validation Succeeded |
21 | |
22 | HISTORY |
23 | 30-JAN-2004 Amit Pradhan Made a new package valdiate_inv_create_api |
24 | |
25 *----------------------------------------------------------------------------*/
26
27 TYPE varchar2_150_tbl_type is Table of Varchar2(150) index by binary_integer;
28 TYPE varchar2_50_tbl_type is Table of Varchar2(50) index by binary_integer;
29 TYPE varchar2_20_tbl_type is Table of Varchar2(50) index by binary_integer;
30 TYPE number_tbl_type is Table of Number index by binary_integer;
31 TYPE date_tbl_type is Table of Date index by binary_integer;
32
33 Type R_interface_line is RECORD
34 (
35 interface_line_id Number_tbl_type,
36 cust_trx_type_id Number_tbl_type,
37 trx_date date_tbl_type,
38 orig_system_address_id Number_tbl_type,
39 line_type Varchar2_150_tbl_type,
40 memo_line_id Number_tbl_type,
41 Inventory_item_id Number_tbl_type,
42 header_gdf_attribute1 Varchar2_150_tbl_type,
43 header_gdf_attribute2 Varchar2_150_tbl_type,
44 header_gdf_attribute3 Varchar2_150_tbl_type,
45 header_gdf_attribute4 Varchar2_150_tbl_type,
46 header_gdf_attribute5 Varchar2_150_tbl_type,
47 header_gdf_attribute6 Varchar2_150_tbl_type,
48 header_gdf_attribute7 Varchar2_150_tbl_type,
49 header_gdf_attribute8 Varchar2_150_tbl_type,
50 header_gdf_attribute9 Varchar2_150_tbl_type,
51 header_gdf_attribute10 Varchar2_150_tbl_type,
52 header_gdf_attribute11 Varchar2_150_tbl_type,
53 header_gdf_attribute12 Varchar2_150_tbl_type,
54 header_gdf_attribute13 Varchar2_150_tbl_type,
55 header_gdf_attribute14 Varchar2_150_tbl_type,
56 header_gdf_attribute15 Varchar2_150_tbl_type,
57 header_gdf_attribute16 Varchar2_150_tbl_type,
58 header_gdf_attribute17 Varchar2_150_tbl_type,
59 line_gdf_attribute1 Varchar2_150_tbl_type,
60 line_gdf_attribute2 Varchar2_150_tbl_type,
61 line_gdf_attribute3 Varchar2_150_tbl_type,
62 line_gdf_attribute4 Varchar2_150_tbl_type,
63 line_gdf_attribute5 Varchar2_150_tbl_type,
64 line_gdf_attribute6 Varchar2_150_tbl_type,
65 line_gdf_attribute7 Varchar2_150_tbl_type,
66 line_gdf_attribute8 Varchar2_150_tbl_type,
67 line_gdf_attribute9 Varchar2_150_tbl_type,
68 line_gdf_attribute10 Varchar2_150_tbl_type,
69 line_gdf_attribute11 Varchar2_150_tbl_type,
70 line_gdf_attribute12 Varchar2_150_tbl_type,
71 warehouse_id Number_tbl_type,
72 batch_source_name Varchar2_50_tbl_type,
73 trx_number Varchar2_20_tbl_type
74 );
75
76 FUNCTION validate_gdf_inv_api (p_request_id IN NUMBER) RETURN NUMBER;
77
78 END JL_ZZ_INVOICE_CREATE;