PACKAGE: APPS.JTY_TAE_GEN_PVT

Source

1 Package JTY_TAE_GEN_PVT AS
2 /* $Header: jtfytaes.pls 120.0 2005/08/21 23:07:54 achanda noship $ */
3 --    Start of Comments
4 --    ---------------------------------------------------
5 --    PACKAGE NAME:   JTY_TAE_GEN_PVT
6 --    ---------------------------------------------------
7 --    PURPOSE
8 --      This package is used to generate batch matching SQLs for all qualifier combinations
9 --
10 --      Procedures:
11 --         (see below for specification)
12 --
13 --    NOTES
14 --      This package is publicly available for use
15 --
16 --    HISTORY
17 --      07/25/05    ACHANDA         Created
18 --
19 --    End of Comments
20 
21 PROCEDURE gen_batch_sql (
22   p_source_id       IN NUMBER,
23   p_trans_id        IN NUMBER,
24   p_mode            IN VARCHAR2,
25   p_qual_prd_tbl    IN JTY_TERR_ENGINE_GEN_PVT.qual_prd_tbl_type,
26   x_Return_Status   OUT NOCOPY VARCHAR2,
27   x_Msg_Count       OUT NOCOPY NUMBER,
28   x_Msg_Data        OUT NOCOPY VARCHAR2,
29   errbuf            OUT NOCOPY VARCHAR2,
30   retcode           OUT NOCOPY VARCHAR2);
31 
32 END JTY_TAE_GEN_PVT;