DBA Data[Home] [Help]

PACKAGE: APPS.GMD_QC_MIGRATE_TO_1151J

Source


1 PACKAGE GMD_QC_MIGRATE_TO_1151J AUTHID CURRENT_USER AS
2 /* $Header: GMDQCMJS.pls 115.14 2004/08/09 16:41:28 bstone noship $ */
3 
4    /*------------------- GLOBAL CURSORS ----------------------*/
5    /*  Get the vendor/supplier ids form purchasing */
6    CURSOR g_get_supplier_ids (pvendor_id NUMBER) IS
7       SELECT of_vendor_id, of_vendor_site_id
8       FROM po_vend_mst
9       WHERE  vendor_id = pvendor_id;
10 
11    FUNCTION Get_Base_Language RETURN VARCHAR2;
12 
13    PROCEDURE Migrate_Assay_Classes (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
14 
15    PROCEDURE Migrate_Action_Codes (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
16 
17    PROCEDURE Migrate_Hold_Reasons (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
18 
19    PROCEDURE Migrate_Tests_Base (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
20 
21    PROCEDURE Migrate_Tests_Translated (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
22 
23    PROCEDURE Migrate_Values_Base (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
24 
25    PROCEDURE Migrate_Values_Translated (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
26 
27    PROCEDURE Chk_overlapping_Spec_Tests (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
28 
29    PROCEDURE Migrate_Specifications (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
30 
31    PROCEDURE Migrate_Samples (p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
32 
33    PROCEDURE Migrate_Results(p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
34 
35    PROCEDURE Create_Sample_Results(p_migration_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2);
36 
37 END GMD_QC_MIGRATE_TO_1151J;
38