1 Package JTF_TERRITORY_CUSTOM AUTHID CURRENT_USER AS
2 /* $Header: jtfptrcs.pls 120.0 2005/06/02 18:20:49 appldev ship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERRITORY_CUSTOM
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- This package will contain all of the user defined function
10 -- that can be used in Territory assignment rules. This can be
11 -- used by customers to include complex processing as part of
12 -- Territory rules.
13 --
14 -- PROCEDURES:
15 -- (see below for specification)
16 --
17 -- NOTES
18 -- This package is publicly available for use
19 --
20 -- HISTORY
21 -- 06/09/99 VNEDUNGA Created
22 -- 04/10/00 VNEDUNGA Adding new validation routines
23 -- 05/08/00 VNEDUNGA Adding inventory ietem validation
24 -- 06/19/00 VNEDUNGA Adding check_partnership function call
25 -- 07/24/00 JDOCHERT Adding Chk_party_id function call
26 -- Adding Chk_comp_name_range function call
27 --
28 -- End of Comments
29 --
30
31 -- Function to check company name (party_id)
32 FUNCTION chk_party_id
33 ( p_Party_Id IN NUMBER,
34 p_Terr_Id IN NUMBER,
35 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
36
37 -- Function to check customer name range
38 FUNCTION chk_comp_name_range
39 ( p_Company_Name IN VARCHAR2,
40 p_Terr_Id IN NUMBER,
41 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
42
43 -- Function to check account hierarchy
44 FUNCTION check_account_Hierarchy
45 ( p_Hierarchy_Id IN NUMBER,
46 p_Terr_Id IN NUMBER,
47 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
48
49 -- Function check whether the party is a partner
50 FUNCTION check_partnership
51 ( p_Partner_Id IN NUMBER,
52 p_Terr_Id IN NUMBER,
53 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
54
55
56 -- Check account classification
57 FUNCTION check_account_classification
58 ( p_Party_Id IN NUMBER,
59 p_Terr_Id IN NUMBER,
60 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
61
62 -- Check Oppor classification rule
63 FUNCTION check_Oppor_classification
64 ( p_Lead_Id IN NUMBER,
65 p_Terr_Id IN NUMBER,
66 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
67
68 -- Check Opportunity Expected purchase
69 FUNCTION check_Oppor_Exp_Purchase
70 ( p_Lead_Id IN NUMBER,
71 p_Terr_Id IN NUMBER,
72 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
73
74 -- Check lead Expected purchase
75 FUNCTION check_Lead_Exp_Purchase
76 ( p_Sales_Lead_Id IN NUMBER,
77 p_Terr_Id IN NUMBER,
78 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
79
80 -- Check Inventory Item
81 FUNCTION check_Inventory_Item
82 ( p_Lead_Id IN NUMBER,
83 p_Terr_Id IN NUMBER,
84 p_Terr_Qual_Id IN NUMBER) RETURN BOOLEAN;
85
86 END JTF_TERRITORY_CUSTOM ;
87
88