DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_CONTROLS_S

Line 3244: SELECT psp_enc_controls_s.nextval

3240: enc_control_tab.r_uom(l_rec_no) := g_uom;
3241: /***** Commented the following for Create and Update multi thread enh.
3242: -- Get a number for enc control id
3243: BEGIN
3244: SELECT psp_enc_controls_s.nextval
3245: INTO l_enc_control_id
3246: FROM DUAL;
3247: END;
3248: End of comment for Create and Update multi thread enh. *****/

Line 3376: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;

3372: CLOSE get_enc_control_id_cur;
3373:
3374: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3375: IF (p_enc_control_id IS NULL) THEN
3376: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3377:
3378: INSERT INTO PSP_ENC_CONTROLS
3379: (time_period_id, enc_control_id,
3380: number_of_dr, number_of_cr,