APPS.XLE_UTILITIES_GRP dependencies on GL_MC_INFO

Line 918: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE := gl_mc_info.le_bsv_tbl_type();

914:
915: l_api_name CONSTANT VARCHAR2(30):= 'Get_LegalEntityID_OU';
916: l_api_version CONSTANT NUMBER:= 1.0;
917: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
918: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE := gl_mc_info.le_bsv_tbl_type();
919: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
920: l_index NUMBER := 0;
921: l_ledger_flag BOOLEAN;
922:

Line 938: -- l_le_list := gl_mc_info.le_bsv_tbl_type();

934: AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'
935: AND O2.ORG_INFORMATION2 = 'Y'
936: AND o.organization_id = p_operating_unit;
937:
938: -- l_le_list := gl_mc_info.le_bsv_tbl_type();
939:
940: l_ledger_flag := GL_MC_INFO.get_legal_entities(
941: l_ledger_id,
942: l_le_list

Line 940: l_ledger_flag := GL_MC_INFO.get_legal_entities(

936: AND o.organization_id = p_operating_unit;
937:
938: -- l_le_list := gl_mc_info.le_bsv_tbl_type();
939:
940: l_ledger_flag := GL_MC_INFO.get_legal_entities(
941: l_ledger_id,
942: l_le_list
943: );
944:

Line 1072: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;

1068: IS
1069: l_api_name CONSTANT VARCHAR2(30):= 'Get_FP_CountryCode_LID';
1070: l_api_version CONSTANT NUMBER:= 1.0;
1071: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1072: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
1073: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1074: l_index NUMBER;
1075: l_ledger_flag BOOLEAN;
1076: l_country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE;

Line 1115: l_ledger_flag := GL_MC_INFO.get_legal_entities(

1111: -- API body
1112:
1113: l_ledger_id := p_ledger_id;
1114:
1115: l_ledger_flag := GL_MC_INFO.get_legal_entities(
1116: p_ledger_id => l_ledger_id,
1117: x_le_list => l_le_list
1118: );
1119:

Line 1214: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;

1210: IS
1211: l_api_name CONSTANT VARCHAR2(30):= 'Get_FP_CountryCode_OU';
1212: l_api_version CONSTANT NUMBER:= 1.0;
1213: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1214: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
1215: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1216: l_index NUMBER;
1217: l_ledger_flag BOOLEAN;
1218: l_country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE;

Line 1563: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;

1559: IS
1560: l_api_name CONSTANT VARCHAR2(30):= 'Get_PartyID_OU';
1561: l_api_version CONSTANT NUMBER:= 1.0;
1562: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1563: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
1564: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1565: l_index NUMBER;
1566: l_party_id HR_ALL_ORGANIZATION_UNITS.PARTY_ID%TYPE;
1567: l_ledger_flag BOOLEAN;

Line 1627: l_ledger_flag := GL_MC_INFO.get_legal_entities(

1623: RAISE FND_API.G_EXC_ERROR;
1624: END;
1625:
1626:
1627: l_ledger_flag := GL_MC_INFO.get_legal_entities(
1628: p_ledger_id => l_ledger_id,
1629: x_le_list => l_le_list
1630: );
1631:

Line 2166: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;

2162: IS
2163: l_api_name CONSTANT VARCHAR2(30):= 'Get_LegalEntity_LGER_BSV';
2164: l_api_version CONSTANT NUMBER := 1.0;
2165: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
2166: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
2167: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
2168: l_index NUMBER;
2169: l_ledger_flag BOOLEAN;
2170: l_country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE;

Line 2218: l_return_var := GL_MC_INFO.INIT_LEDGER_LE_BSV_GT(p_ledger_id);

2214: AND segment_value = p_bsv;
2215:
2216:
2217: IF l_legal_entity_id IS NULL OR l_legal_entity_name IS NULL THEN
2218: l_return_var := GL_MC_INFO.INIT_LEDGER_LE_BSV_GT(p_ledger_id);
2219:
2220: SELECT legal_entity_id,
2221: legal_entity_name
2222: INTO l_legal_entity_id,