PACKAGE: APPS.LNS_APPROVAL_ACTION_PUB

Source

1 PACKAGE LNS_APPROVAL_ACTION_PUB AS
2 /* $Header: LNS_APACT_PUBP_S.pls 120.0.12000000.1 2007/01/17 23:22:33 appldev ship $ */
3 
4 TYPE approval_action_rec_type IS RECORD(
5      ACTION_ID			     NUMBER,
6      CREATED_BY                      NUMBER(15),
7      CREATION_DATE                   DATE,
8      LAST_UPDATED_BY                 NUMBER(15),
9      LAST_UPDATE_DATE                DATE,
10      LAST_UPDATE_LOGIN                        NUMBER(15),
11      OBJECT_VERSION_NUMBER           NUMBER,
12      LOAN_ID                         NUMBER,
13      ACTION_TYPE		     VARCHAR2(30),
14      AMOUNT			     NUMBER,
15      REASON_CODE		     VARCHAR2(30),
16      ATTRIBUTE_CATEGORY		     VARCHAR2(30),
17      ATTRIBUTE1       VARCHAR2(150),
18      ATTRIBUTE2       VARCHAR2(150),
19      ATTRIBUTE3       VARCHAR2(150),
20      ATTRIBUTE4       VARCHAR2(150),
21      ATTRIBUTE5       VARCHAR2(150),
22      ATTRIBUTE6       VARCHAR2(150),
23      ATTRIBUTE7       VARCHAR2(150),
24      ATTRIBUTE8       VARCHAR2(150),
25      ATTRIBUTE9       VARCHAR2(150),
26      ATTRIBUTE10      VARCHAR2(150),
27      ATTRIBUTE11      VARCHAR2(150),
28      ATTRIBUTE12      VARCHAR2(150),
29      ATTRIBUTE13      VARCHAR2(150),
30      ATTRIBUTE14      VARCHAR2(150),
31      ATTRIBUTE15      VARCHAR2(150),
32      ATTRIBUTE16      VARCHAR2(150),
33      ATTRIBUTE17      VARCHAR2(150),
34      ATTRIBUTE18      VARCHAR2(150),
35      ATTRIBUTE19      VARCHAR2(150),
36      ATTRIBUTE20      VARCHAR2(150)
37 );
38 
39 PROCEDURE create_approval_action (
40     p_init_msg_list    IN         VARCHAR2,
41     p_approval_action_rec   IN         approval_action_rec_type,
42     x_action_id		    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 update_approval_action (
49     p_init_msg_list         IN            VARCHAR2,
50     p_approval_action_rec        IN            approval_action_rec_type,
51     p_object_version_number IN OUT NOCOPY 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 PROCEDURE delete_approval_action (
58     p_init_msg_list         IN            VARCHAR2,
59     p_action_id         IN		  NUMBER,
60     x_return_status         OUT NOCOPY    VARCHAR2,
61     x_msg_count             OUT NOCOPY    NUMBER,
62     x_msg_data              OUT NOCOPY    VARCHAR2
63 );
64 /*
65 PROCEDURE get_approval_action_rec (
66     p_init_msg_list   IN         VARCHAR2,
67     p_action_id         IN         NUMBER,
68     x_approval_action_rec   OUT NOCOPY approval_action_rec_type,
69     x_return_status   OUT NOCOPY VARCHAR2,
70     x_msg_count       OUT NOCOPY NUMBER,
71     x_msg_data        OUT NOCOPY VARCHAR2
72 );
73 */
74 END LNS_APPROVAL_ACTION_PUB;