[Home] [Help]
56: error_code := -30;
57:
58: SELECT transaction_calendar_id
59: INTO v_trxn_calendar_id
60: FROM gl_ledgers
61: WHERE ledger_id = x_ledger_id;
62:
63:
64: ------------------------------------------------------
155: error_code := -25;
156:
157: SELECT period_name
158: INTO x_new_para_period
159: FROM gl_date_period_map m, gl_ledgers b
160: WHERE m.period_set_name = b.period_set_name
161: AND m.period_type = b.accounted_period_type
162: AND b.ledger_id = x_ledger_id
163: AND m.accounting_date = x_new_para_date;
776: -- Check if ADB ledgers exist in the batch
777: BEGIN
778: SELECT lgr.ledger_id
779: into v_adb_ledger_id
780: FROM gl_recurring_headers rh, gl_ledgers lgr
781: WHERE rh.recurring_batch_id = v_batch_id
782: AND lgr.ledger_id = rh.ledger_id
783: AND lgr.enable_average_balances_flag = 'Y'
784: AND lgr.consolidation_ledger_flag = 'N'
791: -- Check if consolidation ledgers exist in the batch
792: BEGIN
793: SELECT lgr.ledger_id
794: into v_con_ledger_id
795: FROM gl_recurring_headers rh, gl_ledgers lgr
796: WHERE rh.recurring_batch_id = v_batch_id
797: AND lgr.ledger_id = rh.ledger_id
798: AND lgr.enable_average_balances_flag = 'Y'
799: AND lgr.consolidation_ledger_flag = 'Y'
875: into v_adb_ledger_id
876: FROM gl_alloc_formulas af,
877: gl_alloc_formula_lines al,
878: gl_ledger_set_assignments lsa,
879: gl_ledgers lgr
880: WHERE af.allocation_batch_id = v_batch_id
881: AND al.allocation_formula_id = af.allocation_formula_id
882: AND al.line_number IN (4, 5)
883: AND lsa.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
901: into v_con_ledger_id
902: FROM gl_alloc_formulas af,
903: gl_alloc_formula_lines al,
904: gl_ledger_set_assignments ls,
905: gl_ledgers lgr
906: WHERE af.allocation_batch_id = v_batch_id
907: AND al.allocation_formula_id = af.allocation_formula_id
908: AND al.line_number IN (4, 5)
909: AND ls.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
1002: into v_adb_ledger_id
1003: FROM gl_alloc_formulas af,
1004: gl_alloc_formula_lines al,
1005: gl_ledger_set_assignments lsa,
1006: gl_ledgers lgr
1007: WHERE af.allocation_batch_id = current_bid
1008: AND al.allocation_formula_id = af.allocation_formula_id
1009: AND al.line_number IN (4, 5)
1010: AND lsa.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
1030: into v_con_ledger_id
1031: FROM gl_alloc_formulas af,
1032: gl_alloc_formula_lines al,
1033: gl_ledger_set_assignments ls,
1034: gl_ledgers lgr
1035: WHERE af.allocation_batch_id = current_bid
1036: AND al.allocation_formula_id = af.allocation_formula_id
1037: AND al.line_number IN (4, 5)
1038: AND ls.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
1059: -- Check if ADB ledgers exist in the batch
1060: BEGIN
1061: SELECT lgr.ledger_id
1062: into v_adb_ledger_id
1063: FROM gl_recurring_headers rh, gl_ledgers lgr
1064: WHERE rh.recurring_batch_id = current_bid
1065: AND lgr.ledger_id = rh.ledger_id
1066: AND lgr.enable_average_balances_flag = 'Y'
1067: AND lgr.consolidation_ledger_flag = 'N'
1076: -- Check if consolidation ledgers exist in the batch
1077: BEGIN
1078: SELECT lgr.ledger_id
1079: into v_con_ledger_id
1080: FROM gl_recurring_headers rh, gl_ledgers lgr
1081: WHERE rh.recurring_batch_id = current_bid
1082: AND lgr.ledger_id = rh.ledger_id
1083: AND lgr.enable_average_balances_flag = 'Y'
1084: AND lgr.consolidation_ledger_flag = 'Y'
1277: SELECT lgr.ledger_id
1278: FROM gl_alloc_formulas af,
1279: gl_alloc_formula_lines afl,
1280: gl_ledger_set_assignments lsa,
1281: gl_ledgers lgr
1282: WHERE af.allocation_batch_id = random_bid
1283: AND afl.allocation_formula_id = af.allocation_formula_id
1284: AND afl.line_number IN (4, 5)
1285: AND lsa.ledger_set_id (+) = nvl(afl.ledger_id, x_ledger_id)
1294: SELECT lgr.ledger_id
1295: FROM gl_alloc_formulas af,
1296: gl_alloc_formula_lines afl,
1297: gl_ledger_set_assignments lsa,
1298: gl_ledgers lgr
1299: WHERE af.allocation_batch_id = random_bid
1300: AND afl.allocation_formula_id = af.allocation_formula_id
1301: AND afl.line_number IN (4, 5)
1302: AND lsa.ledger_set_id (+) = afl.ledger_id