APPS.JAI_AR_UTILS_PKG dependencies on JAI_AR_TRX_UPDATE_T

Line 1473: FROM JAI_AR_TRX_UPDATE_T

1469: pragma AUTONOMOUS_TRANSACTION; -- Vijay Shankar for Bug# 3985561
1470:
1471: CURSOR get_temp_count IS
1472: SELECT count(*)
1473: FROM JAI_AR_TRX_UPDATE_T
1474: WHERE trx_id = p_trx_id;
1475:
1476: v_count NUMBER;
1477:

Line 1487: Deadlocks being caused due to JAI_AR_TRX_UPDATE_T table as the same row of table is being updated from different forms and triggers.

1483: CHANGE HISTORY for FILENAME: jai_om_rg_pkg.sql
1484: Slno dd/mm/yyyy Author and Change Details
1485: ------------------------------------------------------------------------------------------
1486: 1. 31/05/2004 Vijay Shankar for Bug# 3985561, Version: 115.1
1487: Deadlocks being caused due to JAI_AR_TRX_UPDATE_T table as the same row of table is being updated from different forms and triggers.
1488: To resolve this, procedure is made to execute in AUTONOMOUS_TRANSACTION (Nested TRANSACTION CYCLE with COMMIT) mode
1489: This whole procedure is modified as an Table Handler for JAI_AR_TRX_UPDATE_T table. for this purpose a new parameter named p_flag
1490: is added that takes care of INSERT/UPDATE/DELETE on the table
1491:

Line 1489: This whole procedure is modified as an Table Handler for JAI_AR_TRX_UPDATE_T table. for this purpose a new parameter named p_flag

1485: ------------------------------------------------------------------------------------------
1486: 1. 31/05/2004 Vijay Shankar for Bug# 3985561, Version: 115.1
1487: Deadlocks being caused due to JAI_AR_TRX_UPDATE_T table as the same row of table is being updated from different forms and triggers.
1488: To resolve this, procedure is made to execute in AUTONOMOUS_TRANSACTION (Nested TRANSACTION CYCLE with COMMIT) mode
1489: This whole procedure is modified as an Table Handler for JAI_AR_TRX_UPDATE_T table. for this purpose a new parameter named p_flag
1490: is added that takes care of INSERT/UPDATE/DELETE on the table
1491:
1492: HIGH DEPENDENCY for future bugs
1493:

Line 1498: UPDATE JAI_AR_TRX_UPDATE_T

1494: ------------------------------------------------------------------------------------------ */
1495:
1496: -- 3985561
1497: If p_flag = 'N' THEN
1498: UPDATE JAI_AR_TRX_UPDATE_T
1499: SET modified_flag = p_flag
1500: WHERE trx_id = p_trx_id;
1501: ELSIF p_flag = 'D' THEN
1502: DELETE FROM JAI_AR_TRX_UPDATE_T

Line 1502: DELETE FROM JAI_AR_TRX_UPDATE_T

1498: UPDATE JAI_AR_TRX_UPDATE_T
1499: SET modified_flag = p_flag
1500: WHERE trx_id = p_trx_id;
1501: ELSIF p_flag = 'D' THEN
1502: DELETE FROM JAI_AR_TRX_UPDATE_T
1503: WHERE trx_id = p_trx_id;
1504:
1505: ELSE
1506:

Line 1513: UPDATE JAI_AR_TRX_UPDATE_T

1509: CLOSE get_temp_count;
1510:
1511: IF v_count > 0 THEN
1512:
1513: UPDATE JAI_AR_TRX_UPDATE_T
1514: SET modified_flag = p_flag
1515: WHERE trx_id = p_trx_id;
1516:
1517: ELSIF p_flag <> 'D' THEN

Line 1519: INSERT INTO JAI_AR_TRX_UPDATE_T(

1515: WHERE trx_id = p_trx_id;
1516:
1517: ELSIF p_flag <> 'D' THEN
1518:
1519: INSERT INTO JAI_AR_TRX_UPDATE_T(
1520: trx_ID, modified_flag,
1521: -- added, Harshita for Bug 4866533
1522: created_by, creation_date, last_updated_by, last_update_date
1523: ) VALUES (