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.PA_FP_CI_MERGE dependencies on PA_CI_IMPACTS

Line 681: p_ci_id IN pa_ci_impacts.ci_id%TYPE,

677: --p_impact_type can be FINPLAN_COST, FINPLAN_REVENUE or
678: --FINPLAN_BOTH in which case both FINPLAN_COST and FINPLAN_REVENUE records will be updated
679: PROCEDURE FP_CI_UPDATE_IMPACT
680: (
681: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
682: p_status_code IN pa_ci_impacts.status_code%TYPE,
683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,

Line 682: p_status_code IN pa_ci_impacts.status_code%TYPE,

678: --FINPLAN_BOTH in which case both FINPLAN_COST and FINPLAN_REVENUE records will be updated
679: PROCEDURE FP_CI_UPDATE_IMPACT
680: (
681: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
682: p_status_code IN pa_ci_impacts.status_code%TYPE,
683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,
686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,

Line 683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,

679: PROCEDURE FP_CI_UPDATE_IMPACT
680: (
681: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
682: p_status_code IN pa_ci_impacts.status_code%TYPE,
683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,
686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,
687: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,

Line 684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,

680: (
681: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
682: p_status_code IN pa_ci_impacts.status_code%TYPE,
683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,
686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,
687: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,
688: p_commit_flag IN VARCHAR2 ,

Line 685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,

681: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
682: p_status_code IN pa_ci_impacts.status_code%TYPE,
683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,
686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,
687: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,
688: p_commit_flag IN VARCHAR2 ,
689: p_init_msg_list IN VARCHAR2 ,

Line 686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,

682: p_status_code IN pa_ci_impacts.status_code%TYPE,
683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,
686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,
687: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,
688: p_commit_flag IN VARCHAR2 ,
689: p_init_msg_list IN VARCHAR2 ,
690: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 687: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,

683: p_implementation_date IN pa_ci_impacts.implementation_date%TYPE,
684: p_implemented_by IN pa_ci_impacts.implemented_by%TYPE,
685: p_record_version_number IN pa_ci_impacts.record_version_number%TYPE,
686: p_impacted_task_id IN pa_ci_impacts.impacted_task_id%TYPE,
687: p_impact_type_code IN pa_ci_impacts.impact_type_code%TYPE,
688: p_commit_flag IN VARCHAR2 ,
689: p_init_msg_list IN VARCHAR2 ,
690: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
691: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 786: -- Update the PA_CI_IMPACTS table

782: and hp.party_id = fu.person_party_id;
783: --and hp.party_id = fu.customer_id;
784: END;
785:
786: -- Update the PA_CI_IMPACTS table
787:
788: UPDATE PA_CI_IMPACTS
789: SET
790: STATUS_CODE = NVL(p_status_code,status_code),

Line 788: UPDATE PA_CI_IMPACTS

784: END;
785:
786: -- Update the PA_CI_IMPACTS table
787:
788: UPDATE PA_CI_IMPACTS
789: SET
790: STATUS_CODE = NVL(p_status_code,status_code),
791: IMPLEMENTATION_DATE = NVL(p_implementation_date,SYSDATE),
792: IMPLEMENTED_BY = l_party_id,

Line 1090: FROM pa_ci_impacts

1086: INTO l_impact_record_exists
1087: FROM DUAL
1088: WHERE EXISTS
1089: (SELECT 1
1090: FROM pa_ci_impacts
1091: WHERE ci_id = l_t_fp_ci_id
1092: AND (l_s_version_type IN ('REVENUE','ALL') AND impact_type_code = 'FINPLAN_REVENUE'
1093: OR l_s_version_type IN ('COST','ALL') AND impact_type_code = 'FINPLAN_COST'));
1094: EXCEPTION

Line 1344: FROM pa_ci_impacts

1340: INTO l_impact_record_exists
1341: FROM DUAL
1342: WHERE EXISTS
1343: (SELECT 1
1344: FROM pa_ci_impacts
1345: WHERE ci_id = l_t_fp_ci_id
1346: AND (l_s_version_type IN ('REVENUE') AND impact_type_code = 'FINPLAN_REVENUE'
1347: OR l_s_version_type IN ('COST','ALL') AND impact_type_code = 'FINPLAN_COST'));
1348: EXCEPTION

Line 1685: FROM pa_ci_impacts

1681: INTO l_impact_record_exists
1682: FROM DUAL
1683: WHERE EXISTS
1684: (SELECT 1
1685: FROM pa_ci_impacts
1686: WHERE ci_id = l_t_fp_ci_id
1687: AND (l_s_version_type IN ('REVENUE') AND impact_type_code = 'FINPLAN_REVENUE'
1688: OR l_s_version_type IN ('COST','ALL') AND impact_type_code = 'FINPLAN_COST'));
1689: EXCEPTION

Line 2212: p_ci_id IN pa_ci_impacts.ci_id%TYPE,

2208:
2209: PROCEDURE FP_CI_MANUAL_MERGE
2210: (
2211: p_project_id IN NUMBER,
2212: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
2213: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2214: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2215: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2216: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 2847: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;

2843: l_src_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2844: l_impl_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2845: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2846:
2847: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
2848:
2849: l_record_version_number pa_budget_versions.record_version_number%TYPE;
2850: l_partial_factor NUMBER := 1;
2851: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;