PACKAGE: APPS.EGO_IMPORT_BATCH_COMPARE_PVT

Source

1 PACKAGE EGO_IMPORT_BATCH_COMPARE_PVT AS
2 /* $Header: EGOVCMPS.pls 120.5 2007/07/20 13:12:25 nshariff ship $ */
3 FUNCTION GET_COMPARED_DATA (p_ss_code         NUMBER,
4                               p_ss_record     VARCHAR2,
5                               p_batch_id      NUMBER,
6                               p_mode          NUMBER,
7                               p_item1         NUMBER,
8                               p_item2         NUMBER,
9                               p_item3         NUMBER,
10                               p_item4         NUMBER,
11                               p_org_Id        NUMBER,
12 	                      p_pdh_revision  VARCHAR2,
13                               p_supplier_id   NUMBER DEFAULT NULL,
14 	                      p_supplier_site_id NUMBER DEFAULT NULL,
15                               p_bundle_id     NUMBER DEFAULT NULL
16                               )
17                               RETURN    SYSTEM.EGO_COMPARE_VIEW_TABLE ;
18 
19 FUNCTION GET_CURRENT_PDH_REVISION(p_inventory_item_id NUMBER
20                                   ,p_organization_id NUMBER)
21 RETURN VARCHAR2;
22 
23 FUNCTION REV_EXISTS_IN_PDH ( p_revision VARCHAR2,
24                              p_inventory_item_id NUMBER,
25                              p_organization_id NUMBER
26                            )
27 RETURN varchar2;
28 
29 END EGO_IMPORT_BATCH_COMPARE_PVT;