DBA Data[Home] [Help]

APPS.OKC_EURO_CONV_PUB dependencies on OKC_K_HEADERS_B

Line 20: FUNCTION set_header_rec(p_chr_rec OKC_K_HEADERS_B%ROWTYPE, x_return_status OUT NOCOPY VARCHAR2 )

16: --Set header rec:
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;

Line 179: ----This procecure is added for rules migration, conversion data now resides in okc_k_headers_b

175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
176: End ;
177:
178:
179: ----This procecure is added for rules migration, conversion data now resides in okc_k_headers_b
180: --Add conversion data
181: --This procedure updates the header record if no/incomplete conversion data
182: ----
183:

Line 184: Procedure Add_conversion_data(p_contracts_rec IN okc_k_headers_b%rowtype,

180: --Add conversion data
181: --This procedure updates the header record if no/incomplete conversion data
182: ----
183:
184: Procedure Add_conversion_data(p_contracts_rec IN okc_k_headers_b%rowtype,
185: p_update_mode IN VARCHAR2 ,
186: x_return_status OUT NOCOPY VARCHAR2 ) is
187:
188: l_proc VARCHAR2(30) := 'Add_Conversion_data';

Line 306: from okc_k_headers_b CHRB, okc_subclasses_b SCS

302:
303:
304: Cursor contracts_csr is
305: Select CHRB.*
306: from okc_k_headers_b CHRB, okc_subclasses_b SCS
307: where CHRB.template_yn='N'
308: and (CHRB.sts_code in (select code from okc_statuses_b
309: where ste_code in ('ACTIVE','SIGNED','HOLD'))
310: OR