DBA Data[Home] [Help]

APPS.PO_COPYDOC_S3 dependencies on DUAL

Line 121: ** Validate individual item on line

117: /*************************************************************
118: ** Initialize date info
119: ** Nullify some attributes which will be inserted from other places
120: ** Validate for correct line_type_id (may not need it ?)
121: ** Validate individual item on line
122: ** Validate transaction reason code
123: ** Get next po_line_id
124: *************************************************************/
125: PROCEDURE validate_line(

Line 586: FROM SYS.DUAL;

582: x_progress := '001';
583: BEGIN
584: SELECT po_lines_s.nextval
585: INTO x_po_line_record.po_line_id
586: FROM SYS.DUAL;
587: EXCEPTION
588: WHEN OTHERS THEN
589: x_po_line_record.po_line_id := NULL;
590: po_copydoc_s1.copydoc_sql_error('validate_line', x_progress, sqlcode,