DBA Data[Home] [Help]

APPS.GMI_RESERVATION_PUB dependencies on INV_RESERVATION_GLOBAL

Line 52: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type

48: , x_return_status OUT NOCOPY VARCHAR2
49: , x_msg_count OUT NOCOPY NUMBER
50: , x_msg_data OUT NOCOPY VARCHAR2
51: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
52: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
53: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
54: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
55: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
56: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

Line 54: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

50: , x_msg_data OUT NOCOPY VARCHAR2
51: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
52: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
53: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
54: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
55: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
56: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
57: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
58: , x_error_code OUT NOCOPY NUMBER

Line 55: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

51: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
52: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
53: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
54: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
55: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
56: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
57: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
58: , x_error_code OUT NOCOPY NUMBER
59: );

Line 56: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

52: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
53: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
54: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
55: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
56: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
57: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
58: , x_error_code OUT NOCOPY NUMBER
59: );
60:

Line 69: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

65: , x_return_status OUT NOCOPY VARCHAR2
66: , x_msg_count OUT NOCOPY NUMBER
67: , x_msg_data OUT NOCOPY VARCHAR2
68: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
69: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
70: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
71: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
72: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
73: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

Line 70: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

66: , x_msg_count OUT NOCOPY NUMBER
67: , x_msg_data OUT NOCOPY VARCHAR2
68: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
69: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
70: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
71: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
72: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
73: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
74: , x_quantity_reserved OUT NOCOPY NUMBER

Line 71: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type

67: , x_msg_data OUT NOCOPY VARCHAR2
68: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
69: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
70: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
71: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
72: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
73: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
74: , x_quantity_reserved OUT NOCOPY NUMBER
75: , x_reservation_id OUT NOCOPY NUMBER

Line 86: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

82: , x_return_status OUT NOCOPY VARCHAR2
83: , x_msg_count OUT NOCOPY NUMBER
84: , x_msg_data OUT NOCOPY VARCHAR2
85: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
87: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
88: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
89: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
90: );

Line 87: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

83: , x_msg_count OUT NOCOPY NUMBER
84: , x_msg_data OUT NOCOPY VARCHAR2
85: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
87: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
88: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
89: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
90: );
91:

Line 88: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

84: , x_msg_data OUT NOCOPY VARCHAR2
85: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
87: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
88: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
89: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
90: );
91:
92: PROCEDURE Delete_Reservation

Line 89: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

85: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
86: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
87: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
88: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
89: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
90: );
91:
92: PROCEDURE Delete_Reservation
93: (

Line 100: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

96: , x_return_status OUT NOCOPY VARCHAR2
97: , x_msg_count OUT NOCOPY NUMBER
98: , x_msg_data OUT NOCOPY VARCHAR2
99: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
100: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
101: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
102: );
103:
104: PROCEDURE Transfer_Reservation

Line 101: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

97: , x_msg_count OUT NOCOPY NUMBER
98: , x_msg_data OUT NOCOPY VARCHAR2
99: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
100: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
101: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
102: );
103:
104: PROCEDURE Transfer_Reservation
105: (

Line 113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER

Line 114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
118: );

Line 115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

111: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
118: );
119:

Line 116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
118: );
119:
120: END GMI_Reservation_PUB;