DBA Data[Home] [Help]

APPS.PQH_GL_POSTING dependencies on GL_INTERFACE

Line 85: PROCEDURE populate_pqh_gl_interface

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:

Line 90: PROCEDURE insert_pqh_gl_interface

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,

Line 92: p_budget_detail_id IN pqh_gl_interface.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,
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,

Line 93: p_period_name IN pqh_gl_interface.period_name%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,

Line 94: p_accounting_date IN pqh_gl_interface.accounting_date%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

Line 95: p_code_combination_id IN pqh_gl_interface.code_combination_id%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: );

Line 96: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,

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:

Line 97: p_amount IN pqh_gl_interface.amount_dr%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:
101: PROCEDURE update_pqh_gl_interface

Line 98: p_currency_code IN pqh_gl_interface.currency_code%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
102: (

Line 101: PROCEDURE update_pqh_gl_interface

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,

Line 103: p_budget_detail_id IN pqh_gl_interface.budget_detail_id%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,

Line 104: p_period_name IN pqh_gl_interface.period_name%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,

Line 105: p_accounting_date IN pqh_gl_interface.accounting_date%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

Line 106: p_code_combination_id IN pqh_gl_interface.code_combination_id%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: );

Line 107: p_cost_allocation_keyflex_id IN pqh_gl_interface.cost_allocation_keyflex_id%TYPE,

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:

Line 108: p_amount IN pqh_gl_interface.amount_dr%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:
112: PROCEDURE populate_gl_tables;

Line 109: p_currency_code IN pqh_gl_interface.currency_code%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;
113:

Line 170: p_period_name IN pqh_gl_interface.period_name%TYPE,

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:

Line 171: p_currency_code IN pqh_gl_interface.currency_code%TYPE,

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

Line 172: p_code_combination_id IN pqh_gl_interface.code_combination_id%TYPE

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

Line 274: p_chart_of_accounts_id IN gl_interface.chart_of_accounts_id%TYPE,

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