eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_BAL_PKG dependencies on FUN_BAL_HEADERS_GT

Line 108: FROM fun_bal_headers_gt headers

104: rows_processed int;
105: l_bal_seg_column_name VARCHAR2(25);
106: CURSOR bal_seg_val_cur IS
107: SELECT DISTINCT bal_seg_column_name
108: FROM fun_bal_headers_gt headers
109: WHERE headers.status = 'OK';
110: BEGIN
111: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.update_inter_seg_val.begin', 'begin');

Line 507: SELECT * FROM fun_bal_headers_gt;

503: ins_results_t(results_tab, results_count);
504: ins_errors_t(errors_tab, errors_count);
505: /*
506: INSERT INTO fun_bal_headers_t
507: SELECT * FROM fun_bal_headers_gt;
508: INSERT INTO fun_bal_lines_t
509: SELECT * FROM fun_bal_lines_gt;
510: INSERT INTO fun_bal_results_t
511: SELECT * FROM fun_bal_results_gt;

Line 587: UPDATE fun_bal_headers_gt headers

583: -- code combination already exists in gl_code_combinations table, we would also need to
584: -- retrieve the correct segment_name for intercompany segment.
585: -- update balancing segment column, chart of accounts
586: --ASLAI_INIT_01
587: UPDATE fun_bal_headers_gt headers
588: SET (bal_seg_column_name, chart_of_accounts_id) =
589: (SELECT bal_seg_column_name, chart_of_accounts_id
590: FROM gl_ledgers ledgers
591: WHERE headers.ledger_id = ledgers.ledger_id);

Line 593: UPDATE fun_bal_headers_gt headers

589: (SELECT bal_seg_column_name, chart_of_accounts_id
590: FROM gl_ledgers ledgers
591: WHERE headers.ledger_id = ledgers.ledger_id);
592:
593: UPDATE fun_bal_headers_gt headers
594: SET bal_seg_column_number = get_segment_index ( headers.chart_of_accounts_id,
595: 'GL_BALANCING'),
596: intercompany_column_number = get_segment_index ( headers.chart_of_accounts_id,
597: 'GL_INTERCOMPANY');

Line 603: from fun_bal_headers_gt headers, gl_ledgers gl

599: UPDATE fun_bal_lines_gt lines
600: SET entered_amt_dr = accounted_amt_dr,
601: entered_amt_cr = accounted_amt_cr,
602: entered_currency_code = (select gl.currency_code
603: from fun_bal_headers_gt headers, gl_ledgers gl
604: where gl.ledger_id = headers.ledger_id
605: and headers.group_id = lines.group_id),
606: exchange_date = null,
607: exchange_rate = null,

Line 613: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');

609: WHERE 1 < (select count(distinct entered_currency_code)
610: from fun_bal_lines_gt lines2
611: where lines2.group_id = lines.group_id);
612:
613: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');
614: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LINES_GT');
615:
616: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.end', 'end');

Line 631: SELECT * FROM fun_bal_headers_gt;

627: l_lines_tab lines_tab_type;
628: l_headers_count NUMBER;
629: l_lines_count NUMBER;
630: CURSOR l_headers_cursor IS
631: SELECT * FROM fun_bal_headers_gt;
632: CURSOR l_lines_cursor IS
633: SELECT * FROM fun_bal_lines_gt;
634: BEGIN
635: OPEN l_headers_cursor;

Line 661: SELECT * FROM fun_bal_headers_gt;

657: l_lines_count NUMBER;
658: l_results_count NUMBER;
659: l_errors_count NUMBER;
660: CURSOR l_headers_cursor IS
661: SELECT * FROM fun_bal_headers_gt;
662: CURSOR l_lines_cursor IS
663: SELECT * FROM fun_bal_lines_gt;
664: CURSOR l_results_cursor IS
665: SELECT * FROM fun_bal_results_gt;

Line 750: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,

746:
747: /* Replaced by sql below from performance review
748: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date)
749: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
750: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
751: gl_ledger_configurations config
752: WHERE hdrs.group_id = lines.group_id
753: AND hdrs.ledger_id = ledger.ledger_id
754: AND ledger.configuration_id = config.configuration_id

Line 777: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger

773: -- Bug 3310453
774: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
775: SELECT 'FUN_BSV_INVALID', main.group_id, main.bal_seg_val
776: FROM (SELECT DISTINCT hdrs.group_id, lines.bal_seg_val, hdrs.gl_date, hdrs.ledger_id
777: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger
778: WHERE hdrs.group_id = lines.group_id
779: AND hdrs.ledger_id = ledger.ledger_id(+)
780: AND ledger.bal_seg_value_option_code = 'I') main
781: WHERE main.bal_seg_val NOT IN (SELECT vals.segment_value

Line 788: UPDATE fun_bal_headers_gt headers

784: AND TRUNC(main.gl_date) BETWEEN
785: TRUNC(NVL(vals.start_date, main.gl_date)) AND
786: TRUNC(NVL(vals.end_date, main.gl_date)));
787: -- Bug 3310453
788: UPDATE fun_bal_headers_gt headers
789: SET status = 'ERROR',
790: error_code = 'FUN_BSV_INVALID'
791: WHERE EXISTS (SELECT 'Invalid BSV Error'
792: FROM FUN_BAL_ERRORS_GT errors

Line 813: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,

809: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date, le_id, je_source_name, je_category_name)
810: SELECT main.group_id, main.ledger_id, main.bal_seg_val, main.gl_date, NVL(vals.legal_entity_id, -99),
811: main.je_source_name, main.je_category_name
812: FROM (SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date, hdrs.je_source_name, hdrs.je_category_name
813: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
814: gl_ledger_configurations config
815: WHERE hdrs.status = 'OK' -- Bug 3310453
816: AND hdrs.group_id = lines.group_id
817: AND hdrs.ledger_id = ledger.ledger_id(+)

Line 828: UPDATE fun_bal_headers_gt headers

824: TRUNC(NVL(vals.end_date, main.gl_date)))
825: AND main.ledger_id = vals.ledger_id(+);
826:
827: --Bug: 12834036.
828: UPDATE fun_bal_headers_gt headers
829: SET (le_id, le_count) =
830: (SELECT MIN(le_bsv_map.le_id), SUM(COUNT(DISTINCT le_bsv_map.le_id))
831: FROM fun_bal_le_bsv_map_gt le_bsv_map
832: WHERE headers.group_id = le_bsv_map.group_id

Line 836: UPDATE fun_bal_headers_gt headers

832: WHERE headers.group_id = le_bsv_map.group_id
833: AND le_bsv_map.le_id <> -99
834: GROUP BY le_bsv_map.group_id, le_bsv_map.le_id);
835:
836: UPDATE fun_bal_headers_gt headers
837: SET status = DECODE(le_id, NULL, status, 'ERROR'),
838: error_code = DECODE(le_id, NULL, error_code, 'FUN_INTER_BSV_NOT_ASSIGNED'),
839: unmapped_bsv_le_id = -99
840: WHERE EXISTS (SELECT 'Unmapped BSV exists'

Line 853: UPDATE fun_bal_headers_gt headers

849: -- III) the clearing BSV entered does not belong to the LE or to the ledger
850: -- or one le count and non-mapped count
851: -- IV) le_count IS NULL and unmapped_bsv_le_id IS NULL if not shared configuration
852: -- and BSV validation set to specific
853: UPDATE fun_bal_headers_gt headers
854: SET status = 'ERROR',
855: error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR'
856: WHERE headers.status = 'OK'
857: AND headers.clearing_bsv IS NOT NULL

Line 878: UPDATE fun_bal_headers_gt hdrs

874: AND vals.ledger_id = headers.ledger_id
875: AND vals.legal_entity_id IS NOT NULL))); -- Bug 3278912
876:
877: -- Bug 3310453
878: UPDATE fun_bal_headers_gt hdrs
879: SET status = 'ERROR',
880: error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR'
881: WHERE hdrs.status = 'OK'
882: AND hdrs.clearing_bsv IS NOT NULL

Line 897: FROM fun_bal_headers_gt hdrs

893: TRUNC(NVL(vals.end_date, hdrs.gl_date))));
894:
895: INSERT INTO fun_bal_errors_gt(error_code, group_id, clearing_bsv)
896: SELECT 'FUN_INTRA_OVERRIDE_BSV_ERROR', hdrs.group_id, hdrs.clearing_bsv
897: FROM fun_bal_headers_gt hdrs
898: WHERE hdrs.error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR';
899:
900: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
901: SELECT 'FUN_INTER_BSV_NOT_ASSIGNED', hdrs.group_id, le_bsv_map.bal_seg_val

Line 902: FROM fun_bal_headers_gt hdrs, fun_bal_le_bsv_map_gt le_bsv_map

898: WHERE hdrs.error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR';
899:
900: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
901: SELECT 'FUN_INTER_BSV_NOT_ASSIGNED', hdrs.group_id, le_bsv_map.bal_seg_val
902: FROM fun_bal_headers_gt hdrs, fun_bal_le_bsv_map_gt le_bsv_map
903: WHERE hdrs.group_id = le_bsv_map.group_id
904: AND hdrs.error_code = 'FUN_INTER_BSV_NOT_ASSIGNED'
905: AND le_bsv_map.le_id = -99;
906:

Line 927: FROM fun_bal_headers_gt headers

923:
924:
925: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
926: WHERE group_id = (SELECT group_id
927: FROM fun_bal_headers_gt headers
928: WHERE headers.status = 'ERROR'
929: AND le_bsv_map.group_id = headers.group_id);
930:
931: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del

Line 947: UPDATE fun_bal_headers_gt hdrs

943: SUM(DECODE(lines.exchange_rate, NULL, NVL(lines.entered_amt_dr, 0), 0)));
944:
945:
946: -- Determine driving_dr_le_id, intercompany mode
947: UPDATE fun_bal_headers_gt hdrs
948: SET (driving_dr_le_id, intercompany_mode) =
949: (SELECT MIN(le_bsv_map.le_id),
950: SUM(COUNT(DISTINCT(le_bsv_map.le_id)))
951: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

Line 972: FROM fun_bal_headers_gt hdrs

968: -- as there won't be any more join to these lines.
969: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
970: WHERE EXISTS
971: (SELECT 'Intercompany balancing is not required'
972: FROM fun_bal_headers_gt hdrs
973: WHERE le_bsv_map.group_id = hdrs.group_id
974: AND hdrs.status = 'OK'
975: AND hdrs.intercompany_mode IS NULL);
976:

Line 978: UPDATE fun_bal_headers_gt hdrs

974: AND hdrs.status = 'OK'
975: AND hdrs.intercompany_mode IS NULL);
976:
977: -- Determine driving_cr_le_id, intercompany_mode
978: UPDATE fun_bal_headers_gt hdrs
979: SET (driving_cr_le_id, intercompany_mode) =
980: (SELECT MIN(le_bsv_map.le_id),
981: DECODE(SUM(COUNT(DISTINCT(le_bsv_map.le_id))), 1,
982: DECODE(hdrs.intercompany_mode, 1, 1, 3),

Line 1000: FROM fun_bal_headers_gt headers

996: WHERE status = 'OK';
997:
998: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
999: WHERE EXISTS (SELECT 'No Driving DR LE or Driving CR LE'
1000: FROM fun_bal_headers_gt headers
1001: WHERE headers.group_id = le_bsv_map.group_id
1002: AND headers.status = 'OK'
1003: AND (headers.driving_dr_le_id IS NULL
1004: OR

Line 1082: FUN_BAL_HEADERS_GT HDRS

1078: 0, DECODE(SIGN((( SUM(NVL(LINES.ENTERED_AMT_CR, 0)) - SUM(NVL(LINES.ENTERED_AMT_DR, 0)) )) -
1079: ( SUM(NVL(LINES.ACCOUNTED_AMT_DR, 0)) - SUM(NVL(LINES.ACCOUNTED_AMT_CR, 0)) )), 1, 'C', 'D')) TYPE
1080: FROM FUN_BAL_LE_BSV_MAP_GT LE_BSV_MAP,
1081: FUN_BAL_LINES_GT LINES,
1082: FUN_BAL_HEADERS_GT HDRS
1083: WHERE HDRS.GROUP_ID = LINES.GROUP_ID
1084: AND LINES.GROUP_ID = LE_BSV_MAP.GROUP_ID
1085: AND LINES.BAL_SEG_VAL = LE_BSV_MAP.BAL_SEG_VAL
1086: AND HDRS.INTERCOMPANY_MODE IN ( 1, 2, 3, 4 )

Line 1649: fun_bal_headers_gt hdrs

1645: Update fun_bal_inter_int_gt bal_inter_int
1646: set REC_BSV = (select min_bal_seg_val from (
1647: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1648: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1649: fun_bal_headers_gt hdrs
1650: WHERE hdrs.group_id = lines.group_id
1651: AND lines.group_id = le_bsv_map.group_id
1652: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
1653: AND hdrs.intercompany_mode IN (1,2,3)

Line 1675: fun_bal_headers_gt hdrs

1671: Update fun_bal_inter_int_gt bal_inter_int
1672: set PAY_BSV = (select min_bal_seg_val from (
1673: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1674: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1675: fun_bal_headers_gt hdrs
1676: WHERE hdrs.group_id = lines.group_id
1677: AND lines.group_id = le_bsv_map.group_id
1678: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
1679: AND hdrs.intercompany_mode IN (1,2,3)

Line 1703: and group_id in (select group_id from fun_bal_headers_gt where intercompany_mode IN (1,2,3));

1699: driving_dr_le_bsv = PAY_BSV ,
1700: LINE_LE_BSV = decode(TYPE, 'D',PAY_BSV,REC_BSV)
1701: where driving_dr_le_bsv='Many'
1702: AND driving_cr_le_bsv='Many'
1703: and group_id in (select group_id from fun_bal_headers_gt where intercompany_mode IN (1,2,3));
1704:
1705: --End Bug:11883614
1706:
1707: --inserting lines into fun_bal_inter_int_gt for the 1:M and M:1 case by redistributing amounts #9392684

Line 2424: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2420: DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), 'R',
2421: get_ccid_concat_disp(DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), hdrs.chart_of_accounts_id,
2422: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv, bal_seg_column_number, intercompany_column_number),
2423: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2424: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2425: WHERE inter_int.group_id = hdrs.group_id AND
2426: ((inter_int.intercompany_mode = 1 AND
2427: inter_int.type = 'C')
2428: OR

Line 2473: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2469: DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), 'P',
2470: get_ccid_concat_disp(DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), hdrs.chart_of_accounts_id,
2471: inter_int.driving_cr_le_bsv, inter_int.driving_dr_le_bsv, bal_seg_column_number, intercompany_column_number),
2472: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2473: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2474: WHERE inter_int.group_id = hdrs.group_id AND
2475: ((inter_int.intercompany_mode = 1 AND
2476: inter_int.type = 'D')
2477: OR

Line 2503: UPDATE fun_bal_headers_gt headers

2499: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
2500: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
2501:
2502:
2503: UPDATE fun_bal_headers_gt headers
2504: SET status = 'ERROR'
2505: WHERE EXISTS (SELECT 'Errors for Rec and Pay Accts'
2506: FROM FUN_BAL_ERRORS_GT errors
2507: WHERE headers.group_id = errors.group_id

Line 2518: FROM fun_bal_headers_gt headers

2514: AND headers.status = 'OK';
2515:
2516: DELETE FROM fun_bal_inter_int_gt inter_int
2517: WHERE EXISTS (SELECT group_id
2518: FROM fun_bal_headers_gt headers
2519: WHERE headers.status = 'ERROR'
2520: AND inter_int.group_id = headers.group_id);
2521:
2522: --Enhancement 7520196 Start

Line 2530: fun_bal_headers_gt hdrs

2526: Update fun_bal_inter_int_gt bal_inter_int
2527: set Rec_BSV = (select min_bal_seg_val from (
2528: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
2529: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
2530: fun_bal_headers_gt hdrs
2531: WHERE hdrs.group_id = lines.group_id
2532: AND lines.group_id = le_bsv_map.group_id
2533: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
2534: AND hdrs.intercompany_mode IN (1,2,3)

Line 2554: fun_bal_headers_gt hdrs

2550: Update fun_bal_inter_int_gt bal_inter_int
2551: set Pay_BSV = (select min_bal_seg_val from (
2552: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
2553: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
2554: fun_bal_headers_gt hdrs
2555: WHERE hdrs.group_id = lines.group_id
2556: AND lines.group_id = le_bsv_map.group_id
2557: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
2558: AND hdrs.intercompany_mode IN (1,2,3)

Line 2595: from fun_bal_headers_gt hdrs

2591: hdrs.BAL_SEG_COLUMN_NUMBER,
2592: hdrs.INTERCOMPANY_COLUMN_NUMBER,
2593: bal_inter_int.GL_DATE
2594: )
2595: from fun_bal_headers_gt hdrs
2596: where bal_inter_int.group_id = hdrs.group_id)
2597: where bal_inter_int.intercompany_mode in (1, 2, 3)
2598: and bal_inter_int.status = 'OK';
2599:

Line 2623: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2619: DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), 'R',
2620: get_ccid_concat_disp(DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), hdrs.chart_of_accounts_id,
2621: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv, bal_seg_column_number, intercompany_column_number),
2622: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2623: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2624: WHERE inter_int.group_id = hdrs.group_id AND
2625: ((inter_int.intercompany_mode = 1 AND
2626: inter_int.type = 'C')
2627: OR

Line 2672: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

2668: DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), 'P',
2669: get_ccid_concat_disp(DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), hdrs.chart_of_accounts_id,
2670: inter_int.driving_cr_le_bsv, inter_int.driving_dr_le_bsv, bal_seg_column_number, intercompany_column_number),
2671: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
2672: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
2673: WHERE inter_int.group_id = hdrs.group_id AND
2674: ((inter_int.intercompany_mode = 1 AND
2675: inter_int.type = 'D')
2676: OR

Line 2702: UPDATE fun_bal_headers_gt headers

2698: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
2699: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
2700:
2701:
2702: UPDATE fun_bal_headers_gt headers
2703: SET status = 'ERROR'
2704: WHERE EXISTS (SELECT 'Errors for Rec and Pay Accts'
2705: FROM FUN_BAL_ERRORS_GT errors
2706: WHERE headers.group_id = errors.group_id

Line 2717: FROM fun_bal_headers_gt headers

2713: AND headers.status = 'OK';
2714:
2715: DELETE FROM fun_bal_inter_int_gt inter_int
2716: WHERE EXISTS (SELECT group_id
2717: FROM fun_bal_headers_gt headers
2718: WHERE headers.status = 'ERROR'
2719: AND inter_int.group_id = headers.group_id);
2720:
2721: /* Changes for Bug # 8212023 End */

