APPS.OKC_LSQ_PVT dependencies on OKC_K_SEQ_LINES

Line 8: line_code OKC_K_SEQ_LINES.LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE lsq_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: line_code OKC_K_SEQ_LINES.LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: doc_sequence_id NUMBER := OKC_API.G_MISS_NUM,
10: business_group_id NUMBER := OKC_API.G_MISS_NUM,
11: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
12: cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 12: cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,

8: line_code OKC_K_SEQ_LINES.LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: doc_sequence_id NUMBER := OKC_API.G_MISS_NUM,
10: business_group_id NUMBER := OKC_API.G_MISS_NUM,
11: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
12: cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: contract_number_prefix OKC_K_SEQ_LINES.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
15: contract_number_suffix OKC_K_SEQ_LINES.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
16: number_format_length NUMBER := OKC_API.G_MISS_NUM,

Line 13: scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,

9: doc_sequence_id NUMBER := OKC_API.G_MISS_NUM,
10: business_group_id NUMBER := OKC_API.G_MISS_NUM,
11: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
12: cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: contract_number_prefix OKC_K_SEQ_LINES.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
15: contract_number_suffix OKC_K_SEQ_LINES.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
16: number_format_length NUMBER := OKC_API.G_MISS_NUM,
17: start_seq_no NUMBER := OKC_API.G_MISS_NUM,

Line 14: contract_number_prefix OKC_K_SEQ_LINES.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,

10: business_group_id NUMBER := OKC_API.G_MISS_NUM,
11: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
12: cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: contract_number_prefix OKC_K_SEQ_LINES.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
15: contract_number_suffix OKC_K_SEQ_LINES.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
16: number_format_length NUMBER := OKC_API.G_MISS_NUM,
17: start_seq_no NUMBER := OKC_API.G_MISS_NUM,
18: end_seq_no NUMBER := OKC_API.G_MISS_NUM,

Line 15: contract_number_suffix OKC_K_SEQ_LINES.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,

11: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
12: cls_code OKC_K_SEQ_LINES.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: scs_code OKC_K_SEQ_LINES.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: contract_number_prefix OKC_K_SEQ_LINES.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
15: contract_number_suffix OKC_K_SEQ_LINES.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
16: number_format_length NUMBER := OKC_API.G_MISS_NUM,
17: start_seq_no NUMBER := OKC_API.G_MISS_NUM,
18: end_seq_no NUMBER := OKC_API.G_MISS_NUM,
19: manual_override_yn OKC_K_SEQ_LINES.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 19: manual_override_yn OKC_K_SEQ_LINES.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,

15: contract_number_suffix OKC_K_SEQ_LINES.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
16: number_format_length NUMBER := OKC_API.G_MISS_NUM,
17: start_seq_no NUMBER := OKC_API.G_MISS_NUM,
18: end_seq_no NUMBER := OKC_API.G_MISS_NUM,
19: manual_override_yn OKC_K_SEQ_LINES.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_K_SEQ_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 22: creation_date OKC_K_SEQ_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

18: end_seq_no NUMBER := OKC_API.G_MISS_NUM,
19: manual_override_yn OKC_K_SEQ_LINES.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,
20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_K_SEQ_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_K_SEQ_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM);
26: g_miss_lsq_rec lsq_rec_type;

Line 24: last_update_date OKC_K_SEQ_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

20: object_version_number NUMBER := OKC_API.G_MISS_NUM,
21: created_by NUMBER := OKC_API.G_MISS_NUM,
22: creation_date OKC_K_SEQ_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
23: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
24: last_update_date OKC_K_SEQ_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_update_login NUMBER := OKC_API.G_MISS_NUM);
26: g_miss_lsq_rec lsq_rec_type;
27: TYPE lsq_tbl_type IS TABLE OF lsq_rec_type
28: INDEX BY BINARY_INTEGER;

Line 31: line_code OKC_K_SEQ_LINES_V.LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,

