PACKAGE: APPS.LNS_COND_ASSIGNMENT_PUB

Source

1 PACKAGE LNS_COND_ASSIGNMENT_PUB AS
2 /* $Header: LNS_CASGM_PUBP_S.pls 120.5 2005/08/22 05:40:02 hikumar noship $ */
3 
4 TYPE cond_assignment_rec_type IS RECORD(
5      COND_ASSIGNMENT_ID			      NUMBER,
6      LOAN_ID                         NUMBER,
7      CONDITION_ID              NUMBER,
8      CONDITION_DESCRIPTION                    VARCHAR2(250),
9      CONDITION_MET_FLAG                       VARCHAR2(1),
10      FULFILLMENT_DATE                   DATE,
11      FULFILLMENT_UPDATED_BY          NUMBER(15),
12      MANDATORY_FLAG                           VARCHAR2(1),
13      CREATED_BY                      NUMBER(15),
14      CREATION_DATE                   DATE,
15      LAST_UPDATED_BY                 NUMBER(15),
16      LAST_UPDATE_DATE                DATE,
17      LAST_UPDATE_LOGIN                        NUMBER(15),
18      OBJECT_VERSION_NUMBER           NUMBER,
19      DISB_HEADER_ID		     NUMBER,
20      DELETE_DISABLED_FLAG	VARCHAR2(1)
21 );
22 
23 PROCEDURE create_COND_ASSIGNMENT (
24     p_init_msg_list    IN         VARCHAR2,
25     p_COND_ASSIGNMENT_rec   IN         cond_assignment_rec_type,
26     x_COND_ASSIGNMENT_id    OUT NOCOPY NUMBER,
27     x_return_status    OUT NOCOPY VARCHAR2,
28     x_msg_count        OUT NOCOPY NUMBER,
29     x_msg_data         OUT NOCOPY VARCHAR2
30 );
31 
32 PROCEDURE update_COND_ASSIGNMENT (
33     p_init_msg_list         IN            VARCHAR2,
34     p_COND_ASSIGNMENT_rec        IN            cond_assignment_rec_type,
35     p_object_version_number IN OUT NOCOPY NUMBER,
36     x_return_status         OUT NOCOPY    VARCHAR2,
37     x_msg_count             OUT NOCOPY    NUMBER,
38     x_msg_data              OUT NOCOPY    VARCHAR2
39 );
40 
41 PROCEDURE delete_COND_ASSIGNMENT (
42     p_init_msg_list         IN            VARCHAR2,
43     p_COND_ASSIGNMENT_id         IN		  NUMBER,
44     x_return_status         OUT NOCOPY    VARCHAR2,
45     x_msg_count             OUT NOCOPY    NUMBER,
46     x_msg_data              OUT NOCOPY    VARCHAR2
47 );
48 /*
49 PROCEDURE get_COND_ASSIGNMENT_rec (
50     p_init_msg_list   IN         VARCHAR2,
51     p_COND_ASSIGNMENT_id         IN         NUMBER,
52     x_COND_ASSIGNMENT_rec   OUT NOCOPY cond_assignment_rec_type,
53     x_return_status   OUT NOCOPY VARCHAR2,
54     x_msg_count       OUT NOCOPY NUMBER,
55     x_msg_data        OUT NOCOPY VARCHAR2
56 );
57 */
58 
59 PROCEDURE create_LP_COND_ASSIGNMENT( P_LOAN_ID IN NUMBER ) ;
60 
61 
62 PROCEDURE create_LP_DISB_COND_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER , P_LOAN_PRODUCT_LINE_ID IN NUMBER ) ;
63 
64 PROCEDURE delete_DISB_COND_ASSIGNMENT( P_DISB_HEADER_ID IN NUMBER ) ;
65 
66 
67 -- function used to check if any condition assignment exists for a specific condition
68 -- if so, disallow deletion of that condition in LNS_CONDITIONS
69 FUNCTION IS_EXIST_COND_ASSIGNMENT (
70     p_condition_id			 NUMBER
71 ) RETURN VARCHAR2;
72 
73 
74 
75 END LNS_COND_ASSIGNMENT_PUB;