APPS.FV_IPAC_TRANSACTIONS_SUMM_PKG dependencies on FV_IPAC_TRX

Line 86: CURSOR C_ROW_ID IS SELECT ROWID FROM FV_IPAC_TRX

82: l_module_name VARCHAR2(200) := g_module_name || 'Insert_Row';
83: l_errbuf VARCHAR2(1024);
84: x_ipac_billing_id_v NUMBER;
85:
86: CURSOR C_ROW_ID IS SELECT ROWID FROM FV_IPAC_TRX
87: WHERE IPAC_BILLING_ID = x_ipac_billing_id_v;
88: BEGIN
89:
90: SELECT FV_IPAC_BILLING_ID_S.NEXTVAL INTO x_ipac_billing_id

Line 93: INSERT INTO FV_IPAC_TRX(

89:
90: SELECT FV_IPAC_BILLING_ID_S.NEXTVAL INTO x_ipac_billing_id
91: FROM DUAL;
92:
93: INSERT INTO FV_IPAC_TRX(
94:
95: CUSTOMER_TRX_ID,
96: CUSTOMER_ID ,
97: CUSTOMER_NAME ,

Line 338: UPDATE FV_IPAC_TRX

334: ) IS
335: l_module_name VARCHAR2(200) := g_module_name || 'Update_Row';
336: l_errbuf VARCHAR2(1024);
337: BEGIN
338: UPDATE FV_IPAC_TRX
339: SET CUSTOMER_TRX_ID = X_CUSTOMER_TRX_ID,
340: CUSTOMER_ID = X_CUSTOMER_ID,
341: CUSTOMER_NAME = X_CUSTOMER_NAME ,
342: TAXPAYER_NUMBER = X_TAXPAYER_NUMBER,

Line 443: FROM fv_ipac_trx

439: customer_id,
440: trx_number,
441: set_of_books_id,
442: ipac_billing_id
443: FROM fv_ipac_trx
444: WHERE ROWID = X_ROWID
445: for UPDATE OF IPAC_BILLING_ID NOWAIT;
446: Recinfo c_lock_record%ROWTYPE;
447:

Line 503: FROM FV_IPAC_TRX

499: BEGIN
500: BEGIN
501: SELECT ipac_billing_id
502: INTO x_ipac_billing_id
503: FROM FV_IPAC_TRX
504: WHERE rowid = x_rowid ;
505:
506:
507: EXCEPTION

Line 513: /* Delete FV_IPAC_TRX - Record */

509: RAISE;
510: END;
511:
512:
513: /* Delete FV_IPAC_TRX - Record */
514: DELETE FROM FV_IPAC_TRX
515: WHERE ipac_billing_id = X_ipac_billing_id ;
516:
517: IF (SQL%NOTFOUND) THEN

Line 514: DELETE FROM FV_IPAC_TRX

510: END;
511:
512:
513: /* Delete FV_IPAC_TRX - Record */
514: DELETE FROM FV_IPAC_TRX
515: WHERE ipac_billing_id = X_ipac_billing_id ;
516:
517: IF (SQL%NOTFOUND) THEN
518: RAISE NO_DATA_FOUND;