APPS.PA_FP_CI_MERGE dependencies on PA_FP_TXN_CURRENCIES

Line 3958: -- Add the currencies in the source which are not there already to PA_FP_TXN_CURRENCIES

3954: RAISE NO_DATA_FOUND;
3955: END;
3956:
3957: --dbms_output.put_line('I8');
3958: -- Add the currencies in the source which are not there already to PA_FP_TXN_CURRENCIES
3959: IF l_src_multi_curr_flag = 'Y' AND l_targ_multi_curr_flag = 'Y' AND nvl(l_targ_app_rev_flag, 'N') = 'N' THEN
3960:
3961: SELECT ptxn_s.txn_currency_code
3962: BULK COLLECT INTO l_txn_curr_code_tbl

Line 3963: FROM pa_fp_txn_currencies ptxn_s

3959: IF l_src_multi_curr_flag = 'Y' AND l_targ_multi_curr_flag = 'Y' AND nvl(l_targ_app_rev_flag, 'N') = 'N' THEN
3960:
3961: SELECT ptxn_s.txn_currency_code
3962: BULK COLLECT INTO l_txn_curr_code_tbl
3963: FROM pa_fp_txn_currencies ptxn_s
3964: WHERE ptxn_s.proj_fp_options_id=l_src_proj_fp_options_id
3965: AND NOT EXISTS (SELECT 'X'
3966: FROM pa_fp_txn_currencies ptxn_t
3967: WHERE ptxn_t.proj_fp_options_id=l_targ_proj_fp_options_id

Line 3966: FROM pa_fp_txn_currencies ptxn_t

3962: BULK COLLECT INTO l_txn_curr_code_tbl
3963: FROM pa_fp_txn_currencies ptxn_s
3964: WHERE ptxn_s.proj_fp_options_id=l_src_proj_fp_options_id
3965: AND NOT EXISTS (SELECT 'X'
3966: FROM pa_fp_txn_currencies ptxn_t
3967: WHERE ptxn_t.proj_fp_options_id=l_targ_proj_fp_options_id
3968: AND ptxn_t.txn_currency_code=ptxn_s.txn_currency_code);
3969:
3970:

Line 3991: INSERT INTO PA_FP_TXN_CURRENCIES (

3987: END IF;
3988:
3989: IF l_txn_curr_code_tbl.COUNT > 0 THEN
3990: Forall jj in l_txn_curr_code_tbl.FIRST..l_txn_curr_code_tbl.LAST
3991: INSERT INTO PA_FP_TXN_CURRENCIES (
3992: fp_txn_currency_id
3993: ,proj_fp_options_id
3994: ,project_id
3995: ,fin_plan_type_id

Line 4014: ( pa_fp_txn_currencies_s.NEXTVAL

4010: ,projfunc_cost_exchange_Rate
4011: ,projfunc_rev_exchange_Rate
4012: )
4013: VALUES
4014: ( pa_fp_txn_currencies_s.NEXTVAL
4015: , l_targ_proj_fp_options_id
4016: , l_PROJECT_ID
4017: , p_fin_plan_type_id
4018: , p_budget_version_id