APPS.PQH_GL_POSTING dependencies on FND_ID_FLEX_SEGMENTS

Line 2964: l_fnd_id_flex_segments fnd_id_flex_segments%ROWTYPE;

2960: --
2961: l_proc varchar2(72) := g_package||'populate_budget_gl_map';
2962: l_budgets_rec pqh_budgets%ROWTYPE;
2963: l_sets_of_books_rec gl_sets_of_books%ROWTYPE;
2964: l_fnd_id_flex_segments fnd_id_flex_segments%ROWTYPE;
2965: l_budget_gl_flex_map_id number(15);
2966: l_object_version_number number(9);
2967:
2968: CURSOR csr_budget_rec IS

Line 2980: FROM fnd_id_flex_segments

2976: WHERE set_of_books_id = p_set_of_books_id;
2977:
2978: CURSOR csr_flex_segments (p_id_flex_num IN number)IS
2979: SELECT *
2980: FROM fnd_id_flex_segments
2981: WHERE application_id = 101
2982: AND id_flex_code = 'GL#'
2983: AND id_flex_num = p_id_flex_num
2984: AND enabled_flag = 'Y'

Line 3009: FETCH csr_flex_segments INTO l_fnd_id_flex_segments;

3005:
3006: -- populate the pqh_budget_gl_flex_maps with the segments
3007: OPEN csr_flex_segments (p_id_flex_num => l_sets_of_books_rec.chart_of_accounts_id );
3008: LOOP
3009: FETCH csr_flex_segments INTO l_fnd_id_flex_segments;
3010: EXIT WHEN csr_flex_segments%NOTFOUND;
3011: -- call the insert API here
3012: pqh_budget_gl_flex_maps_api.create_budget_gl_flex_map
3013: (

Line 3017: ,p_gl_account_segment => l_fnd_id_flex_segments.application_column_name

3013: (
3014: p_validate => false
3015: ,p_budget_gl_flex_map_id => l_budget_gl_flex_map_id
3016: ,p_budget_id => p_budget_id
3017: ,p_gl_account_segment => l_fnd_id_flex_segments.application_column_name
3018: ,p_payroll_cost_segment => null
3019: ,p_object_version_number => l_object_version_number
3020: );
3021:

Line 3022: hr_utility.set_location('Segment : '||l_fnd_id_flex_segments.application_column_name, 200);

3018: ,p_payroll_cost_segment => null
3019: ,p_object_version_number => l_object_version_number
3020: );
3021:
3022: hr_utility.set_location('Segment : '||l_fnd_id_flex_segments.application_column_name, 200);
3023: hr_utility.set_location('budget_gl_flex_map_id : '||l_budget_gl_flex_map_id,250);
3024:
3025: END LOOP;
3026: CLOSE csr_flex_segments;