PACKAGE: APPS.LNS_FEE_ASSIGNMENT_PUB

Source

1 PACKAGE LNS_FEE_ASSIGNMENT_PUB AS
2 /* $Header: LNS_FASGM_PUBP_S.pls 120.5.12010000.2 2008/11/04 17:17:28 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 );
29 
30 PROCEDURE create_FEE_ASSIGNMENT (
31     p_init_msg_list    IN         VARCHAR2,
32     p_FEE_ASSIGNMENT_rec   IN         fee_assignment_rec_type,
33     x_fee_assignment_id    OUT NOCOPY NUMBER,
34     x_return_status    OUT NOCOPY VARCHAR2,
35     x_msg_count        OUT NOCOPY NUMBER,
36     x_msg_data         OUT NOCOPY VARCHAR2
37 );
38 
39 PROCEDURE update_FEE_ASSIGNMENT (
40     p_init_msg_list         IN            VARCHAR2,
41     p_FEE_ASSIGNMENT_rec        IN            fee_assignment_rec_type,
42     p_object_version_number IN OUT NOCOPY NUMBER,
43     x_return_status         OUT NOCOPY    VARCHAR2,
44     x_msg_count             OUT NOCOPY    NUMBER,
45     x_msg_data              OUT NOCOPY    VARCHAR2
46 );
47 
48 PROCEDURE delete_FEE_ASSIGNMENT (
49     p_init_msg_list         IN            VARCHAR2,
50     p_fee_assignment_id         IN		  NUMBER,
51     x_return_status         OUT NOCOPY    VARCHAR2,
52     x_msg_count             OUT NOCOPY    NUMBER,
53     x_msg_data              OUT NOCOPY    VARCHAR2
54 );
55 /*
56 PROCEDURE get_FEE_ASSIGNMENT_rec (
57     p_init_msg_list   IN         VARCHAR2
58     p_fee_assignment_id         IN         NUMBER,
59     x_FEE_ASSIGNMENT_rec   OUT NOCOPY fee_assignment_rec_type,
60     x_return_status   OUT NOCOPY VARCHAR2,
61     x_msg_count       OUT NOCOPY NUMBER,
62     x_msg_data        OUT NOCOPY VARCHAR2
63 );
64 */
65 
66 -- function used to check if any fee assignment exists for a specific fee
67 -- if so, disallow deletion of that fee in LNS_FEES
68 FUNCTION IS_EXIST_FEE_ASSIGNMENT (
69     p_fee_id			 NUMBER
70 ) RETURN VARCHAR2;
71 
72 
73 PROCEDURE create_LP_FEE_ASSIGNMENT( P_LOAN_ID NUMBER ) ;
74 
75 PROCEDURE create_LP_DISB_FEE_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER, P_LOAN_PRODUCT_LINE_ID IN NUMBER, P_LOAN_ID IN NUMBER ) ;
76 
77 PROCEDURE delete_DISB_FEE_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) ;
78 
79 
80 END LNS_FEE_ASSIGNMENT_PUB;