eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONTRACT_SEQ_PVT dependencies on OKC_K_SEQ_LINES

Line 291: cursor c1(p_line_code okc_k_seq_lines.line_code%TYPE,

287: -- AOL sequence need not be created if the prefix and the suffix
288: -- are already used bu some other detail. Use the same document
289: -- sequence id in this case.
290: --
291: cursor c1(p_line_code okc_k_seq_lines.line_code%TYPE,
292: p_prefix okc_k_seq_lines.contract_number_prefix%TYPE,
293: p_suffix okc_k_seq_lines.contract_Number_suffix%TYPE) is
294: select doc_sequence_id
295: from okc_k_seq_lines

Line 292: p_prefix okc_k_seq_lines.contract_number_prefix%TYPE,

288: -- are already used bu some other detail. Use the same document
289: -- sequence id in this case.
290: --
291: cursor c1(p_line_code okc_k_seq_lines.line_code%TYPE,
292: p_prefix okc_k_seq_lines.contract_number_prefix%TYPE,
293: p_suffix okc_k_seq_lines.contract_Number_suffix%TYPE) is
294: select doc_sequence_id
295: from okc_k_seq_lines
296: where line_code = p_line_code

Line 293: p_suffix okc_k_seq_lines.contract_Number_suffix%TYPE) is

289: -- sequence id in this case.
290: --
291: cursor c1(p_line_code okc_k_seq_lines.line_code%TYPE,
292: p_prefix okc_k_seq_lines.contract_number_prefix%TYPE,
293: p_suffix okc_k_seq_lines.contract_Number_suffix%TYPE) is
294: select doc_sequence_id
295: from okc_k_seq_lines
296: where line_code = p_line_code
297: and ((contract_number_prefix = p_prefix)

Line 295: from okc_k_seq_lines

291: cursor c1(p_line_code okc_k_seq_lines.line_code%TYPE,
292: p_prefix okc_k_seq_lines.contract_number_prefix%TYPE,
293: p_suffix okc_k_seq_lines.contract_Number_suffix%TYPE) is
294: select doc_sequence_id
295: from okc_k_seq_lines
296: where line_code = p_line_code
297: and ((contract_number_prefix = p_prefix)
298: or (contract_number_prefix is null
299: and p_prefix is null))

Line 349: select okc_k_seq_lines_s1.nextval into l_seq from dual;

345: -- If doc sequence does not exist, do the AOL setup here first
346: -- First create the document sequence details.
347: -- Populate fnd_document_sequences table
348: --
349: select okc_k_seq_lines_s1.nextval into l_seq from dual;
350: l_docseq_name := Fnd_Profile.Value('OKC_DOC_SEQUENCE_NAME') ||
351: To_Char(l_seq);
352: l_return_status := Fnd_Seqnum.Define_Doc_Seq
353: (app_id => 510,