DBA Data[Home] [Help]

APPS.INV_LOC_WMS_PUB dependencies on FND_API

Line 369: ** To update the attribute with NULL, pass fnd_api.g_miss_char

365: * @param p_status_id Material Status that needs to be associated to locator is passed as input in this variable
366: * @param p_dropping_order Number that identifies relative position of locator for consolidation and put away drop-off operations is passed as input in this variable* @rep:scope public
367: ** For the DFF attributes mentioned below, to update correctly use the following strategy
368: ** To retain the value in the table, do not pass any value OR pass NULL as i/p
369: ** To update the attribute with NULL, pass fnd_api.g_miss_char
370: ** To update with any other value, pass the appropriate value
371: * @param p_attribute_category Holds the Context of the Descriptive FlexField for the Locator
372: * @paraminfo {@rep:Not Mandatory}
373: * @param p_attribute1 Holds the Descriptive FlexField attribute for the Locator

Line 414: p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

410: p_organization_id IN NUMBER ,
411: p_organization_code IN VARCHAR2,
412: p_inventory_location_id IN NUMBER,
413: p_concatenated_segments IN VARCHAR2,
414: p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,

411: p_organization_code IN VARCHAR2,
412: p_inventory_location_id IN NUMBER,
413: p_concatenated_segments IN VARCHAR2,
414: p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,

412: p_inventory_location_id IN NUMBER,
413: p_concatenated_segments IN VARCHAR2,
414: p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,

413: p_concatenated_segments IN VARCHAR2,
414: p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,

414: p_description IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

415: p_disabled_date IN DATE DEFAULT FND_API.G_MISS_DATE,
416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,

416: p_inventory_location_type IN NUMBER DEFAULT FND_API.G_MISS_NUM,
417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

417: p_picking_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,

418: p_location_maximum_units IN NUMBER DEFAULT FND_API.G_MISS_NUM,
419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

419: p_location_Weight_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

420: p_max_weight IN NUMBER DEFAULT FND_API.G_MISS_NUM,
421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,

421: p_volume_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

422: p_max_cubic_area IN NUMBER DEFAULT FND_API.G_MISS_NUM,
423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

423: p_x_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

424: p_y_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,

425: p_z_coordinate IN NUMBER DEFAULT FND_API.G_MISS_NUM,
426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,

426: p_physical_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
434: p_attribute_category IN VARCHAR2 DEFAULT NULL,

Line 431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,

427: p_pick_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
434: p_attribute_category IN VARCHAR2 DEFAULT NULL,
435: p_attribute1 IN VARCHAR2 DEFAULT NULL

Line 432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

428: p_dimension_uom_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
434: p_attribute_category IN VARCHAR2 DEFAULT NULL,
435: p_attribute1 IN VARCHAR2 DEFAULT NULL
436: , p_attribute2 IN VARCHAR2 DEFAULT NULL

Line 433: p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,

429: p_length IN NUMBER DEFAULT FND_API.G_MISS_NUM,
430: p_width IN NUMBER DEFAULT FND_API.G_MISS_NUM,
431: p_height IN NUMBER DEFAULT FND_API.G_MISS_NUM,
432: p_status_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
433: p_dropping_order IN NUMBER DEFAULT FND_API.G_MISS_NUM,
434: p_attribute_category IN VARCHAR2 DEFAULT NULL,
435: p_attribute1 IN VARCHAR2 DEFAULT NULL
436: , p_attribute2 IN VARCHAR2 DEFAULT NULL
437: , p_attribute3 IN VARCHAR2 DEFAULT NULL