APPS.INV_KANBAN_PVT dependencies on FND_API

Line 61: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM

57: /* **
58: Defining a structure of type Pull_sequence_Rec
59: ** */
60: TYPE Pull_Sequence_Rec_Type IS RECORD
61: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM

Line 62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM

58: Defining a structure of type Pull_sequence_Rec
59: ** */
60: TYPE Pull_Sequence_Rec_Type IS RECORD
61: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM

Line 63: , organization_id NUMBER := FND_API.G_MISS_NUM

59: ** */
60: TYPE Pull_Sequence_Rec_Type IS RECORD
61: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE

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

60: TYPE Pull_Sequence_Rec_Type IS RECORD
61: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM

61: ( pull_sequence_id NUMBER := FND_API.G_MISS_NUM
62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE

Line 66: , source_type NUMBER := FND_API.G_MISS_NUM

62: , inventory_item_id NUMBER := FND_API.G_MISS_NUM
63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM

Line 67: , last_update_date DATE := FND_API.G_MISS_DATE

63: , organization_id NUMBER := FND_API.G_MISS_NUM
64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM

Line 68: , last_updated_by NUMBER := FND_API.G_MISS_NUM

64: , subinventory_name VARCHAR2(10) := FND_API.G_MISS_CHAR
65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM

Line 69: , creation_date DATE := FND_API.G_MISS_DATE

65: , Kanban_plan_id NUMBER := FND_API.G_MISS_NUM
66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM

Line 70: , created_by NUMBER := FND_API.G_MISS_NUM

66: , source_type NUMBER := FND_API.G_MISS_NUM
67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM

Line 71: , locator_id NUMBER := FND_API.G_MISS_NUM

67: , last_update_date DATE := FND_API.G_MISS_DATE
68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 72: , supplier_id NUMBER := FND_API.G_MISS_NUM

68: , last_updated_by NUMBER := FND_API.G_MISS_NUM
69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM

Line 73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM

69: , creation_date DATE := FND_API.G_MISS_DATE
70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM

Line 74: , source_organization_id NUMBER := FND_API.G_MISS_NUM

70: , created_by NUMBER := FND_API.G_MISS_NUM
71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM

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

71: , locator_id NUMBER := FND_API.G_MISS_NUM
72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM

Line 76: , source_locator_id NUMBER := FND_API.G_MISS_NUM

72: , supplier_id NUMBER := FND_API.G_MISS_NUM
73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM

Line 77: , wip_line_id NUMBER := FND_API.G_MISS_NUM

73: , supplier_site_id NUMBER := FND_API.G_MISS_NUM
74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM

Line 78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM

74: , source_organization_id NUMBER := FND_API.G_MISS_NUM
75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM

Line 79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM

75: , source_subinventory VARCHAR2(10) := FND_API.G_MISS_CHAR
76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM

Line 80: , kanban_size NUMBER := FND_API.G_MISS_NUM

76: , source_locator_id NUMBER := FND_API.G_MISS_NUM
77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM

Line 81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM

77: , wip_line_id NUMBER := FND_API.G_MISS_NUM
78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM

Line 82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM

78: , replenishment_lead_time NUMBER := FND_API.G_MISS_NUM
79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM

Line 83: , number_of_cards NUMBER := FND_API.G_MISS_NUM

79: , calculate_kanban_flag NUMBER := FND_API.G_MISS_NUM
80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM

80: , kanban_size NUMBER := FND_API.G_MISS_NUM
81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM

Line 85: , aggregation_type NUMBER := FND_API.G_MISS_NUM

81: , fixed_lot_multiplier NUMBER := FND_API.G_MISS_NUM
82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 86: , allocation_percent NUMBER := FND_API.G_MISS_NUM

82: , safety_stock_days NUMBER := FND_API.G_MISS_NUM
83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 87: , last_update_login NUMBER := FND_API.G_MISS_NUM

83: , number_of_cards NUMBER := FND_API.G_MISS_NUM
84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 88: , updated_flag NUMBER := FND_API.G_MISS_NUM

84: , minimum_order_quantity NUMBER := FND_API.G_MISS_NUM
85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

85: , aggregation_type NUMBER := FND_API.G_MISS_NUM
86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

86: , allocation_percent NUMBER := FND_API.G_MISS_NUM
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

88: , updated_flag NUMBER := FND_API.G_MISS_NUM
89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

89: , attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

90: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

91: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

92: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

93: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

94: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

95: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

96: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

97: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM

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

98: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM

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

99: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM

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

100: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE

Line 105: , request_id NUMBER := FND_API.G_MISS_NUM

101: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM

Line 106: , program_application_id NUMBER := FND_API.G_MISS_NUM

102: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM

Line 107: , program_id NUMBER := FND_API.G_MISS_NUM

103: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM

Line 108: , program_update_date DATE := FND_API.G_MISS_DATE

104: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM

Line 109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM

105: , request_id NUMBER := FND_API.G_MISS_NUM
106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM

Line 110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM

106: , program_application_id NUMBER := FND_API.G_MISS_NUM
107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
114: , planning_update_status NUMBER := FND_API.G_MISS_NUM

Line 111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM

107: , program_id NUMBER := FND_API.G_MISS_NUM
108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
114: , planning_update_status NUMBER := FND_API.G_MISS_NUM
115: , auto_request VARCHAR2(1) := NULL

Line 112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM

108: , program_update_date DATE := FND_API.G_MISS_DATE
109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
114: , planning_update_status NUMBER := FND_API.G_MISS_NUM
115: , auto_request VARCHAR2(1) := NULL
116: , kanban_card_type NUMBER := NULL

Line 113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM

109: , release_kanban_flag NUMBER := FND_API.G_MISS_NUM
110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
114: , planning_update_status NUMBER := FND_API.G_MISS_NUM
115: , auto_request VARCHAR2(1) := NULL
116: , kanban_card_type NUMBER := NULL
117: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.

Line 114: , planning_update_status NUMBER := FND_API.G_MISS_NUM

110: , point_of_use_x NUMBER := FND_API.G_MISS_NUM
111: , point_of_use_y NUMBER := FND_API.G_MISS_NUM
112: , point_of_supply_x NUMBER := FND_API.G_MISS_NUM
113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
114: , planning_update_status NUMBER := FND_API.G_MISS_NUM
115: , auto_request VARCHAR2(1) := NULL
116: , kanban_card_type NUMBER := NULL
117: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.
118: -- eKanban Changes

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

113: , point_of_supply_y NUMBER := FND_API.G_MISS_NUM
114: , planning_update_status NUMBER := FND_API.G_MISS_NUM
115: , auto_request VARCHAR2(1) := NULL
116: , kanban_card_type NUMBER := NULL
117: , auto_allocate_flag NUMBER := FND_API.G_MISS_NUM --Added for 3905884.
118: -- eKanban Changes
119: , replenishment_type NUMBER := NULL
120: , future_card_size NUMBER := NULL
121: , future_no_of_cards NUMBER := NULL

Line 138: ( kanban_card_id NUMBER := FND_API.g_miss_num

134: /* **
135: Defining a structure of type Kanban_Card_Rec_Type
136: ** */
137: TYPE Kanban_Card_Rec_Type IS RECORD
138: ( kanban_card_id NUMBER := FND_API.g_miss_num
139: /* eKanban Changes */
140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char
141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num

Line 140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char

136: ** */
137: TYPE Kanban_Card_Rec_Type IS RECORD
138: ( kanban_card_id NUMBER := FND_API.g_miss_num
139: /* eKanban Changes */
140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char
141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char

Line 141: , pull_sequence_id NUMBER := FND_API.g_miss_num

137: TYPE Kanban_Card_Rec_Type IS RECORD
138: ( kanban_card_id NUMBER := FND_API.g_miss_num
139: /* eKanban Changes */
140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char
141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num

Line 142: , inventory_item_id NUMBER := FND_API.g_miss_num

138: ( kanban_card_id NUMBER := FND_API.g_miss_num
139: /* eKanban Changes */
140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char
141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num

Line 143: , organization_id NUMBER := FND_API.g_miss_num

139: /* eKanban Changes */
140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char
141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num

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

140: , kanban_card_number VARCHAR2(200) := FND_API.g_miss_char
141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num

Line 145: , supply_status NUMBER := FND_API.g_miss_num

141: , pull_sequence_id NUMBER := FND_API.g_miss_num
142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num

Line 146: , card_status NUMBER := FND_API.g_miss_num

142: , inventory_item_id NUMBER := FND_API.g_miss_num
143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date

Line 147: , kanban_card_type NUMBER := FND_API.g_miss_num

143: , organization_id NUMBER := FND_API.g_miss_num
144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num

Line 148: , source_type NUMBER := FND_API.g_miss_num

144: , subinventory_name VARCHAR2(10) := FND_API.g_miss_char
145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date

Line 149: , kanban_size NUMBER := FND_API.g_miss_num

145: , supply_status NUMBER := FND_API.g_miss_num
146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num

Line 150: , last_update_date DATE := FND_API.g_miss_date

146: , card_status NUMBER := FND_API.g_miss_num
147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num

Line 151: , last_updated_by NUMBER := FND_API.g_miss_num

147: , kanban_card_type NUMBER := FND_API.g_miss_num
148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num

Line 152: , creation_date DATE := FND_API.g_miss_date

148: , source_type NUMBER := FND_API.g_miss_num
149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num

Line 153: , created_by NUMBER := FND_API.g_miss_num

149: , kanban_size NUMBER := FND_API.g_miss_num
150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num

Line 154: , locator_id NUMBER := FND_API.g_miss_num

150: , last_update_date DATE := FND_API.g_miss_date
151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char

Line 155: , supplier_id NUMBER := FND_API.g_miss_num

151: , last_updated_by NUMBER := FND_API.g_miss_num
152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num

Line 156: , supplier_site_id NUMBER := FND_API.g_miss_num

152: , creation_date DATE := FND_API.g_miss_date
153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num

Line 157: , source_organization_id NUMBER := FND_API.g_miss_num

153: , created_by NUMBER := FND_API.g_miss_num
154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num

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

154: , locator_id NUMBER := FND_API.g_miss_num
155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM

Line 159: , source_locator_id NUMBER := FND_API.g_miss_num

155: , supplier_id NUMBER := FND_API.g_miss_num
156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM

Line 160: , wip_line_id NUMBER := FND_API.g_miss_num

156: , supplier_site_id NUMBER := FND_API.g_miss_num
157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM

Line 161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num

157: , source_organization_id NUMBER := FND_API.g_miss_num
158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char

Line 162: , document_type NUMBER := FND_API.G_MISS_NUM

158: , source_subinventory VARCHAR2(10) := FND_API.g_miss_char
159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num

Line 163: , document_header_id NUMBER := FND_API.G_MISS_NUM

159: , source_locator_id NUMBER := FND_API.g_miss_num
160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date

Line 164: , document_detail_id NUMBER := FND_API.G_MISS_NUM

160: , wip_line_id NUMBER := FND_API.g_miss_num
161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char

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

161: , current_replnsh_cycle_id NUMBER := FND_API.g_miss_num
162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char

Line 166: , last_update_login NUMBER := FND_API.g_miss_num

162: , document_type NUMBER := FND_API.G_MISS_NUM
163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char

Line 167: , last_print_date DATE := FND_API.g_miss_date

163: , document_header_id NUMBER := FND_API.G_MISS_NUM
164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char

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

164: , document_detail_id NUMBER := FND_API.G_MISS_NUM
165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char

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

165: , error_code VARCHAR2(30) := FND_API.g_miss_char
166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char

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

166: , last_update_login NUMBER := FND_API.g_miss_num
167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char

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

167: , last_print_date DATE := FND_API.g_miss_date
168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char

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

168: , attribute_category VARCHAR2(30) := FND_API.g_miss_char
169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char

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

169: , attribute1 VARCHAR2(150) := FND_API.g_miss_char
170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char

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

170: , attribute2 VARCHAR2(150) := FND_API.g_miss_char
171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char

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

171: , attribute3 VARCHAR2(150) := FND_API.g_miss_char
172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char

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

172: , attribute4 VARCHAR2(150) := FND_API.g_miss_char
173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char

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

173: , attribute5 VARCHAR2(150) := FND_API.g_miss_char
174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char

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

174: , attribute6 VARCHAR2(150) := FND_API.g_miss_char
175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char

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

175: , attribute7 VARCHAR2(150) := FND_API.g_miss_char
176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char

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

176: , attribute8 VARCHAR2(150) := FND_API.g_miss_char
177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num

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

177: , attribute9 VARCHAR2(150) := FND_API.g_miss_char
178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num

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

178: , attribute10 VARCHAR2(150) := FND_API.g_miss_char
179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num
186: , program_id NUMBER := FND_API.g_miss_num

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

179: , attribute11 VARCHAR2(150) := FND_API.g_miss_char
180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num
186: , program_id NUMBER := FND_API.g_miss_num
187: , program_update_date DATE := FND_API.g_miss_date

Line 184: , request_id NUMBER := FND_API.g_miss_num

180: , attribute12 VARCHAR2(150) := FND_API.g_miss_char
181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num
186: , program_id NUMBER := FND_API.g_miss_num
187: , program_update_date DATE := FND_API.g_miss_date
188: , lot_item_id NUMBER DEFAULT NULL

Line 185: , program_application_id NUMBER := FND_API.g_miss_num

181: , attribute13 VARCHAR2(150) := FND_API.g_miss_char
182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num
186: , program_id NUMBER := FND_API.g_miss_num
187: , program_update_date DATE := FND_API.g_miss_date
188: , lot_item_id NUMBER DEFAULT NULL
189: -- Increased lot size to 80 Char - Mercy Thomas - B4625329

Line 186: , program_id NUMBER := FND_API.g_miss_num

182: , attribute14 VARCHAR2(150) := FND_API.g_miss_char
183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num
186: , program_id NUMBER := FND_API.g_miss_num
187: , program_update_date DATE := FND_API.g_miss_date
188: , lot_item_id NUMBER DEFAULT NULL
189: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
190: , lot_number VARCHAR2(80) DEFAULT NULL

Line 187: , program_update_date DATE := FND_API.g_miss_date

183: , attribute15 VARCHAR2(150) := FND_API.g_miss_char
184: , request_id NUMBER := FND_API.g_miss_num
185: , program_application_id NUMBER := FND_API.g_miss_num
186: , program_id NUMBER := FND_API.g_miss_num
187: , program_update_date DATE := FND_API.g_miss_date
188: , lot_item_id NUMBER DEFAULT NULL
189: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
190: , lot_number VARCHAR2(80) DEFAULT NULL
191: , lot_item_revision VARCHAR2(3) DEFAULT NULL /* Bug12875778 Changed the length from 1 to 3*/

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

293: p_Supply_Status Number);
294:
295: PROCEDURE Update_Card_Supply_Status
296: ( p_api_version_number IN NUMBER
297: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
298: , p_commit IN VARCHAR2 := FND_API.G_FALSE
299: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
300: , x_return_status OUT NOCOPY VARCHAR2
301: , x_msg_count OUT NOCOPY NUMBER

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

294:
295: PROCEDURE Update_Card_Supply_Status
296: ( p_api_version_number IN NUMBER
297: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
298: , p_commit IN VARCHAR2 := FND_API.G_FALSE
299: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
300: , x_return_status OUT NOCOPY VARCHAR2
301: , x_msg_count OUT NOCOPY NUMBER
302: , x_msg_data OUT NOCOPY VARCHAR2

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

295: PROCEDURE Update_Card_Supply_Status
296: ( p_api_version_number IN NUMBER
297: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
298: , p_commit IN VARCHAR2 := FND_API.G_FALSE
299: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
300: , x_return_status OUT NOCOPY VARCHAR2
301: , x_msg_count OUT NOCOPY NUMBER
302: , x_msg_data OUT NOCOPY VARCHAR2
303: , p_Kanban_Card_Id Number