81: (
82: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE
83: );
84:
85: PROCEDURE populate_pqh_gl_interface
86: (
87: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE
88: );
89:
86: (
87: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE
88: );
89:
90: PROCEDURE insert_pqh_gl_interface
91: (
92: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
88: );
89:
90: PROCEDURE insert_pqh_gl_interface
91: (
92: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
89:
90: PROCEDURE insert_pqh_gl_interface
91: (
92: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
90: PROCEDURE insert_pqh_gl_interface
91: (
92: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
98: p_currency_code IN pqh_gl_interface.currency_code%TYPE
91: (
92: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
98: p_currency_code IN pqh_gl_interface.currency_code%TYPE
99: );
92: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
98: p_currency_code IN pqh_gl_interface.currency_code%TYPE
99: );
100:
93: p_period_name IN pqh_gl_interface.period_name%TYPE,
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
98: p_currency_code IN pqh_gl_interface.currency_code%TYPE
99: );
100:
101: PROCEDURE update_pqh_gl_interface
94: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
95: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
98: p_currency_code IN pqh_gl_interface.currency_code%TYPE
99: );
100:
101: PROCEDURE update_pqh_gl_interface
102: (
97: p_amount IN pqh_gl_interface.amount_dr%TYPE,
98: p_currency_code IN pqh_gl_interface.currency_code%TYPE
99: );
100:
101: PROCEDURE update_pqh_gl_interface
102: (
103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
99: );
100:
101: PROCEDURE update_pqh_gl_interface
102: (
103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
100:
101: PROCEDURE update_pqh_gl_interface
102: (
103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
108: p_amount IN pqh_gl_interface.amount_dr%TYPE,
101: PROCEDURE update_pqh_gl_interface
102: (
103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
108: p_amount IN pqh_gl_interface.amount_dr%TYPE,
109: p_currency_code IN pqh_gl_interface.currency_code%TYPE
102: (
103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
108: p_amount IN pqh_gl_interface.amount_dr%TYPE,
109: p_currency_code IN pqh_gl_interface.currency_code%TYPE
110: );
103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%TYPE,
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
108: p_amount IN pqh_gl_interface.amount_dr%TYPE,
109: p_currency_code IN pqh_gl_interface.currency_code%TYPE
110: );
111:
104: p_period_name IN pqh_gl_interface.period_name%TYPE,
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
108: p_amount IN pqh_gl_interface.amount_dr%TYPE,
109: p_currency_code IN pqh_gl_interface.currency_code%TYPE
110: );
111:
112: PROCEDURE populate_gl_tables;
105: p_accounting_date IN pqh_gl_interface.accounting_date%TYPE,
106: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE,
107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,
108: p_amount IN pqh_gl_interface.amount_dr%TYPE,
109: p_currency_code IN pqh_gl_interface.currency_code%TYPE
110: );
111:
112: PROCEDURE populate_gl_tables;
113:
166: );
167:
168: PROCEDURE reverse_budget_details
169: (
170: p_period_name IN pqh_gl_interface.period_name%TYPE,
171: p_currency_code IN pqh_gl_interface.currency_code%TYPE,
172: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
173: );
174:
167:
168: PROCEDURE reverse_budget_details
169: (
170: p_period_name IN pqh_gl_interface.period_name%TYPE,
171: p_currency_code IN pqh_gl_interface.currency_code%TYPE,
172: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
173: );
174:
175: PROCEDURE populate_period_enc_tab
168: PROCEDURE reverse_budget_details
169: (
170: p_period_name IN pqh_gl_interface.period_name%TYPE,
171: p_currency_code IN pqh_gl_interface.currency_code%TYPE,
172: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE
173: );
174:
175: PROCEDURE populate_period_enc_tab
176: (
270: --
271:
272: PROCEDURE get_ccid_for_commitment(
273: p_budget_id IN pqh_budgets.budget_id%type,
274: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%TYPE,
275: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
276: p_budget_period_id IN pqh_budget_periods.budget_period_id%TYPE,
277: p_cost_allocation_keyflex_id IN pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE,
278: p_code_combination_id OUT NOCOPY gl_code_combinations.code_combination_id%TYPE);