[Home] [Help]
PACKAGE: APPS.OKL_ACCT_GEN_RULE_PVT
Source
1 PACKAGE OKL_ACCT_GEN_RULE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRACGS.pls 115.6 2002/12/18 12:45:45 kjinger noship $ */
3
4
5 SUBTYPE aulv_rec_type IS OKL_ACC_GEN_RULE_PUB.AULV_REC_TYPE;
6 SUBTYPE aulv_tbl_type IS OKL_ACC_GEN_RULE_PUB.AULV_TBL_TYPE;
7 SUBTYPE agrv_rec_type IS OKL_ACC_GEN_RULE_PUB.AGRV_REC_TYPE;
8
9 TYPE acct_rec_type IS RECORD (
10 id NUMBER := OKC_API.G_MISS_NUM,
11 SEGMENT OKL_ACCT_GEN_RULES_V.SEGMENT%TYPE := OKC_API.G_MISS_CHAR,
12 SEGMENT_DESC OKL_ACCT_GEN_RULES_V.SEGMENT_DESC%TYPE
13 := OKC_API.G_MISS_CHAR,
14 segment_number NUMBER := OKC_API.G_MISS_NUM,
15 agr_id NUMBER := OKC_API.G_MISS_NUM,
16 AE_LINE_TYPE OKL_ACCT_GEN_RULES_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17 source OKL_ACCT_GEN_RULES_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
18 constants OKL_ACCT_GEN_RULES_V.CONSTANTS%TYPE := OKC_API.G_MISS_CHAR,
19 object_version_number NUMBER := OKC_API.G_MISS_NUM,
20 attribute_category OKL_ACCT_GEN_RULES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21 attribute1 OKL_ACCT_GEN_RULES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22 attribute2 OKL_ACCT_GEN_RULES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23 attribute3 OKL_ACCT_GEN_RULES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24 attribute4 OKL_ACCT_GEN_RULES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25 attribute5 OKL_ACCT_GEN_RULES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26 attribute6 OKL_ACCT_GEN_RULES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27 attribute7 OKL_ACCT_GEN_RULES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28 attribute8 OKL_ACCT_GEN_RULES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29 attribute9 OKL_ACCT_GEN_RULES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30 attribute10 OKL_ACCT_GEN_RULES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31 attribute11 OKL_ACCT_GEN_RULES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32 attribute12 OKL_ACCT_GEN_RULES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33 attribute13 OKL_ACCT_GEN_RULES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34 attribute14 OKL_ACCT_GEN_RULES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35 attribute15 OKL_ACCT_GEN_RULES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
36 created_by NUMBER := OKC_API.G_MISS_NUM,
37 creation_date OKL_ACCT_GEN_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39 last_update_date OKL_ACCT_GEN_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40 last_update_login NUMBER := OKC_API.G_MISS_NUM);
41
42 TYPE acct_tbl_type IS table of acct_rec_type INDEX BY BINARY_INTEGER;
43
44 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
45 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
46 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
47
48
49
50 PROCEDURE GET_RULE_LINES_COUNT(p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_ae_line_type IN VARCHAR2,
56 x_line_count OUT NOCOPY NUMBER);
57
58
59 PROCEDURE GET_RULE_LINES(p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_ae_line_type IN VARCHAR2,
65 x_acc_lines OUT NOCOPY ACCT_TBL_TYPE);
66
67
68
69 PROCEDURE UPDT_RULE_LINES(p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_acc_lines IN ACCT_TBL_TYPE,
75 x_acc_lines OUT NOCOPY ACCT_TBL_TYPE);
76
77
78 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCT_GEN_RULE_PVT' ;
79 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
80
81 END OKL_ACCT_GEN_RULE_PVT;