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 1078: FROM pa_ci_impacts

1074: INTO l_impact_record_exists
1075: FROM DUAL
1076: WHERE EXISTS
1077: (SELECT 1
1078: FROM pa_ci_impacts
1079: WHERE ci_id = l_t_fp_ci_id
1080: AND (l_s_version_type IN ('REVENUE','ALL') AND impact_type_code = 'FINPLAN_REVENUE'
1081: OR l_s_version_type IN ('COST','ALL') AND impact_type_code = 'FINPLAN_COST'));
1082: EXCEPTION

Line 1510: FROM pa_ci_impacts

1506: INTO l_impact_record_exists
1507: FROM DUAL
1508: WHERE EXISTS
1509: (SELECT 1
1510: FROM pa_ci_impacts
1511: WHERE ci_id = l_t_fp_ci_id
1512: AND (l_s_version_type IN ('REVENUE') AND impact_type_code = 'FINPLAN_REVENUE'
1513: OR l_s_version_type IN ('COST') AND impact_type_code = 'FINPLAN_COST'));
1514: EXCEPTION

Line 2073: FROM pa_ci_impacts

2069: INTO l_impact_record_exists
2070: FROM DUAL
2071: WHERE EXISTS
2072: (SELECT 1
2073: FROM pa_ci_impacts
2074: WHERE ci_id = l_t_fp_ci_id
2075: AND (l_s_version_type IN ('REVENUE') AND impact_type_code = 'FINPLAN_REVENUE'
2076: OR l_s_version_type IN ('COST') AND impact_type_code = 'FINPLAN_COST'));
2077: EXCEPTION

Line 2856: p_ci_id IN pa_ci_impacts.ci_id%TYPE,

2852:
2853: PROCEDURE FP_CI_MANUAL_MERGE
2854: (
2855: p_project_id IN NUMBER,
2856: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
2857: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
2858: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
2859: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
2860: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 3491: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;

3487: l_src_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3488: l_impl_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3489: l_impl_qty_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
3490:
3491: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
3492:
3493: l_record_version_number pa_budget_versions.record_version_number%TYPE;
3494: l_partial_factor NUMBER := 1;
3495: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;