DBA Data[Home] [Help]

APPS.INV_RESERVATION_FORM_PKG dependencies on FND_API

Line 7: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

3: -- INVCONV Overloaded- Incorporate secondaries into parameter list
4: --R12- Project - SU : Added variables p_Serial_Number_Tbl and p_CrossDock_Flag
5: PROCEDURE create_reservation(
6: p_api_version_number IN NUMBER
7: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
8: , x_return_status OUT NOCOPY VARCHAR2
9: , x_msg_count OUT NOCOPY NUMBER
10: , x_msg_data OUT NOCOPY VARCHAR2
11: , p_requirement_date IN DATE

Line 65: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

61: , p_attribute12 IN VARCHAR2 DEFAULT NULL
62: , p_attribute13 IN VARCHAR2 DEFAULT NULL
63: , p_attribute14 IN VARCHAR2 DEFAULT NULL
64: , p_attribute15 IN VARCHAR2 DEFAULT NULL
65: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
66: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
67: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
68: , x_quantity_reserved OUT NOCOPY NUMBER
69: , x_secondary_quantity_reserved OUT NOCOPY NUMBER

Line 66: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

62: , p_attribute13 IN VARCHAR2 DEFAULT NULL
63: , p_attribute14 IN VARCHAR2 DEFAULT NULL
64: , p_attribute15 IN VARCHAR2 DEFAULT NULL
65: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
66: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
67: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
68: , x_quantity_reserved OUT NOCOPY NUMBER
69: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
70: , x_reservation_id OUT NOCOPY NUMBER

Line 67: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

63: , p_attribute14 IN VARCHAR2 DEFAULT NULL
64: , p_attribute15 IN VARCHAR2 DEFAULT NULL
65: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
66: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
67: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
68: , x_quantity_reserved OUT NOCOPY NUMBER
69: , x_secondary_quantity_reserved OUT NOCOPY NUMBER
70: , x_reservation_id OUT NOCOPY NUMBER
71: );

Line 75: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

71: );
72:
73: PROCEDURE create_reservation(
74: p_api_version_number IN NUMBER
75: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
76: , x_return_status OUT NOCOPY VARCHAR2
77: , x_msg_count OUT NOCOPY NUMBER
78: , x_msg_data OUT NOCOPY VARCHAR2
79: , p_requirement_date IN DATE

Line 126: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

122: , p_attribute12 IN VARCHAR2 DEFAULT NULL
123: , p_attribute13 IN VARCHAR2 DEFAULT NULL
124: , p_attribute14 IN VARCHAR2 DEFAULT NULL
125: , p_attribute15 IN VARCHAR2 DEFAULT NULL
126: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
127: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
128: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
129: , x_quantity_reserved OUT NOCOPY NUMBER
130: , x_reservation_id OUT NOCOPY NUMBER

Line 127: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false

123: , p_attribute13 IN VARCHAR2 DEFAULT NULL
124: , p_attribute14 IN VARCHAR2 DEFAULT NULL
125: , p_attribute15 IN VARCHAR2 DEFAULT NULL
126: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
127: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
128: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
129: , x_quantity_reserved OUT NOCOPY NUMBER
130: , x_reservation_id OUT NOCOPY NUMBER
131: );

Line 128: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

124: , p_attribute14 IN VARCHAR2 DEFAULT NULL
125: , p_attribute15 IN VARCHAR2 DEFAULT NULL
126: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
127: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
128: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
129: , x_quantity_reserved OUT NOCOPY NUMBER
130: , x_reservation_id OUT NOCOPY NUMBER
131: );
132:

Line 137: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

133: --
134: -- INVCONV - Incorporate secondaries into parameter list
135: PROCEDURE update_reservation(
136: p_api_version_number IN NUMBER
137: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
138: , x_return_status OUT NOCOPY VARCHAR2
139: , x_msg_count OUT NOCOPY NUMBER
140: , x_msg_data OUT NOCOPY VARCHAR2
141: , p_from_reservation_id IN NUMBER

Line 244: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

240: , p_to_attribute12 IN VARCHAR2 DEFAULT NULL
241: , p_to_attribute13 IN VARCHAR2 DEFAULT NULL
242: , p_to_attribute14 IN VARCHAR2 DEFAULT NULL
243: , p_to_attribute15 IN VARCHAR2 DEFAULT NULL
244: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
245: );
246:
247: --
248: -- INVCONV - Incorporate secondaries into parameter list

