[Home] [Help]
PACKAGE: APPS.AR_INVOICE_VALIDATE_FLEX
Source
1 PACKAGE AR_INVOICE_VALIDATE_FLEX AS
2 /* $Header: ARXVINFS.pls 120.2.12010000.2 2008/12/02 12:09:32 npanchak ship $ */
3
4
5 TYPE flex_context_type IS TABLE OF
6 fnd_descr_flex_contexts.descriptive_flex_context_code%type
7 INDEX by binary_integer;
8
9 TYPE flex_num_type IS TABLE OF number INDEX by binary_integer;
10
11 TYPE seg_value_type IS TABLE OF
12 ra_interface_lines.interface_line_attribute1%type
13 INDEX by binary_integer;
14
15 TYPE cursor_tbl_type IS
16 TABLE OF BINARY_INTEGER
17 INDEX BY BINARY_INTEGER;
18
19 TYPE interface_hdr_rec_type IS RECORD(
20 interface_header_context VARCHAR2(30) DEFAULT NULL,
21 /***** Updated fix for Bug 7151383 *******/
22 interface_header_attribute1 VARCHAR2(150) DEFAULT NULL,
23 interface_header_attribute2 VARCHAR2(150) DEFAULT NULL,
24 interface_header_attribute3 VARCHAR2(150) DEFAULT NULL,
25 interface_header_attribute4 VARCHAR2(150) DEFAULT NULL,
26 interface_header_attribute5 VARCHAR2(150) DEFAULT NULL,
27 interface_header_attribute6 VARCHAR2(150) DEFAULT NULL,
28 interface_header_attribute7 VARCHAR2(150) DEFAULT NULL,
29 interface_header_attribute8 VARCHAR2(150) DEFAULT NULL,
30 interface_header_attribute9 VARCHAR2(150) DEFAULT NULL,
31 interface_header_attribute10 VARCHAR2(150) DEFAULT NULL,
32 interface_header_attribute11 VARCHAR2(150) DEFAULT NULL,
33 interface_header_attribute12 VARCHAR2(150) DEFAULT NULL,
34 interface_header_attribute13 VARCHAR2(150) DEFAULT NULL,
35 interface_header_attribute14 VARCHAR2(150) DEFAULT NULL,
36 interface_header_attribute15 VARCHAR2(150) DEFAULT NULL);
37 /***** Changes End Here *******/
38
39 TYPE interface_line_rec_type IS RECORD(
40 interface_line_context VARCHAR2(30) DEFAULT NULL,
41 /***** Updated fix for Bug 7151383 *******/
42 interface_line_attribute1 VARCHAR2(150) DEFAULT NULL,
43 interface_line_attribute2 VARCHAR2(150) DEFAULT NULL,
44 interface_line_attribute3 VARCHAR2(150) DEFAULT NULL,
45 interface_line_attribute4 VARCHAR2(150) DEFAULT NULL,
46 interface_line_attribute5 VARCHAR2(150) DEFAULT NULL,
47 interface_line_attribute6 VARCHAR2(150) DEFAULT NULL,
48 interface_line_attribute7 VARCHAR2(150) DEFAULT NULL,
49 interface_line_attribute8 VARCHAR2(150) DEFAULT NULL,
50 interface_line_attribute9 VARCHAR2(150) DEFAULT NULL,
51 interface_line_attribute10 VARCHAR2(150) DEFAULT NULL,
52 interface_line_attribute11 VARCHAR2(150) DEFAULT NULL,
53 interface_line_attribute12 VARCHAR2(150) DEFAULT NULL,
54 interface_line_attribute13 VARCHAR2(150) DEFAULT NULL,
55 interface_line_attribute14 VARCHAR2(150) DEFAULT NULL,
56 interface_line_attribute15 VARCHAR2(150) DEFAULT NULL);
57 /***** Changes End Here *******/
58
59 pg_char_dummy varchar2(10) := '!#$%^&*';
60 pg_num_segs flex_num_type; -- number of segments for each context
61 pg_flex_contexts flex_context_type; -- flex context values
62 pg_ctl_cursors cursor_tbl_type; -- cursors for ra_customer_trx_lines
63 pg_ril_cursors cursor_tbl_type; -- cursors for ra_interface_lines
64 pg_active_segs flex_num_type; -- active segment numbers
65 pg_start_loc flex_num_type; -- for a context, index to first
66 -- segment in pg_active_segs
67 pg_ctx_count number; -- total number of contexts
68
69
70 PROCEDURE validate_desc_flex (
71 p_validation_type IN VARCHAR2,
72 x_errmsg OUT NOCOPY VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2 );
74
75 END AR_INVOICE_VALIDATE_FLEX;