1 PACKAGE OKL_OPEN_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRKOIS.pls 120.4 2005/11/07 18:36:20 dedey noship $*/
3
4 -- Contract Header Record Type Definition
5 subtype khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
6 subtype chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
7
8 -- Contract Party Role Record Type Definition
9 subtype cplv_rec_type IS OKL_OKC_MIGRATION_PVT.cplv_rec_type;
10 subtype kplv_rec_type IS OKL_K_PARTY_ROLES_PVT.kplv_rec_type; -- Bug 4558486
11
12 -- Contract Rule Record Record Type
13 subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
14 subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
15 subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
16
17 -- Contract Line Record Type Definition
18 subtype clev_rec_type IS OKL_CREATE_KLE_PUB.clev_rec_type;
19 subtype klev_rec_type IS OKL_CREATE_KLE_PUB.klev_rec_type;
20 subtype cimv_rec_type IS OKL_CREATE_KLE_PUB.cimv_rec_type;
21 subtype talv_rec_type IS OKL_CREATE_KLE_PUB.talv_rec_type;
22 subtype itiv_tbl_type IS OKL_CREATE_KLE_PUB.itiv_tbl_type;
23 subtype sidv_rec_type IS OKL_SUPP_INVOICE_DTLS_PUB.sidv_rec_type;
24
25 subtype rmpv_rec_type IS OKL_RULE_PUB.rmpv_rec_type;
26
27 subtype gvev_rec_type IS OKL_OKC_MIGRATION_PVT.gvev_rec_type;
28 subtype adpv_rec_type IS okl_txd_assets_pub.adpv_rec_type;
29
30 subtype pphv_rec_type is okl_party_payments_pvt.pphv_rec_type;
31 subtype pphv_tbl_type is okl_party_payments_pvt.pphv_tbl_type;
32
33 subtype ppydv_rec_type IS okl_pyd_pvt.ppydv_rec_type;
34 subtype ppydv_tbl_type is okl_pyd_pvt.ppydv_tbl_type;
35
36 PROCEDURE Process_Record_Parallel (
37 errbuf OUT NOCOPY VARCHAR2,
38 retcode OUT NOCOPY VARCHAR2,
39 p_batch_number IN VARCHAR2,
40 p_start_date_from IN VARCHAR2,
41 p_start_date_to IN VARCHAR2,
42 p_contract_number IN VARCHAR2,
43 p_customer_number IN VARCHAR2,
44 p_instance_number IN NUMBER
45 );
46
47 PROCEDURE Process_Record (
48 errbuf OUT NOCOPY VARCHAR2,
49 retcode OUT NOCOPY VARCHAR2,
50 p_batch_number IN VARCHAR2,
51 p_start_date_from IN VARCHAR2,
52 p_start_date_to IN VARCHAR2,
53 p_contract_number IN VARCHAR2,
54 p_customer_number IN VARCHAR2,
55 p_instance_number IN VARCHAR2 DEFAULT 'NONE'
56 );
57
58 PROCEDURE Check_Input_Record(
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_batch_number IN VARCHAR2,
64 p_start_date_from IN DATE,
65 p_start_date_to IN DATE,
66 p_contract_number IN VARCHAR2,
67 p_customer_number IN VARCHAR2,
68 x_total_checked OUT NOCOPY NUMBER
69 );
70
71
72 PROCEDURE Load_Input_Record(
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_batch_number IN VARCHAR2,
78 p_start_date_from IN DATE,
79 p_start_date_to IN DATE,
80 p_contract_number IN VARCHAR2,
81 p_customer_number IN VARCHAR2,
82 x_total_loaded OUT NOCOPY NUMBER
83 );
84
85 PROCEDURE contract_further_process(
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
91 p_import_stage IN VARCHAR2
92 );
93
94 PROCEDURE contract_after_yield(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
101 );
102
103 PROCEDURE Report_Error(
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 PROCEDURE Update_Interface_Status (p_contract_number IN okl_header_interface.contract_number_old%TYPE,
109 p_new_contract_number IN okl_header_interface.contract_number%TYPE,
110 p_status IN VARCHAR2,
111 x_return_status OUT NOCOPY VARCHAR2);
112
113 -- Function to submit the concurrent request for Contract Import.
114
115 FUNCTION Submit_Import_Contract(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_batch_number IN VARCHAR2,
122 p_contract_number IN VARCHAR2,
123 p_start_date IN DATE,
124 p_end_date IN DATE,
125 p_party_number IN VARCHAR2)
126 RETURN NUMBER ;
127
128 END OKL_OPEN_INTERFACE_PVT;