APPS.GL_RX_TRIAL_BALANCE_PKG dependencies on GL_RX_TRIAL_BALANCE_ITF

Line 54: FROM gl_rx_trial_balance_itf

50: CURSOR c1 IS
51: SELECT rowid,
52: balancing_segment,
53: account_segment
54: FROM gl_rx_trial_balance_itf
55: WHERE request_id = l_request_id;
56:
57: BEGIN
58: --

Line 232: l_dyn_stmt := 'insert into gl_rx_trial_balance_itf (

228: END IF;
229: --
230: -- set the sql statement for dynamic sql
231: --
232: l_dyn_stmt := 'insert into gl_rx_trial_balance_itf (
233: request_id,
234: period_name,
235: ledger_id,
236: ledger_name,

Line 354: UPDATE gl_rx_trial_balance_itf set

350: IF (debug_mode = 'Y') THEN
351: -- dbms_output.put_line('Subtracting the opening year balances');
352: NULL;
353: END IF;
354: UPDATE gl_rx_trial_balance_itf set
355: begin_year_balance_dr = 0,
356: begin_year_balance_cr = 0,
357: begin_period_balance_dr = (begin_period_balance_dr - begin_year_balance_dr),
358: begin_period_balance_cr = (begin_period_balance_cr - begin_year_balance_cr)

Line 376: UPDATE gl_rx_trial_balance_itf SET

372: FETCH c1 INTO l_rowid, l_balancing, l_account;
373: exit when c1%notfound;
374: l_balancing_description := fa_rx_shared_pkg.get_flex_val_meaning(NULL, l_balancing_value_set, l_balancing);
375: l_account_description := fa_rx_shared_pkg.get_flex_val_meaning(NULL, l_account_value_set, l_account);
376: UPDATE gl_rx_trial_balance_itf SET
377: balancing_description = l_balancing_description,
378: account_description = l_account_description,
379: prior_periods_net_dr = (begin_period_balance_dr - (begin_year_balance_dr + begin_adj_period_net_dr)),
380: prior_periods_net_cr = (begin_period_balance_cr - (begin_year_balance_cr + begin_adj_period_net_cr)),