Line 2928: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines

2924: chart_of_accounts_id, bal_seg_column_number,intercompany_column_number)
2925: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date,
2926: hdrs.je_source_name, hdrs.je_category_name, hdrs.clearing_bsv,
2927: hdrs.chart_of_accounts_id, hdrs.bal_seg_column_number, hdrs.intercompany_column_number
2928: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines
2929: WHERE hdrs.group_id = lines.group_id
2930: AND hdrs.status = 'OK';
2931:
2932:

Line 3201: UPDATE fun_bal_headers_gt headers

3197: AND TRUNC(NVL(gl_seg.end_date, le_bsv_map.gl_date)));
3198:
3199: -- Balancing API Changes, End , Feb 2005
3200:
3201: UPDATE fun_bal_headers_gt headers
3202: SET STATUS = 'ERROR'
3203: WHERE EXISTS (SELECT 'Errors for no template or no clearing bsv or clearing bsv invalid'
3204: FROM FUN_BAL_ERRORS_GT errors
3205: WHERE headers.group_id = errors.group_id

Line 3213: FROM fun_bal_headers_gt headers

3209: AND headers.status = 'OK';
3210:
3211: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
3212: WHERE EXISTS (SELECT group_id
3213: FROM fun_bal_headers_gt headers
3214: WHERE headers.status = 'ERROR'
3215: AND le_bsv_map.group_id = headers.group_id);
3216:
3217: -- Update ccid for each DB BSV and CR BSV /* change here */

Line 3463: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs

3459: 'D')) type,
3460: */
3461: DECODE(lines.accounted_amt_cr, NULL, DECODE(lines.entered_amt_cr, NULL, 'D', 'C'), 'C') type,
3462: le_bsv_map.clearing_bsv
3463: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs
3464: WHERE hdrs.group_id = lines.group_id
3465: AND lines.group_id = le_bsv_map.group_id
3466: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
3467: AND hdrs.status = 'OK'

