136: FND_LOOKUP_VALUES LKUP,
137: HZ_PARTIES INIT_P,
138: FUN_TRX_TYPES_VL FTTVL,
139: FND_CURRENCIES_VL FCV,
140: GL_LEDGERS GL,
141: FUN_TRX_BATCHES FTB_ORIG,
142: FUN_TRX_BATCHES FTB_REV,
143: GL_LEDGERS GL1,
144: FUN_TRX_HEADERS FTH_ORIG,
139: FND_CURRENCIES_VL FCV,
140: GL_LEDGERS GL,
141: FUN_TRX_BATCHES FTB_ORIG,
142: FUN_TRX_BATCHES FTB_REV,
143: GL_LEDGERS GL1,
144: FUN_TRX_HEADERS FTH_ORIG,
145: FUN_TRX_HEADERS FTH_REV,
146: HZ_PARTIES RECI_P,
147: XLE_ENTITY_PROFILES XLE1,
459: FUN_TRX_TYPES_VL FTTVL,
460: GL_PERIODS GLP,
461: FND_CURRENCIES_VL FCV,
462: FUN_TRX_LINES FTL,
463: GL_LEDGERS GL0,
464: GL_LEDGERS GL1,
465: XLE_ENTITY_PROFILES XLE,
466: XLE_ENTITY_PROFILES XLE1,
467: FND_GRANTS FG,
460: GL_PERIODS GLP,
461: FND_CURRENCIES_VL FCV,
462: FUN_TRX_LINES FTL,
463: GL_LEDGERS GL0,
464: GL_LEDGERS GL1,
465: XLE_ENTITY_PROFILES XLE,
466: XLE_ENTITY_PROFILES XLE1,
467: FND_GRANTS FG,
468: FND_OBJECT_INSTANCE_SETS FOIS,
799: FND_LOOKUP_VALUES LKUP,
800: HZ_PARTIES INIT_P,
801: FUN_TRX_TYPES_VL FTTVL,
802: FND_CURRENCIES_VL FCV,
803: GL_LEDGERS GL,
804: FUN_TRX_BATCHES FTB_ORIG,
805: FUN_TRX_BATCHES FTB_REV,
806: GL_LEDGERS GL1,
807: FUN_TRX_HEADERS FTH_ORIG,
802: FND_CURRENCIES_VL FCV,
803: GL_LEDGERS GL,
804: FUN_TRX_BATCHES FTB_ORIG,
805: FUN_TRX_BATCHES FTB_REV,
806: GL_LEDGERS GL1,
807: FUN_TRX_HEADERS FTH_ORIG,
808: FUN_TRX_HEADERS FTH_REV,
809: HZ_PARTIES RECI_P,
810: XLE_ENTITY_PROFILES XLE1,
1105: FUN_TRX_TYPES_VL FTTVL,
1106: GL_PERIODS GLP,
1107: FND_CURRENCIES_VL FCV,
1108: FUN_TRX_LINES FTL,
1109: GL_LEDGERS GL0,
1110: GL_LEDGERS GL1,
1111: XLE_ENTITY_PROFILES XLE,
1112: XLE_ENTITY_PROFILES XLE1,
1113: FND_GRANTS FG,
1106: GL_PERIODS GLP,
1107: FND_CURRENCIES_VL FCV,
1108: FUN_TRX_LINES FTL,
1109: GL_LEDGERS GL0,
1110: GL_LEDGERS GL1,
1111: XLE_ENTITY_PROFILES XLE,
1112: XLE_ENTITY_PROFILES XLE1,
1113: FND_GRANTS FG,
1114: FND_OBJECT_INSTANCE_SETS FOIS
1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;
1639: l_transact_ledger GL_LEDGERS.name%TYPE;
1640: l_trading_ledger GL_LEDGERS.name%TYPE;
1641: l_encoding VARCHAR2(20);
1642: l_offset INTEGER;
1643: BEGIN
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;
1639: l_transact_ledger GL_LEDGERS.name%TYPE;
1640: l_trading_ledger GL_LEDGERS.name%TYPE;
1641: l_encoding VARCHAR2(20);
1642: l_offset INTEGER;
1643: BEGIN
1644: l_api_name := 'construct_account_output';
1696: END IF;
1697: IF p_para_rec.transact_ledger IS NOT NULL THEN
1698: SELECT name
1699: INTO l_transact_ledger
1700: FROM gl_ledgers
1701: WHERE ledger_id = p_para_rec.transact_ledger;
1702: END IF;
1703: IF p_para_rec.trading_ledger IS NOT NULL THEN
1704: SELECT name
1702: END IF;
1703: IF p_para_rec.trading_ledger IS NOT NULL THEN
1704: SELECT name
1705: INTO l_trading_ledger
1706: FROM gl_ledgers
1707: WHERE ledger_id = p_para_rec.trading_ledger;
1708: END IF;
1709: EXCEPTION
1710: WHEN OTHERS THEN