DBA Data[Home] [Help]

APPS.PA_FP_CI_MERGE dependencies on PA_BUDGET_VERSIONS

Line 12: p_s_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

8:
9: PROCEDURE FP_CI_LINK_CONTROL_ITEMS
10: (
11: p_project_id IN NUMBER,
12: p_s_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
13: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
14: p_inclusion_method IN VARCHAR2 DEFAULT 'AUTOMATIC',
15: p_included_by IN NUMBER DEFAULT NULL,
16: --Added for bug 3550073

Line 13: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

9: PROCEDURE FP_CI_LINK_CONTROL_ITEMS
10: (
11: p_project_id IN NUMBER,
12: p_s_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
13: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
14: p_inclusion_method IN VARCHAR2 DEFAULT 'AUTOMATIC',
15: p_included_by IN NUMBER DEFAULT NULL,
16: --Added for bug 3550073
17: p_version_type IN pa_budget_versions.version_type%TYPE,

Line 17: p_version_type IN pa_budget_versions.version_type%TYPE,

13: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
14: p_inclusion_method IN VARCHAR2 DEFAULT 'AUTOMATIC',
15: p_included_by IN NUMBER DEFAULT NULL,
16: --Added for bug 3550073
17: p_version_type IN pa_budget_versions.version_type%TYPE,
18: p_ci_id IN pa_control_items.ci_id%TYPE,
19: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
20: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
21: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,

Line 38: p_s_fp_ci_id IN pa_budget_versions.ci_id%TYPE,

34:
35: PROCEDURE FP_CI_MERGE_CI_ITEMS
36: (
37: p_project_id IN NUMBER,
38: p_s_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
39: p_t_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
40: p_merge_unmerge_mode IN VARCHAR2 DEFAULT 'MERGE',
41: p_commit_flag IN VARCHAR2 DEFAULT 'N',
42: p_init_msg_list IN VARCHAR2 DEFAULT 'N',

Line 39: p_t_fp_ci_id IN pa_budget_versions.ci_id%TYPE,

35: PROCEDURE FP_CI_MERGE_CI_ITEMS
36: (
37: p_project_id IN NUMBER,
38: p_s_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
39: p_t_fp_ci_id IN pa_budget_versions.ci_id%TYPE,
40: p_merge_unmerge_mode IN VARCHAR2 DEFAULT 'MERGE',
41: p_commit_flag IN VARCHAR2 DEFAULT 'N',
42: p_init_msg_list IN VARCHAR2 DEFAULT 'N',
43: p_calling_context IN VARCHAR2 DEFAULT 'COPY',

Line 69: ( p_project_id IN pa_budget_versions.project_id%TYPE

65: ) ;
66:
67: --Bug 4247703. Added the parameter 4247703. The valid values are NULL or GENERATION
68: PROCEDURE copy_merged_ctrl_items
69: ( p_project_id IN pa_budget_versions.project_id%TYPE
70: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE
71: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE
72: ,p_calling_context IN VARCHAR2 DEFAULT NULL
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 70: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE

66:
67: --Bug 4247703. Added the parameter 4247703. The valid values are NULL or GENERATION
68: PROCEDURE copy_merged_ctrl_items
69: ( p_project_id IN pa_budget_versions.project_id%TYPE
70: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE
71: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE
72: ,p_calling_context IN VARCHAR2 DEFAULT NULL
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 71: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE

67: --Bug 4247703. Added the parameter 4247703. The valid values are NULL or GENERATION
68: PROCEDURE copy_merged_ctrl_items
69: ( p_project_id IN pa_budget_versions.project_id%TYPE
70: ,p_source_version_id IN pa_budget_versions.budget_version_id%TYPE
71: ,p_target_version_id IN pa_budget_versions.budget_version_id%TYPE
72: ,p_calling_context IN VARCHAR2 DEFAULT NULL
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
75: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 79: p_project_id IN pa_budget_versions.project_id%TYPE,

75: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
76:
77: PROCEDURE FP_CI_UPDATE_EST_AMOUNTS
78: (
79: p_project_id IN pa_budget_versions.project_id%TYPE,
80: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
81: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
82: p_merge_unmerge_mode IN VARCHAR2 DEFAULT 'MERGE',
83: p_commit_flag IN VARCHAR2 DEFAULT 'N',

Line 80: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

76:
77: PROCEDURE FP_CI_UPDATE_EST_AMOUNTS
78: (
79: p_project_id IN pa_budget_versions.project_id%TYPE,
80: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
81: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
82: p_merge_unmerge_mode IN VARCHAR2 DEFAULT 'MERGE',
83: p_commit_flag IN VARCHAR2 DEFAULT 'N',
84: p_init_msg_list IN VARCHAR2 DEFAULT 'N',

Line 81: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,

77: PROCEDURE FP_CI_UPDATE_EST_AMOUNTS
78: (
79: p_project_id IN pa_budget_versions.project_id%TYPE,
80: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
81: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
82: p_merge_unmerge_mode IN VARCHAR2 DEFAULT 'MERGE',
83: p_commit_flag IN VARCHAR2 DEFAULT 'N',
84: p_init_msg_list IN VARCHAR2 DEFAULT 'N',
85: p_update_agreement IN VARCHAR2 DEFAULT 'N',

Line 95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

91: PROCEDURE FP_CI_MANUAL_MERGE
92: (
93: p_project_id IN NUMBER,
94: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
99: p_targ_version_type IN pa_budget_versions.version_type%TYPE,

Line 96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

92: (
93: p_project_id IN NUMBER,
94: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
99: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,

93: p_project_id IN NUMBER,
94: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
99: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,

94: p_ci_id IN pa_ci_impacts.ci_id%TYPE,
95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
99: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
102: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 99: p_targ_version_type IN pa_budget_versions.version_type%TYPE,

95: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
96: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
97: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
98: p_t_fp_version_id IN pa_budget_versions.budget_version_id%TYPE,
99: p_targ_version_type IN pa_budget_versions.version_type%TYPE,
100: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
102: x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
103: ----------------------------------------------------------------------------------------------------------