eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GL_POSTING dependencies on PQH_BUDGET_GL_FLEX_MAPS

Line 438: FROM pqh_budget_gl_flex_maps

434: WHERE je_category_name = 'Public Sector Budget';
435:
436: CURSOR csr_flex_maps_counts (p_budget_id IN number)IS
437: SELECT COUNT(*)
438: FROM pqh_budget_gl_flex_maps
439: WHERE budget_id = p_budget_id;
440:
441: CURSOR csr_table_route IS
442: -- ns (p_table_alias IN varchar2 )IS

Line 450: FROM pqh_budget_gl_flex_maps

446: -- = p_table_alias;
447:
448: CURSOR csr_cost_map_null (p_budget_id IN number) IS
449: SELECT COUNT(*)
450: FROM pqh_budget_gl_flex_maps
451: WHERE budget_id = p_budget_id
452: AND payroll_cost_segment IS NULL;
453:
454:

Line 594: -- check if rows in pqh_budget_gl_flex_maps with NULL cost segments

590: -- set l_error_flag to Y
591: l_error_flag := 'Y';
592: END IF;
593: ELSE
594: -- check if rows in pqh_budget_gl_flex_maps with NULL cost segments
595: OPEN csr_cost_map_null(p_budget_id => g_budget_id);
596: FETCH csr_cost_map_null INTO l_map_count_null;
597: CLOSE csr_cost_map_null;
598:

Line 2096: l_pqh_budget_gl_flex_maps_rec pqh_budget_gl_flex_maps%ROWTYPE;

2092: -- local variables
2093: --
2094: l_proc varchar2(72) := g_package||'.get_gl_ccid';
2095: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
2096: l_pqh_budget_gl_flex_maps_rec pqh_budget_gl_flex_maps%ROWTYPE;
2097: i BINARY_INTEGER :=1;
2098: l_where_str varchar2(8000) ;
2099: sql_stmt varchar2(8000) := '';
2100:

Line 2115: FROM pqh_budget_gl_flex_maps

2111:
2112:
2113: CURSOR csr_map_segments IS
2114: SELECT *
2115: FROM pqh_budget_gl_flex_maps
2116: WHERE budget_id = g_budget_id ;
2117:
2118: BEGIN
2119:

Line 2221: FETCH csr_map_segments INTO l_pqh_budget_gl_flex_maps_rec;

2217: -- populate the g_map_tab for the current budget id
2218:
2219: OPEN csr_map_segments;
2220: LOOP
2221: FETCH csr_map_segments INTO l_pqh_budget_gl_flex_maps_rec;
2222: EXIT WHEN csr_map_segments%NOTFOUND;
2223: g_map_tab(i).gl_segment_name := l_pqh_budget_gl_flex_maps_rec.GL_ACCOUNT_SEGMENT;
2224: g_map_tab(i).cost_segment_name := l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT;
2225: g_map_tab(i).segment_value := get_value_from_array ( p_segment_name => l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT);

Line 2223: g_map_tab(i).gl_segment_name := l_pqh_budget_gl_flex_maps_rec.GL_ACCOUNT_SEGMENT;

2219: OPEN csr_map_segments;
2220: LOOP
2221: FETCH csr_map_segments INTO l_pqh_budget_gl_flex_maps_rec;
2222: EXIT WHEN csr_map_segments%NOTFOUND;
2223: g_map_tab(i).gl_segment_name := l_pqh_budget_gl_flex_maps_rec.GL_ACCOUNT_SEGMENT;
2224: g_map_tab(i).cost_segment_name := l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT;
2225: g_map_tab(i).segment_value := get_value_from_array ( p_segment_name => l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT);
2226:
2227: hr_utility.set_location('i : '||i,11);

Line 2224: g_map_tab(i).cost_segment_name := l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT;

2220: LOOP
2221: FETCH csr_map_segments INTO l_pqh_budget_gl_flex_maps_rec;
2222: EXIT WHEN csr_map_segments%NOTFOUND;
2223: g_map_tab(i).gl_segment_name := l_pqh_budget_gl_flex_maps_rec.GL_ACCOUNT_SEGMENT;
2224: g_map_tab(i).cost_segment_name := l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT;
2225: g_map_tab(i).segment_value := get_value_from_array ( p_segment_name => l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT);
2226:
2227: hr_utility.set_location('i : '||i,11);
2228: hr_utility.set_location('gl_segment_name: '||g_map_tab(i).gl_segment_name, 15);

Line 2225: g_map_tab(i).segment_value := get_value_from_array ( p_segment_name => l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT);

2221: FETCH csr_map_segments INTO l_pqh_budget_gl_flex_maps_rec;
2222: EXIT WHEN csr_map_segments%NOTFOUND;
2223: g_map_tab(i).gl_segment_name := l_pqh_budget_gl_flex_maps_rec.GL_ACCOUNT_SEGMENT;
2224: g_map_tab(i).cost_segment_name := l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT;
2225: g_map_tab(i).segment_value := get_value_from_array ( p_segment_name => l_pqh_budget_gl_flex_maps_rec.PAYROLL_COST_SEGMENT);
2226:
2227: hr_utility.set_location('i : '||i,11);
2228: hr_utility.set_location('gl_segment_name: '||g_map_tab(i).gl_segment_name, 15);
2229: hr_utility.set_location('cost_segment_name: '||g_map_tab(i).cost_segment_name , 20);

Line 2953: This procedure will populate the pqh_budget_gl_flex_maps

2949: p_budget_id IN pqh_budgets.budget_id%TYPE
2950: ) IS
2951: /*
2952: Called from Budget Charactaristics FORM
2953: This procedure will populate the pqh_budget_gl_flex_maps
2954: This will be called from the Budget Characteristics Form when the user presses the Map Tab
2955: This will get all the segments for the current GL Chart of Account and populate the map table
2956: This procedure will only be called if transfer to gl flag is Y and gl_set_of_books_id is not null
2957: */

Line 3006: -- populate the pqh_budget_gl_flex_maps with the segments

3002: CLOSE csr_gl_sets_of_books_rec;
3003:
3004: hr_utility.set_location('Chart of Account ID : '||l_sets_of_books_rec.chart_of_accounts_id,100);
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;

Line 3012: pqh_budget_gl_flex_maps_api.create_budget_gl_flex_map

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: (
3014: p_validate => false
3015: ,p_budget_gl_flex_map_id => l_budget_gl_flex_map_id
3016: ,p_budget_id => p_budget_id