APPS.OKC_CFG_PUB dependencies on FND_API

Line 11: id NUMBER := FND_API.G_MISS_NUM,

7: -- config related Contract Line information that is
8: -- obtained from Authoring form OKCAUDET.fmx.
9: -- ---------------------------------------------------------------------------
10: TYPE au_rec_type IS RECORD (
11: id NUMBER := FND_API.G_MISS_NUM,
12: cle_id NUMBER := FND_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,

Line 12: cle_id NUMBER := FND_API.G_MISS_NUM,

8: -- obtained from Authoring form OKCAUDET.fmx.
9: -- ---------------------------------------------------------------------------
10: TYPE au_rec_type IS RECORD (
11: id NUMBER := FND_API.G_MISS_NUM,
12: cle_id NUMBER := FND_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,

Line 13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,

9: -- ---------------------------------------------------------------------------
10: TYPE au_rec_type IS RECORD (
11: id NUMBER := FND_API.G_MISS_NUM,
12: cle_id NUMBER := FND_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,

10: TYPE au_rec_type IS RECORD (
11: id NUMBER := FND_API.G_MISS_NUM,
12: cle_id NUMBER := FND_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,

11: id NUMBER := FND_API.G_MISS_NUM,
12: cle_id NUMBER := FND_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 16: qty NUMBER := FND_API.G_MISS_NUM,

12: cle_id NUMBER := FND_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,

Line 17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

13: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,

Line 18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,

14: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,

15: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,

Line 20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,

16: qty NUMBER := FND_API.G_MISS_NUM,
17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,

Line 21: config_cre_date DATE := FND_API.G_MISS_DATE,

17: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,

Line 22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

18: config_complete_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,

19: config_valid_yn VARCHAR2(3) := FND_API.G_MISS_CHAR,
20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,

Line 24: start_date DATE := FND_API.G_MISS_DATE,

20: inventory_item_id VARCHAR2(100):= FND_API.G_MISS_CHAR,
21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,

Line 25: end_date DATE := FND_API.G_MISS_DATE,

21: config_cre_date DATE := FND_API.G_MISS_DATE,
22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,

Line 26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

22: line_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,

Line 27: lse_id NUMBER := FND_API.G_MISS_NUM,

23: ctx_org VARCHAR2(100):= FND_API.G_MISS_CHAR,
24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 28: price_negotiated NUMBER := FND_API.G_MISS_NUM,

24: start_date DATE := FND_API.G_MISS_DATE,
25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,

Line 29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,

25: end_date DATE := FND_API.G_MISS_DATE,
26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,
33: item_object1_id2 VARCHAR2(200):= FND_API.G_MISS_CHAR

Line 30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,

26: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,
33: item_object1_id2 VARCHAR2(200):= FND_API.G_MISS_CHAR
34: );

Line 31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

27: lse_id NUMBER := FND_API.G_MISS_NUM,
28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,
33: item_object1_id2 VARCHAR2(200):= FND_API.G_MISS_CHAR
34: );
35:

Line 32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,

28: price_negotiated NUMBER := FND_API.G_MISS_NUM,
29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,
33: item_object1_id2 VARCHAR2(200):= FND_API.G_MISS_CHAR
34: );
35:
36: TYPE au_tbl_type IS TABLE OF au_rec_type

Line 33: item_object1_id2 VARCHAR2(200):= FND_API.G_MISS_CHAR

29: hdr_estimated_amt NUMBER := FND_API.G_MISS_NUM,
30: hdr_price_list_id NUMBER := FND_API.G_MISS_NUM,
31: item_jtot_obj_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
32: item_object1_id1 VARCHAR2(40) := FND_API.G_MISS_CHAR,
33: item_object1_id2 VARCHAR2(200):= FND_API.G_MISS_CHAR
34: );
35:
36: TYPE au_tbl_type IS TABLE OF au_rec_type
37: INDEX BY BINARY_INTEGER;

Line 46: config_hdr_id NUMBER := FND_API.G_MISS_NUM,

42: -- to instantiate any config related detailed information
43: -- that is obtained from Oracle Configurator schema.
44: -- ---------------------------------------------------------------------------
45: TYPE config_rec_type IS RECORD (
46: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

Line 47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,

43: -- that is obtained from Oracle Configurator schema.
44: -- ---------------------------------------------------------------------------
45: TYPE config_rec_type IS RECORD (
46: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,

Line 48: config_item_id NUMBER := FND_API.G_MISS_NUM,

44: -- ---------------------------------------------------------------------------
45: TYPE config_rec_type IS RECORD (
46: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,

Line 49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,

45: TYPE config_rec_type IS RECORD (
46: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,

Line 50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

46: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,
54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 51: organization_id NUMBER := FND_API.G_MISS_NUM,

47: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,
54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
55: operation VARCHAR2(10) := FND_API.G_MISS_CHAR );

Line 52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,

48: config_item_id NUMBER := FND_API.G_MISS_NUM,
49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,
54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
55: operation VARCHAR2(10) := FND_API.G_MISS_CHAR );
56:

Line 53: quantity NUMBER := FND_API.G_MISS_NUM,

49: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,
54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
55: operation VARCHAR2(10) := FND_API.G_MISS_CHAR );
56:
57: TYPE config_tbl_type IS TABLE OF config_rec_type

Line 54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

50: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,
54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
55: operation VARCHAR2(10) := FND_API.G_MISS_CHAR );
56:
57: TYPE config_tbl_type IS TABLE OF config_rec_type
58: INDEX BY BINARY_INTEGER;

