APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PER_BUDGETS

Line 8: p_budget_name IN per_budgets.name%TYPE DEFAULT NULL,

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:

Line 10: p_business_group_id IN per_budgets.business_group_id%TYPE

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: (

Line 15: p_per_budgets_rec IN per_budgets%ROWTYPE,

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: );

Line 45: FUNCTION get_shared_type_id (p_unit IN per_budgets.unit%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:

Line 85: p_budget_id IN per_budgets.budget_id%TYPE,

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:

Line 110: p_budget_name IN per_budgets.name%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:

Line 112: p_business_group_id IN per_budgets.business_group_id%TYPE

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: (

Line 117: p_per_budgets_rec IN per_budgets%ROWTYPE,

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,