1 PACKAGE JTF_TTY_ALIGN_WEBADI_INT_PKG AS
2 /* $Header: jtftyaws.pls 120.0 2005/06/02 18:22:03 appldev ship $ */
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_GEO_WEBADI_INTERFACE_PKG
11 -- ---------------------------------------------------
12 -- PURPOSE
13 --
14 -- This package is used to return a list of column in order of selectivity.
15 -- And create indices on columns in order of input
16 --
17 --
18 -- Procedures:
19 -- (see below for specification)
20 --
21 -- NOTES
22 -- This package is publicly available for use
23 --
24 -- HISTORY
25 -- 06/20/2002 SHLI Created
26 --
27 -- End of Comments
28 --
29 -- *******************************************************
30 -- Start of Comments
31 -- *******************************************************
32
33 TYPE VARRAY_TYPE IS VARRAY(30) OF VARCHAR(360);
34 TYPE NARRAY_TYPE IS VARRAY(30) OF NUMBER;
35
36
37
38 procedure POPULATE_INTERFACE( p_userid in varchar2,
39 p_align_id in varchar2,
40 p_init_flag in varchar2,
41 x_seq out NOCOPY varchar2);
42
43 G_USER CONSTANT VARCHAR2(60):=FND_GLOBAL.USER_ID;
44 G_LOGIN CONSTANT VARCHAR2(60):=fnd_global.LOGIN_ID;
45 g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TTY_ALIGN_WEBADI_INT_PKG';
46
47 TYPE Number_table_type IS TABLE OF NUMBER;
48
49 PROCEDURE UPDATE_ALIGNMENT_TEAM(
50 p_api_version_number IN NUMBER,
51 p_init_msg_list IN VARCHAR2,
52 p_SQL_Trace IN VARCHAR2,
53 p_Debug_Flag IN VARCHAR2,
54 p_alignment_id IN NUMBER,
55 p_user_id IN NUMBER,
56 p_user_attribute1 IN VARCHAR2,
57 p_added_rscs_tbl IN JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE,
58 p_removed_rscs_tbl IN JTF_TTY_NACCT_SALES_PUB.SALESREP_RSC_TBL_TYPE,
59 p_affected_parties_tbl IN JTF_TTY_NACCT_SALES_PUB.AFFECTED_PARTY_TBL_TYPE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65
66
67 END JTF_TTY_ALIGN_WEBADI_INT_PKG;