Line 3498: fun_bal_headers_gt hdrs

3494: 0, DECODE(SIGN(SUM(NVL(lines.entered_amt_cr, 0)) - SUM(NVL(lines.accounted_amt_dr, 0))),
3495: 1, 'C',
3496: 'D')) type, le_bsv_map.clearing_bsv
3497: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
3498: fun_bal_headers_gt hdrs
3499: WHERE hdrs.group_id = lines.group_id
3500: AND lines.group_id = le_bsv_map.group_id
3501: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
3502: AND hdrs.status = 'OK'

Line 3733: FROM fun_bal_headers_gt headers, fun_bal_results_gt results, gl_code_combinations cc

3729: results.acct_type, get_ccid_concat_disp(results.ccid, headers.chart_of_accounts_id,
3730: DECODE(results.acct_type, 'C', results.cr_bsv, results.dr_bsv),
3731: DECODE(results.acct_type, 'C', results.dr_bsv, results.cr_bsv),
3732: headers.bal_seg_column_number, headers.intercompany_column_number)
3733: FROM fun_bal_headers_gt headers, fun_bal_results_gt results, gl_code_combinations cc
3734: WHERE headers.group_id = results.group_id
3735: AND headers.status = 'OK'
3736: AND results.ccid = cc.code_combination_id(+)
3737: AND (results.ccid < 0

Line 3751: UPDATE fun_bal_headers_gt headers

3747: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
3748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.get_ccid_concat_disp.end', 'end');
3749: END IF;
3750:
3751: UPDATE fun_bal_headers_gt headers
3752: SET STATUS = 'ERROR'
3753: WHERE EXISTS (SELECT 'Invalid CCID error'
3754: FROM FUN_BAL_ERRORS_GT errors
3755: WHERE headers.group_id = errors.group_id

Line 3763: FROM fun_bal_headers_gt headers

3759:
3760:
3761: DELETE FROM fun_bal_results_gt results
3762: WHERE EXISTS (SELECT group_id
3763: FROM fun_bal_headers_gt headers
3764: WHERE headers.status = 'ERROR'
3765: AND results.group_id = headers.group_id);
3766:
3767: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN

Line 3779: select 'FUN_INTER_UNEXPECTED_ERROR', FH.group_id, ERR_MESSAGE FROM FUN_BAL_HEADERS_GT FH;

3775: ( ERR_MESSAGE IN VARCHAR2)
3776: IS
3777: BEGIN
3778: INSERT INTO fun_bal_errors_gt(error_code, group_id, error_message)
3779: select 'FUN_INTER_UNEXPECTED_ERROR', FH.group_id, ERR_MESSAGE FROM FUN_BAL_HEADERS_GT FH;
3780: END unexpected_error;
3781:
3782: PROCEDURE journal_balancing
3783: ( p_api_version IN NUMBER,