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.AHL_MM_RESERVATIONS_PVT dependencies on FND_API

Line 22: reservation_id NUMBER := fnd_api.g_miss_num

18:
19: -- TYPES are inv_reservation_global.mtl_reservation_rec_type , INVRSVGS.pls
20: TYPE mtl_reservation_rec_type is RECORD
21: (
22: reservation_id NUMBER := fnd_api.g_miss_num
23: , requirement_date DATE := fnd_api.g_miss_date
24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num

Line 23: , requirement_date DATE := fnd_api.g_miss_date

19: -- TYPES are inv_reservation_global.mtl_reservation_rec_type , INVRSVGS.pls
20: TYPE mtl_reservation_rec_type is RECORD
21: (
22: reservation_id NUMBER := fnd_api.g_miss_num
23: , requirement_date DATE := fnd_api.g_miss_date
24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char

Line 24: , organization_id NUMBER := fnd_api.g_miss_num

20: TYPE mtl_reservation_rec_type is RECORD
21: (
22: reservation_id NUMBER := fnd_api.g_miss_num
23: , requirement_date DATE := fnd_api.g_miss_date
24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num

Line 25: , inventory_item_id NUMBER := fnd_api.g_miss_num

21: (
22: reservation_id NUMBER := fnd_api.g_miss_num
23: , requirement_date DATE := fnd_api.g_miss_date
24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num

Line 26: , demand_source_type_id NUMBER := fnd_api.g_miss_num

22: reservation_id NUMBER := fnd_api.g_miss_num
23: , requirement_date DATE := fnd_api.g_miss_date
24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num

Line 27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char

23: , requirement_date DATE := fnd_api.g_miss_date
24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

Line 28: , demand_source_header_id NUMBER := fnd_api.g_miss_num

24: , organization_id NUMBER := fnd_api.g_miss_num
25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num

Line 29: , demand_source_line_id NUMBER := fnd_api.g_miss_num

25: , inventory_item_id NUMBER := fnd_api.g_miss_num
26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

Line 30: , demand_source_delivery NUMBER := fnd_api.g_miss_num

26: , demand_source_type_id NUMBER := fnd_api.g_miss_num
27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num

Line 31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

27: , demand_source_name VARCHAR2(30) := fnd_api.g_miss_char
28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char

Line 32: , primary_uom_id NUMBER := fnd_api.g_miss_num

28: , demand_source_header_id NUMBER := fnd_api.g_miss_num
29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num

Line 33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char

29: , demand_source_line_id NUMBER := fnd_api.g_miss_num
30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num

Line 34: , secondary_uom_id NUMBER := fnd_api.g_miss_num

30: , demand_source_delivery NUMBER := fnd_api.g_miss_num
31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num

Line 35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char

31: , primary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num

Line 36: , reservation_uom_id NUMBER := fnd_api.g_miss_num

32: , primary_uom_id NUMBER := fnd_api.g_miss_num
33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num

Line 37: , reservation_quantity NUMBER := fnd_api.g_miss_num

33: , secondary_uom_code VARCHAR2(3) := fnd_api.g_miss_char
34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num

Line 38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num

34: , secondary_uom_id NUMBER := fnd_api.g_miss_num
35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num

Line 39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num

35: , reservation_uom_code VARCHAR2(3) := fnd_api.g_miss_char
36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char

Line 40: , detailed_quantity NUMBER := fnd_api.g_miss_num

36: , reservation_uom_id NUMBER := fnd_api.g_miss_num
37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num

Line 41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num

37: , reservation_quantity NUMBER := fnd_api.g_miss_num
38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num

Line 42: , autodetail_group_id NUMBER := fnd_api.g_miss_num

38: , primary_reservation_quantity NUMBER := fnd_api.g_miss_num
39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num

Line 43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char

39: , secondary_reservation_quantity NUMBER := fnd_api.g_miss_num
40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num

Line 44: , external_source_line_id NUMBER := fnd_api.g_miss_num

40: , detailed_quantity NUMBER := fnd_api.g_miss_num
41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char

Line 45: , supply_source_type_id NUMBER := fnd_api.g_miss_num

41: , secondary_detailed_quantity NUMBER := fnd_api.g_miss_num
42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num

Line 46: , supply_source_header_id NUMBER := fnd_api.g_miss_num

42: , autodetail_group_id NUMBER := fnd_api.g_miss_num
43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char

Line 47: , supply_source_line_id NUMBER := fnd_api.g_miss_num

43: , external_source_code VARCHAR2(30) := fnd_api.g_miss_char
44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char

Line 48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char

44: , external_source_line_id NUMBER := fnd_api.g_miss_num
45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num

Line 49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num

45: , supply_source_type_id NUMBER := fnd_api.g_miss_num
46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num

Line 50: , revision VARCHAR2(3) := fnd_api.g_miss_char

46: , supply_source_header_id NUMBER := fnd_api.g_miss_num
47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char

Line 51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char

47: , supply_source_line_id NUMBER := fnd_api.g_miss_num
48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num

Line 52: , subinventory_id NUMBER := fnd_api.g_miss_num

48: , supply_source_name VARCHAR2(30) := fnd_api.g_miss_char
49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num

Line 53: , locator_id NUMBER := fnd_api.g_miss_num

49: , supply_source_line_detail NUMBER := fnd_api.g_miss_num
50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num

Line 54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char

50: , revision VARCHAR2(3) := fnd_api.g_miss_char
51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char

Line 55: , lot_number_id NUMBER := fnd_api.g_miss_num

51: , subinventory_code VARCHAR2(10) := fnd_api.g_miss_char
52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char

Line 56: , pick_slip_number NUMBER := fnd_api.g_miss_num

52: , subinventory_id NUMBER := fnd_api.g_miss_num
53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char

Line 57: , lpn_id NUMBER := fnd_api.g_miss_num

53: , locator_id NUMBER := fnd_api.g_miss_num
54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char

Line 58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char

54: , lot_number VARCHAR2(80) := fnd_api.g_miss_char
55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char

Line 59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char

55: , lot_number_id NUMBER := fnd_api.g_miss_num
56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char

Line 60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char

56: , pick_slip_number NUMBER := fnd_api.g_miss_num
57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char

Line 61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char

57: , lpn_id NUMBER := fnd_api.g_miss_num
58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char

Line 62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char

58: , attribute_category VARCHAR2(30) := fnd_api.g_miss_char
59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char

Line 63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char

59: , attribute1 VARCHAR2(150) := fnd_api.g_miss_char
60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char

Line 64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char

60: , attribute2 VARCHAR2(150) := fnd_api.g_miss_char
61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char

Line 65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char

61: , attribute3 VARCHAR2(150) := fnd_api.g_miss_char
62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char

Line 66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char

62: , attribute4 VARCHAR2(150) := fnd_api.g_miss_char
63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char

Line 67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char

63: , attribute5 VARCHAR2(150) := fnd_api.g_miss_char
64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char

Line 68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char

64: , attribute6 VARCHAR2(150) := fnd_api.g_miss_char
65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char

Line 69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char

65: , attribute7 VARCHAR2(150) := fnd_api.g_miss_char
66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char

Line 70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char

66: , attribute8 VARCHAR2(150) := fnd_api.g_miss_char
67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num

Line 71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char

67: , attribute9 VARCHAR2(150) := fnd_api.g_miss_char
68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char

Line 72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char

68: , attribute10 VARCHAR2(150) := fnd_api.g_miss_char
69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char

Line 73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char

69: , attribute11 VARCHAR2(150) := fnd_api.g_miss_char
70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num

Line 74: , ship_ready_flag NUMBER := fnd_api.g_miss_num

70: , attribute12 VARCHAR2(150) := fnd_api.g_miss_char
71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num

Line 75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char

71: , attribute13 VARCHAR2(150) := fnd_api.g_miss_char
72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num

Line 76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char

72: , attribute14 VARCHAR2(150) := fnd_api.g_miss_char
73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date

Line 77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num

73: , attribute15 VARCHAR2(150) := fnd_api.g_miss_char
74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date

Line 78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num

74: , ship_ready_flag NUMBER := fnd_api.g_miss_num
75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num

Line 79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num

75: , staged_flag VARCHAR2(1) := fnd_api.g_miss_char
76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num

Line 80: , supply_receipt_date DATE := fnd_api.g_miss_date

76: , crossdock_flag VARCHAR2(1) := fnd_api.g_miss_char
77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num

Line 81: , demand_ship_date DATE := fnd_api.g_miss_date

77: , crossdock_criteria_id NUMBER := fnd_api.g_miss_num
78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num

Line 82: , project_id NUMBER := fnd_api.g_miss_num

78: , demand_source_line_detail NUMBER := fnd_api.g_miss_num
79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num

Line 83: , task_id NUMBER := fnd_api.g_miss_num

79: , serial_reservation_quantity NUMBER := fnd_api.g_miss_num
80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num

Line 84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num

80: , supply_receipt_date DATE := fnd_api.g_miss_date
81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num

Line 85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num

81: , demand_ship_date DATE := fnd_api.g_miss_date
82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num

Line 86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num

82: , project_id NUMBER := fnd_api.g_miss_num
83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num

Line 87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num

83: , task_id NUMBER := fnd_api.g_miss_num
84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num

Line 88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num

84: , orig_supply_source_type_id NUMBER := fnd_api.g_miss_num
85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
92: , serial_number VARCHAR2(30) := fnd_api.g_miss_char

Line 89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num

85: , orig_supply_source_header_id NUMBER := fnd_api.g_miss_num
86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
92: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
93: );

Line 90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num

86: , orig_supply_source_line_id NUMBER := fnd_api.g_miss_num
87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
92: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
93: );
94:

Line 91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num

87: , orig_supply_source_line_detail NUMBER := fnd_api.g_miss_num
88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
92: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
93: );
94:
95: TYPE number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 92: , serial_number VARCHAR2(30) := fnd_api.g_miss_char

88: , orig_demand_source_type_id NUMBER := fnd_api.g_miss_num
89: , orig_demand_source_header_id NUMBER := fnd_api.g_miss_num
90: , orig_demand_source_line_id NUMBER := fnd_api.g_miss_num
91: , orig_demand_source_line_detail NUMBER := fnd_api.g_miss_num
92: , serial_number VARCHAR2(30) := fnd_api.g_miss_char
93: );
94:
95: TYPE number_table_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
96: TYPE varchar_table_type IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

