7:
8: G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
9: G_PKG_NAME CONSTANT VARCHAR2(40) := 'OKE_FUNDING_PUB';
10: G_PRODUCT_CODE CONSTANT VARCHAR2(3) := 'OKE';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
14: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_CONTRACTS_UNEXPECTED_ERROR';
15: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
31: --
32: --
33:
34: PROCEDURE create_funding(p_api_version IN NUMBER ,
35: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2 ,
32: --
33:
34: PROCEDURE create_funding(p_api_version IN NUMBER ,
35: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2 ,
40: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
36: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
37: x_return_status OUT NOCOPY VARCHAR2 ,
38: x_msg_count OUT NOCOPY NUMBER ,
39: x_msg_data OUT NOCOPY VARCHAR2 ,
40: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
41: p_agreement_type IN VARCHAR2 ,
42: p_receivables_term_id IN NUMBER default null , /*skuchima bug 14344021*/
43: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
44: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
54: --
55: --
56:
57: PROCEDURE update_funding(p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
59: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
60: x_return_status OUT NOCOPY VARCHAR2 ,
61: x_msg_count OUT NOCOPY NUMBER ,
62: x_msg_data OUT NOCOPY VARCHAR2 ,
55: --
56:
57: PROCEDURE update_funding(p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
59: p_commit IN VARCHAR2 := OKE_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_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
59: p_commit IN VARCHAR2 := OKE_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_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
64: p_agreement_type IN VARCHAR2 ,
65: p_receivables_term_id IN NUMBER default null , /*skuchima bug 14344021*/
66: p_funding_in_rec IN FUNDING_REC_IN_TYPE ,
67: x_funding_out_rec OUT NOCOPY FUNDING_REC_OUT_TYPE ,
76: --
77: --
78:
79: PROCEDURE delete_funding(p_api_version IN NUMBER ,
80: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
81: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
82: x_return_status OUT NOCOPY VARCHAR2 ,
83: x_msg_count OUT NOCOPY NUMBER ,
84: x_msg_data OUT NOCOPY VARCHAR2 ,
77: --
78:
79: PROCEDURE delete_funding(p_api_version IN NUMBER ,
80: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
81: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
82: x_return_status OUT NOCOPY VARCHAR2 ,
83: x_msg_count OUT NOCOPY NUMBER ,
84: x_msg_data OUT NOCOPY VARCHAR2 ,
85: p_funding_source_id IN NUMBER
82: x_return_status OUT NOCOPY VARCHAR2 ,
83: x_msg_count OUT NOCOPY NUMBER ,
84: x_msg_data OUT NOCOPY VARCHAR2 ,
85: p_funding_source_id IN NUMBER
86: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
87: );
88:
89:
90: --
94: --
95: --
96:
97: PROCEDURE add_allocation(p_api_version IN NUMBER ,
98: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
99: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,
95: --
96:
97: PROCEDURE add_allocation(p_api_version IN NUMBER ,
98: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
99: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,
103: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
99: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,
103: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
104: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
105: x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
106: );
107:
113: --
114: --
115:
116: PROCEDURE update_allocation(p_api_version IN NUMBER ,
117: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
118: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
119: x_return_status OUT NOCOPY VARCHAR2 ,
120: x_msg_count OUT NOCOPY NUMBER ,
121: x_msg_data OUT NOCOPY VARCHAR2 ,
114: --
115:
116: PROCEDURE update_allocation(p_api_version IN NUMBER ,
117: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
118: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
119: x_return_status OUT NOCOPY VARCHAR2 ,
120: x_msg_count OUT NOCOPY NUMBER ,
121: x_msg_data OUT NOCOPY VARCHAR2 ,
122: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
118: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
119: x_return_status OUT NOCOPY VARCHAR2 ,
120: x_msg_count OUT NOCOPY NUMBER ,
121: x_msg_data OUT NOCOPY VARCHAR2 ,
122: p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE ,
123: p_allocation_in_rec IN ALLOCATION_REC_IN_TYPE ,
124: x_allocation_out_rec OUT NOCOPY ALLOCATION_REC_OUT_TYPE
125: );
126:
132: --
133: --
134:
135: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
136: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
137: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
138: x_return_status OUT NOCOPY VARCHAR2 ,
139: x_msg_count OUT NOCOPY NUMBER ,
140: x_msg_data OUT NOCOPY VARCHAR2 ,
133: --
134:
135: PROCEDURE delete_allocation(p_api_version IN NUMBER ,
136: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
137: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
138: x_return_status OUT NOCOPY VARCHAR2 ,
139: x_msg_count OUT NOCOPY NUMBER ,
140: x_msg_data OUT NOCOPY VARCHAR2 ,
141: p_fund_allocation_id IN NUMBER
138: x_return_status OUT NOCOPY VARCHAR2 ,
139: x_msg_count OUT NOCOPY NUMBER ,
140: x_msg_data OUT NOCOPY VARCHAR2 ,
141: p_fund_allocation_id IN NUMBER
142: -- p_agreement_flag IN VARCHAR2 := OKE_API.G_FALSE
143: );
144:
145:
146: --
150: --
151: --
152:
153: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
154: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
155: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
156: x_return_status OUT NOCOPY VARCHAR2 ,
157: x_msg_count OUT NOCOPY NUMBER ,
158: x_msg_data OUT NOCOPY VARCHAR2 ,
151: --
152:
153: PROCEDURE create_pa_oke_funding(p_api_version IN NUMBER ,
154: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
155: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
156: x_return_status OUT NOCOPY VARCHAR2 ,
157: x_msg_count OUT NOCOPY NUMBER ,
158: x_msg_data OUT NOCOPY VARCHAR2 ,
159: x_funding_source_id OUT NOCOPY NUMBER ,