[Home] [Help]
3770: from table qrm_saved_analyses_col.
3771: The label of table qrm_saved_analyses_row will be updated at run
3772: time in OA.
3773:
3774: DEAL_TYPE -> xtr_deal_types.user_deal_type
3775:
3776: DEAL_SUBTYPE -> xtr_deal_subtypes.user_deal_subtype
3777: is taken care in the dynamic cursor when aggregation is done.
3778: ***************************************************************/
3792: FOR i IN 1..p_agg.COUNT LOOP
3793: IF p_agg(i)='DEAL_TYPE' AND p_att_type(i)='C' THEN
3794: --update the column header to reflect user defined DEAL_TYPE
3795: UPDATE qrm_saved_analyses_col
3796: SET a1=(SELECT DISTINCT user_deal_type FROM xtr_deal_types WHERE deal_type=a1), last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3797: WHERE analysis_name=p_name AND type=-1;
3798: COMMIT;
3799:
3800: IF (g_event_level>=g_debug_level) THEN --bug 3236479