PACKAGE: APPS.JTY_TRANS_USG_PGM_SQL_PKG

Source

1 PACKAGE JTY_TRANS_USG_PGM_SQL_PKG as
2 /* $Header: jtftupss.pls 120.0 2005/09/12 20:19:58 achanda noship $ */
3 --    Start of Comments
4 --    ---------------------------------------------------
5 --    PACKAGE NAME:   JTY_TRANS_USG_PGM_SQL_PKG
6 --    ---------------------------------------------------
7 --    PURPOSE
8 --      This package is used to create the transaction type SQLs
9 --      and the corresponding TRANS tables.
10 --
11 --      Procedures:
12 --         (see below for specification)
13 --
14 --    NOTES
15 --      This package is publicly available for use
16 --
17 --    HISTORY
18 --      09/08/05    ACHANDA         Created
19 --
20 --    End of Comments
21 --
22 
23 PROCEDURE Insert_Row(
24    p_source_id IN NUMBER
25   ,p_trans_type_id IN NUMBER
26   ,p_program_name IN VARCHAR2
27   ,p_version_name IN VARCHAR2
28   ,p_real_time_sql IN VARCHAR2
29   ,p_batch_total_sql IN VARCHAR2
30   ,p_batch_incr_sql IN VARCHAR2
31   ,p_batch_dea_sql IN VARCHAR2
32   ,p_incr_reassign_sql IN VARCHAR2
33   ,p_use_total_for_dea_flag IN VARCHAR2
34   ,p_enabled_flag IN VARCHAR2
35   ,retcode OUT NOCOPY VARCHAR2
36   ,errbuf OUT NOCOPY VARCHAR2);
37 
38 END JTY_TRANS_USG_PGM_SQL_PKG;