[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