DBA Data[Home] [Help]

APPS.XLE_BUSINESSINFO_GRP dependencies on GL_MC_INFO

Line 190: x_bsv_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();

186: x_allow_all_bsv_flag varchar2(1);
187:
188: l_index number := 1;
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);

Line 191: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();

187:
188: l_index number := 1;
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;

Line 208: l_le_flag := gl_mc_info.get_legal_entities(

204: x_return_status := 'E';
205: return;
206: end if;
207:
208: l_le_flag := gl_mc_info.get_legal_entities(
209: p_ledger_id,x_le_list);
210:
211:
212: if x_le_list.count > 0 then

Line 215: x_bsv_list := gl_mc_info.le_bsv_tbl_type();

211:
212: if x_le_list.count > 0 then
213: for i in x_le_list.first..x_le_list.last loop
214:
215: x_bsv_list := gl_mc_info.le_bsv_tbl_type();
216: /* Invoke GL API get_legal_entities to get the legal entities
217: associated with the given ledger. The output legal entities are returned in x_le_list.*/
218:
219: l_bsv_flag := gl_mc_info.get_bal_seg_values(

Line 219: l_bsv_flag := gl_mc_info.get_bal_seg_values(

215: x_bsv_list := gl_mc_info.le_bsv_tbl_type();
216: /* Invoke GL API get_legal_entities to get the legal entities
217: associated with the given ledger. The output legal entities are returned in x_le_list.*/
218:
219: l_bsv_flag := gl_mc_info.get_bal_seg_values(
220: p_ledger_id,
221: x_le_list(i).legal_entity_id,
222: null,
223: x_allow_all_bsv_flag,

Line 359: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();

355: l_msg_data VARCHAR2(1000);
356: l_msg_count number;
357: l_return_status varchar2(10);
358:
359: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
360: BEGIN
361:
362:
363: /* Parameters Ledger ID and BSV are mandatory */

Line 375: l_le_flag := gl_mc_info.get_legal_entities(

371:
372: /* Invoke the GL API get_legal_entities to retrieve the legal entities associated with the
373: Ledger and BSV combination. The legal entity is returned in x_le_list*/
374:
375: l_le_flag := gl_mc_info.get_legal_entities(
376: p_ledger_id,P_BSV,null,x_le_list);
377:
378:
379: if x_le_list.count > 0 then

Line 463: x_ledger_list gl_mc_info.ledger_tbl_type := gl_mc_info.ledger_tbl_type();

459: x_allow_all_bsv_flag varchar2(1) := 'N';
460:
461: l_index number := 1;
462:
463: x_ledger_list gl_mc_info.ledger_tbl_type := gl_mc_info.ledger_tbl_type();
464: x_bsv_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
465:
466:
467:

Line 464: x_bsv_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();

460:
461: l_index number := 1;
462:
463: x_ledger_list gl_mc_info.ledger_tbl_type := gl_mc_info.ledger_tbl_type();
464: x_bsv_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();
465:
466:
467:
468: BEGIN

Line 516: l_ledger_flag := gl_mc_info.get_le_ledgers(

512: end if;
513:
514:
515:
516: l_ledger_flag := gl_mc_info.get_le_ledgers(
517: p_LegalEntity_ID,
518: 'Y',
519: 'Y',
520: null,

Line 529: l_bsv_flag := gl_mc_info.get_bal_seg_values(

525: for i in x_ledger_list.first..x_ledger_list.last loop
526:
527: l_ledger_return_flag := true;
528:
529: l_bsv_flag := gl_mc_info.get_bal_seg_values(
530: x_ledger_list(i).ledger_id,
531: p_LegalEntity_ID,
532: null,
533: x_allow_all_bsv_flag,

Line 630: x_ledger_list GL_MC_INFO.ledger_tbl_type := GL_MC_INFO.ledger_tbl_type();

626: l_return_status varchar2(1);
627: l_msg_data varchar2(1000);
628:
629: x_ledger_info XLE_BUSINESSINFO_GRP.LE_Ledger_Rec_Type;
630: x_ledger_list GL_MC_INFO.ledger_tbl_type := GL_MC_INFO.ledger_tbl_type();
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;

Line 631: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();

627: l_msg_data varchar2(1000);
628:
629: x_ledger_info XLE_BUSINESSINFO_GRP.LE_Ledger_Rec_Type;
630: x_ledger_list GL_MC_INFO.ledger_tbl_type := GL_MC_INFO.ledger_tbl_type();
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;

Line 696: l_le_flag := gl_mc_info.get_legal_entities(

692: AND o.organization_id = p_operating_unit;
693:
694: /* The following API call retrieves legal entities associated with the ledger
695: identified in previous step */
696: l_le_flag := gl_mc_info.get_legal_entities(
697: l_ledger_id,x_le_list);
698:
699: /* The following statement loops through the legal entities and
700: populates the output table */

Line 795: l_ledger_flag := gl_mc_info.get_le_ledgers(

791: end if;
792:
793: /* Invoke API get_le_ledgers to retrieve ledger associated with
794: the LE */
795: l_ledger_flag := gl_mc_info.get_le_ledgers(
796: l_legal_entity_id,
797: 'Y',
798: 'Y',
799: null,

Line 1133: x_le_list gl_mc_info.le_bsv_tbl_type := gl_mc_info.le_bsv_tbl_type();

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:
1136:
1137: /* Check for mandatory information */