DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_FLEX_MAPPING_PVT

Line 11190: PSB_Flex_Mapping_PVT.Flex_Info(

11186:
11187: --
11188: BEGIN
11189:
11190: PSB_Flex_Mapping_PVT.Flex_Info(
11191: p_flex_code => p_chart_of_accounts_id,
11192: p_return_status => l_return_status
11193: );
11194: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 11204: /*FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP

11200: --
11201: /*For Bug No : 2127951 Start*/
11202: --the following code has been commented because of the
11203: --initialization has to be done for each segment group
11204: /*FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP
11205: l_seg_apply_cr(l_index) := 0;
11206: l_seg_balance_cr(l_index) := 0;
11207: l_seg_apply_dr(l_index) := 0;
11208: l_seg_balance_dr(l_index) := 0;

Line 11311: FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP

11307: FETCH l_seg_cur INTO l_seg_value;
11308: EXIT WHEN l_seg_cur%NOTFOUND;
11309:
11310: --for every segment initialize the array to zero values
11311: FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP
11312: l_seg_apply_cr(l_index) := 0;
11313: l_seg_balance_cr(l_index) := 0;
11314: l_seg_apply_dr(l_index) := 0;
11315: l_seg_balance_dr(l_index) := 0;

Line 11357: FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP

11353:
11354: END LOOP;
11355: CLOSE l_acct_cur;
11356: --End of the segment validation cursor
11357: FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP
11358: IF ( l_seg_apply_dr(l_index) = l_seg_balance_cr(l_index) AND l_seg_apply_cr(l_index) = l_seg_balance_dr(l_index) ) THEN
11359: IF (p_rule_validation_status IS NULL OR p_rule_validation_status <> 'F' ) THEN
11360: p_rule_validation_status := 'S';
11361: END IF;

Line 11389: FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP

11385: END IF;
11386: --
11387: ELSIF p_application_column_name IS NOT null THEN
11388: --
11389: FOR l_index IN 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP
11390: IF ( l_seg_apply_dr(l_index) = l_seg_balance_cr(l_index) AND l_seg_apply_cr(l_index) = l_seg_balance_dr(l_index) ) THEN
11391: if p_rule_validation_status = 'F' then
11392: p_rule_validation_status := 'F';
11393: else

Line 11618: FOR i in 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP

11614: END IF;
11615: END IF;
11616: ELSIF p_application_column_name is not null THEN
11617: --
11618: FOR i in 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP
11619: --
11620: IF PSB_Flex_Mapping_PVT.g_seg_name(i) = p_application_column_name THEN
11621: --
11622: IF p_apply_balance_flag = 'A' then

Line 11620: IF PSB_Flex_Mapping_PVT.g_seg_name(i) = p_application_column_name THEN

11616: ELSIF p_application_column_name is not null THEN
11617: --
11618: FOR i in 1..PSB_Flex_Mapping_PVT.g_num_segs LOOP
11619: --
11620: IF PSB_Flex_Mapping_PVT.g_seg_name(i) = p_application_column_name THEN
11621: --
11622: IF p_apply_balance_flag = 'A' then
11623: IF l_account_type IN('A','E') THEN
11624: IF (l_revision_type = 'I' AND p_apply_account_set_flag <> 'D') THEN