1 PACKAGE JTF_TTY_NA_WF AUTHID CURRENT_USER AS
2 /* $Header: jtftrwas.pls 120.0 2005/06/02 18:21:59 appldev ship $ */
3
4 -- ---------------------------------------------------
5 -- Start of Comments
6 -- ---------------------------------------------------
7 -- PACKAGE NAME: JTF_TTY_NA_WF
8 -- ---------------------------------------------------
9 -- PURPOSE
10 -- Reassign Catch All territories and create appropriate named accounts
11 --
12 --
13 -- PROCEDURES:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package is for PRIVATE USE ONLY use
18 --
19 -- HISTORY
20 -- 12/13/02 ARPATEL Package Created
21 -- End of Comments
22 --
23
24 G_USER CONSTANT VARCHAR2(60):=FND_GLOBAL.USER_ID;
25
26 TYPE NA_Rec_Type IS RECORD (
27 NAMED_ACCOUNT_ID NUMBER
28 , TERR_GROUP_ID NUMBER
29 , SITE_RANK NUMBER );
30
31 PROCEDURE AssignRep
32 ( itemtype IN VARCHAR2
33 , itemkey IN VARCHAR2
34 , actid IN NUMBER
35 , funcmode IN VARCHAR2
36 , resultout OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE add_org_to_terrgp(p_terr_gp_id IN NUMBER,
40 p_ref_account_id IN NUMBER,
41 p_party_id IN NUMBER,
42 p_resource_id IN NUMBER,
43 p_role_code IN VARCHAR2,
44 p_user_id in NUMBER,
45 p_rsc_group_id IN NUMBER,
46 p_lead_keyword IN VARCHAR2,
47 p_lead_postal_code IN VARCHAR2,
48 x_account_id OUT NOCOPY NUMBER);
49
50 PROCEDURE create_mapping_rules (p_account_id IN NUMBER
51 , p_keyword IN VARCHAR2
52 , p_postal_code IN VARCHAR2);
53
54 function get_site_type_code( p_party_id NUMBER ) return varchar2;
55
56 END JTF_TTY_NA_WF;
57