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_KSQ_PVT dependencies on OKC_K_SEQ_LINES

Line 18: okc_k_seq_lines.doc_sequence_id%TYPE Index By Binary_Integer;

14:
15: g_seq_header seq_header;
16:
17: Type doc_sequence_id_tbl Is Table Of
18: okc_k_seq_lines.doc_sequence_id%TYPE Index By Binary_Integer;
19: Type business_group_id_tbl Is Table Of
20: okc_k_seq_lines.business_group_id%TYPE Index By Binary_Integer;
21: Type operating_unit_id_tbl Is Table Of
22: okc_k_seq_lines.operating_unit_id%TYPE Index By Binary_Integer;

Line 20: okc_k_seq_lines.business_group_id%TYPE Index By Binary_Integer;

16:
17: Type doc_sequence_id_tbl Is Table Of
18: okc_k_seq_lines.doc_sequence_id%TYPE Index By Binary_Integer;
19: Type business_group_id_tbl Is Table Of
20: okc_k_seq_lines.business_group_id%TYPE Index By Binary_Integer;
21: Type operating_unit_id_tbl Is Table Of
22: okc_k_seq_lines.operating_unit_id%TYPE Index By Binary_Integer;
23: Type cls_code_tbl Is Table Of
24: okc_k_seq_lines.cls_code%TYPE Index By Binary_Integer;

Line 22: okc_k_seq_lines.operating_unit_id%TYPE Index By Binary_Integer;

18: okc_k_seq_lines.doc_sequence_id%TYPE Index By Binary_Integer;
19: Type business_group_id_tbl Is Table Of
20: okc_k_seq_lines.business_group_id%TYPE Index By Binary_Integer;
21: Type operating_unit_id_tbl Is Table Of
22: okc_k_seq_lines.operating_unit_id%TYPE Index By Binary_Integer;
23: Type cls_code_tbl Is Table Of
24: okc_k_seq_lines.cls_code%TYPE Index By Binary_Integer;
25: Type scs_code_tbl Is Table Of
26: okc_k_seq_lines.scs_code%TYPE Index By Binary_Integer;

Line 24: okc_k_seq_lines.cls_code%TYPE Index By Binary_Integer;

20: okc_k_seq_lines.business_group_id%TYPE Index By Binary_Integer;
21: Type operating_unit_id_tbl Is Table Of
22: okc_k_seq_lines.operating_unit_id%TYPE Index By Binary_Integer;
23: Type cls_code_tbl Is Table Of
24: okc_k_seq_lines.cls_code%TYPE Index By Binary_Integer;
25: Type scs_code_tbl Is Table Of
26: okc_k_seq_lines.scs_code%TYPE Index By Binary_Integer;
27: Type manual_override_yn_tbl Is Table Of
28: okc_k_seq_lines.manual_override_yn%TYPE Index By Binary_Integer;

Line 26: okc_k_seq_lines.scs_code%TYPE Index By Binary_Integer;

22: okc_k_seq_lines.operating_unit_id%TYPE Index By Binary_Integer;
23: Type cls_code_tbl Is Table Of
24: okc_k_seq_lines.cls_code%TYPE Index By Binary_Integer;
25: Type scs_code_tbl Is Table Of
26: okc_k_seq_lines.scs_code%TYPE Index By Binary_Integer;
27: Type manual_override_yn_tbl Is Table Of
28: okc_k_seq_lines.manual_override_yn%TYPE Index By Binary_Integer;
29: Type contract_number_prefix_tbl Is Table Of
30: okc_k_seq_lines.contract_number_prefix%TYPE Index By Binary_Integer;

Line 28: okc_k_seq_lines.manual_override_yn%TYPE Index By Binary_Integer;

24: okc_k_seq_lines.cls_code%TYPE Index By Binary_Integer;
25: Type scs_code_tbl Is Table Of
26: okc_k_seq_lines.scs_code%TYPE Index By Binary_Integer;
27: Type manual_override_yn_tbl Is Table Of
28: okc_k_seq_lines.manual_override_yn%TYPE Index By Binary_Integer;
29: Type contract_number_prefix_tbl Is Table Of
30: okc_k_seq_lines.contract_number_prefix%TYPE Index By Binary_Integer;
31: Type contract_number_suffix_tbl Is Table Of
32: okc_k_seq_lines.contract_number_suffix%TYPE Index By Binary_Integer;

