APPS.CSC_PROFILE_ENGINE_PKG dependencies on CCT_MEDIA_ITEMS

Line 6781: Updates the columns jit_status, jit_err_code in CCT_MEDIA_ITEMS.

6777:
6778: /*******************************************
6779: UPDATE_JIT_STATUS
6780: Added this procedure for JIT enhancement -- Bug 4535407
6781: Updates the columns jit_status, jit_err_code in CCT_MEDIA_ITEMS.
6782: Called from CSC_PROF_JIT
6783: ********************************************/
6784:
6785: PROCEDURE update_jit_status

Line 6793: UPDATE CCT_MEDIA_ITEMS

6789: )
6790: IS
6791: PRAGMA AUTONOMOUS_TRANSACTION;
6792: BEGIN
6793: UPDATE CCT_MEDIA_ITEMS
6794: SET jit_status = p_status,
6795: jit_err_code = p_err_code
6796: WHERE media_item_id = p_media_item_id;
6797: COMMIT;

Line 6857: FROM CCT_MEDIA_ITEMS

6853: l_sql_code NUMBER;
6854:
6855: CURSOR chk_status IS
6856: SELECT jit_status
6857: FROM CCT_MEDIA_ITEMS
6858: WHERE media_item_id = l_media_item_id;
6859:
6860: CURSOR group_crs IS
6861: SELECT a.dashboard_group_id