APPS.XTR_RM_MD_CURVE_RATES_PKG dependencies on XTR_RM_MD_CURVE_RATES

Line 1: PACKAGE BODY XTR_RM_MD_CURVE_RATES_PKG as

1: PACKAGE BODY XTR_RM_MD_CURVE_RATES_PKG as
2: /* $Header: xtrmdcrb.pls 120.1 2005/06/29 10:33:15 csutaria ship $ */
3:
4: PROCEDURE INSERT_ROW(
5: X_ROWID IN out nocopy VARCHAR2,

Line 14: CURSOR C IS SELECT ROWID FROM XTR_RM_MD_CURVE_RATES

10: X_LAST_UPDATED_BY NUMBER,
11: X_LAST_UPDATE_DATE DATE,
12: X_LAST_UPDATE_LOGIN NUMBER) IS
13:
14: CURSOR C IS SELECT ROWID FROM XTR_RM_MD_CURVE_RATES
15: WHERE RATE_CODE = X_RATE_CODE AND CURVE_CODE = X_CURVE_CODE;
16:
17: CURSOR CHECK_UNIQUE IS SELECT RATE_CODE, CURVE_CODE FROM XTR_RM_MD_CURVE_RATES
18: WHERE RATE_CODE = X_RATE_CODE AND CURVE_CODE = X_CURVE_CODE;

Line 17: CURSOR CHECK_UNIQUE IS SELECT RATE_CODE, CURVE_CODE FROM XTR_RM_MD_CURVE_RATES

13:
14: CURSOR C IS SELECT ROWID FROM XTR_RM_MD_CURVE_RATES
15: WHERE RATE_CODE = X_RATE_CODE AND CURVE_CODE = X_CURVE_CODE;
16:
17: CURSOR CHECK_UNIQUE IS SELECT RATE_CODE, CURVE_CODE FROM XTR_RM_MD_CURVE_RATES
18: WHERE RATE_CODE = X_RATE_CODE AND CURVE_CODE = X_CURVE_CODE;
19:
20: V_RATE_CODE VARCHAR2(20);
21: V_CURVE_CODE VARCHAR2(20);

Line 28: INSERT INTO XTR_RM_MD_CURVE_RATES

24: OPEN CHECK_UNIQUE;
25: FETCH CHECK_UNIQUE INTO V_RATE_CODE, V_CURVE_CODE;
26: -- ONLY INSERT IF NO DUPLICATE ROWS FOUND, ELSE DO NOTHING
27: IF (CHECK_UNIQUE%NOTFOUND) THEN
28: INSERT INTO XTR_RM_MD_CURVE_RATES
29: (
30: RATE_CODE,
31: CURVE_CODE,
32: CREATED_BY,

Line 58: DELETE FROM XTR_RM_MD_CURVE_RATES

54:
55: PROCEDURE DELETE_ROW (X_ROWID VARCHAR2) IS
56: BEGIN
57: -- Perform delete
58: DELETE FROM XTR_RM_MD_CURVE_RATES
59: WHERE ROWID = X_ROWID;
60: IF (SQL%NOTFOUND) THEN
61: RAISE NO_DATA_FOUND;
62: END IF;

Line 74: UPDATE XTR_RM_MD_CURVE_RATES

70: X_LAST_UPDATED_BY NUMBER,
71: X_LAST_UPDATE_DATE DATE,
72: X_LAST_UPDATE_LOGIN NUMBER) IS
73: BEGIN
74: UPDATE XTR_RM_MD_CURVE_RATES
75: SET RATE_CODE = X_RATE_CODE,
76: CURVE_CODE = X_CURVE_CODE,
77: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
78: LAST_UPDATE_DATE= X_LAST_UPDATE_DATE,

Line 94: FROM XTR_RM_MD_CURVE_RATES

90: X_CURVE_CODE VARCHAR2) IS
91:
92: CURSOR C IS
93: SELECT *
94: FROM XTR_RM_MD_CURVE_RATES
95: WHERE ROWID = X_ROWID
96: FOR UPDATE OF RATE_CODE, CURVE_CODE NOWAIT;
97:
98: RECINFO C%ROWTYPE;

Line 121: END XTR_RM_MD_CURVE_RATES_PKG;

117: END IF;
118: END LOCK_ROW;
119:
120:
121: END XTR_RM_MD_CURVE_RATES_PKG;
122: