1 PACKAGE JTY_TRANS_USG_PGM_DETAILS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtftupds.pls 120.1 2005/11/18 11:37:02 achanda noship $ */
3
4 PROCEDURE Insert_Row(
5 X_ROW_ID IN OUT NOCOPY VARCHAR2,
6 X_TRANS_USG_PGM_DETAILS_ID IN OUT NOCOPY NUMBER,
7 P_SOURCE_ID IN NUMBER,
8 P_TRANS_TYPE_ID IN NUMBER,
9 P_PROGRAM_NAME IN VARCHAR2,
10 P_LAST_UPDATE_DATE IN DATE,
11 P_LAST_UPDATED_BY IN NUMBER,
12 P_CREATION_DATE IN DATE,
13 P_CREATED_BY IN NUMBER,
14 P_LAST_UPDATE_LOGIN IN NUMBER,
15 P_PARAM_PASSING_MECHANISM IN VARCHAR2,
16 P_REAL_TIME_ENABLE_FLAG IN VARCHAR2,
17 P_BATCH_ENABLE_FLAG IN VARCHAR2,
18 P_MULTI_LEVEL_WINNING_FLAG IN VARCHAR2,
19 P_REAL_TIME_TRANS_TABLE IN VARCHAR2,
20 P_BATCH_TRANS_TABLE IN VARCHAR2,
21 P_BATCH_NM_TRANS_TABLE IN VARCHAR2,
22 P_BATCH_DEA_TRANS_TABLE IN VARCHAR2,
23 P_BATCH_MATCH_TABLE IN VARCHAR2,
24 P_BATCH_UNIQUE_MATCH_TABLE IN VARCHAR2,
25 P_BATCH_WINNER_TABLE IN VARCHAR2,
26 P_BATCH_UNIQUE_WINNER_TABLE IN VARCHAR2,
27 P_BATCH_L1_WINNER_TABLE IN VARCHAR2,
28 P_BATCH_L2_WINNER_TABLE IN VARCHAR2,
29 P_BATCH_L3_WINNER_TABLE IN VARCHAR2,
30 P_BATCH_L4_WINNER_TABLE IN VARCHAR2,
31 P_BATCH_L5_WINNER_TABLE IN VARCHAR2,
32 P_BATCH_WT_WINNER_TABLE IN VARCHAR2,
33 P_BATCH_MP_WINNER_TABLE IN VARCHAR2,
34 P_BATCH_DMC_WINNER_TABLE IN VARCHAR2,
35 P_INDEX_EXTN IN VARCHAR2);
36
37 PROCEDURE Update_Row(
38 P_ROW_ID IN VARCHAR2,
39 P_TRANS_USG_PGM_DETAILS_ID IN NUMBER,
40 P_SOURCE_ID IN NUMBER,
41 P_TRANS_TYPE_ID IN NUMBER,
42 P_PROGRAM_NAME IN VARCHAR2,
43 P_LAST_UPDATE_DATE IN DATE,
44 P_LAST_UPDATED_BY IN NUMBER,
45 P_CREATION_DATE IN DATE,
46 P_CREATED_BY IN NUMBER,
47 P_LAST_UPDATE_LOGIN IN NUMBER,
48 P_PARAM_PASSING_MECHANISM IN VARCHAR2,
49 P_REAL_TIME_ENABLE_FLAG IN VARCHAR2,
50 P_BATCH_ENABLE_FLAG IN VARCHAR2,
51 P_MULTI_LEVEL_WINNING_FLAG IN VARCHAR2,
52 P_REAL_TIME_TRANS_TABLE IN VARCHAR2,
53 P_BATCH_TRANS_TABLE IN VARCHAR2,
54 P_BATCH_NM_TRANS_TABLE IN VARCHAR2,
55 P_BATCH_DEA_TRANS_TABLE IN VARCHAR2,
56 P_BATCH_MATCH_TABLE IN VARCHAR2,
57 P_BATCH_UNIQUE_MATCH_TABLE IN VARCHAR2,
58 P_BATCH_WINNER_TABLE IN VARCHAR2,
59 P_BATCH_UNIQUE_WINNER_TABLE IN VARCHAR2,
60 P_BATCH_L1_WINNER_TABLE IN VARCHAR2,
61 P_BATCH_L2_WINNER_TABLE IN VARCHAR2,
62 P_BATCH_L3_WINNER_TABLE IN VARCHAR2,
63 P_BATCH_L4_WINNER_TABLE IN VARCHAR2,
64 P_BATCH_L5_WINNER_TABLE IN VARCHAR2,
65 P_BATCH_WT_WINNER_TABLE IN VARCHAR2,
66 P_BATCH_MP_WINNER_TABLE IN VARCHAR2,
67 P_BATCH_DMC_WINNER_TABLE IN VARCHAR2,
68 P_INDEX_EXTN IN VARCHAR2);
69
70 PROCEDURE Delete_Row(P_TRANS_USG_PGM_DETAILS_ID IN NUMBER);
71
72 END JTY_TRANS_USG_PGM_DETAILS_PKG;