[Home] [Help]
2281: UPDATE fii_budget_interface int
2282: SET (int.user_dim1_id, int.user_dim1,
2283: int.user_dim2_id, int.user_dim2) =
2284: (SELECT l_id_val_rec.l_id(i), l_id_val_rec.l_value(i),
2285: FIIBUUP_UNASSIGNED_UDD_ID, 'UNASSIGNED' from dual)
2286: WHERE NVL(int.user_dim1, 'UNASSIGNED') = l_id_val_rec.l_value(i)
2287: AND int.ledger_id = l_id_val_rec.l_ledger_id(i);
2288:
2289: CLOSE udd1_cursor;
2293: -- the pre-seeded unassigned ID.
2294: UPDATE fii_budget_interface int
2295: SET (int.user_dim1_id, int.user_dim1, int.user_dim2_id, int.user_dim2) =
2296: (SELECT FIIBUUP_UNASSIGNED_UDD_ID, 'UNASSIGNED',
2297: FIIBUUP_UNASSIGNED_UDD_ID, 'UNASSIGNED' from dual);
2298:
2299: END IF;
2300:
2301: -- Process Product Category Dimension
2615: AND fs.application_column_name = mr.application_column_name1
2616: AND mr.dimension_short_name = 'FII_USER_DEFINED_1'
2617: AND fv.flex_value_set_id = fs.flex_value_set_id
2618: UNION
2619: SELECT FIIBUUP_UNASSIGNED_UDD_ID from DUAL))
2620: FOR UPDATE OF b.STATUS_CODE;
2621:
2622: -- This is the cursor that validates conversion rates are present
2623: -- for any record with only the primary global amount provided, and
2746: END IF;
2747:
2748: g_phase := 'Update all other records to status_code = VALIDATED and upload_date = sysdate';
2749: update FII_BUDGET_INTERFACE
2750: set (status_code, upload_date) = (SELECT 'VALIDATED', sysdate from dual);
2751:
2752: -- Bug fix 4943332: We don't need to count the rows of FII_BUDGET_INTERFACE
2753: -- as we can get the row count updated by previuos SQL
2754: IF (SQL%ROWCOUNT = 0) THEN
2973: l_print_hdr1 := TRUE;
2974: END IF;
2975:
2976:
2977: -- Print out individual invalid reporting time period
2978: FII_MESSAGE.Write_Output
2979: (msg_name => 'FII_TIM_PRD',
2980: token_num => 1,
2981: t1 => 'TIME_PERIOD',
3063: token_num => 0);
3064: l_print_hdr1 := TRUE;
3065: END IF;
3066:
3067: -- Print out individual invalid reporting time period
3068: FII_MESSAGE.Write_Output
3069: (msg_name => 'FII_TIM_PRD',
3070: token_num => 1,
3071: t1 => 'TIME_PERIOD',
3317:
3318: l_print_hdr1 := TRUE;
3319: END IF;
3320:
3321: -- print out individual invalid ledger id
3322: FII_UTIL.Write_Output (l_ledger_id || ' ' || l_ledger);
3323:
3324: UPDATE FII_BUDGET_INTERFACE
3325: SET status_code = 'ERROR'
3361:
3362: l_print_hdr1 := TRUE;
3363: END IF;
3364:
3365: -- print out individual invalid company id
3366: FII_UTIL.Write_Output (l_com_id || ' ' || l_com);
3367:
3368: UPDATE FII_BUDGET_INTERFACE
3369: SET status_code = 'ERROR'
3405:
3406: l_print_hdr1 := TRUE;
3407: END IF;
3408:
3409: -- print out individual invalid cost center id
3410: FII_UTIL.Write_Output (l_cc_id || ' ' || l_cc);
3411:
3412: UPDATE FII_BUDGET_INTERFACE
3413: SET status_code = 'ERROR'
3448:
3449: l_print_hdr1 := TRUE;
3450: END IF;
3451:
3452: -- print out individual invalid financial category id
3453: FII_UTIL.Write_Output (l_fin_cat_id || ' ' || l_fin_item);
3454:
3455: UPDATE FII_BUDGET_INTERFACE
3456: SET status_code = 'ERROR'
3495:
3496: l_print_hdr1 := TRUE;
3497: END IF;
3498:
3499: -- print out individual invalid product category id
3500: FII_UTIL.Write_Output (l_prod_cat_id || ' ' || l_prod_code);
3501:
3502: UPDATE FII_BUDGET_INTERFACE
3503: SET Status_Code = 'ERROR'
3542:
3543: l_print_hdr1 := TRUE;
3544: END IF;
3545:
3546: -- print out individual invalid user defined dimension 1 ID
3547: FII_UTIL.Write_Output (l_udd1_id || ' ' || l_udd1);
3548:
3549: UPDATE FII_BUDGET_INTERFACE
3550: SET status_code = 'ERROR'
3648: token_num => 0);
3649: l_print_hdr2 := TRUE;
3650: END IF;
3651:
3652: -- Print out individual duplicate record
3653: FII_UTIL.Write_Output (l_ver_date || ' ' ||
3654: l_time_unit || ' ' ||
3655: l_ledger_id || ' ' ||
3656: l_com_id || ' ' ||
3722: token_num => 0);
3723: l_print_hdr2 := TRUE;
3724: END IF;
3725:
3726: -- Print out individual record with invalid version date
3727: FII_UTIL.Write_Output (l_ver_date || ' ' ||
3728: l_time_unit || ' ' ||
3729: l_ledger_id || ' ' ||
3730: l_com_id || ' ' ||
3781: token_num => 0);
3782: l_print_hdr2 := TRUE;
3783: END IF;
3784:
3785: -- Print out individual record with invalid version date
3786: FII_UTIL.Write_Output (l_ver_date || ' ' ||
3787: l_time_unit || ' ' ||
3788: l_ledger_id || ' ' ||
3789: l_com_id || ' ' ||
3840: token_num => 0);
3841: l_print_hdr2 := TRUE;
3842: END IF;
3843:
3844: -- Print out individual record with invalid version date
3845: FII_UTIL.Write_Output (l_ver_date || ' ' ||
3846: l_time_unit || ' ' ||
3847: l_ledger_id || ' ' ||
3848: l_com_id || ' ' ||
7143: g_phase := 'Indicate in FII_CHANGE_LOG - budget needs to be dropped';
7144:
7145: MERGE INTO FII_CHANGE_LOG l1
7146: USING
7147: (SELECT 'TRUNCATE_BUDGET' log_item from DUAL) l2
7148: ON (l1.log_item = l2.log_item)
7149: WHEN MATCHED THEN UPDATE SET
7150: item_value = 'Y',
7151: last_update_date = SYSDATE,
7216: END IF;
7217:
7218: MERGE INTO FII_CHANGE_LOG l1
7219: USING
7220: (SELECT 'TRUNCATE_FORECAST' log_item from DUAL) l2
7221: ON (l1.log_item = l2.log_item)
7222: WHEN MATCHED THEN UPDATE SET
7223: item_value = 'Y',
7224: last_update_date = SYSDATE,