Line 108: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

104: -- Function : Reserves the serial numbers in the p_serial_number_tbl
105: -- Pre-reqs :
106: -- Standard IN Parameters :
107: -- p_api_version IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
111: -- p_module_type IN VARCHAR2 Default NULL
112: -- Standard OUT Parameters :

Line 109: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

105: -- Pre-reqs :
106: -- Standard IN Parameters :
107: -- p_api_version IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
111: -- p_module_type IN VARCHAR2 Default NULL
112: -- Standard OUT Parameters :
113: -- x_return_status OUT VARCHAR2 Required

Line 110: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

106: -- Standard IN Parameters :
107: -- p_api_version IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
111: -- p_module_type IN VARCHAR2 Default NULL
112: -- Standard OUT Parameters :
113: -- x_return_status OUT VARCHAR2 Required
114: -- x_msg_count OUT NUMBER Required

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

139: -- End of Comments.
140: ---------------------------------------------------------------------------------------------------------
141: PROCEDURE CREATE_RESERVATION(
142: p_api_version IN NUMBER := 1.0,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_module_type IN VARCHAR2,
147: x_return_status OUT NOCOPY VARCHAR2,

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

140: ---------------------------------------------------------------------------------------------------------
141: PROCEDURE CREATE_RESERVATION(
142: p_api_version IN NUMBER := 1.0,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_module_type IN VARCHAR2,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,

Line 145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

141: PROCEDURE CREATE_RESERVATION(
142: p_api_version IN NUMBER := 1.0,
143: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144: p_commit IN VARCHAR2 := FND_API.G_FALSE,
145: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: p_module_type IN VARCHAR2,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,

Line 165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

161: -- Function : Updates reservation attributes for the reservation : p_reservation_id
162: -- Pre-reqs :
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- p_module_type IN VARCHAR2 Default NULL
169: -- Standard OUT Parameters :

Line 166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

162: -- Pre-reqs :
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- p_module_type IN VARCHAR2 Default NULL
169: -- Standard OUT Parameters :
170: -- x_return_status OUT VARCHAR2 Required

Line 167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- p_module_type IN VARCHAR2 Default NULL
169: -- Standard OUT Parameters :
170: -- x_return_status OUT VARCHAR2 Required
171: -- x_msg_count OUT NUMBER Required

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

181: -- End of Comments.
182: ---------------------------------------------------------------------------------------------------------
183: PROCEDURE UPDATE_RESERVATION(
184: p_api_version IN NUMBER := 1.0,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_TRUE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: p_module_type IN VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,

Line 186: p_commit IN VARCHAR2 := FND_API.G_TRUE,

182: ---------------------------------------------------------------------------------------------------------
183: PROCEDURE UPDATE_RESERVATION(
184: p_api_version IN NUMBER := 1.0,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_TRUE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: p_module_type IN VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,

Line 187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

183: PROCEDURE UPDATE_RESERVATION(
184: p_api_version IN NUMBER := 1.0,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_TRUE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: p_module_type IN VARCHAR2,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,

Line 207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

203: -- Function : API to delete the reservation made for a requirement asainst p_reservation_id
204: -- Pre-reqs :
205: -- Standard IN Parameters :
206: -- p_api_version IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
210: -- p_module_type IN VARCHAR2 Default NULL
211: -- Standard OUT Parameters :

Line 208: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

204: -- Pre-reqs :
205: -- Standard IN Parameters :
206: -- p_api_version IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
210: -- p_module_type IN VARCHAR2 Default NULL
211: -- Standard OUT Parameters :
212: -- x_return_status OUT VARCHAR2 Required

Line 209: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

205: -- Standard IN Parameters :
206: -- p_api_version IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
210: -- p_module_type IN VARCHAR2 Default NULL
211: -- Standard OUT Parameters :
212: -- x_return_status OUT VARCHAR2 Required
213: -- x_msg_count OUT NUMBER Required

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

220: -- End of Comments.
221: ---------------------------------------------------------------------------------------------------------
222: PROCEDURE DELETE_RESERVATION(
223: p_api_version IN NUMBER := 1.0,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: p_module_type IN VARCHAR2,
228: x_return_status OUT NOCOPY VARCHAR2,

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

221: ---------------------------------------------------------------------------------------------------------
222: PROCEDURE DELETE_RESERVATION(
223: p_api_version IN NUMBER := 1.0,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: p_module_type IN VARCHAR2,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,

Line 226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

222: PROCEDURE DELETE_RESERVATION(
223: p_api_version IN NUMBER := 1.0,
224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
225: p_commit IN VARCHAR2 := FND_API.G_FALSE,
226: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
227: p_module_type IN VARCHAR2,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,

Line 244: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

240: -- Function : API to delete a particular serial number from the reservation.
241: -- Pre-reqs :
242: -- Standard IN Parameters :
243: -- p_api_version IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
247: -- p_module_type IN VARCHAR2 Default NULL
248: -- Standard OUT Parameters :

Line 245: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

241: -- Pre-reqs :
242: -- Standard IN Parameters :
243: -- p_api_version IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
247: -- p_module_type IN VARCHAR2 Default NULL
248: -- Standard OUT Parameters :
249: -- x_return_status OUT VARCHAR2 Required

Line 246: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

242: -- Standard IN Parameters :
243: -- p_api_version IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
247: -- p_module_type IN VARCHAR2 Default NULL
248: -- Standard OUT Parameters :
249: -- x_return_status OUT VARCHAR2 Required
250: -- x_msg_count OUT NUMBER Required

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

258: -- End of Comments.
259: ---------------------------------------------------------------------------------------------------------
260: PROCEDURE RELIEVE_RESERVATION(
261: p_api_version IN NUMBER := 1.0,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_module_type IN VARCHAR2,
266: x_return_status OUT NOCOPY VARCHAR2,

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

259: ---------------------------------------------------------------------------------------------------------
260: PROCEDURE RELIEVE_RESERVATION(
261: p_api_version IN NUMBER := 1.0,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_module_type IN VARCHAR2,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,

Line 264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

260: PROCEDURE RELIEVE_RESERVATION(
261: p_api_version IN NUMBER := 1.0,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: p_module_type IN VARCHAR2,
266: x_return_status OUT NOCOPY VARCHAR2,
267: x_msg_count OUT NOCOPY NUMBER,
268: x_msg_data OUT NOCOPY VARCHAR2,

Line 283: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

279: -- Used only when supply source type value changes (eg. IR to INV or INV to WO kind).
280: -- Pre-reqs :
281: -- Standard IN Parameters :
282: -- p_api_version IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
286: -- p_module_type IN VARCHAR2 Default NULL
287: -- Standard OUT Parameters :

Line 284: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

280: -- Pre-reqs :
281: -- Standard IN Parameters :
282: -- p_api_version IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
286: -- p_module_type IN VARCHAR2 Default NULL
287: -- Standard OUT Parameters :
288: -- x_return_status OUT VARCHAR2 Required

Line 285: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

281: -- Standard IN Parameters :
282: -- p_api_version IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
286: -- p_module_type IN VARCHAR2 Default NULL
287: -- Standard OUT Parameters :
288: -- x_return_status OUT VARCHAR2 Required
289: -- x_msg_count OUT NUMBER Required

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

316: -- End of Comments.
317: ---------------------------------------------------------------------------------------------------------
318: PROCEDURE TRANSFER_RESERVATION(
319: p_api_version IN NUMBER := 1.0,
320: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
321: p_commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: p_module_type IN VARCHAR2,
324: x_return_status OUT NOCOPY VARCHAR2,

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

317: ---------------------------------------------------------------------------------------------------------
318: PROCEDURE TRANSFER_RESERVATION(
319: p_api_version IN NUMBER := 1.0,
320: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
321: p_commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: p_module_type IN VARCHAR2,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,

Line 322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

318: PROCEDURE TRANSFER_RESERVATION(
319: p_api_version IN NUMBER := 1.0,
320: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
321: p_commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: p_module_type IN VARCHAR2,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,

Line 343: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

339: -- Function : API to create/update/transfer the reservation for a particular requirement and serials combination.
340: -- Pre-reqs :
341: -- Standard IN Parameters :
342: -- p_api_version IN NUMBER Required
343: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
344: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
346: -- p_module_type IN VARCHAR2 Default NULL
347: -- Standard OUT Parameters :

Line 344: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

340: -- Pre-reqs :
341: -- Standard IN Parameters :
342: -- p_api_version IN NUMBER Required
343: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
344: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
346: -- p_module_type IN VARCHAR2 Default NULL
347: -- Standard OUT Parameters :
348: -- x_return_status OUT VARCHAR2 Required

Line 345: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

341: -- Standard IN Parameters :
342: -- p_api_version IN NUMBER Required
343: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
344: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
346: -- p_module_type IN VARCHAR2 Default NULL
347: -- Standard OUT Parameters :
348: -- x_return_status OUT VARCHAR2 Required
349: -- x_msg_count OUT NUMBER Required

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

368: -- End of Comments.
369: ---------------------------------------------------------------------------------------------------------
370: PROCEDURE PROCESS_RESERVATION(
371: p_api_version IN NUMBER := 1.0,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_module_type IN VARCHAR2,
376: x_return_status OUT NOCOPY VARCHAR2,

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

369: ---------------------------------------------------------------------------------------------------------
370: PROCEDURE PROCESS_RESERVATION(
371: p_api_version IN NUMBER := 1.0,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_module_type IN VARCHAR2,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,

Line 374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

370: PROCEDURE PROCESS_RESERVATION(
371: p_api_version IN NUMBER := 1.0,
372: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
373: p_commit IN VARCHAR2 := FND_API.G_FALSE,
374: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
375: p_module_type IN VARCHAR2,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2,

Line 394: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

390: -- Function : API to relieve given serial numbers from their respective reservation.
391: -- Pre-reqs :
392: -- Standard IN Parameters :
393: -- p_api_version IN NUMBER Required
394: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
397: -- p_module_type IN VARCHAR2 Default NULL
398: -- Standard OUT Parameters :

Line 395: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

391: -- Pre-reqs :
392: -- Standard IN Parameters :
393: -- p_api_version IN NUMBER Required
394: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
397: -- p_module_type IN VARCHAR2 Default NULL
398: -- Standard OUT Parameters :
399: -- x_return_status OUT VARCHAR2 Required

Line 396: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

392: -- Standard IN Parameters :
393: -- p_api_version IN NUMBER Required
394: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
397: -- p_module_type IN VARCHAR2 Default NULL
398: -- Standard OUT Parameters :
399: -- x_return_status OUT VARCHAR2 Required
400: -- x_msg_count OUT NUMBER Required

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

411: -- End of Comments.
412: ---------------------------------------------------------------------------------------------------------
413: PROCEDURE CANCEL_RESERVATION(
414: p_api_version IN NUMBER := 1.0,
415: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416: p_commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: p_module_type IN VARCHAR2,
419: x_return_status OUT NOCOPY VARCHAR2,

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

412: ---------------------------------------------------------------------------------------------------------
413: PROCEDURE CANCEL_RESERVATION(
414: p_api_version IN NUMBER := 1.0,
415: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416: p_commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: p_module_type IN VARCHAR2,
419: x_return_status OUT NOCOPY VARCHAR2,
420: x_msg_count OUT NOCOPY NUMBER,

Line 417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

413: PROCEDURE CANCEL_RESERVATION(
414: p_api_version IN NUMBER := 1.0,
415: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
416: p_commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: p_module_type IN VARCHAR2,
419: x_return_status OUT NOCOPY VARCHAR2,
420: x_msg_count OUT NOCOPY NUMBER,
421: x_msg_data OUT NOCOPY VARCHAR2,