[Home] [Help]
PACKAGE: APPS.PQH_BUDGET_DATA_MIGRATION
Source
1 package PQH_BUDGET_DATA_MIGRATION AUTHID CURRENT_USER as
2 /* $Header: pqbdgmig.pkh 115.12 2002/11/27 04:21:40 rpasapul ship $ */
3
4 PROCEDURE extract_data
5 (
6 errbuf OUT NOCOPY VARCHAR2,
7 retcode OUT NOCOPY VARCHAR2,
8 p_budget_name IN per_budgets.name%TYPE DEFAULT NULL,
9 p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE,
10 p_business_group_id IN per_budgets.business_group_id%TYPE
11 );
12
13 PROCEDURE populate_budgets
14 (
15 p_per_budgets_rec IN per_budgets%ROWTYPE,
16 p_valid IN varchar2,
17 p_budget_id_o OUT NOCOPY pqh_budgets.budget_id%TYPE,
18 p_tot_budget_val_o OUT NOCOPY per_budget_values.value%TYPE
19 );
20
21 PROCEDURE populate_budget_versions
22 (
23 p_per_budget_ver_rec IN per_budget_versions%ROWTYPE,
24 p_budget_id IN pqh_budgets.budget_id%TYPE,
25 p_budget_version_id_o OUT NOCOPY pqh_budget_versions.budget_version_id%TYPE
26 );
27
28 PROCEDURE populate_budget_details
29 (
30 p_per_budget_elmnt_rec IN per_budget_elements%ROWTYPE,
31 p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE,
32 p_tot_budget_val IN per_budget_values.value%TYPE,
33 p_budget_detail_id_o OUT NOCOPY pqh_budget_details.budget_detail_id%TYPE,
34 p_budget_unit1_value_o OUT NOCOPY pqh_budget_details.budget_unit1_value%TYPE
35 );
36
37 PROCEDURE populate_budget_periods
38 (
39 p_per_budget_val_rec IN per_budget_values%ROWTYPE,
40 p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
41 p_budget_unit1_value IN pqh_budget_details.budget_unit1_value%TYPE,
42 p_budget_period_id_o OUT NOCOPY pqh_budget_periods.budget_period_id%TYPE
43 );
44
45 FUNCTION get_shared_type_id (p_unit IN per_budgets.unit%TYPE )
46 RETURN number;
47
48 PROCEDURE populate_per_shared_types;
49
50 PROCEDURE populate_empty_budget_versions;
51
52 PROCEDURE populate_period_details
53 (
54 p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
55 p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE
56 );
57
58 PROCEDURE populate_budget_sets
59 (
60 p_dflt_budget_sets_rec IN pqh_dflt_budget_sets%ROWTYPE,
61 p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
62 p_budget_set_id_o OUT NOCOPY pqh_budget_sets.budget_set_id%TYPE
63 );
64
65 PROCEDURE populate_budget_elements
66 (
67 p_dflt_budget_elements_rec IN pqh_dflt_budget_elements%ROWTYPE,
68 p_budget_set_id IN pqh_budget_sets.budget_set_id%TYPE,
69 p_budget_element_id_o OUT NOCOPY pqh_budget_elements.budget_element_id%TYPE
70 );
71
72 PROCEDURE populate_budget_fund_srcs
73 (
74 p_dflt_fund_srcs IN pqh_dflt_fund_srcs%ROWTYPE,
75 p_budget_element_id IN pqh_budget_elements.budget_element_id%TYPE,
76 p_budget_fund_src_id_o OUT NOCOPY pqh_budget_fund_srcs.budget_fund_src_id%TYPE
77 );
78
79
80 PROCEDURE populate_globals;
81
82
83 PROCEDURE set_p_bgt_log_context
84 (
85 p_budget_id IN per_budgets.budget_id%TYPE,
86 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
87 );
88
89
90 PROCEDURE set_p_bvr_log_context
91 (
92 p_budget_version_id IN per_budget_versions.budget_version_id%TYPE,
93 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
94 );
95
96 PROCEDURE set_p_bdt_log_context
97 (
98 p_budget_element_id IN per_budget_elements.budget_element_id%TYPE,
99 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
100 );
101
102 PROCEDURE set_p_bpr_log_context
103 (
104 p_budget_value_id IN per_budget_values.budget_value_id%TYPE,
105 p_log_context OUT NOCOPY pqh_process_log.log_context%TYPE
106 );
107
108 PROCEDURE check_params
109 (
110 p_budget_name IN per_budgets.name%TYPE,
111 p_budget_set_name IN pqh_dflt_budget_sets.dflt_budget_set_name%TYPE,
112 p_business_group_id IN per_budgets.business_group_id%TYPE
113 );
114
115 PROCEDURE check_valid_budget
116 (
117 p_per_budgets_rec IN per_budgets%ROWTYPE,
118 p_valid OUT NOCOPY varchar2
119 );
120
121 PROCEDURE migrate_bdgt(p_budget_id in number,
122 p_dflt_budget_set_id in number,
123 p_request_number out nocopy number);
124
125 END; -- Package Specification PQH_BUDGET_DATA_MIGRATION
126