13:
14: -- Flow_Schedule record type
15:
16: TYPE Flow_Schedule_Rec_Type IS RECORD
17: ( alternate_bom_designator VARCHAR2(10) := FND_API.G_MISS_CHAR
18: , alternate_routing_desig VARCHAR2(10) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: -- Flow_Schedule record type
15:
16: TYPE Flow_Schedule_Rec_Type IS RECORD
17: ( alternate_bom_designator VARCHAR2(10) := FND_API.G_MISS_CHAR
18: , alternate_routing_desig VARCHAR2(10) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
15:
16: TYPE Flow_Schedule_Rec_Type IS RECORD
17: ( alternate_bom_designator VARCHAR2(10) := FND_API.G_MISS_CHAR
18: , alternate_routing_desig VARCHAR2(10) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: TYPE Flow_Schedule_Rec_Type IS RECORD
17: ( alternate_bom_designator VARCHAR2(10) := FND_API.G_MISS_CHAR
18: , alternate_routing_desig VARCHAR2(10) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ( alternate_bom_designator VARCHAR2(10) := FND_API.G_MISS_CHAR
18: , alternate_routing_desig VARCHAR2(10) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , alternate_routing_desig VARCHAR2(10) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
28: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
29: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
30: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
31: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
32: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
33: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
34: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
35: , bom_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
36: , bom_revision_date DATE := FND_API.G_MISS_DATE
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
37: , build_sequence NUMBER := FND_API.G_MISS_NUM
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
38: , class_code VARCHAR2(10) := FND_API.G_MISS_CHAR
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
39: , completion_locator_id NUMBER := FND_API.G_MISS_NUM
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
40: , completion_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
41: , created_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
42: , creation_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
43: , date_closed DATE := FND_API.G_MISS_DATE
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
44: , demand_class VARCHAR2(30) := FND_API.G_MISS_CHAR
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
45: , demand_source_delivery VARCHAR2(30) := FND_API.G_MISS_CHAR
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
46: , demand_source_header_id NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
47: , demand_source_line VARCHAR2(30) := FND_API.G_MISS_CHAR
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
48: , demand_source_type NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
49: , last_updated_by NUMBER := FND_API.G_MISS_NUM
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
50: , last_update_date DATE := FND_API.G_MISS_DATE
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
51: , last_update_login NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
52: , line_id NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
53: , material_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
54: , material_overhead_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
55: , material_variance_account NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
56: , mps_net_quantity NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
57: , mps_scheduled_comp_date DATE := FND_API.G_MISS_DATE
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
58: , organization_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
59: , outside_processing_acct NUMBER := FND_API.G_MISS_NUM
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
60: , outside_proc_var_acct NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
61: , overhead_account NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
62: , overhead_variance_account NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
63: , planned_quantity NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
64: , primary_item_id NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
65: , program_application_id NUMBER := FND_API.G_MISS_NUM
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
66: , program_id NUMBER := FND_API.G_MISS_NUM
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
67: , program_update_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
68: , project_id NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
69: , quantity_completed NUMBER := FND_API.G_MISS_NUM
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
70: , request_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
71: , resource_account NUMBER := FND_API.G_MISS_NUM
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
72: , resource_variance_account NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
73: , routing_revision VARCHAR2(3) := FND_API.G_MISS_CHAR
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
74: , routing_revision_date DATE := FND_API.G_MISS_DATE
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
75: , scheduled_completion_date DATE := FND_API.G_MISS_DATE
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
76: , scheduled_flag NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
77: , scheduled_start_date DATE := FND_API.G_MISS_DATE
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , schedule_group_id NUMBER := FND_API.G_MISS_NUM
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
79: , schedule_number VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , status NUMBER := FND_API.G_MISS_NUM
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
81: , std_cost_adjustment_acct NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
82: , task_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
83: , wip_entity_id NUMBER := FND_API.G_MISS_NUM
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
91: , synch_schedule_num VARCHAR2(30) := FND_API.G_MISS_CHAR
84: , scheduled_by NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
91: , synch_schedule_num VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , synch_operation_seq_num NUMBER := FND_API.G_MISS_NUM
85: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
91: , synch_schedule_num VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , synch_operation_seq_num NUMBER := FND_API.G_MISS_NUM
93: , roll_forwarded_flag NUMBER
86: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
91: , synch_schedule_num VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , synch_operation_seq_num NUMBER := FND_API.G_MISS_NUM
93: , roll_forwarded_flag NUMBER
94: , current_line_operation NUMBER
87: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
91: , synch_schedule_num VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , synch_operation_seq_num NUMBER := FND_API.G_MISS_NUM
93: , roll_forwarded_flag NUMBER
94: , current_line_operation NUMBER
95: );
88: , end_item_unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , quantity_scrapped NUMBER := FND_API.G_MISS_NUM
90: , kanban_card_id NUMBER := FND_API.G_MISS_NUM
91: , synch_schedule_num VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , synch_operation_seq_num NUMBER := FND_API.G_MISS_NUM
93: , roll_forwarded_flag NUMBER
94: , current_line_operation NUMBER
95: );
96:
99:
100: -- Flow_Schedule value record type
101:
102: TYPE Flow_Schedule_Val_Rec_Type IS RECORD
103: ( completion_locator VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , line VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
100: -- Flow_Schedule value record type
101:
102: TYPE Flow_Schedule_Val_Rec_Type IS RECORD
103: ( completion_locator VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , line VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
101:
102: TYPE Flow_Schedule_Val_Rec_Type IS RECORD
103: ( completion_locator VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , line VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , task VARCHAR2(240) := FND_API.G_MISS_CHAR
102: TYPE Flow_Schedule_Val_Rec_Type IS RECORD
103: ( completion_locator VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , line VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , task VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , wip_entity VARCHAR2(240) := FND_API.G_MISS_CHAR
103: ( completion_locator VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , line VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , task VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , wip_entity VARCHAR2(240) := FND_API.G_MISS_CHAR
111: );
104: , line VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , task VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , wip_entity VARCHAR2(240) := FND_API.G_MISS_CHAR
111: );
112:
105: , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , task VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , wip_entity VARCHAR2(240) := FND_API.G_MISS_CHAR
111: );
112:
113: TYPE Flow_Schedule_Val_Tbl_Type IS TABLE OF Flow_Schedule_Val_Rec_Type
106: , primary_item VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , project VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , schedule_group VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , task VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , wip_entity VARCHAR2(240) := FND_API.G_MISS_CHAR
111: );
112:
113: TYPE Flow_Schedule_Val_Tbl_Type IS TABLE OF Flow_Schedule_Val_Rec_Type
114: INDEX BY BINARY_INTEGER;
149: /*#
150: * The Process_Flow_Schedule API is used to create, update and delete a flow schedule.
151: * @param p_api_version_number API version number
152: * @paraminfo {@rep:required}
153: * @param p_init_msg_list Pass fnd_api.g_false or fnd_api.g_true to determin whether to clear message stack or not
154: * @param p_return_values Return values
155: * @param p_commit Pass fnd_api.g_false or fnd_api.g_true to determin whether to commit or not
156: * @param x_return_status Return status
157: * @param x_msg_count Number of messages
151: * @param p_api_version_number API version number
152: * @paraminfo {@rep:required}
153: * @param p_init_msg_list Pass fnd_api.g_false or fnd_api.g_true to determin whether to clear message stack or not
154: * @param p_return_values Return values
155: * @param p_commit Pass fnd_api.g_false or fnd_api.g_true to determin whether to commit or not
156: * @param x_return_status Return status
157: * @param x_msg_count Number of messages
158: * @param x_msg_data Message data
159: * @param p_flow_schedule_rec Input flow schedule record of type MRP_FLOW_SCHEDULE_PUB. FLOW_SCHEDULE_REC_TYPE. Default value: G_MISS_FLOW_SCHEDULE_VAL_REC
166: * @rep:displayname Process Flow Schedule
167: */
168: PROCEDURE Process_Flow_Schedule
169: ( p_api_version_number IN NUMBER
170: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
171: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
172: , p_commit IN VARCHAR2 := FND_API.G_FALSE
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
167: */
168: PROCEDURE Process_Flow_Schedule
169: ( p_api_version_number IN NUMBER
170: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
171: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
172: , p_commit IN VARCHAR2 := FND_API.G_FALSE
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2
168: PROCEDURE Process_Flow_Schedule
169: ( p_api_version_number IN NUMBER
170: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
171: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
172: , p_commit IN VARCHAR2 := FND_API.G_FALSE
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2
176: , p_flow_schedule_rec IN Flow_Schedule_Rec_Type :=
209: */
210:
211: PROCEDURE Lock_Flow_Schedule
212: ( p_api_version_number IN NUMBER
213: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
214: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
215: , x_return_status OUT NOCOPY VARCHAR2
216: , x_msg_count OUT NOCOPY NUMBER
217: , x_msg_data OUT NOCOPY VARCHAR2
210:
211: PROCEDURE Lock_Flow_Schedule
212: ( p_api_version_number IN NUMBER
213: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
214: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
215: , x_return_status OUT NOCOPY VARCHAR2
216: , x_msg_count OUT NOCOPY NUMBER
217: , x_msg_data OUT NOCOPY VARCHAR2
218: , p_flow_schedule_rec IN Flow_Schedule_Rec_Type :=
247: /*#
248: * The Get_Flow_Schedule API is to get the information for the a flow schedule.
249: * @param p_api_version_number API version number
250: * @paraminfo {@rep:required}
251: * @param p_init_msg_list Pass fnd_api.g_false or fnd_api.g_true to determin whether to clear message stack or not
252: * @param p_return_values Return values
253: * @param x_return_status Return status
254: * @param x_msg_count Number of messages
255: * @param x_msg_data Message data
262: * @rep:displayname Get Flow Schedule
263: */
264: PROCEDURE Get_Flow_Schedule
265: ( p_api_version_number IN NUMBER
266: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
267: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
268: , x_return_status OUT NOCOPY VARCHAR2
269: , x_msg_count OUT NOCOPY NUMBER
270: , x_msg_data OUT NOCOPY VARCHAR2
263: */
264: PROCEDURE Get_Flow_Schedule
265: ( p_api_version_number IN NUMBER
266: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
267: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
268: , x_return_status OUT NOCOPY VARCHAR2
269: , x_msg_count OUT NOCOPY NUMBER
270: , x_msg_data OUT NOCOPY VARCHAR2
271: , p_wip_entity_id IN NUMBER :=
268: , x_return_status OUT NOCOPY VARCHAR2
269: , x_msg_count OUT NOCOPY NUMBER
270: , x_msg_data OUT NOCOPY VARCHAR2
271: , p_wip_entity_id IN NUMBER :=
272: FND_API.G_MISS_NUM
273: , p_wip_entity IN VARCHAR2 :=
274: FND_API.G_MISS_CHAR
275: , x_flow_schedule_rec OUT NOCOPY Flow_Schedule_Rec_Type
276: , x_flow_schedule_val_rec OUT NOCOPY Flow_Schedule_Val_Rec_Type
270: , x_msg_data OUT NOCOPY VARCHAR2
271: , p_wip_entity_id IN NUMBER :=
272: FND_API.G_MISS_NUM
273: , p_wip_entity IN VARCHAR2 :=
274: FND_API.G_MISS_CHAR
275: , x_flow_schedule_rec OUT NOCOPY Flow_Schedule_Rec_Type
276: , x_flow_schedule_val_rec OUT NOCOPY Flow_Schedule_Val_Rec_Type
277: );
278: