APPS.JAI_AR_UTILS_PKG dependencies on JAI_AR_TRX_UPDATE_T

Line 892: FROM JAI_AR_TRX_UPDATE_T

888: pragma AUTONOMOUS_TRANSACTION; -- Vijay Shankar for Bug# 3985561
889:
890: CURSOR get_temp_count IS
891: SELECT count(*)
892: FROM JAI_AR_TRX_UPDATE_T
893: WHERE trx_id = p_trx_id;
894:
895: v_count NUMBER;
896:

Line 906: 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.

902: CHANGE HISTORY for FILENAME: jai_om_rg_pkg.sql
903: Slno dd/mm/yyyy Author and Change Details
904: ------------------------------------------------------------------------------------------
905: 1. 31/05/2004 Vijay Shankar for Bug# 3985561, Version: 115.1
906: 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.
907: To resolve this, procedure is made to execute in AUTONOMOUS_TRANSACTION (Nested TRANSACTION CYCLE with COMMIT) mode
908: 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
909: is added that takes care of INSERT/UPDATE/DELETE on the table
910:

Line 908: 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

904: ------------------------------------------------------------------------------------------
905: 1. 31/05/2004 Vijay Shankar for Bug# 3985561, Version: 115.1
906: 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.
907: To resolve this, procedure is made to execute in AUTONOMOUS_TRANSACTION (Nested TRANSACTION CYCLE with COMMIT) mode
908: 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
909: is added that takes care of INSERT/UPDATE/DELETE on the table
910:
911: HIGH DEPENDENCY for future bugs
912:

Line 917: UPDATE JAI_AR_TRX_UPDATE_T

913: ------------------------------------------------------------------------------------------ */
914:
915: -- 3985561
916: If p_flag = 'N' THEN
917: UPDATE JAI_AR_TRX_UPDATE_T
918: SET modified_flag = p_flag
919: WHERE trx_id = p_trx_id;
920: ELSIF p_flag = 'D' THEN
921: DELETE FROM JAI_AR_TRX_UPDATE_T

Line 921: DELETE FROM JAI_AR_TRX_UPDATE_T

917: UPDATE JAI_AR_TRX_UPDATE_T
918: SET modified_flag = p_flag
919: WHERE trx_id = p_trx_id;
920: ELSIF p_flag = 'D' THEN
921: DELETE FROM JAI_AR_TRX_UPDATE_T
922: WHERE trx_id = p_trx_id;
923:
924: ELSE
925:

Line 932: UPDATE JAI_AR_TRX_UPDATE_T

928: CLOSE get_temp_count;
929:
930: IF v_count > 0 THEN
931:
932: UPDATE JAI_AR_TRX_UPDATE_T
933: SET modified_flag = p_flag
934: WHERE trx_id = p_trx_id;
935:
936: ELSIF p_flag <> 'D' THEN

Line 938: INSERT INTO JAI_AR_TRX_UPDATE_T(

934: WHERE trx_id = p_trx_id;
935:
936: ELSIF p_flag <> 'D' THEN
937:
938: INSERT INTO JAI_AR_TRX_UPDATE_T(
939: trx_ID, modified_flag,
940: -- added, Harshita for Bug 4866533
941: created_by, creation_date, last_updated_by, last_update_date
942: ) VALUES (