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_WF dependencies on ZPB_AC_PARAM_VALUES

Line 102: from ZPB_AC_PARAM_VALUES

98: and LOOKUP_TYPE = 'ZPB_PARAMS';
99:
100: select value
101: Into StartDateTxt
102: from ZPB_AC_PARAM_VALUES
103: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = paramID;
104:
105: StartDateDt := to_date(StartDateTxt, 'YYYY/MM/DD-HH24:MI:SS');
106:

Line 118: from zpb_ac_param_values pva,

114:
115: begin
116:
117: select pva.value into freqType
118: from zpb_ac_param_values pva,
119: fnd_lookup_values_vl pna
120: where pna.lookup_code='CALENDAR_FREQUENCY_TYPE'
121: and pna.tag = pva.param_id and
122: pna.lookup_type = 'ZPB_PARAMS' and

Line 368: from ZPB_AC_PARAM_VALUES

364:
365: -- 28 MIGRATION_INSTANCE
366: CURSOR c_mparams is
367: select value
368: from ZPB_AC_PARAM_VALUES
369: where ANALYSIS_CYCLE_ID = InstanceID and PARAM_ID = 28;
370:
371: v_mparams c_mparams%ROWTYPE;
372:

Line 1217: FROM ZPB_AC_PARAM_VALUES AcParamValuesEO,

1213: ,new_ac_id IN NUMBER)
1214: is
1215: CURSOR records_cur IS
1216: SELECT AcParamValuesEO.VALUE,ParamsEO.lookup_code
1217: FROM ZPB_AC_PARAM_VALUES AcParamValuesEO,
1218: FND_LOOKUP_VALUES_VL ParamsEO
1219: WHERE AcParamValuesEO.PARAM_ID = ParamsEO.TAG and
1220: ParamsEO.LOOKUP_TYPE = 'ZPB_PARAMS' and ParamsEO.TAG in (4,5,6,7,8,9,10,11,12,13,14,15,16,17) and AcParamValuesEO.ANALYSIS_CYCLE_ID = new_ac_id;
1221: opRec records_cur%ROWTYPE;

Line 1228: UPDATE zpb_ac_param_values SET value = p_start_mem,

1224: l_msgCnt number;
1225: l_msgData varchar2(2000);
1226: BEGIN
1227: IF (p_start_mem IS NOT NULL ) THEN
1228: UPDATE zpb_ac_param_values SET value = p_start_mem,
1229: LAST_UPDATED_BY = fnd_global.USER_ID,
1230: LAST_UPDATE_DATE = SYSDATE,
1231: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1232: WHERE

Line 1239: UPDATE zpb_ac_param_values SET value = p_end_mem,

1235: lookup_code = 'CAL_HS_TIME_MEMBER');
1236: END IF;
1237:
1238: IF (p_end_mem IS NOT NULL ) THEN
1239: UPDATE zpb_ac_param_values SET value = p_end_mem,
1240: LAST_UPDATED_BY = fnd_global.USER_ID,
1241: LAST_UPDATE_DATE = SYSDATE,
1242: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1243: WHERE

Line 1661: from ZPB_AC_PARAM_VALUES

1657: v_instances c_instances%ROWTYPE;
1658:
1659: CURSOR c_params is
1660: select value
1661: from ZPB_AC_PARAM_VALUES
1662: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 2;
1663:
1664: v_params c_params%ROWTYPE;
1665:

Line 1720: from ZPB_AC_PARAM_VALUES

1716: begin
1717:
1718: select value
1719: into l_appended
1720: from ZPB_AC_PARAM_VALUES
1721: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 26;
1722: exception
1723: when NO_DATA_FOUND then
1724: l_appended := 'PARM_NOT_FOUND';

Line 2054: from ZPB_AC_PARAM_VALUES

2050: compDay varchar2(100);
2051:
2052: CURSOR c_params is
2053: select param_id, value
2054: from ZPB_AC_PARAM_VALUES
2055: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID IN (19, 20, 21, 22, 23, 24);
2056:
2057: v_params c_params%ROWTYPE;
2058:

Line 2404: from ZPB_AC_PARAM_VALUES

2400: if freqMode = 'ABSOLUTE' then
2401:
2402: select Value
2403: into freqRep
2404: from ZPB_AC_PARAM_VALUES
2405: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 21;
2406:
2407: -- make adjustment
2408: addMonths := freqRep * 12;

Line 2443: from ZPB_AC_PARAM_VALUES

2439: -- have gone over all days specified; reset REMAININGSEL from DB
2440: -- AC Param value
2441: select Value
2442: into freqSel
2443: from ZPB_AC_PARAM_VALUES
2444: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 24;
2445:
2446: end if; -- comma
2447:

Line 2472: from ZPB_AC_PARAM_VALUES

2468: -- make adjustment 21 CALENDAR_REPEAT_FREQUENCY
2469:
2470: select Value
2471: into freqRep
2472: from ZPB_AC_PARAM_VALUES
2473: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 21;
2474:
2475: -- NewDate := add_months(sysdate, freqRep);
2476: NewDate := to_date((to_char(add_months(sysdate, freqRep), 'YYYY/MM') || '/01'), 'YYYY/MM/DD');

Line 2515: from ZPB_AC_PARAM_VALUES

2511: -- have gone over all days specified; reset REMAININGSEL from DB
2512: -- AC Param value
2513: select Value
2514: into freqSel
2515: from ZPB_AC_PARAM_VALUES
2516: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 23;
2517:
2518: end if; -- comma
2519:

Line 2540: from ZPB_AC_PARAM_VALUES

2536: -- make adjustment 21 CALENDAR_REPEAT_FREQUENCY
2537:
2538: select Value
2539: into freqRep
2540: from ZPB_AC_PARAM_VALUES
2541: where ANALYSIS_CYCLE_ID = ACID and PARAM_ID = 21;
2542:
2543: NewDate := sysdate + (7*freqRep);
2544:

Line 2963: from ZPB_AC_PARAM_VALUES

2959:
2960: -- 28 MIGRATION_INSTANCE
2961: CURSOR c_mparams is
2962: select value
2963: from ZPB_AC_PARAM_VALUES
2964: where ANALYSIS_CYCLE_ID = l_InstanceID and PARAM_ID = 28;
2965:
2966: v_mparams c_mparams%ROWTYPE;
2967:

Line 3145: from zpb_ac_param_values pa

3141: from zpb_published_cycles_v v
3142: where v.status_code not in ('DISABLE_ASAP', 'DISABLE_NEXT') and
3143: v.validate_status = 'VALID' and
3144: v.analysis_cycle_id in (select pa.analysis_cycle_id
3145: from zpb_ac_param_values pa
3146: where pa.param_id = 20 and pa.value in (select d.value
3147: from ZPB_PROCESS_DETAILS_V d
3148: where d.name = 'CREATE_EVENT_IDENTIFIER' and d.task_id = TaskID));
3149:

Line 3479: from zpb_ac_param_values pva,

3475:
3476: begin
3477:
3478: select pva.value into freqType
3479: from zpb_ac_param_values pva,
3480: fnd_lookup_values_vl pna
3481: where pna.lookup_code='CALENDAR_FREQUENCY_TYPE'
3482: and pna.tag = pva.param_id and
3483: pna.lookup_type = 'ZPB_PARAMS' and