[Home] [Help]
93:
94: -- Get start date for WF WAIT
95: select TAG as PARAM_ID
96: into paramID
97: from FND_LOOKUP_VALUES_VL WHERE LOOKUP_CODE = 'CALENDAR_START_DATE'
98: and LOOKUP_TYPE = 'ZPB_PARAMS';
99:
100: select value
101: Into StartDateTxt
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
123: pva.analysis_cycle_id=ACID;
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;
1222: l_tmpVar varchar2(4000);
1230: LAST_UPDATE_DATE = SYSDATE,
1231: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1232: WHERE
1233: analysis_cycle_id = new_ac_id AND param_id =
1234: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND
1235: lookup_code = 'CAL_HS_TIME_MEMBER');
1236: END IF;
1237:
1238: IF (p_end_mem IS NOT NULL ) THEN
1241: LAST_UPDATE_DATE = SYSDATE,
1242: LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
1243: WHERE
1244: analysis_cycle_id = new_ac_id AND param_id =
1245: ( SELECT tag FROM fnd_lookup_values_vl WHERE lookup_type = 'ZPB_PARAMS' AND
1246: lookup_code = 'CAL_HE_TIME_MEMBER');
1247: END IF;
1248: --the following code adds two more params to zpb_ac_params_values
1249: -- to store start and end periods for the running BP so as to display
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
3484: pva.analysis_cycle_id=Pacid;