APPS.ZPB_PERSONAL_AW dependencies on ZPB_DC_OBJECTS

Line 246: UPDATE zpb_dc_objects

242: where USER_ID = p_user
243: and BUSINESS_AREA_ID = p_business_area_id;
244:
245: -- Added for Bug: 5842827
246: UPDATE zpb_dc_objects
247: SET copy_source_type_flag = 'Y',
248: create_solve_program_flag = 'Y',
249: create_instance_measures_flag = 'Y',
250: status = 'DISTRIBUTION_PENDING'

Line 255: UPDATE zpb_dc_objects

251: WHERE object_type IN ('C', 'W')
252: AND object_user_id = p_user
253: AND business_area_id = p_business_area_id;
254:
255: UPDATE zpb_dc_objects
256: SET copy_source_type_flag = 'Y',
257: create_solve_program_flag = 'Y',
258: create_instance_measures_flag = 'Y'
259: WHERE object_type IN ('E')

Line 452: update ZPB_DC_OBJECTS

448:
449: --
450: -- Update DC objects to regenerate the solve program (5093114)
451: --
452: update ZPB_DC_OBJECTS
453: set CREATE_SOLVE_PROGRAM_FLAG = 'Y',
454: LAST_UPDATE_DATE = sysdate,
455: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
456: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 991: from ZPB_DC_OBJECTS

987: l_ecm zpb_ecm.global_ecm;
988:
989: cursor del_wrksh is
990: select distinct TEMPLATE_ID, AC_INSTANCE_ID
991: from ZPB_DC_OBJECTS
992: where DELETE_INSTANCE_MEASURES_FLAG = 'Y'
993: and OBJECT_USER_ID = p_user
994: and business_area_id = sys_context('ZPB_CONTEXT', 'business_area_id');
995: begin

Line 1406: from ZPB_DC_OBJECTS

1402: cursor deleted_measures is
1403: select AC_INSTANCE_ID,
1404: OBJECT_USER_ID,
1405: TEMPLATE_ID
1406: from ZPB_DC_OBJECTS
1407: where APPROVER_USER_ID = p_user
1408: and DELETE_APPROVAL_MEASURES_FLAG = 'Y'
1409: and business_area_id = sys_context('ZPB_CONTEXT', 'business_area_id');
1410:

Line 1414: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B , ZPB_MEASURES Z

1410:
1411: cursor pers_to_attach is
1412: select distinct
1413: OBJECT_USER_ID
1414: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B , ZPB_MEASURES Z
1415: where APPROVER_USER_ID = p_user
1416: and A.AC_INSTANCE_ID = B.ANALYSIS_CYCLE_ID
1417: and A.AC_INSTANCE_ID = Z.INSTANCE_ID
1418: and A.TEMPLATE_ID = Z.TEMPLATE_ID

Line 1437: update ZPB_DC_OBJECTS

1433: begin
1434: MEASURES_DELETE (p_user, del_meas.AC_INSTANCE_ID, 'APPROVER',
1435: del_meas.TEMPLATE_ID, del_meas.OBJECT_USER_ID);
1436:
1437: update ZPB_DC_OBJECTS
1438: set DELETE_APPROVAL_MEASURES_FLAG = 'N'
1439: where APPROVER_USER_ID = p_user
1440: and AC_INSTANCE_ID = del_meas.AC_INSTANCE_ID
1441: and TEMPLATE_ID = del_meas.TEMPLATE_ID