DBA Data[Home] [Help]

APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_LEDGERS_ATTR

Line 339: FROM fem_ledgers_attr f

335: THEN
336: BEGIN
337: SELECT dim_attribute_numeric_member
338: INTO v_global_vs_id
339: FROM fem_ledgers_attr f
340: WHERE f.ledger_id = v_ledger_id
341: AND f.attribute_id =
342: (SELECT attribute_id
343: FROM fem_dim_attributes_b

Line 453: FROM fem_ledgers_attr f

449: THEN
450: BEGIN
451: SELECT dim_attribute_numeric_member
452: INTO v_global_vs_id
453: FROM fem_ledgers_attr f
454: WHERE f.ledger_id = v_ledger_id
455: AND f.attribute_id =
456: (SELECT attribute_id
457: FROM fem_dim_attributes_b

Line 733: FROM fem_ledgers_attr f

729:
730: BEGIN
731: SELECT dim_attribute_numeric_member
732: INTO v_global_vs_id
733: FROM fem_ledgers_attr f
734: WHERE f.ledger_id = v_current_session_ledger_id
735: AND f.attribute_id =
736: (SELECT attribute_id
737: FROM fem_dim_attributes_b

Line 1708: FROM fem_ledgers_attr

1704: AND default_version_flag='Y';
1705:
1706: SELECT dim_attribute_numeric_member
1707: INTO v_ledger_calphier_id
1708: FROM fem_ledgers_attr
1709: WHERE ledger_id = p_ledger_id
1710: AND attribute_id = v_ledgerobj_attr_id
1711: AND version_id = v_ledgerobj_vers_id;
1712:

Line 1847: FROM fem_ledgers_attr

1843: AND default_version_flag='Y';
1844:
1845: SELECT dim_attribute_numeric_member
1846: INTO v_ledger_calphier_id
1847: FROM fem_ledgers_attr
1848: WHERE ledger_id = p_ledger_id
1849: AND attribute_id = v_ledgerobj_attr_id
1850: AND version_id = v_ledgerobj_vers_id;
1851:

Line 5216: INSERT INTO fem_ledgers_attr(

5212: END;
5213: v_attr_num := '';
5214: END IF;
5215:
5216: INSERT INTO fem_ledgers_attr(
5217: attribute_id,
5218: version_id,
5219: ledger_id,
5220: dim_attribute_numeric_member,

Line 5254: INSERT INTO fem_ledgers_attr(

5250: THEN
5251: ----------------------------------------
5252: -- Attribute is an assigned number value
5253: ----------------------------------------
5254: INSERT INTO fem_ledgers_attr(
5255: attribute_id,
5256: version_id,
5257: ledger_id,
5258: dim_attribute_numeric_member,

Line 5292: INSERT INTO fem_ledgers_attr(

5288: THEN
5289: -----------------------------------------
5290: -- Attribute is an assigned varchar value
5291: -----------------------------------------
5292: INSERT INTO fem_ledgers_attr(
5293: attribute_id,
5294: version_id,
5295: ledger_id,
5296: dim_attribute_numeric_member,

Line 5330: INSERT INTO fem_ledgers_attr(

5326: THEN
5327: --------------------------------------
5328: -- Attribute is an assigned date value
5329: --------------------------------------
5330: INSERT INTO fem_ledgers_attr(
5331: attribute_id,
5332: version_id,
5333: ledger_id,
5334: dim_attribute_numeric_member,

Line 5753: INSERT INTO fem_ledgers_attr(

5749: END;
5750: v_attr_num := '';
5751: END IF;
5752:
5753: INSERT INTO fem_ledgers_attr(
5754: attribute_id,
5755: version_id,
5756: ledger_id,
5757: dim_attribute_numeric_member,

Line 5791: INSERT INTO fem_ledgers_attr(

5787: THEN
5788: ----------------------------------------
5789: -- Attribute is an assigned number value
5790: ----------------------------------------
5791: INSERT INTO fem_ledgers_attr(
5792: attribute_id,
5793: version_id,
5794: ledger_id,
5795: dim_attribute_numeric_member,

Line 5829: INSERT INTO fem_ledgers_attr(

5825: THEN
5826: -----------------------------------------
5827: -- Attribute is an assigned varchar value
5828: -----------------------------------------
5829: INSERT INTO fem_ledgers_attr(
5830: attribute_id,
5831: version_id,
5832: ledger_id,
5833: dim_attribute_numeric_member,

Line 5867: INSERT INTO fem_ledgers_attr(

5863: THEN
5864: --------------------------------------
5865: -- Attribute is an assigned date value
5866: --------------------------------------
5867: INSERT INTO fem_ledgers_attr(
5868: attribute_id,
5869: version_id,
5870: ledger_id,
5871: dim_attribute_numeric_member,

Line 7315: INSERT INTO fem_ledgers_attr(

7311: END;
7312: v_attr_num := '';
7313: END IF;
7314:
7315: INSERT INTO fem_ledgers_attr(
7316: attribute_id,
7317: version_id,
7318: ledger_id,
7319: dim_attribute_numeric_member,

Line 7353: INSERT INTO fem_ledgers_attr(

7349: THEN
7350: ----------------------------------------
7351: -- Attribute is an assigned number value
7352: ----------------------------------------
7353: INSERT INTO fem_ledgers_attr(
7354: attribute_id,
7355: version_id,
7356: ledger_id,
7357: dim_attribute_numeric_member,

Line 7391: INSERT INTO fem_ledgers_attr(

7387: THEN
7388: -----------------------------------------
7389: -- Attribute is an assigned varchar value
7390: -----------------------------------------
7391: INSERT INTO fem_ledgers_attr(
7392: attribute_id,
7393: version_id,
7394: ledger_id,
7395: dim_attribute_numeric_member,

Line 7429: INSERT INTO fem_ledgers_attr(

7425: THEN
7426: --------------------------------------
7427: -- Attribute is an assigned date value
7428: --------------------------------------
7429: INSERT INTO fem_ledgers_attr(
7430: attribute_id,
7431: version_id,
7432: ledger_id,
7433: dim_attribute_numeric_member,