APPS.JTY_TRANS_USG_PGM_DETAILS_PKG dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 1: PACKAGE BODY JTY_TRANS_USG_PGM_DETAILS_PKG as

1: PACKAGE BODY JTY_TRANS_USG_PGM_DETAILS_PKG as
2: /* $Header: jtftupdb.pls 120.1 2005/11/18 11:37:23 achanda noship $ */
3:
4: PROCEDURE Insert_Row(
5: X_ROW_ID IN OUT NOCOPY VARCHAR2,

Line 39: FROM JTY_TRANS_USG_PGM_DETAILS

35: P_INDEX_EXTN IN VARCHAR2) IS
36:
37: CURSOR C1 IS
38: SELECT rowid
39: FROM JTY_TRANS_USG_PGM_DETAILS
40: WHERE TRANS_USG_PGM_DETAILS_ID = X_TRANS_USG_PGM_DETAILS_ID;
41:
42: CURSOR C2 IS SELECT jty_trans_usg_pgm_details_s.nextval FROM sys.dual;
43:

Line 42: CURSOR C2 IS SELECT jty_trans_usg_pgm_details_s.nextval FROM sys.dual;

38: SELECT rowid
39: FROM JTY_TRANS_USG_PGM_DETAILS
40: WHERE TRANS_USG_PGM_DETAILS_ID = X_TRANS_USG_PGM_DETAILS_ID;
41:
42: CURSOR C2 IS SELECT jty_trans_usg_pgm_details_s.nextval FROM sys.dual;
43:
44: BEGIN
45: If (X_TRANS_USG_PGM_DETAILS_ID IS NULL) then
46: OPEN C2;

Line 51: INSERT INTO JTY_TRANS_USG_PGM_DETAILS(

47: FETCH C2 INTO X_TRANS_USG_PGM_DETAILS_ID;
48: CLOSE C2;
49: End If;
50:
51: INSERT INTO JTY_TRANS_USG_PGM_DETAILS(
52: TRANS_USG_PGM_DETAILS_ID,
53: SOURCE_ID,
54: TRANS_TYPE_ID,
55: PROGRAM_NAME,

Line 154: Update JTY_TRANS_USG_PGM_DETAILS

150: P_BATCH_MP_WINNER_TABLE IN VARCHAR2,
151: P_BATCH_DMC_WINNER_TABLE IN VARCHAR2,
152: P_INDEX_EXTN IN VARCHAR2) IS
153: BEGIN
154: Update JTY_TRANS_USG_PGM_DETAILS
155: SET
156: SOURCE_ID = decode(P_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, P_SOURCE_ID),
157: TRANS_TYPE_ID = decode(P_TRANS_TYPE_ID, FND_API.G_MISS_NUM, TRANS_TYPE_ID, P_TRANS_TYPE_ID),
158: PROGRAM_NAME = decode(P_PROGRAM_NAME, FND_API.G_MISS_CHAR, PROGRAM_NAME, P_PROGRAM_NAME),

Line 210: DELETE FROM JTY_TRANS_USG_PGM_DETAILS

206: END Update_Row;
207:
208: PROCEDURE Delete_Row(P_TRANS_USG_PGM_DETAILS_ID IN NUMBER) IS
209: BEGIN
210: DELETE FROM JTY_TRANS_USG_PGM_DETAILS
211: WHERE TRANS_USG_PGM_DETAILS_ID = P_TRANS_USG_PGM_DETAILS_ID;
212: If (SQL%NOTFOUND) then
213: RAISE NO_DATA_FOUND;
214: End If;

Line 217: END JTY_TRANS_USG_PGM_DETAILS_PKG;

213: RAISE NO_DATA_FOUND;
214: End If;
215: END Delete_Row;
216:
217: END JTY_TRANS_USG_PGM_DETAILS_PKG;