DBA Data[Home] [Help]

APPS.XLE_BUSINESSINFO_GRP dependencies on XLE_UTILITIES_GRP

Line 193: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;

189:
190: x_bsv_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
191: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
192:
193: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;
194: l_msg_data VARCHAR2(1000);
195: l_msg_count number;
196: l_return_status varchar2(10);
197:

Line 242: xle_utilities_grp.get_legalentity_info(

238: x_ledger_info(l_index).bal_seg_value := x_bsv_list(j).bal_seg_value;
239:
240:
241:
242: xle_utilities_grp.get_legalentity_info(
243: x_return_status => l_return_status,
244: x_msg_count => l_msg_count,
245: x_msg_data => l_msg_data,
246: p_party_id => null,

Line 287: xle_utilities_grp.get_legalentity_info(

283: x_Ledger_info(l_index).legal_entity_id := x_le_list(i).legal_entity_id;
284:
285: /* Invoke XLE API Get_LegalEntity_Info to retrieve legale entity information */
286:
287: xle_utilities_grp.get_legalentity_info(
288: x_return_status => l_return_status,
289: x_msg_count => l_msg_count,
290: x_msg_data => l_msg_data,
291: p_party_id => null,

Line 354: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;

350:
351: l_index number := 1;
352:
353:
354: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;
355: l_msg_data VARCHAR2(1000);
356: l_msg_count number;
357: l_return_status varchar2(10);
358:

Line 394: xle_utilities_grp.get_legalentity_info(

390: x_ledger_info(l_index).ledger_id := p_ledger_id;
391: x_ledger_info(l_index).bal_seg_value := P_BSV;
392:
393: /* Invoke XLE API Get_LegalEntity_Info to retrieve legale entity information */
394: xle_utilities_grp.get_legalentity_info(
395: x_return_status => l_return_status,
396: x_msg_count => l_msg_count,
397: x_msg_data => l_msg_data,
398: p_party_id => null,

Line 547: xle_utilities_grp.get_legalentity_info(

543: x_ledger_info(l_index).ledger_id := x_ledger_list(i).ledger_id;
544: x_ledger_info(l_index).bal_seg_value := x_bsv_list(j).bal_seg_value;
545:
546:
547: xle_utilities_grp.get_legalentity_info(
548: x_return_status => l_return_status,
549: x_msg_count => l_msg_count,
550: x_msg_data => l_msg_data,
551: p_party_id => null,

Line 635: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;

631: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
632:
633: l_index number:= 1;
634: l_legal_entity_id number;
635: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;
636: l_msg_count number;
637:
638:
639: /* The following cursor selects operating unit information associated

Line 711: xle_utilities_grp.get_legalentity_info(

707:
708: /* Invoke XLE API Get_LegalEntity_Info to retrieve legal entity
709: information */
710:
711: xle_utilities_grp.get_legalentity_info(
712: x_return_status => l_return_status,
713: x_msg_count => l_msg_count,
714: x_msg_data => l_msg_data,
715: p_party_id => null,

Line 818: xle_utilities_grp.get_legalentity_info(

814:
815:
816: /* Invoke XLE API Get_LegalEntity_Info to retrieve legal entity
817: information */
818: xle_utilities_grp.get_legalentity_info(
819: x_return_status => l_return_status,
820: x_msg_count => l_msg_count,
821: x_msg_data => l_msg_data,
822: p_party_id => null,

Line 907: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;

903: AND (hou.organization_id)= p_InvOrg_ID;
904:
905:
906:
907: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;
908: l_msg_data VARCHAR2(1000);
909: l_msg_count number;
910: l_return_status varchar2(10);
911:

Line 988: xle_utilities_grp.get_legalentity_info(

984:
985: x_Inv_Le_info(l_index).legal_entity_id := l_le_id;
986: x_Inv_Le_info(l_index).inv_org_id := le_r.organization_id;
987:
988: xle_utilities_grp.get_legalentity_info(
989: x_return_status => l_return_status,
990: x_msg_count => l_msg_count,
991: x_msg_data => l_msg_data,
992: p_party_id => null,

Line 1047: xle_utilities_grp.get_legalentity_info(

1043:
1044: x_Inv_Le_info(l_index).legal_entity_id := org_rec.legal_entity;
1045: x_Inv_Le_info(l_index).inv_org_id := l_inv_org_id;
1046:
1047: xle_utilities_grp.get_legalentity_info(
1048: x_return_status => l_return_status,
1049: x_msg_count => l_msg_count,
1050: x_msg_data => l_msg_data,
1051: p_party_id => null,

Line 1131: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;

1127: l_segment VARCHAR2(500);
1128: l_sel_column varchar2(10);
1129: l_ledger_id Number;
1130: l_le_id Number;
1131: l_legalentity_info XLE_UTILITIES_GRP.LegalEntity_Rec;
1132:
1133: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
1134: BEGIN
1135:

Line 1257: l_le_id := xle_utilities_grp.GET_DefaultLegalContext_OU(p_operating_unit_id);

1253:
1254:
1255: end loop;
1256: else
1257: l_le_id := xle_utilities_grp.GET_DefaultLegalContext_OU(p_operating_unit_id);
1258: xle_utilities_grp.get_legalentity_info(
1259: x_return_status => l_return_status,
1260: x_msg_count => l_msg_count,
1261: x_msg_data => l_msg_data,

Line 1258: xle_utilities_grp.get_legalentity_info(

1254:
1255: end loop;
1256: else
1257: l_le_id := xle_utilities_grp.GET_DefaultLegalContext_OU(p_operating_unit_id);
1258: xle_utilities_grp.get_legalentity_info(
1259: x_return_status => l_return_status,
1260: x_msg_count => l_msg_count,
1261: x_msg_data => l_msg_data,
1262: p_party_id => null,

Line 1321: l_le_info XLE_UTILITIES_GRP.LegalEntity_Rec;

1317: l_msg_count NUMBER(5);
1318: x_le_flag BOOLEAN :=FALSE;
1319: l_le_id NUMBER(15);
1320: l_registration_code VARCHAR2(10);
1321: l_le_info XLE_UTILITIES_GRP.LegalEntity_Rec;
1322: TYPE l_le_tbl_type IS TABLE OF XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE INDEX BY BINARY_INTEGER;
1323: l_le_tbl l_le_tbl_type;
1324:
1325: l_ccid_le_info XLE_BUSINESSINFO_GRP.ccid_le_Rec_Type;

Line 1521: l_le_id := XLE_UTILITIES_GRP.get_defaultlegalcontext_ou(p_operating_unit => p_operating_unit_id);

1517:
1518: /* Use the Default Legal Context */
1519: if (p_operating_unit_id IS NOT NULL) AND (NOT x_le_flag) then
1520:
1521: l_le_id := XLE_UTILITIES_GRP.get_defaultlegalcontext_ou(p_operating_unit => p_operating_unit_id);
1522:
1523:
1524: if l_le_id is NOT NULL then
1525: x_le_flag := TRUE;

Line 1530: Xle_utilities_grp.get_legalentity_info (

1526: end if;
1527: end if;
1528:
1529: if (x_le_flag) then
1530: Xle_utilities_grp.get_legalentity_info (
1531: x_return_status => l_return_status,
1532: x_msg_count => l_msg_count,
1533: x_msg_data => l_msg_data,
1534: p_party_id => null,

Line 1661: l_le_id := xle_utilities_grp.GET_DefaultLegalContext_OU(

1657:
1658: /* If no Legal Entity Id found then returns -1*/
1659: if l_le_id = -1 then
1660: /* Next try to get LE id from Default Legal Context */
1661: l_le_id := xle_utilities_grp.GET_DefaultLegalContext_OU(
1662: P_operating_unit_id);
1663: if l_le_id = -1 then
1664: x_return_status := FND_API.G_RET_STS_ERROR ;
1665: x_msg_data := 'No Legal Entity Found';