eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_AC_OPS dependencies on ZPB_ANALYSIS_CYCLE_INSTANCES

Line 29: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

25:
26: --Cursor modified for missing objects
27: CURSOR c_active_instance IS
28: SELECT zaci.instance_ac_id, zac.current_instance_id, t.wf_process_name, t.item_key, t.task_id
29: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
30: ZPB_ANALYSIS_CYCLES zac,
31: zpb_analysis_cycle_tasks t,
32: ZPB_ANALYSIS_CYCLES publishedac
33: WHERE publishedac.analysis_cycle_id = p_acid and

Line 1226: FROM zpb_analysis_cycle_instances zaci,

1222: curr_instance_options_in IN VARCHAR2)
1223: IS
1224: CURSOR previous_instance_cur IS
1225: SELECT zaci.instance_ac_id
1226: FROM zpb_analysis_cycle_instances zaci,
1227: zpb_analysis_cycles zac
1228: WHERE zaci.analysis_cycle_id = ac_id_in and
1229: zac.analysis_cycle_id = zaci.analysis_cycle_id and
1230: zaci.instance_ac_id <> zac.current_instance_id;

Line 1238: DELETE FROM zpb_analysis_cycle_instances

1234: BEGIN
1235:
1236: IF prev_instance_options_in = 'DELETE_PREVIOUS_INSTANCE' THEN
1237: FOR instance_rec IN previous_instance_cur LOOP
1238: DELETE FROM zpb_analysis_cycle_instances
1239: WHERE instance_ac_id = instance_rec.instance_ac_id;
1240:
1241: delete_ac(instance_rec.instance_ac_id);
1242: END LOOP;

Line 1254: DELETE FROM zpb_analysis_cycle_instances

1250:
1251: --DELETE FROM zpb_current_instances
1252: -- WHERE current_instance_ac_id = curr_instance_ac_id;
1253:
1254: DELETE FROM zpb_analysis_cycle_instances
1255: WHERE instance_ac_id = curr_instance_ac_id;
1256:
1257: delete_ac(curr_instance_ac_id);
1258:

Line 1265: UPDATE zpb_analysis_cycle_instances

1261: /*
1262: * The instances can no longer refer to their definition
1263: * AC_ID because it has been deleted from the tables.
1264: */
1265: UPDATE zpb_analysis_cycle_instances
1266: SET analysis_cycle_id = NULL,
1267: LAST_UPDATED_BY = fnd_global.USER_ID,
1268: LAST_UPDATE_DATE = SYSDATE,
1269: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID

Line 1545: instance_rec zpb_analysis_cycle_instances%ROWTYPE;

1541: instance_ac_id_out OUT NOCOPY zpb_analysis_cycles.analysis_cycle_id%TYPE)
1542: IS
1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1544: ac_rec zpb_analysis_cycles%ROWTYPE;
1545: instance_rec zpb_analysis_cycle_instances%ROWTYPE;
1546: instance_desc zpb_analysis_cycle_instances.instance_description%TYPE;
1547: curr_count INTEGER;
1548: curr_count_str VARCHAR2(5);
1549: l_app_view_status zpb_ac_param_values.value%TYPE;

Line 1546: instance_desc zpb_analysis_cycle_instances.instance_description%TYPE;

1542: IS
1543: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
1544: ac_rec zpb_analysis_cycles%ROWTYPE;
1545: instance_rec zpb_analysis_cycle_instances%ROWTYPE;
1546: instance_desc zpb_analysis_cycle_instances.instance_description%TYPE;
1547: curr_count INTEGER;
1548: curr_count_str VARCHAR2(5);
1549: l_app_view_status zpb_ac_param_values.value%TYPE;
1550: l_appview_param_id zpb_ac_param_values.param_id%TYPE;

Line 1555: from zpb_analysis_cycle_instances

