[Home] [Help]
PACKAGE: APPS.OKL_TRANSACTION_PVT
Source
1 PACKAGE OKL_TRANSACTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTXNS.pls 120.3 2007/06/06 15:51:17 akrangan ship $*/
3
4 G_INVALID_VALUE CONSTANT VARCHAR2(1000) := 'OKL_INVALID_VALUE';
5 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(1000) := 'OKL_UNEXPECTED_ERROR';
6 G_LLA_CHR_ID CONSTANT VARCHAR2(1000) := 'OKL_LLA_CHR_ID';
7 G_LLA_NO_TRY CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_TRY';
8 G_LLA_INVALID_TRX_TYPE CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_TRX_TYPE';
9 G_LLA_MISSING_TRX_DATE CONSTANT VARCHAR2(1000) := 'OKL_LLA_MISSING_TRX_DATE';
10 G_LLA_WRONG_TRX_DATE CONSTANT VARCHAR2(1000) := 'OKL_LLA_WRONG_TRX_DATE'; -- Bug# 2504598
11 G_LLA_SECU_ERROR CONSTANT VARCHAR2(1000) := 'OKL_LLA_SECU_ERROR';
12
13 subtype tcnv_rec_type IS OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
14 subtype inv_agmt_chr_id_tbl_type IS okl_securitization_pvt.inv_agmt_chr_id_tbl_type;
15
16 -------------------------------------------------
17
18 TYPE rev_rec_type IS RECORD (
19 chr_id OKC_K_HEADERS_V.ID%TYPE := OKC_API.G_MISS_NUM
20 );
21
22 TYPE rev_tbl_type IS TABLE OF rev_rec_type INDEX BY BINARY_INTEGER;
23
24 subtype chrv_rec_type is OKL_OKC_MIGRATION_PVT.chrv_rec_type;
25 subtype khrv_rec_type is OKL_CONTRACT_PUB.khrv_rec_type;
26 ----------------------------------------------------
27
28 PROCEDURE create_transaction(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
35 p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
36 p_reason_code IN VARCHAR2,
37 p_description IN VARCHAR2,
38 p_trx_date IN DATE,
39 p_trx_type IN VARCHAR2, -- 'REBOOK' or 'SPLIT'
40 x_tcnv_rec OUT NOCOPY tcnv_rec_type
41 );
42
43 PROCEDURE update_trx_status(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
50 p_status IN VARCHAR2,
51 x_tcnv_rec OUT NOCOPY tcnv_rec_type
52 );
53
54 PROCEDURE abandon_revisions(
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_rev_tbl IN rev_tbl_type,
61 p_contract_status IN VARCHAR2,
62 p_tsu_code IN VARCHAR2,
63 --akrangan added for ebtax rebook changes starts
64 p_source_trx_id IN NUMBER DEFAULT NULL ,
65 p_source_trx_name IN VARCHAR2 DEFAULT NULL
66 --akrangan added for ebtax rebook changes ends
67 );
68
69 PROCEDURE check_contract_securitized(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
76 p_trx_date IN DATE
77 );
78
79 PROCEDURE check_contract_securitized(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
86 p_cle_id IN OKC_K_LINES_V.ID%TYPE,
87 p_stream_type_class IN okl_strm_type_b.stream_type_subclass%TYPE,
88 p_trx_date IN DATE
89 );
90
91 PROCEDURE create_service_transaction(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_lease_id IN OKC_K_HEADERS_V.ID%TYPE,
98 p_service_id IN OKC_K_HEADERS_V.ID%TYPE,
99 p_description IN VARCHAR2,
100 p_trx_date IN DATE,
101 p_status IN VARCHAR2,
102 x_tcnv_rec OUT NOCOPY tcnv_rec_type
103 );
104
105 PROCEDURE create_ppd_transaction(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
112 p_trx_date IN DATE,
113 p_trx_type IN VARCHAR2,
114 p_reason_code IN VARCHAR2,
115 x_tcnv_rec OUT NOCOPY tcnv_rec_type
116 );
117 END OKL_TRANSACTION_PVT;