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_AC_PARAM_VALUES

Line 188: INSERT INTO zpb_ac_param_values

184: source_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE,
185: target_ac_id_in IN zpb_analysis_cycles.analysis_cycle_id%TYPE)
186: IS
187: BEGIN
188: INSERT INTO zpb_ac_param_values
189: (ANALYSIS_CYCLE_ID,
190: PARAM_ID,
191: VALUE,
192: CREATED_BY,

Line 205: FROM zpb_ac_param_values

201: SYSDATE,
202: fnd_global.USER_ID,
203: SYSDATE,
204: fnd_global.LOGIN_ID
205: FROM zpb_ac_param_values
206: WHERE ANALYSIS_CYCLE_ID = source_ac_id_in;
207: END copy_ac_param_values_recs;
208:
209: PROCEDURE copy_cycle_currency_recs (

Line 1069: UPDATE zpb_ac_param_values SET value = p_start_mem WHERE

1065: ,p_end_mem IN VARCHAR2
1066: ,new_ac_id IN NUMBER) AS
1067: BEGIN
1068: IF (p_start_mem IS NOT NULL ) THEN
1069: UPDATE zpb_ac_param_values SET value = p_start_mem WHERE
1070: analysis_cycle_id = new_ac_id AND param_id =
1071: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND
1072: lookup_code = 'CAL_HS_TIME_MEMBER');
1073: END IF;

Line 1076: UPDATE zpb_ac_param_values SET value = p_end_mem WHERE

1072: lookup_code = 'CAL_HS_TIME_MEMBER');
1073: END IF;
1074:
1075: IF (p_end_mem IS NOT NULL ) THEN
1076: UPDATE zpb_ac_param_values SET value = p_end_mem WHERE
1077: analysis_cycle_id = new_ac_id AND param_id =
1078: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND
1079: lookup_code = 'CAL_HE_TIME_MEMBER');
1080: END IF;

Line 1168: DELETE FROM zpb_ac_param_values

1164:
1165: DELETE FROM zpb_cycle_model_dimensions
1166: WHERE analysis_cycle_id = ac_id_in;
1167:
1168: DELETE FROM zpb_ac_param_values
1169: WHERE analysis_cycle_id = ac_id_in;
1170:
1171: DELETE FROM zpb_cycle_datasets
1172: WHERE analysis_cycle_id = ac_id_in;

Line 1549: l_app_view_status zpb_ac_param_values.value%TYPE;

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;
1551:
1552: --Missing Obj modified the cur to work based on current instance id
1553: cursor latest_instance_desc_cur is

Line 1550: l_appview_param_id zpb_ac_param_values.param_id%TYPE;

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;
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))

Line 1566: SELECT VALUE FROM ZPB_AC_PARAM_VALUES

1562: runac.current_instance_id
1563: and runac.analysis_cycle_id = aci.instance_ac_id);
1564:
1565: CURSOR c_append_view IS
1566: SELECT VALUE FROM ZPB_AC_PARAM_VALUES
1567: WHERE ANALYSIS_CYCLE_ID = ac_id_in AND PARAM_ID = l_appview_param_id ;
1568:
1569: BEGIN
1570: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

Line 2517: ac_param_rec zpb_ac_param_values%rowtype;

2513: procedure create_ac_param_values(p_ac_id in number,
2514: p_param_id in number,
2515: p_value in varchar2,
2516: p_apps_user_id in number) AS
2517: ac_param_rec zpb_ac_param_values%rowtype;
2518: begin
2519: ac_param_rec.analysis_cycle_id := p_ac_id;
2520: ac_param_rec.param_id := p_param_id;
2521: ac_param_rec.value := p_value;

Line 2528: INSERT INTO zpb_ac_param_values(ANALYSIS_CYCLE_ID,

2524: ac_param_rec.LAST_UPDATED_BY := p_apps_user_id;
2525: ac_param_rec.LAST_UPDATE_DATE := SYSDATE;
2526: ac_param_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
2527:
2528: INSERT INTO zpb_ac_param_values(ANALYSIS_CYCLE_ID,
2529: PARAM_ID,
2530: VALUE,
2531: LAST_UPDATE_LOGIN,
2532: LAST_UPDATE_DATE,

Line 2698: ac_param_rec zpb_ac_param_values%ROWTYPE;

2694: current_inst_id zpb_analysis_cycles.current_instance_id%TYPE;
2695: ac_rec zpb_analysis_cycles%ROWTYPE;
2696: pet_rec zpb_cycle_relationships%ROWTYPE;
2697: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
2698: ac_param_rec zpb_ac_param_values%ROWTYPE;
2699: invalid_versions exception;
2700: invalid_calendar_start_type exception;
2701: invalid_calendar_end_type exception;
2702: invalid_calendar_start_pf exception;

Line 3601: l_param_value ZPB_AC_PARAM_VALUES.VALUE%TYPE;

3597: IS
3598: l_api_name CONSTANT VARCHAR2(30) := 'Get_VM_instance_id';
3599: l_api_version CONSTANT NUMBER := 1.0;
3600:
3601: l_param_value ZPB_AC_PARAM_VALUES.VALUE%TYPE;
3602:
3603: BEGIN
3604:
3605: -- Standard call to check for call compatibility.

Line 3624: FROM ZPB_AC_PARAM_VALUES

3620: x_return_status := FND_API.G_RET_STS_SUCCESS;
3621:
3622: SELECT value
3623: INTO l_param_value
3624: FROM ZPB_AC_PARAM_VALUES
3625: WHERE analysis_cycle_id = p_ac_id_in
3626: AND param_id =
3627: (SELECT tag
3628: FROM fnd_lookup_values_vl