Line 30: okc_k_seq_lines.contract_number_prefix%TYPE Index By Binary_Integer;

26: okc_k_seq_lines.scs_code%TYPE Index By Binary_Integer;
27: Type manual_override_yn_tbl Is Table Of
28: okc_k_seq_lines.manual_override_yn%TYPE Index By Binary_Integer;
29: Type contract_number_prefix_tbl Is Table Of
30: okc_k_seq_lines.contract_number_prefix%TYPE Index By Binary_Integer;
31: Type contract_number_suffix_tbl Is Table Of
32: okc_k_seq_lines.contract_number_suffix%TYPE Index By Binary_Integer;
33: Type number_format_length_tbl Is Table Of
34: okc_k_seq_lines.number_format_length%TYPE Index By Binary_Integer;

Line 32: okc_k_seq_lines.contract_number_suffix%TYPE Index By Binary_Integer;

28: okc_k_seq_lines.manual_override_yn%TYPE Index By Binary_Integer;
29: Type contract_number_prefix_tbl Is Table Of
30: okc_k_seq_lines.contract_number_prefix%TYPE Index By Binary_Integer;
31: Type contract_number_suffix_tbl Is Table Of
32: okc_k_seq_lines.contract_number_suffix%TYPE Index By Binary_Integer;
33: Type number_format_length_tbl Is Table Of
34: okc_k_seq_lines.number_format_length%TYPE Index By Binary_Integer;
35: Type start_seq_no_tbl Is Table Of
36: okc_k_seq_lines.start_seq_no%TYPE Index By Binary_Integer;

Line 34: okc_k_seq_lines.number_format_length%TYPE Index By Binary_Integer;

30: okc_k_seq_lines.contract_number_prefix%TYPE Index By Binary_Integer;
31: Type contract_number_suffix_tbl Is Table Of
32: okc_k_seq_lines.contract_number_suffix%TYPE Index By Binary_Integer;
33: Type number_format_length_tbl Is Table Of
34: okc_k_seq_lines.number_format_length%TYPE Index By Binary_Integer;
35: Type start_seq_no_tbl Is Table Of
36: okc_k_seq_lines.start_seq_no%TYPE Index By Binary_Integer;
37: Type end_seq_no_tbl Is Table Of
38: okc_k_seq_lines.end_seq_no%TYPE Index By Binary_Integer;

Line 36: okc_k_seq_lines.start_seq_no%TYPE Index By Binary_Integer;

32: okc_k_seq_lines.contract_number_suffix%TYPE Index By Binary_Integer;
33: Type number_format_length_tbl Is Table Of
34: okc_k_seq_lines.number_format_length%TYPE Index By Binary_Integer;
35: Type start_seq_no_tbl Is Table Of
36: okc_k_seq_lines.start_seq_no%TYPE Index By Binary_Integer;
37: Type end_seq_no_tbl Is Table Of
38: okc_k_seq_lines.end_seq_no%TYPE Index By Binary_Integer;
39:
40: g_doc_sequence_id_tbl doc_sequence_id_tbl;

Line 38: okc_k_seq_lines.end_seq_no%TYPE Index By Binary_Integer;

34: okc_k_seq_lines.number_format_length%TYPE Index By Binary_Integer;
35: Type start_seq_no_tbl Is Table Of
36: okc_k_seq_lines.start_seq_no%TYPE Index By Binary_Integer;
37: Type end_seq_no_tbl Is Table Of
38: okc_k_seq_lines.end_seq_no%TYPE Index By Binary_Integer;
39:
40: g_doc_sequence_id_tbl doc_sequence_id_tbl;
41: g_business_group_id_tbl business_group_id_tbl;
42: g_operating_unit_id_tbl operating_unit_id_tbl;

Line 2353: from okc_k_seq_lines

2349: contract_number_suffix,
2350: number_format_length,
2351: start_seq_no,
2352: end_seq_no
2353: from okc_k_seq_lines
2354: where line_code = p_line_code;
2355:
2356: cursor csr_cls is
2357: select cls_code