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 PAY_COST_ALLOCATION_KEYFLEX

Line 2071: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,

2067: PROCEDURE get_gl_ccid
2068: (
2069: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
2070: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
2071: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
2072: p_code_combination_id OUT NOCOPY gl_code_combinations.code_combination_id%TYPE
2073: ) IS
2074: /*
2075: This procedure will return the code_combination_id from gl_code_combinations corresponding to the

Line 2095: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;

2091: --
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) := '';

Line 2109: FROM pay_cost_allocation_keyflex

2105:
2106:
2107: CURSOR csr_cost_segments IS
2108: SELECT *
2109: FROM pay_cost_allocation_keyflex
2110: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
2111:
2112:
2113: CURSOR csr_map_segments IS

Line 2740: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,

2736: END set_bpr_log_context;
2737: --------------------------------------------------------------------------------------------------------------
2738: PROCEDURE set_bfs_log_context
2739: (
2740: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
2741: p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
2742: ) IS
2743:
2744: /*

Line 2748: Table : pay_cost_allocation_keyflex

2744: /*
2745: This procedure will set the log_context at wks budget fund srcs level
2746:
2747: Display the CONCATENATED_SEGMENTS
2748: Table : pay_cost_allocation_keyflex
2749:
2750: */
2751:
2752: l_proc varchar2(72) := g_package||'set_bfs_log_context';

Line 2753: l_pay_cost_allocation_kf_rec pay_cost_allocation_keyflex%ROWTYPE;

2749:
2750: */
2751:
2752: l_proc varchar2(72) := g_package||'set_bfs_log_context';
2753: l_pay_cost_allocation_kf_rec pay_cost_allocation_keyflex%ROWTYPE;
2754:
2755:
2756: CURSOR csr_pay_cost_allocation_kf_rec IS
2757: SELECT *

Line 2758: FROM pay_cost_allocation_keyflex

2754:
2755:
2756: CURSOR csr_pay_cost_allocation_kf_rec IS
2757: SELECT *
2758: FROM pay_cost_allocation_keyflex
2759: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
2760:
2761: BEGIN
2762:

Line 3613: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

3609: -- local variables
3610: --
3611: l_proc varchar2(72) := g_package||' .get_payroll_defaults';
3612:
3613: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3614: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3615:
3616: CURSOR csr_cost_allocation_keyflex_id IS
3617: SELECT cost_allocation_keyflex_id

Line 3614: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;

3610: --
3611: l_proc varchar2(72) := g_package||' .get_payroll_defaults';
3612:
3613: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3614: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3615:
3616: CURSOR csr_cost_allocation_keyflex_id IS
3617: SELECT cost_allocation_keyflex_id
3618: FROM PAY_ALL_PAYROLLS_F pay,

Line 3637: FROM pay_cost_allocation_keyflex

3633: );
3634:
3635: CURSOR csr_cost_segments (p_cost_allocation_keyflex_id IN number) IS
3636: SELECT *
3637: FROM pay_cost_allocation_keyflex
3638: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3639:
3640:
3641:

Line 3823: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

3819: -- local variables
3820: --
3821: l_proc varchar2(72) := g_package||' .get_element_link_defaults';
3822:
3823: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3824: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3825:
3826: CURSOR csr_cost_allocation_keyflex_id IS
3827: SELECT cost_allocation_keyflex_id

Line 3824: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;

3820: --
3821: l_proc varchar2(72) := g_package||' .get_element_link_defaults';
3822:
3823: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3824: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3825:
3826: CURSOR csr_cost_allocation_keyflex_id IS
3827: SELECT cost_allocation_keyflex_id
3828: FROM pqh_budget_details bdt, pqh_budget_periods bpr,

Line 3842: FROM pay_cost_allocation_keyflex

3838:
3839:
3840: CURSOR csr_cost_segments (p_cost_allocation_keyflex_id IN number) IS
3841: SELECT *
3842: FROM pay_cost_allocation_keyflex
3843: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3844:
3845:
3846:

Line 3934: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;

3930: -- local variables
3931: --
3932: l_proc varchar2(72) := g_package||' .get_organization_defaults';
3933:
3934: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3935: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3936:
3937: CURSOR csr_cost_allocation_keyflex_id IS
3938: SELECT cost_allocation_keyflex_id

Line 3935: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;

3931: --
3932: l_proc varchar2(72) := g_package||' .get_organization_defaults';
3933:
3934: l_cost_allocation_keyflex_id pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE;
3935: l_pay_cost_allocation_rec pay_cost_allocation_keyflex%ROWTYPE;
3936:
3937: CURSOR csr_cost_allocation_keyflex_id IS
3938: SELECT cost_allocation_keyflex_id
3939: FROM pqh_budget_details bdt,

Line 3947: FROM pay_cost_allocation_keyflex

3943:
3944:
3945: CURSOR csr_cost_segments (p_cost_allocation_keyflex_id IN number) IS
3946: SELECT *
3947: FROM pay_cost_allocation_keyflex
3948: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
3949:
3950:
3951:

Line 4191: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,

4187: p_budget_id IN pqh_budgets.budget_id%type,
4188: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%TYPE,
4189: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
4190: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
4191: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
4192: p_code_combination_id OUT NOCOPY gl_code_combinations.code_combination_id%TYPE) IS
4193: --
4194: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
4195: --