1 PACKAGE JTF_TERR_NAMED_ACCOUNT AS
2 /* $Header: jtftnams.pls 120.0 2005/06/02 18:21:21 appldev ship $ */
3 -- Start of Comments
4 -- PURPOSE
5 -- Custom Assignment API
6 --
7 -- NOTES
8 -- ORACLE INTERNAL USE ONLY: NOT for customer use
9 --
10 -- HISTORY
11 -- 03/18/02 SGKUMAR Created
12 -- 03/20/02 SGKUMAR Created procedure insert_qualifiers
13 -- 03/20/02 SGKUMAR Created procedure set_winners
14 -- End of Comments
15 ----
16
17 PROCEDURE insert_customer_qual(p_account_id IN NUMBER);
18 PROCEDURE delete_qual(p_acct_qual_map_id IN NUMBER);
19 PROCEDURE update_mapping(p_account_id IN VARCHAR2,
20 p_flag in VARCHAR2);
21 PROCEDURE save_qual(p_acct_id IN NUMBER,
22 p_acct_qual_map_id IN NUMBER,
23 p_qual_usg_id IN NUMBER,
24 p_operator in VARCHAR2,
25 p_value1_char IN VARCHAR2,
26 p_value2_char IN VARCHAR2,
27 p_value1_num IN NUMBER,
28 p_value2_num IN NUMBER,
29 p_user_id in NUMBER
30 );
31 PROCEDURE get_customer_qual_count(p_account_id IN NUMBER, p_qual_count OUT NOCOPY NUMBER);
32 PROCEDURE get_postal_qual_count(p_account_id IN NUMBER, p_qual_count OUT NOCOPY NUMBER);
33 end JTF_TERR_NAMED_ACCOUNT;