APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_BUSAREA_LEDGERS

Line 169: l_ledger ZPB_BUSAREA_LEDGERS.LEDGER_ID%type;

165: p_func_dim_set_id IN NUMBER, -- "Consistent Dimension"
166: p_dimension_id IN NUMBER)
167: is
168: l_def_hier ZPB_BUSAREA_DIMENSIONS.DEFAULT_HIERARCHY_ID%type;
169: l_ledger ZPB_BUSAREA_LEDGERS.LEDGER_ID%type;
170: l_cal_dim_id FEM_XDIM_DIMENSIONS.DIMENSION_ID%type;
171: l_cal_dim_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
172: l_cal_dim_code FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%type;
173: l_vs_req FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

Line 210: from ZPB_BUSAREA_LEDGERS

206: --
207: begin
208: select MIN(LEDGER_ID)
209: into l_ledger
210: from ZPB_BUSAREA_LEDGERS
211: where VERSION_ID = p_version_id;
212: exception
213: when no_data_found then
214: l_ledger := to_number(FND_PROFILE.VALUE_SPECIFIC('FEM_LEDGER',

Line 580: insert into ZPB_BUSAREA_LEDGERS

576: PROCEDURE ADD_LEDGER (p_version_id IN NUMBER,
577: p_ledger_id IN NUMBER)
578: is
579: begin
580: insert into ZPB_BUSAREA_LEDGERS
581: (VERSION_ID,
582: LEDGER_ID,
583: CREATION_DATE,
584: CREATED_BY,

Line 731: delete from ZPB_BUSAREA_LEDGERS

727:
728: delete from ZPB_BUSAREA_CONDITIONS
729: where VERSION_ID = p_version_id;
730:
731: delete from ZPB_BUSAREA_LEDGERS
732: where VERSION_ID = p_version_id;
733:
734: delete from ZPB_BUSAREA_DATASETS
735: where VERSION_ID = p_version_id;

Line 1217: insert into ZPB_BUSAREA_LEDGERS

1213: FND_GLOBAL.USER_ID
1214: from ZPB_BUSAREA_DATASETS
1215: where VERSION_ID = l_from_version_id;
1216:
1217: insert into ZPB_BUSAREA_LEDGERS
1218: (VERSION_ID,
1219: LEDGER_ID,
1220: CREATION_DATE,
1221: CREATED_BY,

Line 1232: from ZPB_BUSAREA_LEDGERS

1228: FND_GLOBAL.USER_ID,
1229: FND_GLOBAL.LOGIN_ID,
1230: sysdate,
1231: FND_GLOBAL.USER_ID
1232: from ZPB_BUSAREA_LEDGERS
1233: where VERSION_ID = l_from_version_id;
1234:
1235: if (p_to_version_type = 'P') then
1236: update ZPB_BUSINESS_AREAS

Line 1868: delete from ZPB_BUSAREA_LEDGERS

1864: PROCEDURE REMOVE_LEDGER (p_version_id IN NUMBER,
1865: p_ledger_id IN NUMBER)
1866: is
1867: begin
1868: delete from ZPB_BUSAREA_LEDGERS
1869: where VERSION_ID = p_version_id
1870: and LEDGER_ID = p_ledger_id;
1871: end REMOVE_LEDGER;
1872:

Line 1971: from ZPB_BUSAREA_LEDGERS BA_LEDGER

1967: and LEDGER_ATTR.LEDGER_ID = DATA_LOC.LEDGER_ID
1968: and LEDGER_ATTR.ATTRIBUTE_ID = l_gvsc_attr_id
1969: and LEDGER_ATTR.DIM_ATTRIBUTE_NUMERIC_MEMBER = OBJ.LOCAL_VS_COMBO_ID
1970: and NOT EXISTS (select BA_LEDGER.LEDGER_ID
1971: from ZPB_BUSAREA_LEDGERS BA_LEDGER
1972: where BA_LEDGER.VERSION_ID = p_version_id
1973: and BA_LEDGER.LEDGER_ID = DATA_LOC.LEDGER_ID);
1974:
1975: BEGIN