DBA Data[Home] [Help]

APPS.GMD_OUTBOUND_APIS_PUB dependencies on GMD_SAMPLES

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

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

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

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

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

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

Line 431: g_samples_table system.gmd_samples_tab_type;

427: g_tests_table system.gmd_qc_tests_tab_type;
428: g_specifications_table system.gmd_specifications_tab_type;
429: g_results_table system.gmd_results_tab_type;
430: g_composite_results_table system.gmd_composite_results_tab_type;
431: g_samples_table system.gmd_samples_tab_type;
432: g_sample_groups_table system.gmd_sampling_events_tab_type;
433:
434: /*#
435: * Fetches Sample Test Results

Line 756: , x_samples_table OUT NOCOPY system.gmd_samples_tab_type

752: , p_retain_as IN VARCHAR2 DEFAULT NULL
753: , p_delete_mark IN NUMBER DEFAULT NULL
754: , p_lpn IN VARCHAR2 DEFAULT NULL -- 7027149
755: , p_lpn_id IN NUMBER DEFAULT NULL-- 7027149
756: , x_samples_table OUT NOCOPY system.gmd_samples_tab_type
757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_msg_count OUT NOCOPY NUMBER
759: , x_msg_data OUT NOCOPY VARCHAR2
760: );