APPS.FV_GTAS_INTERFACE dependencies on FV_GTAS1_PERIOD_ATTRIBUTES

Line 1773: UPDATE fv_gtas1_period_attributes

1769:
1770: --Set the reported_group to Null so that fv_gtas1_period_balances_v
1771: --picks up only the rows processed in the current run
1772: log(l_module_name, 'Setting reported_group to NULL');
1773: UPDATE fv_gtas1_period_attributes
1774: SET reported_group = NULL
1775: WHERE set_of_books_id = gbl_set_of_books_id
1776: AND period_year = gbl_period_year;
1777:

Line 2192: from fv_gtas1_period_attributes

2188: LOOP
2189:
2190: begin
2191: select 'N' into l_new_record_l(i)
2192: from fv_gtas1_period_attributes
2193: where ccid = l_ccid_l(i)
2194: and period_year = gbl_fiscal_year
2195: and set_of_books_id = gbl_set_of_books_id;
2196: exception

Line 2437: INSERT INTO fv_gtas1_period_attributes

2433:
2434:
2435: log(l_module_name, 'Inserting no of new records ' || l_indx);
2436: FORALL i IN 1 .. l_indx
2437: INSERT INTO fv_gtas1_period_attributes
2438: ( period_year,
2439: period_num,
2440: period_name,
2441: set_of_books_id,

Line 2504: -- Update gtas attributes in fv_gtas1_period_attributes

2500: l_treasury_symbol_id_n(i),
2501: l_end_bal_ind_n(i)
2502: );
2503:
2504: -- Update gtas attributes in fv_gtas1_period_attributes
2505:
2506: log(l_module_name, 'Updating records ' || (l_ccid_l.count - l_indx));
2507:
2508: FORALL i IN l_ccid_l.first .. l_ccid_l.last

Line 2509: UPDATE fv_gtas1_period_attributes

2505:
2506: log(l_module_name, 'Updating records ' || (l_ccid_l.count - l_indx));
2507:
2508: FORALL i IN l_ccid_l.first .. l_ccid_l.last
2509: UPDATE fv_gtas1_period_attributes
2510: SET ussgl_account = l_sgl_acct_num_l(i),
2511: exch_non_exch = l_exch_non_exch_l(i),
2512: cust_non_cust = l_cust_non_cust_l(i),
2513: account_type = l_account_type_l(i),

Line 3216: DELETE FROM fv_gtas1_period_attributes

3212: BEGIN
3213: log(l_module_name, 'Begin');
3214:
3215: log(l_module_name,'Deleting: '||p_acct_num||' from period attributes.');
3216: DELETE FROM fv_gtas1_period_attributes
3217: WHERE period_year = gbl_period_year
3218: AND set_of_books_id = gbl_set_of_books_id
3219: AND account_number = p_acct_num ;
3220: