DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_CONTROLS_S

Line 3475: SELECT psp_enc_controls_s.nextval

3471: enc_control_tab.r_uom(l_rec_no) := g_uom;
3472: /***** Commented the following for Create and Update multi thread enh.
3473: -- Get a number for enc control id
3474: BEGIN
3475: SELECT psp_enc_controls_s.nextval
3476: INTO l_enc_control_id
3477: FROM DUAL;
3478: END;
3479: End of comment for Create and Update multi thread enh. *****/

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

3604: CLOSE get_enc_control_id_cur;
3605:
3606: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3607: IF (p_enc_control_id IS NULL) THEN
3608: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3609:
3610: INSERT INTO PSP_ENC_CONTROLS
3611: (time_period_id, enc_control_id,
3612: number_of_dr, number_of_cr,