APPS.CSC_PROFILE_ENGINE_PKG dependencies on CCT_MEDIA_ITEMS

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

9515:
9516: /*******************************************
9517: UPDATE_JIT_STATUS
9518: added this procedure for JIT enhancement -- Bug 4535407
9519: Updates the columns jit_status, jit_err_code in CCT_MEDIA_ITEMS.
9520: Called from CSC_PROF_JIT
9521: ********************************************/
9522:
9523: PROCEDURE update_jit_status ( p_status VARCHAR2 DEFAULT NULL,

Line 9529: UPDATE CCT_MEDIA_ITEMS

9525: p_media_item_id NUMBER
9526: ) IS
9527: PRAGMA AUTONOMOUS_TRANSACTION;
9528: BEGIN
9529: UPDATE CCT_MEDIA_ITEMS
9530: SET jit_status = p_status,
9531: jit_err_code = p_err_code
9532: WHERE media_item_id = p_media_item_id;
9533: COMMIT;

Line 9589: FROM CCT_MEDIA_ITEMS

9585: l_jit_complete_status VARCHAR2(30) := 'COMPLETED';
9586: l_sql_code NUMBER;
9587: CURSOR chk_status IS
9588: SELECT jit_status
9589: FROM CCT_MEDIA_ITEMS
9590: WHERE media_item_id = l_media_item_id;
9591:
9592: CURSOR group_crs IS
9593: SELECT a.dashboard_group_id