1 PACKAGE HZ_CREDIT_USAGES_CASCADE_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHCRCCS.pls 115.8 2003/01/09 02:47:43 vto noship $ */
3 --======================================================================
4 --CONSTANTS
5 --======================================================================
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_CREDIT_USAGES_CASCADE_PKG' ;
7
8
9 ---------------------------
10 -- PROCEDURES AND FUNCTIONS
11 ---------------------------
12 ------------------------------------------------------------------------
13 -- PROCEDURE cascade_credit_usage_rules
14 -- The procedure accepts the input parameters
15 --
16 -- p_cust_acct_profile_amt_id
17 -- New cust acct profile amt ID that is being created
18 --
19 -- p_cust_profile_id
20 -- The parent cust profile id of the new cust acct profile amt ID
21 -- being created
22 --
23 -- p_profile_class_amt_id
24 -- The profile_class_amt_id that is being used to create the new
25 -- cust_acct_profile_amt_id
26 --
27 -- p_profile_class_id
28 -- The parent profile_class_id of the profile_class_amt_id that is
29 -- being used to create the new cust_acct_profile_amt_id
30 --
31 ------------------------------------------------------------------------
32
33 PROCEDURE cascade_credit_usage_rules
34 ( p_cust_acct_profile_amt_id IN NUMBER
35 , p_cust_profile_id IN NUMBER
36 , p_profile_class_amt_id IN NUMBER
37 , p_profile_class_id IN NUMBER
38 , X_return_status OUT NOCOPY VARCHAR2
39 , X_msg_count OUT NOCOPY NUMBER
40 , X_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 ------------------------------------------------------------------------
44 -- PROCEDURE: delete_credit_usages
45 -- COMMENTS: This procedure will accept the
46 -- cust_acct_profile_amt_id as input and
47 -- remove records from the multi currency credit checking
48 -- usages table HZ_CREDIT_USAGES for this ID
49 ------------------------------------------------------------------------
50 PROCEDURE delete_credit_usages
51 ( p_cust_acct_profile_amt_id IN NUMBER
52 , X_return_status OUT NOCOPY VARCHAR2
53 , X_msg_count OUT NOCOPY NUMBER
54 , X_msg_data OUT NOCOPY VARCHAR2
55 );
56
57
58 ------------------------------------------------------------------------
59 -- PROCEDURE: Check_Duplicate_all
60 -- COMMENTS: This procedure will check the
61 -- duplication of currencies across the
62 -- existing assigned rule sets with the
63 -- profile
64 ------------------------------------------------------------------------
65 PROCEDURE Check_Duplicate_all
66 ( p_rule_set_id IN NUMBER
67 , p_entity IN VARCHAR2
68 , p_entity_id IN NUMBER
69 , p_cust_account_id IN NUMBER
70 , p_include_all IN VARCHAR2
71 , p_cust_acct_profile_amt_id IN NUMBER
72 , x_duplicate OUT NOCOPY VARCHAR2
73 , x_dupl_curr OUT NOCOPY VARCHAR2
74 ) ;
75
76 END HZ_CREDIT_USAGES_CASCADE_PKG ;