27: TYPE lsq_tbl_type IS TABLE OF lsq_rec_type
28: INDEX BY BINARY_INTEGER;
29: TYPE lsqv_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM,
31: line_code OKC_K_SEQ_LINES_V.LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
32: doc_sequence_id NUMBER := OKC_API.G_MISS_NUM,
33: business_group_id NUMBER := OKC_API.G_MISS_NUM,
34: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
35: cls_code OKC_K_SEQ_LINES_V.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 35: cls_code OKC_K_SEQ_LINES_V.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,

31: line_code OKC_K_SEQ_LINES_V.LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
32: doc_sequence_id NUMBER := OKC_API.G_MISS_NUM,
33: business_group_id NUMBER := OKC_API.G_MISS_NUM,
34: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
35: cls_code OKC_K_SEQ_LINES_V.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: scs_code OKC_K_SEQ_LINES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: contract_number_prefix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
38: contract_number_suffix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
39: number_format_length NUMBER := OKC_API.G_MISS_NUM,

Line 36: scs_code OKC_K_SEQ_LINES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,

32: doc_sequence_id NUMBER := OKC_API.G_MISS_NUM,
33: business_group_id NUMBER := OKC_API.G_MISS_NUM,
34: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
35: cls_code OKC_K_SEQ_LINES_V.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: scs_code OKC_K_SEQ_LINES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: contract_number_prefix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
38: contract_number_suffix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
39: number_format_length NUMBER := OKC_API.G_MISS_NUM,
40: start_seq_no NUMBER := OKC_API.G_MISS_NUM,

Line 37: contract_number_prefix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,

33: business_group_id NUMBER := OKC_API.G_MISS_NUM,
34: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
35: cls_code OKC_K_SEQ_LINES_V.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: scs_code OKC_K_SEQ_LINES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: contract_number_prefix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
38: contract_number_suffix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
39: number_format_length NUMBER := OKC_API.G_MISS_NUM,
40: start_seq_no NUMBER := OKC_API.G_MISS_NUM,
41: end_seq_no NUMBER := OKC_API.G_MISS_NUM,

Line 38: contract_number_suffix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,

34: operating_unit_id NUMBER := OKC_API.G_MISS_NUM,
35: cls_code OKC_K_SEQ_LINES_V.CLS_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: scs_code OKC_K_SEQ_LINES_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: contract_number_prefix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_PREFIX%TYPE := OKC_API.G_MISS_CHAR,
38: contract_number_suffix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
39: number_format_length NUMBER := OKC_API.G_MISS_NUM,
40: start_seq_no NUMBER := OKC_API.G_MISS_NUM,
41: end_seq_no NUMBER := OKC_API.G_MISS_NUM,
42: manual_override_yn OKC_K_SEQ_LINES_V.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 42: manual_override_yn OKC_K_SEQ_LINES_V.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,

38: contract_number_suffix OKC_K_SEQ_LINES_V.CONTRACT_NUMBER_SUFFIX%TYPE := OKC_API.G_MISS_CHAR,
39: number_format_length NUMBER := OKC_API.G_MISS_NUM,
40: start_seq_no NUMBER := OKC_API.G_MISS_NUM,
41: end_seq_no NUMBER := OKC_API.G_MISS_NUM,
42: manual_override_yn OKC_K_SEQ_LINES_V.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKC_K_SEQ_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 45: creation_date OKC_K_SEQ_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

41: end_seq_no NUMBER := OKC_API.G_MISS_NUM,
42: manual_override_yn OKC_K_SEQ_LINES_V.MANUAL_OVERRIDE_YN%TYPE := OKC_API.G_MISS_CHAR,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKC_K_SEQ_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKC_K_SEQ_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: g_miss_lsqv_rec lsqv_rec_type;

Line 47: last_update_date OKC_K_SEQ_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: created_by NUMBER := OKC_API.G_MISS_NUM,
45: creation_date OKC_K_SEQ_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47: last_update_date OKC_K_SEQ_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_update_login NUMBER := OKC_API.G_MISS_NUM);
49: g_miss_lsqv_rec lsqv_rec_type;
50: TYPE lsqv_tbl_type IS TABLE OF lsqv_rec_type
51: INDEX BY BINARY_INTEGER;