Line 251: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

247: --
248: -- INVCONV - Incorporate secondaries into parameter list
249: PROCEDURE delete_reservation(
250: p_api_version_number IN NUMBER
251: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
252: , x_return_status OUT NOCOPY VARCHAR2
253: , x_msg_count OUT NOCOPY NUMBER
254: , x_msg_data OUT NOCOPY VARCHAR2
255: , p_reservation_id IN NUMBER

Line 314: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

310:
311: --
312: PROCEDURE transfer_supply(
313: p_api_version_number IN NUMBER
314: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
315: , x_return_status OUT NOCOPY VARCHAR2
316: , x_msg_count OUT NOCOPY NUMBER
317: , x_msg_data OUT NOCOPY VARCHAR2
318: , p_from_reservation_id IN NUMBER

Line 386: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

382: , p_to_lot_number IN VARCHAR2
383: , p_to_lot_number_id IN NUMBER
384: , p_to_pick_slip_number IN NUMBER
385: , p_to_lpn_id IN NUMBER
386: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
387: , x_to_reservation_id OUT NOCOPY NUMBER
388: );
389:
390: --

Line 393: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true

389:
390: --
391: PROCEDURE transfer_demand(
392: p_api_version_number IN NUMBER
393: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_true
394: , x_return_status OUT NOCOPY VARCHAR2
395: , x_msg_count OUT NOCOPY NUMBER
396: , x_msg_data OUT NOCOPY VARCHAR2
397: , p_from_reservation_id IN NUMBER

Line 461: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true

457: , p_to_secondary_uom_code IN VARCHAR2 -- INVCONV
458: , p_to_secondary_rsv_quantity IN NUMBER -- INVCONV
459: , p_to_project_id IN NUMBER Default Null
460: , p_to_task_id IN NUMBER Default Null
461: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
462: , x_to_reservation_id OUT NOCOPY NUMBER
463: );
464:
465: --

Line 468: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

464:
465: --
466: PROCEDURE query_reservation(
467: p_api_version_number IN NUMBER
468: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
469: , x_return_status OUT NOCOPY VARCHAR2
470: , x_msg_count OUT NOCOPY NUMBER
471: , x_msg_data OUT NOCOPY VARCHAR2
472: , p_reservation_id IN NUMBER

Line 473: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false

469: , x_return_status OUT NOCOPY VARCHAR2
470: , x_msg_count OUT NOCOPY NUMBER
471: , x_msg_data OUT NOCOPY VARCHAR2
472: , p_reservation_id IN NUMBER
473: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
474: , p_sort_by_req_date IN NUMBER
475: , p_cancel_order_mode IN NUMBER
476: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
477: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER

Line 484: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

480:
481: --
482: PROCEDURE get_reservable_quantity(
483: p_api_version_number IN NUMBER
484: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
485: , x_return_status OUT NOCOPY VARCHAR2
486: , x_msg_count OUT NOCOPY NUMBER
487: , x_msg_data OUT NOCOPY VARCHAR2
488: , p_reservation_id IN NUMBER

Line 504: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

500: -- GME CONVERGENCE BEGIN
501: PROCEDURE create_move_order_header
502: (
503: p_api_version_number IN NUMBER
504: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
505: , p_organization_id IN NUMBER
506: , x_return_status OUT NOCOPY VARCHAR2
507: , x_msg_count OUT NOCOPY NUMBER
508: , x_msg_data OUT NOCOPY VARCHAR2

Line 515: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

511:
512: PROCEDURE create_move_order_line
513: (
514: p_api_version_number IN NUMBER
515: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
516: , p_organization_id IN NUMBER
517: , p_move_order_header_id IN NUMBER
518: , p_inventory_item_id IN NUMBER
519: , p_quantity IN NUMBER

Line 538: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

534:
535: PROCEDURE delete_move_order
536: (
537: p_api_version_number IN NUMBER
538: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
539: , p_move_order_header_id IN NUMBER
540: , x_return_status OUT NOCOPY VARCHAR2
541: , x_msg_count OUT NOCOPY NUMBER
542: , x_msg_data OUT NOCOPY VARCHAR2