Line 55: operation VARCHAR2(10) := FND_API.G_MISS_CHAR );

51: organization_id NUMBER := FND_API.G_MISS_NUM,
52: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
53: quantity NUMBER := FND_API.G_MISS_NUM,
54: uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
55: operation VARCHAR2(10) := FND_API.G_MISS_CHAR );
56:
57: TYPE config_tbl_type IS TABLE OF config_rec_type
58: INDEX BY BINARY_INTEGER;
59:

Line 69: config_item_id NUMBER := FND_API.G_MISS_NUM,

65: -- with the new contract line ids including parent ids. The
66: -- model tree is correspondingly created as contract lines.
67: -- ---------------------------------------------------------------------------
68: TYPE cz_track_rec_type IS RECORD (
69: config_item_id NUMBER := FND_API.G_MISS_NUM,
70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,

Line 70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,

66: -- model tree is correspondingly created as contract lines.
67: -- ---------------------------------------------------------------------------
68: TYPE cz_track_rec_type IS RECORD (
69: config_item_id NUMBER := FND_API.G_MISS_NUM,
70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,

Line 71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

67: -- ---------------------------------------------------------------------------
68: TYPE cz_track_rec_type IS RECORD (
69: config_item_id NUMBER := FND_API.G_MISS_NUM,
70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,

Line 72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,

68: TYPE cz_track_rec_type IS RECORD (
69: config_item_id NUMBER := FND_API.G_MISS_NUM,
70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,

Line 73: id NUMBER := FND_API.G_MISS_NUM,

69: config_item_id NUMBER := FND_API.G_MISS_NUM,
70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,

Line 74: chr_id NUMBER := FND_API.G_MISS_NUM,

70: parent_config_item_id NUMBER := FND_API.G_MISS_NUM,
71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,

Line 75: cle_id NUMBER := FND_API.G_MISS_NUM,

71: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,

Line 76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,

72: component_code VARCHAR2(1200) := FND_API.G_MISS_CHAR,
73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
80: organization_id NUMBER := FND_API.G_MISS_NUM,

Line 77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,

73: id NUMBER := FND_API.G_MISS_NUM,
74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
80: organization_id NUMBER := FND_API.G_MISS_NUM,
81: line_index NUMBER := FND_API.G_MISS_NUM );

Line 78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,

74: chr_id NUMBER := FND_API.G_MISS_NUM,
75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
80: organization_id NUMBER := FND_API.G_MISS_NUM,
81: line_index NUMBER := FND_API.G_MISS_NUM );
82:

Line 79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,

75: cle_id NUMBER := FND_API.G_MISS_NUM,
76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
80: organization_id NUMBER := FND_API.G_MISS_NUM,
81: line_index NUMBER := FND_API.G_MISS_NUM );
82:
83: TYPE cz_track_tbl_type IS TABLE OF cz_track_rec_type

Line 80: organization_id NUMBER := FND_API.G_MISS_NUM,

76: dnz_chr_id NUMBER := FND_API.G_MISS_NUM,
77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
80: organization_id NUMBER := FND_API.G_MISS_NUM,
81: line_index NUMBER := FND_API.G_MISS_NUM );
82:
83: TYPE cz_track_tbl_type IS TABLE OF cz_track_rec_type
84: INDEX BY BINARY_INTEGER;

Line 81: line_index NUMBER := FND_API.G_MISS_NUM );

77: top_model_line_id NUMBER := FND_API.G_MISS_NUM,
78: config_hdr_id NUMBER := FND_API.G_MISS_NUM,
79: config_rev_nbr NUMBER := FND_API.G_MISS_NUM,
80: organization_id NUMBER := FND_API.G_MISS_NUM,
81: line_index NUMBER := FND_API.G_MISS_NUM );
82:
83: TYPE cz_track_tbl_type IS TABLE OF cz_track_rec_type
84: INDEX BY BINARY_INTEGER;
85:

Line 121: p_api_version_number IN NUMBER := FND_API.G_MISS_NUM,

117: -- gets the configuration details from the
118: -- CZ schema tables join to OKC lines table.
119: -- ---------------------------------------------------------------------------
120: PROCEDURE build_cle_from_cz (
121: p_api_version_number IN NUMBER := FND_API.G_MISS_NUM,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_config_complete_yn IN VARCHAR2 := 'N',
125: p_config_valid_yn IN VARCHAR2 := 'N',

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

118: -- CZ schema tables join to OKC lines table.
119: -- ---------------------------------------------------------------------------
120: PROCEDURE build_cle_from_cz (
121: p_api_version_number IN NUMBER := FND_API.G_MISS_NUM,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_config_complete_yn IN VARCHAR2 := 'N',
125: p_config_valid_yn IN VARCHAR2 := 'N',
126: p_au_line_rec IN OKC_CFG_PUB.au_rec_type,

Line 123: p_commit IN VARCHAR2 := FND_API.G_FALSE,

119: -- ---------------------------------------------------------------------------
120: PROCEDURE build_cle_from_cz (
121: p_api_version_number IN NUMBER := FND_API.G_MISS_NUM,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_config_complete_yn IN VARCHAR2 := 'N',
125: p_config_valid_yn IN VARCHAR2 := 'N',
126: p_au_line_rec IN OKC_CFG_PUB.au_rec_type,
127: p_config_rec IN OKC_CFG_PUB.config_rec_type,