1551:
1552: --Missing Obj modified the cur to work based on current instance id
1553: cursor latest_instance_desc_cur is
1554: select to_number(substr(instance_description,length(instance_description) -2))
1555: from zpb_analysis_cycle_instances
1556: where instance_ac_id = (select max(instance_ac_id)
1557: from zpb_analysis_cycle_instances aci,
1558: zpb_analysis_cycles pubac,
1559: zpb_analysis_cycles runac

Line 1557: from zpb_analysis_cycle_instances aci,

1553: cursor latest_instance_desc_cur is
1554: select to_number(substr(instance_description,length(instance_description) -2))
1555: from zpb_analysis_cycle_instances
1556: where instance_ac_id = (select max(instance_ac_id)
1557: from zpb_analysis_cycle_instances aci,
1558: zpb_analysis_cycles pubac,
1559: zpb_analysis_cycles runac
1560: where pubac.analysis_cycle_id = ac_id_in
1561: and pubac.current_instance_id =

Line 1649: INSERT INTO zpb_analysis_cycle_instances(ANALYSIS_CYCLE_ID,

1645: instance_rec.CREATION_DATE := SYSDATE;
1646: instance_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1647: instance_rec.LAST_UPDATE_DATE := SYSDATE;
1648: instance_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1649: INSERT INTO zpb_analysis_cycle_instances(ANALYSIS_CYCLE_ID,
1650: INSTANCE_AC_ID,
1651: INSTANCE_DESCRIPTION,
1652: CREATION_DATE,
1653: CREATED_BY,

Line 1760: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,

1756: curr_instance_options_in IN VARCHAR2)
1757: IS
1758: CURSOR previous_instance_cur IS
1759: SELECT aci.instance_ac_id, ac.current_instance_id
1760: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,
1761: zpb_analysis_cycles currinst
1762: where currinst.ANALYSIS_CYCLE_ID = ac_id_in
1763: and currinst.current_instance_id=ac.current_instance_id
1764: and ac.analysis_cycle_id=aci.instance_ac_id

Line 1941: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,

1937: LAST_UPDATE_DATE = SYSDATE,
1938: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1939: WHERE analysis_cycle_id in
1940: (select instance_ac_id
1941: from zpb_analysis_cycle_instances aci,zpb_analysis_cycles ac,
1942: zpb_analysis_cycles currinst
1943: where currinst.ANALYSIS_CYCLE_ID =ac_id_in
1944: and currinst.current_instance_id=ac.current_instance_id
1945: and ac.analysis_cycle_id=aci.instance_ac_id

Line 2034: -- instances in ZPB_ANALYSIS_CYCLE_INSTANCES will also be updated

2030: END publish_cycle;
2031:
2032: -- This procedure will convert the EDITABLE_AC_ID into PUBLISHED_AC_ID.
2033: -- Old published_ac_id will be deleted. All the related ACTIVE
2034: -- instances in ZPB_ANALYSIS_CYCLE_INSTANCES will also be updated
2035: -- with the latest definition of the BP incase user chooses to update
2036: -- current runs.
2037:
2038:

Line 2064: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,

2060: these will be updated with the new definition below */
2061:
2062: CURSOR instance_cur IS
2063: SELECT zaci.instance_ac_id, zaci.analysis_cycle_id
2064: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
2065: ZPB_ANALYSIS_CYCLES zac
2066: WHERE zaci.analysis_cycle_id = editable_ac_id_in and
2067: zaci.instance_ac_id = zac.analysis_cycle_id and
2068: zac.status_code not in('COMPLETE', 'COMPLETE_WITH_WARNING', 'DISABLE_ASAP', 'ERROR', 'MARKED_FOR_DELETION');

Line 2149: /* UPDATE ZPB_ANALYSIS_CYCLE_INSTANCES

2145:
2146: published_before := 'Y';
2147: END IF;
2148:
2149: /* UPDATE ZPB_ANALYSIS_CYCLE_INSTANCES
2150: SET Analysis_Cycle_Id = editable_ac_id_in
2151: WHERE Analysis_Cycle_Id = old_published_ac_id; */
2152:
2153: -- UPDATE ZPB_DC_OBJECTS

Line 3146: instance_rec zpb_analysis_cycle_instances%ROWTYPE;

3142: p_current_instance in varchar2) AS
3143:
3144: l_api_name CONSTANT VARCHAR2(30) := 'create_migrate_inst';
3145: l_api_version CONSTANT NUMBER := 1.0;
3146: instance_rec zpb_analysis_cycle_instances%ROWTYPE;
3147: new_ac_id zpb_analysis_cycles.analysis_cycle_id%TYPE;
3148: invalid_calendar_start_member exception;
3149: invalid_calendar_end_member exception;
3150: begin

Line 3218: INSERT INTO zpb_analysis_cycle_instances(ANALYSIS_CYCLE_ID,

3214: instance_rec.LAST_UPDATED_BY := p_apps_user_id;
3215: instance_rec.LAST_UPDATE_DATE := SYSDATE;
3216: instance_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
3217:
3218: INSERT INTO zpb_analysis_cycle_instances(ANALYSIS_CYCLE_ID,
3219: INSTANCE_AC_ID,
3220: INSTANCE_DESCRIPTION,
3221: CREATION_DATE,
3222: CREATED_BY,