[Home] [Help]
87: cur_hdl := dbms_sql.open_cursor;
88: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
89: ' SET rec_bsv = ' ||
90: ' (SELECT ' || l_bal_seg_column_name ||
91: ' FROM gl_code_combinations ' ||
92: ' WHERE code_combination_id = inter_int.rec_acct ' ||
93: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
94: ' WHERE inter_int.rec_acct IS NOT NULL AND inter_int.rec_acct <> -1';
95: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
99: cur_hdl := dbms_sql.open_cursor;
100: stmt_str := 'UPDATE fun_bal_inter_int_gt inter_int ' ||
101: ' SET pay_bsv = ' ||
102: ' (SELECT ' || l_bal_seg_column_name ||
103: ' FROM gl_code_combinations ' ||
104: ' WHERE code_combination_id = inter_int.pay_acct ' ||
105: ' AND inter_int.bal_seg_column_name = ''' || l_bal_seg_column_name || ''') ' ||
106: ' WHERE inter_int.pay_acct IS NOT NULL AND inter_int.pay_acct <> -1';
107: dbms_sql.parse(cur_hdl, stmt_str, dbms_sql.native);
522: END IF;
523:
524:
525: -- Note: bal_seg_column_number is different from SUBSTR(bal_seg_column_name, 8),
526: -- since bal_seg_column_name refers to the naming in GL_CODE_COMBINATIONS,
527: -- but bal_seg_column_number refers to the position relative to the COA.
528: -- These 2 values are used in different context (name when dealing with GL_CODE_COMB table
529: -- and number when dealing with AOL routines. Do not be confused.
530: -- Problem here: Later on when we deal with performance and decided to check whether the
527: -- but bal_seg_column_number refers to the position relative to the COA.
528: -- These 2 values are used in different context (name when dealing with GL_CODE_COMB table
529: -- and number when dealing with AOL routines. Do not be confused.
530: -- Problem here: Later on when we deal with performance and decided to check whether the
531: -- code combination already exists in gl_code_combinations table, we would also need to
532: -- retrieve the correct segment_name for intercompany segment.
533: -- update balancing segment column, chart of accounts
534: --ASLAI_INIT_01
535: UPDATE fun_bal_headers_gt headers
1483: inter_int.rec_acct = -1
1484: OR
1485: (inter_int.rec_acct IS NOT NULL AND
1486: NOT EXISTS (SELECT 'Receivables account not valid'
1487: FROM gl_code_combinations cc
1488: WHERE inter_int.rec_acct = cc.code_combination_id
1489: AND cc.detail_posting_allowed_flag = 'Y'
1490: AND cc.enabled_flag = 'Y'
1491: AND cc.summary_flag = 'N'
1531: inter_int.pay_acct = -1
1532: OR
1533: (inter_int.pay_acct IS NOT NULL AND
1534: NOT EXISTS (SELECT 'Payables account not valid'
1535: FROM gl_code_combinations cc
1536: WHERE inter_int.pay_acct = cc.code_combination_id
1537: AND cc.detail_posting_allowed_flag = 'Y'
1538: AND cc.enabled_flag = 'Y'
1539: AND cc.summary_flag = 'N'
1680: inter_int.rec_acct = -1
1681: OR
1682: (inter_int.rec_acct IS NOT NULL AND
1683: NOT EXISTS (SELECT 'Receivables account not valid'
1684: FROM gl_code_combinations cc
1685: WHERE inter_int.rec_acct = cc.code_combination_id
1686: AND cc.detail_posting_allowed_flag = 'Y'
1687: AND cc.enabled_flag = 'Y'
1688: AND cc.summary_flag = 'N'
1728: inter_int.pay_acct = -1
1729: OR
1730: (inter_int.pay_acct IS NOT NULL AND
1731: NOT EXISTS (SELECT 'Payables account not valid'
1732: FROM gl_code_combinations cc
1733: WHERE inter_int.pay_acct = cc.code_combination_id
1734: AND cc.detail_posting_allowed_flag = 'Y'
1735: AND cc.enabled_flag = 'Y'
1736: AND cc.summary_flag = 'N'
2373: AND 'OTHER1234567890123456789012345' = accts.cr_bsv
2374: AND 'OTHER1234567890123456789012345' = accts.dr_bsv)
2375: WHERE cr_dr_debit_ccid IS NULL;
2376:
2377: /* Not done for checking ccid valid through gl_code_combinations directly
2378: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2379: SET (dr_cr_debit_ccid, dr_cr_debit_complete) =
2380: (SELECT code_combination_id, DECODE(ccid, NULL, 'N', 'Y')
2381: FROM gl_code_combinations cc1,
2377: /* Not done for checking ccid valid through gl_code_combinations directly
2378: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2379: SET (dr_cr_debit_ccid, dr_cr_debit_complete) =
2380: (SELECT code_combination_id, DECODE(ccid, NULL, 'N', 'Y')
2381: FROM gl_code_combinations cc1,
2382: gl_code_combinations cc2
2383: WHERE le_bsv_map.dr_cr_debit_ccid = cc1.code_combination_id
2384: AND cc1.segment1 = DECODE(le_bsv_map.bal_seg_column_no, 1, le_bsv_)
2385: WHERE dr_cr_debit_complete = 'N'
2378: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
2379: SET (dr_cr_debit_ccid, dr_cr_debit_complete) =
2380: (SELECT code_combination_id, DECODE(ccid, NULL, 'N', 'Y')
2381: FROM gl_code_combinations cc1,
2382: gl_code_combinations cc2
2383: WHERE le_bsv_map.dr_cr_debit_ccid = cc1.code_combination_id
2384: AND cc1.segment1 = DECODE(le_bsv_map.bal_seg_column_no, 1, le_bsv_)
2385: WHERE dr_cr_debit_complete = 'N'
2386: */
2759: results.acct_type, get_ccid_concat_disp(results.ccid, headers.chart_of_accounts_id,
2760: DECODE(results.acct_type, 'C', results.cr_bsv, results.dr_bsv),
2761: DECODE(results.acct_type, 'C', results.dr_bsv, results.cr_bsv),
2762: headers.bal_seg_column_number, headers.intercompany_column_number)
2763: FROM fun_bal_headers_gt headers, fun_bal_results_gt results, gl_code_combinations cc
2764: WHERE headers.group_id = results.group_id
2765: AND headers.status = 'OK'
2766: AND results.ccid = cc.code_combination_id(+)
2767: AND (results.ccid < 0