APPS.INV_KANBAN_PVT dependencies on FND_API

Line 53: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM

49: /* **
50: Defining a structure of type Pull_sequence_Rec
51: ** */
52: TYPE Pull_Sequence_Rec_Type IS RECORD
53: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM

Line 54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

50: Defining a structure of type Pull_sequence_Rec
51: ** */
52: TYPE Pull_Sequence_Rec_Type IS RECORD
53: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM

Line 55: , organization_id NUMBER := FND_API.G_MISS_NUM

51: ** */
52: TYPE Pull_Sequence_Rec_Type IS RECORD
53: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE

Line 56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR

52: TYPE Pull_Sequence_Rec_Type IS RECORD
53: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM

53: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE

Line 58: , source_type NUMBER := FND_API.G_MISS_NUM

54: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM

Line 59: , last_update_date DATE := FND_API.G_MISS_DATE

55: , organization_id NUMBER := FND_API.G_MISS_NUM
56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM

Line 60: , last_updated_by NUMBER := FND_API.G_MISS_NUM

56: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM

Line 61: , creation_date DATE := FND_API.G_MISS_DATE

57: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM

Line 62: , created_by NUMBER := FND_API.G_MISS_NUM

58: , source_type NUMBER := FND_API.G_MISS_NUM
59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM

Line 63: , locator_id NUMBER := FND_API.G_MISS_NUM

59: , last_update_date DATE := FND_API.G_MISS_DATE
60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 64: , supplier_id NUMBER := FND_API.G_MISS_NUM

60: , last_updated_by NUMBER := FND_API.G_MISS_NUM
61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM

Line 65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM

61: , creation_date DATE := FND_API.G_MISS_DATE
62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM

Line 66: , source_organization_id NUMBER := FND_API.G_MISS_NUM

62: , created_by NUMBER := FND_API.G_MISS_NUM
63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM

Line 67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR

63: , locator_id NUMBER := FND_API.G_MISS_NUM
64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM

Line 68: , source_locator_id NUMBER := FND_API.G_MISS_NUM

64: , supplier_id NUMBER := FND_API.G_MISS_NUM
65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM

Line 69: , wip_line_id NUMBER := FND_API.G_MISS_NUM

65: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM

Line 70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM

66: , source_organization_id NUMBER := FND_API.G_MISS_NUM
67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM

Line 71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM

67: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM

Line 72: , kanban_size NUMBER := FND_API.G_MISS_NUM

68: , source_locator_id NUMBER := FND_API.G_MISS_NUM
69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM

Line 73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM

69: , wip_line_id NUMBER := FND_API.G_MISS_NUM
70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM

Line 74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM

70: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM

Line 75: , number_of_cards NUMBER := FND_API.G_MISS_NUM

71: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM

72: , kanban_size NUMBER := FND_API.G_MISS_NUM
73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM

Line 77: , aggregation_type NUMBER := FND_API.G_MISS_NUM

73: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 78: , allocation_percent NUMBER := FND_API.G_MISS_NUM

74: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 79: , last_update_login NUMBER := FND_API.G_MISS_NUM

75: , number_of_cards NUMBER := FND_API.G_MISS_NUM
76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 80: , updated_flag NUMBER := FND_API.G_MISS_NUM

76: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

77: , aggregation_type NUMBER := FND_API.G_MISS_NUM
78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

78: , allocation_percent NUMBER := FND_API.G_MISS_NUM
79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

79: , last_update_login NUMBER := FND_API.G_MISS_NUM
80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

80: , updated_flag NUMBER := FND_API.G_MISS_NUM
81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

81: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

82: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

83: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

84: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

85: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

86: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

87: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

88: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

89: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM

Line 94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

90: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

91: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM

Line 96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

92: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE

Line 97: , request_id NUMBER := FND_API.G_MISS_NUM

93: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM

Line 98: , program_application_id NUMBER := FND_API.G_MISS_NUM

94: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM

Line 99: , program_id NUMBER := FND_API.G_MISS_NUM

95: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM

Line 100: , program_update_date DATE := FND_API.G_MISS_DATE

96: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM

Line 101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM

97: , request_id NUMBER := FND_API.G_MISS_NUM
98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM

Line 102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM

98: , program_application_id NUMBER := FND_API.G_MISS_NUM
99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
106: , planning_update_status NUMBER := FND_API.G_MISS_NUM

Line 103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM

99: , program_id NUMBER := FND_API.G_MISS_NUM
100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
106: , planning_update_status NUMBER := FND_API.G_MISS_NUM
107: , auto_request VARCHAR2(1) := NULL

Line 104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM

100: , program_update_date DATE := FND_API.G_MISS_DATE
101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
106: , planning_update_status NUMBER := FND_API.G_MISS_NUM
107: , auto_request VARCHAR2(1) := NULL
108: , kanban_card_type NUMBER := NULL

Line 105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM

101: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
106: , planning_update_status NUMBER := FND_API.G_MISS_NUM
107: , auto_request VARCHAR2(1) := NULL
108: , kanban_card_type NUMBER := NULL
109: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.

Line 106: , planning_update_status NUMBER := FND_API.G_MISS_NUM

102: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
103: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
104: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
106: , planning_update_status NUMBER := FND_API.G_MISS_NUM
107: , auto_request VARCHAR2(1) := NULL
108: , kanban_card_type NUMBER := NULL
109: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.
110: );

Line 109: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.

105: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
106: , planning_update_status NUMBER := FND_API.G_MISS_NUM
107: , auto_request VARCHAR2(1) := NULL
108: , kanban_card_type NUMBER := NULL
109: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.
110: );
111:
112:
113:

Line 118: ( kanban_card_id NUMBER := FND_API.g_miss_num

114: /* **
115: Defining a structure of type Kanban_Card_Rec_Type
116: ** */
117: TYPE Kanban_Card_Rec_Type IS RECORD
118: ( kanban_card_id NUMBER := FND_API.g_miss_num
119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char
120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num

Line 119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char

115: Defining a structure of type Kanban_Card_Rec_Type
116: ** */
117: TYPE Kanban_Card_Rec_Type IS RECORD
118: ( kanban_card_id NUMBER := FND_API.g_miss_num
119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char
120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char

Line 120: , pull_sequence_id NUMBER := FND_API.g_miss_num

116: ** */
117: TYPE Kanban_Card_Rec_Type IS RECORD
118: ( kanban_card_id NUMBER := FND_API.g_miss_num
119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char
120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num

Line 121: , inventory_item_id NUMBER := FND_API.g_miss_num

117: TYPE Kanban_Card_Rec_Type IS RECORD
118: ( kanban_card_id NUMBER := FND_API.g_miss_num
119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char
120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num

Line 122: , organization_id NUMBER := FND_API.g_miss_num

118: ( kanban_card_id NUMBER := FND_API.g_miss_num
119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char
120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num

Line 123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char

119: , kanban_card_number VARCHAR2(30) := FND_API.g_miss_char
120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num

Line 124: , supply_status NUMBER := FND_API.g_miss_num

120: , pull_sequence_id NUMBER := FND_API.g_miss_num
121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num

Line 125: , card_status NUMBER := FND_API.g_miss_num

121: , inventory_item_id NUMBER := FND_API.g_miss_num
122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date

Line 126: , kanban_card_type NUMBER := FND_API.g_miss_num

122: , organization_id NUMBER := FND_API.g_miss_num
123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num

Line 127: , source_type NUMBER := FND_API.g_miss_num

123: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date

Line 128: , kanban_size NUMBER := FND_API.g_miss_num

124: , supply_status NUMBER := FND_API.g_miss_num
125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num

Line 129: , last_update_date DATE := FND_API.g_miss_date

125: , card_status NUMBER := FND_API.g_miss_num
126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num

Line 130: , last_updated_by NUMBER := FND_API.g_miss_num

126: , kanban_card_type NUMBER := FND_API.g_miss_num
127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num

Line 131: , creation_date DATE := FND_API.g_miss_date

127: , source_type NUMBER := FND_API.g_miss_num
128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num

Line 132: , created_by NUMBER := FND_API.g_miss_num

128: , kanban_size NUMBER := FND_API.g_miss_num
129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num

Line 133: , locator_id NUMBER := FND_API.g_miss_num

129: , last_update_date DATE := FND_API.g_miss_date
130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char

Line 134: , supplier_id NUMBER := FND_API.g_miss_num

130: , last_updated_by NUMBER := FND_API.g_miss_num
131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num

Line 135: , supplier_site_id NUMBER := FND_API.g_miss_num

131: , creation_date DATE := FND_API.g_miss_date
132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num

Line 136: , source_organization_id NUMBER := FND_API.g_miss_num

132: , created_by NUMBER := FND_API.g_miss_num
133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num

Line 137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char

133: , locator_id NUMBER := FND_API.g_miss_num
134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM

Line 138: , source_locator_id NUMBER := FND_API.g_miss_num

134: , supplier_id NUMBER := FND_API.g_miss_num
135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM

Line 139: , wip_line_id NUMBER := FND_API.g_miss_num

135: , supplier_site_id NUMBER := FND_API.g_miss_num
136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM

Line 140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num

136: , source_organization_id NUMBER := FND_API.g_miss_num
137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char

Line 141: , document_type NUMBER := FND_API.G_MISS_NUM

137: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num

Line 142: , document_header_id NUMBER := FND_API.G_MISS_NUM

138: , source_locator_id NUMBER := FND_API.g_miss_num
139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date

Line 143: , document_detail_id NUMBER := FND_API.G_MISS_NUM

139: , wip_line_id NUMBER := FND_API.g_miss_num
140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char

Line 144: , error_code VARCHAR2(30) := FND_API.g_miss_char

140: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char

Line 145: , last_update_login NUMBER := FND_API.g_miss_num

141: , document_type NUMBER := FND_API.G_MISS_NUM
142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char

Line 146: , last_print_date DATE := FND_API.g_miss_date

142: , document_header_id NUMBER := FND_API.G_MISS_NUM
143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char

Line 147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char

143: , document_detail_id NUMBER := FND_API.G_MISS_NUM
144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char

Line 148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char

144: , error_code VARCHAR2(30) := FND_API.g_miss_char
145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char

Line 149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char

145: , last_update_login NUMBER := FND_API.g_miss_num
146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char

Line 150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char

146: , last_print_date DATE := FND_API.g_miss_date
147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char

Line 151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char

147: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char

Line 152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char

148: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char

Line 153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char

149: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char

Line 154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char

150: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char

Line 155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char

151: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char

Line 156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char

152: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char

Line 157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char

153: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char

Line 158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char

154: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char

Line 159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char

155: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num

Line 160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char

156: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num

Line 161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char

157: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num
165: , program_id NUMBER := FND_API.g_miss_num

Line 162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char

158: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num
165: , program_id NUMBER := FND_API.g_miss_num
166: , program_update_date DATE := FND_API.g_miss_date

Line 163: , request_id NUMBER := FND_API.g_miss_num

159: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num
165: , program_id NUMBER := FND_API.g_miss_num
166: , program_update_date DATE := FND_API.g_miss_date
167: , lot_item_id NUMBER DEFAULT NULL

Line 164: , program_application_id NUMBER := FND_API.g_miss_num

160: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num
165: , program_id NUMBER := FND_API.g_miss_num
166: , program_update_date DATE := FND_API.g_miss_date
167: , lot_item_id NUMBER DEFAULT NULL
168: -- Increased lot size to 80 Char - Mercy Thomas - B4625329

Line 165: , program_id NUMBER := FND_API.g_miss_num

161: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num
165: , program_id NUMBER := FND_API.g_miss_num
166: , program_update_date DATE := FND_API.g_miss_date
167: , lot_item_id NUMBER DEFAULT NULL
168: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
169: , lot_number VARCHAR2(80) DEFAULT NULL

Line 166: , program_update_date DATE := FND_API.g_miss_date

162: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
163: , request_id NUMBER := FND_API.g_miss_num
164: , program_application_id NUMBER := FND_API.g_miss_num
165: , program_id NUMBER := FND_API.g_miss_num
166: , program_update_date DATE := FND_API.g_miss_date
167: , lot_item_id NUMBER DEFAULT NULL
168: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
169: , lot_number VARCHAR2(80) DEFAULT NULL
170: , lot_item_revision VARCHAR2(1) DEFAULT NULL

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

265: p_Supply_Status Number);
266:
267: PROCEDURE Update_Card_Supply_Status
268: ( p_api_version_number IN NUMBER
269: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
270: , p_commit IN VARCHAR2 := FND_API.G_FALSE
271: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
272: , x_return_status OUT NOCOPY VARCHAR2
273: , x_msg_count OUT NOCOPY NUMBER

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

266:
267: PROCEDURE Update_Card_Supply_Status
268: ( p_api_version_number IN NUMBER
269: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
270: , p_commit IN VARCHAR2 := FND_API.G_FALSE
271: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
272: , x_return_status OUT NOCOPY VARCHAR2
273: , x_msg_count OUT NOCOPY NUMBER
274: , x_msg_data OUT NOCOPY VARCHAR2

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

267: PROCEDURE Update_Card_Supply_Status
268: ( p_api_version_number IN NUMBER
269: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
270: , p_commit IN VARCHAR2 := FND_API.G_FALSE
271: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
272: , x_return_status OUT NOCOPY VARCHAR2
273: , x_msg_count OUT NOCOPY NUMBER
274: , x_msg_data OUT NOCOPY VARCHAR2
275: , p_Kanban_Card_Id Number