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;