1 PACKAGE JTF_TTY_EXCEL_NAORG_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfamifs.pls 120.6 2006/07/28 22:56:17 mhtran noship $ */
3 -- ===========================================================================+
4 -- | Copyright (c) 1999 Oracle Corporation |
5 -- | Redwood Shores, California, USA |
6 -- | All rights reserved. |
7 -- +===========================================================================
8 -- Start of Comments
9 -- ---------------------------------------------------
10 -- PACKAGE NAME: JTF_TTY_EXCEL_NAORG_PVT
11 -- ---------------------------------------------------
12 -- PURPOSE
13 --
14 -- This package is used to populate the interface table jtf_tty_webadi_interface
15 -- for the admin export download
16 --
17 --
18 -- Procedures:
19 -- (see below for specification)
20 --
21 -- NOTES
22 -- This package is publicly available for use
23 --
24 -- HISTORY
25 -- 02/24/2004 ACHANDA Created
26 -- 10/14/2005 VBGHOSH Added mapped status to support for Export button
27 --
28 -- End of Comments
29 --
30
31 TYPE VARRAY_TYPE IS VARRAY(30) OF VARCHAR2(360);
32 TYPE NARRAY_TYPE IS VARRAY(30) OF NUMBER;
33 TYPE DARRAY_TYPE IS VARRAY(30) OF DATE;
34
35 procedure POPULATE_WEBADI_INTERFACE( P_CALLFROM IN VARCHAR2
36 ,P_SEARCHTYPE IN VARCHAR2
37 ,P_SEARCHVALUE IN VARCHAR2
38 ,P_USERID IN INTEGER
39 ,P_GRPNAME IN VARCHAR2
40 ,P_GRPID IN NUMBER
41 ,P_SITE_TYPE IN VARCHAR2
42 ,P_SICCODE IN VARCHAR2
43 ,P_SICCODE_TYPE IN VARCHAR2 DEFAULT NULL
44 ,P_SITE_DUNS IN VARCHAR2
45 ,P_NAMED_ACCOUNT IN VARCHAR2
46 ,P_WEB_SITE IN VARCHAR2 DEFAULT NULL
47 ,P_EMAIL_ADDR IN VARCHAR2 DEFAULT NULL
48 ,P_CITY IN VARCHAR2
49 ,P_STATE IN VARCHAR2
50 ,P_COUNTY IN VARCHAR2 DEFAULT NULL
51 ,P_PROVINCE IN VARCHAR2
52 ,P_POSTAL_CODE_FROM IN VARCHAR2
53 ,P_POSTAL_CODE_TO IN VARCHAR2
54 ,P_COUNTRY IN VARCHAR2
55 ,P_DU_DUNS IN VARCHAR2
56 ,P_DU_NAME IN VARCHAR2
57 ,P_PARTY_NUMBER IN VARCHAR2
58 ,P_GU_DUNS IN VARCHAR2
59 ,P_GU_NAME IN VARCHAR2
60 ,P_CERT_LEVEL IN VARCHAR2
61 ,P_SALESPERSON IN NUMBER
62 ,P_SALES_GROUP IN NUMBER
63 ,P_SALES_ROLE IN VARCHAR2
64 ,P_ASSIGNED_STATUS IN VARCHAR2
65 ,P_ISADMINFLAG IN VARCHAR2
66 ,P_PARTY_TYPE IN VARCHAR2 DEFAULT NULL
67 ,P_HIERARCHY_TYPE IN VARCHAR2 DEFAULT NULL
68 ,P_RELATIONSHIP_ROLE IN VARCHAR2 DEFAULT NULL
69 ,P_CLASS_TYPE IN VARCHAR2 DEFAULT NULL
70 ,P_CLASS_CODE IN VARCHAR2 DEFAULT NULL
71 ,P_ANN_REV_FROM IN NUMBER DEFAULT NULL
72 ,P_ANN_REV_TO IN NUMBER DEFAULT NULL
73 ,P_NUM_EMP_FROM IN VARCHAR2 DEFAULT NULL
74 ,P_NUM_EMP_TO IN VARCHAR2 DEFAULT NULL
75 ,P_CUST_CATEGORY IN VARCHAR2 DEFAULT NULL
76 ,P_IDENT_ADDR_FLAG IN VARCHAR2 DEFAULT NULL
77 ,P_MAPPED_STATUS IN VARCHAR2 DEFAULT NULL
78 ,P_VIEW_DATE IN DATE DEFAULT NULL
79 ,P_ORG_ID IN NUMBER DEFAULT NULL
80 ,X_SEQ OUT NOCOPY VARCHAR2
81 ,X_RETCODE OUT NOCOPY VARCHAR2
82 ,X_ERRBUF OUT NOCOPY VARCHAR2);
83
84
85 END JTF_TTY_EXCEL_NAORG_PVT;