[Home] [Help]
46: X_REFERENCE3 IN VARCHAR2 DEFAULT NULL,
47: X_REVERSAL_CCID IN NUMBER DEFAULT NULL,
48: X_MODE in VARCHAR2
49: ) is
50: cursor C is select ROWID from PSA_MF_RCT_DIST_ALL
51: where RECEIVABLE_APPLICATION_ID = X_RECEIVABLE_APPLICATION_ID
52: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
53: X_LAST_UPDATE_DATE DATE;
54: X_LAST_UPDATED_BY NUMBER;
76: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
77: -- ========================= FND LOG ===========================
78: app_exception.raise_exception;
79: end if;
80: insert into PSA_MF_RCT_DIST_ALL (
81: ATTRIBUTE2,
82: ATTRIBUTE3,
83: ATTRIBUTE4,
84: ATTRIBUTE5,
234: REFERENCE2,
235: REFERENCE1,
236: REFERENCE3,
237: REVERSAL_CCID
238: from PSA_MF_RCT_DIST_ALL
239: where RECEIVABLE_APPLICATION_ID = X_RECEIVABLE_APPLICATION_ID
240: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
241: and reference1 = x_reference1
242: for update of RECEIVABLE_APPLICATION_ID nowait;
407: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
408: -- ========================= FND LOG ===========================
409: app_exception.raise_exception;
410: end if;
411: update PSA_MF_RCT_DIST_ALL set
412: ATTRIBUTE2 = X_ATTRIBUTE2,
413: ATTRIBUTE3 = X_ATTRIBUTE3,
414: ATTRIBUTE4 = X_ATTRIBUTE4,
415: ATTRIBUTE5 = X_ATTRIBUTE5,
488: X_REFERENCE3 IN VARCHAR2 DEFAULT NULL,
489: X_REVERSAL_CCID IN NUMBER DEFAULT NULL,
490: X_MODE in VARCHAR2
491: ) is
492: cursor c1 is select rowid from PSA_MF_RCT_DIST_ALL
493: where RECEIVABLE_APPLICATION_ID = X_RECEIVABLE_APPLICATION_ID
494: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID
495: ;
496: dummy c1%rowtype;
579: X_RECEIVABLE_APPLICATION_ID in NUMBER,
580: X_CUST_TRX_LINE_GL_DIST_ID in NUMBER
581: ) is
582: begin
583: delete from PSA_MF_RCT_DIST_ALL
584: where RECEIVABLE_APPLICATION_ID = X_RECEIVABLE_APPLICATION_ID
585: and CUST_TRX_LINE_GL_DIST_ID = X_CUST_TRX_LINE_GL_DIST_ID;
586: if (sql%notfound) then
587: raise no_data_found;