[Home] [Help]
PACKAGE: APPS.WSH_AR_INTERFACE_PUB
Source
1 PACKAGE WSH_AR_INTERFACE_PUB AUTHID CURRENT_USER as
2 /* $Header: WSHARMGS.pls 115.1 99/07/16 08:17:51 porting ship $ */
3 --
4 -- Package
5 -- WSH_AR_INTERFACE_PUB
6 -- Purpose
7 -- Stub routine using which client might NULL out some of Mandatory
8 -- grouping Rule Columns
9 -- History
10 -- 04-FEB-97 ANEOGI Created
11
12 --
13 -- PUBLIC VARIABLES
14 --
15 TYPE cintTabTyp IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
16 TYPE cnameTabTyp IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
17 TYPE cvalTabTyp IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
18
19 -- name of the columns which will passed and the value could be modified to NULL
20
21 col_comments CONSTANT varchar2(30) := 'COMMENTS';
22 col_cr_mthd_acct_rule CONSTANT varchar2(30) := 'CREDIT_METHOD_FOR_ACCT_RULE';
23 col_cr_mthd_install CONSTANT varchar2(30) := 'CREDIT_METHOD_FOR_INSTALLMENTS';
24 col_hdr_attr1 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE1';
25 col_hdr_attr2 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE2';
26 col_hdr_attr3 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE3';
27 col_hdr_attr4 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE4';
28 col_hdr_attr5 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE5';
29 col_hdr_attr6 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE6';
30 col_hdr_attr7 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE7';
31 col_hdr_attr8 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE8';
32 col_hdr_attr9 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE9';
33 col_hdr_attr10 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE10';
34 col_hdr_attr11 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE11';
35 col_hdr_attr12 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE12';
36 col_hdr_attr13 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE13';
37 col_hdr_attr14 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE14';
38 col_hdr_attr15 CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE15';
39 col_hdr_attr_cat CONSTANT varchar2(30) := 'HEADER_ATTRIBUTE_CATEGORY';
40 col_orig_bill_contact_id CONSTANT varchar2(30):='ORIG_SYSTEM_BILL_CONTACT_ID';
41 col_orig_bill_cust_id CONSTANT varchar2(30) := 'ORIG_SYSTEM_BILL_CUSTOMER_ID';
42 col_orig_ship_contact_id CONSTANT varchar2(30):='ORIG_SYSTEM_SHIP_CONTACT_ID';
43 col_purchase_order CONSTANT varchar2(30) := 'PURCHASE_ORDER';
44 col_reason_code CONSTANT varchar2(30) := 'REASON_CODE';
45
46
47 --
48 -- PUBLIC FUNCTIONS
49 --
50
51 -- Name
52 -- wsh_ar_null_grouping_cols
53 -- Purpose
54 -- It passes the column names in the first parameters and their existing
55 -- values in the 2nd parameter. User could check the names and NULL out
56 -- any of those column values.
57 -- Arguments
58 -- col_names
59 -- col_values
60
61 PROCEDURE wsh_ar_null_group_cols(
62 col_names IN cnameTabTyp,
63 col_values IN OUT cvalTabTyp);
64
65
66 END WSH_AR_INTERFACE_PUB;