[Home] [Help]
1070: --
1071: l_proc varchar2(72) := g_package||'.update_period_amt_tab';
1072: l_period_name gl_period_statuses.period_name%TYPE;
1073: l_accounting_date gl_period_statuses.start_date%TYPE;
1074: l_code_combination_id gl_code_combinations.code_combination_id%TYPE;
1075: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1076: l_message_text pqh_process_log.message_text%TYPE;
1077: l_message_text_out fnd_new_messages.message_text%TYPE;
1078: l_count NUMBER;
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
2076: cost_allocation_keyflex_id. The mapping between the gl segments and cost_allocation_keyflex segments is
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
2076: cost_allocation_keyflex_id. The mapping between the gl segments and cost_allocation_keyflex segments is
2077: stored in pqh_gl_flex_maps table corresponding to the current budget.
2078:
2079: First we will check to see if there are any defaults set for cost segments and if so populate the
2099: sql_stmt varchar2(8000) := '';
2100:
2101: TYPE SegCurTyp IS REF CURSOR;
2102: seg_cv SegCurTyp;
2103: l_gl_cc_rec gl_code_combinations%ROWTYPE;
2104: l_gl_cc_count number ;
2105:
2106:
2107: CURSOR csr_cost_segments IS
2253: END IF;
2254:
2255: hr_utility.set_location('Built dynamic select ',26);
2256: --
2257: sql_stmt := 'SELECT * FROM gl_code_combinations WHERE chart_of_accounts_id = :g_chart_of_accounts_id and '||l_where_str ;
2258:
2259: hr_utility.set_location('sql stmt : '||substr(sql_stmt,1,50),27);
2260: hr_utility.set_location('sql stmt : '||substr(sql_stmt,51,50),27);
2261: hr_utility.set_location('sql stmt : '||substr(sql_stmt,101,50),27);
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: --
4196: l_proc varchar2(72) := g_package||'.get_ccid_for_commitment';
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: --
4196: l_proc varchar2(72) := g_package||'.get_ccid_for_commitment';
4197: --
4198: BEGIN