DBA Data[Home] [Help]

APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_SAMPLES

Line 311: g_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/

307: g_subinventory MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE ;/*NSRIVAST, INVCONV*/
308:
309: g_location VARCHAR(16);
310: g_location_id NUMBER;
311: g_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
312: g_source_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
313: g_storage_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
314:
315: g_wip_plant_code VARCHAR2(4);

Line 312: g_source_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/

308:
309: g_location VARCHAR(16);
310: g_location_id NUMBER;
311: g_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
312: g_source_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
313: g_storage_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
314:
315: g_wip_plant_code VARCHAR2(4);
316: g_wip_batch_no VARCHAR2(32);

Line 313: g_storage_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/

309: g_location VARCHAR(16);
310: g_location_id NUMBER;
311: g_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
312: g_source_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
313: g_storage_locator_id GMD_SAMPLES.locator_id%TYPE; /*--SXFEINST, INVCONV*/
314:
315: g_wip_plant_code VARCHAR2(4);
316: g_wip_batch_no VARCHAR2(32);
317: g_wip_batch_id NUMBER;

Line 426: g_samples_table system.gmd_samples_tab_type;

422: g_tests_table system.gmd_qc_tests_tab_type;
423: g_specifications_table system.gmd_specifications_tab_type;
424: g_results_table system.gmd_results_tab_type;
425: g_composite_results_table system.gmd_composite_results_tab_type;
426: g_samples_table system.gmd_samples_tab_type;
427: g_sample_groups_table system.gmd_sampling_events_tab_type;
428:
429: /*#
430: * Fetches Sample Test Results

Line 747: , x_samples_table OUT NOCOPY system.gmd_samples_tab_type

743: , p_from_last_update_date IN DATE DEFAULT NULL
744: , p_to_last_update_date IN DATE DEFAULT NULL
745: , p_retain_as IN VARCHAR2 DEFAULT NULL
746: , p_delete_mark IN NUMBER DEFAULT NULL
747: , x_samples_table OUT NOCOPY system.gmd_samples_tab_type
748: , x_return_status OUT NOCOPY VARCHAR2
749: , x_msg_count OUT NOCOPY NUMBER
750: , x_msg_data OUT NOCOPY VARCHAR2
751: );