466: open get_dimension_le_ytd (p_t_allowance_balance(i).balance_type_id);
467: fetch get_dimension_le_ytd into l_defined_balance_id;
468: IF get_dimension_le_ytd%NOTFOUND THEN
469: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Balance : '|| p_t_allowance_balance(i).balance_name||' without _LE_YTD');
470: pay_db_pay_setup.create_defined_balance(
471: p_balance_name => p_t_allowance_balance(i).balance_name,
472: p_balance_dimension => '_LE_YTD',
473: p_business_group_name => p_business_group_name
474: );
480: open get_dimension_le_run (p_t_allowance_balance(i).balance_type_id);
481: fetch get_dimension_le_run into l_defined_balance_id;
482: IF get_dimension_le_run%NOTFOUND THEN
483: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Balance : '|| p_t_allowance_balance(i).balance_name||' without _LE_RUN');
484: pay_db_pay_setup.create_defined_balance(
485: p_balance_name => p_t_allowance_balance(i).balance_name,
486: p_balance_dimension => '_LE_RUN',
487: p_business_group_name => p_business_group_name
488: );
502: open get_dimension_le_ytd (p_tl_allowance_balance(i).balance_type_id);
503: fetch get_dimension_le_ytd into l_defined_balance_id;
504: IF get_dimension_le_ytd%NOTFOUND THEN
505: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Balance : '|| p_tl_allowance_balance(i).balance_name||' without _LE_YTD');
506: pay_db_pay_setup.create_defined_balance(
507: p_balance_name => p_tl_allowance_balance(i).balance_name,
508: p_balance_dimension => '_LE_YTD',
509: p_business_group_name => p_business_group_name
510: );
516: open get_dimension_le_run (p_tl_allowance_balance(i).balance_type_id);
517: fetch get_dimension_le_run into l_defined_balance_id;
518: IF get_dimension_le_run%NOTFOUND THEN
519: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Balance : '|| p_tl_allowance_balance(i).balance_name||' without _LE_RUN');
520: pay_db_pay_setup.create_defined_balance(
521: p_balance_name => p_tl_allowance_balance(i).balance_name,
522: p_balance_dimension => '_LE_RUN',
523: p_business_group_name => p_business_group_name
524: );