DBA Data[Home] [Help]

APPS.OKC_EURO_CONV_PUB dependencies on OKC_CONTRACT_PUB

Line 21: RETURN OKC_CONTRACT_PUB.chrv_tbl_type IS

17: --This procedure populates the table of record with the contract
18: --hdr infomation to be updated
19: ----
20: FUNCTION set_header_rec(p_chr_rec OKC_K_HEADERS_B%ROWTYPE, x_return_status OUT NOCOPY VARCHAR2 )
21: RETURN OKC_CONTRACT_PUB.chrv_tbl_type IS
22: x_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
23: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
24: l_rate number;
25: l_euro_rate number;

Line 22: x_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;

18: --hdr infomation to be updated
19: ----
20: FUNCTION set_header_rec(p_chr_rec OKC_K_HEADERS_B%ROWTYPE, x_return_status OUT NOCOPY VARCHAR2 )
21: RETURN OKC_CONTRACT_PUB.chrv_tbl_type IS
22: x_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
23: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
24: l_rate number;
25: l_euro_rate number;
26: l_proc VARCHAR2(30) := 'set header rec';

Line 23: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

19: ----
20: FUNCTION set_header_rec(p_chr_rec OKC_K_HEADERS_B%ROWTYPE, x_return_status OUT NOCOPY VARCHAR2 )
21: RETURN OKC_CONTRACT_PUB.chrv_tbl_type IS
22: x_chrv_rec OKC_CONTRACT_PUB.chrv_rec_type;
23: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
24: l_rate number;
25: l_euro_rate number;
26: l_proc VARCHAR2(30) := 'set header rec';
27: l_return_status varchar2(1) :='S';

Line 192: l_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

188: l_proc VARCHAR2(30) := 'Add_Conversion_data';
189: l_return_status VARCHAR2(1) := 'S';
190: y_return_status VARCHAR2(1) := 'S';
191: p_update_all VARCHAR2(1) ;
192: l_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
193: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
194:
195: BEGIN
196: IF (l_debug = 'Y') THEN

Line 193: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;

189: l_return_status VARCHAR2(1) := 'S';
190: y_return_status VARCHAR2(1) := 'S';
191: p_update_all VARCHAR2(1) ;
192: l_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
193: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
194:
195: BEGIN
196: IF (l_debug = 'Y') THEN
197: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');

Line 242: OKC_CONTRACT_PUB.update_contract_header(

238: IF (l_debug = 'Y') THEN
239: okc_debug.log('640: Calling update_contract_header');
240: END IF;
241:
242: OKC_CONTRACT_PUB.update_contract_header(
243: p_api_version => g_api_version,
244: p_init_msg_list => g_init_msg_list,
245: x_return_status => l_return_status,
246: x_msg_count => g_msg_count,