PACKAGE: APPS.LNS_FEE_ASSIGNMENT_PUB

Source

1 PACKAGE LNS_FEE_ASSIGNMENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: LNS_FASGM_PUBP_S.pls 120.11 2010/06/28 10:32:44 gparuchu ship $ */
3 
4 TYPE fee_assignment_rec_type IS RECORD(
5      fee_assignment_id			      NUMBER,
6      LOAN_ID                         NUMBER,
7      FEE_ID              NUMBER,
8      FEE                                      NUMBER,
9      FEE_TYPE                                 VARCHAR2(30),
10      FEE_BASIS                                VARCHAR2(30),
11      NUMBER_GRACE_DAYS                        NUMBER,
12      COLLECTED_THIRD_PARTY_FLAG		      VARCHAR2(1),
13      RATE_TYPE				      VARCHAR2(30),
14      BEGIN_INSTALLMENT_NUMBER		      NUMBER,
15      END_INSTALLMENT_NUMBER		      NUMBER,
16      NUMBER_OF_PAYMENTS			      NUMBER,
17      BILLING_OPTION			      VARCHAR2(30),
18      CREATED_BY                      NUMBER(15),
19      CREATION_DATE                   DATE,
20      LAST_UPDATED_BY                 NUMBER(15),
21      LAST_UPDATE_DATE                DATE,
22      LAST_UPDATE_LOGIN                        NUMBER(15),
23      OBJECT_VERSION_NUMBER           NUMBER,
24      START_DATE_ACTIVE		     DATE,
25      END_DATE_ACTIVE		     DATE,
26      DISB_HEADER_ID		     NUMBER,
27      DELETE_DISABLED_FLAG	     VARCHAR2(1),
28      OPEN_PHASE_FLAG		     VARCHAR2(1),
29      PHASE			     VARCHAR2(30),
30      CUSTOM_PROCEDURE		     VARCHAR2(250)
31 
32 );
33 
34 PROCEDURE create_FEE_ASSIGNMENT (
35     p_init_msg_list    IN         VARCHAR2,
36     p_FEE_ASSIGNMENT_rec   IN         fee_assignment_rec_type,
37     x_fee_assignment_id    OUT NOCOPY 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 PROCEDURE update_FEE_ASSIGNMENT (
44     p_init_msg_list         IN            VARCHAR2,
45     p_FEE_ASSIGNMENT_rec        IN            fee_assignment_rec_type,
46     p_object_version_number IN OUT NOCOPY NUMBER,
47     x_return_status         OUT NOCOPY    VARCHAR2,
48     x_msg_count             OUT NOCOPY    NUMBER,
49     x_msg_data              OUT NOCOPY    VARCHAR2
50 );
51 
52 PROCEDURE delete_FEE_ASSIGNMENT (
53     p_init_msg_list         IN            VARCHAR2,
54     p_fee_assignment_id         IN		  NUMBER,
55     x_return_status         OUT NOCOPY    VARCHAR2,
56     x_msg_count             OUT NOCOPY    NUMBER,
57     x_msg_data              OUT NOCOPY    VARCHAR2
58 );
59 /*
60 PROCEDURE get_FEE_ASSIGNMENT_rec (
61     p_init_msg_list   IN         VARCHAR2
62     p_fee_assignment_id         IN         NUMBER,
63     x_FEE_ASSIGNMENT_rec   OUT NOCOPY fee_assignment_rec_type,
64     x_return_status   OUT NOCOPY VARCHAR2,
65     x_msg_count       OUT NOCOPY NUMBER,
66     x_msg_data        OUT NOCOPY VARCHAR2
67 );
68 */
69 
70 -- function used to check if any fee assignment exists for a specific fee
71 -- if so, disallow deletion of that fee in LNS_FEES
72 FUNCTION IS_EXIST_FEE_ASSIGNMENT (
73     p_fee_id			 NUMBER
74 ) RETURN VARCHAR2;
75 
76 
77 PROCEDURE create_LP_FEE_ASSIGNMENT( P_LOAN_ID NUMBER ) ;
78 
79 PROCEDURE create_LP_DISB_FEE_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER, P_LOAN_PRODUCT_LINE_ID IN NUMBER, P_LOAN_ID IN NUMBER ) ;
80 
81 PROCEDURE delete_DISB_FEE_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) ;
82 
83 -- function used to check if any fee assignment is editable
84 function IS_LOAN_FASGM_EDITABLE(p_loan_id           in NUMBER
85 				,p_fee_id              in NUMBER
86 				,p_disb_header_id in NUMBER
87 	    )  return VARCHAR2;
88 
89 
90 END LNS_FEE_ASSIGNMENT_PUB;