APPS.CE_PAYMENT_TRXN_PKG dependencies on CE_PAYMENT_TRANSACTIONS

Line 83: CURSOR C IS SELECT ROWID FROM CE_PAYMENT_TRANSACTIONS

79: X_LAST_UPDATE_DATE DATE,
80: X_LAST_UPDATE_LOGIN NUMBER
81: ) IS
82:
83: CURSOR C IS SELECT ROWID FROM CE_PAYMENT_TRANSACTIONS
84: WHERE TRXN_REFERENCE_NUMBER = X_TRXN_REFERENCE_NUMBER;
85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL;
86:
87: BEGIN

Line 85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL;

81: ) IS
82:
83: CURSOR C IS SELECT ROWID FROM CE_PAYMENT_TRANSACTIONS
84: WHERE TRXN_REFERENCE_NUMBER = X_TRXN_REFERENCE_NUMBER;
85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL;
86:
87: BEGIN
88: IF ( X_TRXN_REFERENCE_NUMBER ) IS NULL THEN
89: OPEN C1;

Line 94: INSERT INTO CE_PAYMENT_TRANSACTIONS

90: FETCH C1 INTO X_TRXN_REFERENCE_NUMBER;
91: CLOSE C1;
92: END IF;
93:
94: INSERT INTO CE_PAYMENT_TRANSACTIONS
95: ( TRXN_REFERENCE_NUMBER,
96: SETTLE_BY_SYSTEM_FLAG,
97: TRANSACTION_TYPE,
98: TRXN_SUBTYPE_CODE_ID,

Line 288: UPDATE CE_PAYMENT_TRANSACTIONS

284: X_LAST_UPDATE_DATE DATE,
285: X_LAST_UPDATE_LOGIN NUMBER,
286: X_OBJECT_VERSION_NUMBER NUMBER ) IS
287: BEGIN
288: UPDATE CE_PAYMENT_TRANSACTIONS
289: SET
290: TRXN_REFERENCE_NUMBER = X_TRXN_REFERENCE_NUMBER,
291: SETTLE_BY_SYSTEM_FLAG = X_SETTLE_BY_SYSTEM_FLAG,
292: TRANSACTION_TYPE = X_TRANSACTION_TYPE,

Line 359: DELETE FROM CE_PAYMENT_TRANSACTIONS

355: END UPDATE_ROW;
356:
357: PROCEDURE Delete_Row( X_Row_id VARCHAR2 ) IS
358: BEGIN
359: DELETE FROM CE_PAYMENT_TRANSACTIONS
360: WHERE rowid = X_Row_Id;
361: IF (SQL%NOTFOUND) THEN
362: Raise NO_DATA_FOUND;
363: END IF;

Line 369: UPDATE CE_PAYMENT_TRANSACTIONS

365:
366: PROCEDURE Update_Transfer_Status ( X_TRXN_NUMBER NUMBER, X_STATUS VARCHAR2) IS
367: BEGIN
368: -- Bug 10029478 added who columns in the update
369: UPDATE CE_PAYMENT_TRANSACTIONS
370: SET TRXN_STATUS_CODE = X_STATUS,
371: LAST_UPDATED_BY = FND_GLOBAL.user_id,
372: LAST_UPDATE_DATE = sysdate,
373: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id