APPS.GMPMRACT dependencies on DUAL

Line 352: SELECT gem5_matl_rep_id_s.nextval INTO X_rep_id FROM dual;

348: dbms_sql.define_column (cur_planning, 2, X_item_id);
349:
350: X_row_count := dbms_sql.execute_and_fetch (cur_planning);
351: IF X_row_count > 0 THEN
352: SELECT gem5_matl_rep_id_s.nextval INTO X_rep_id FROM dual;
353:
354: G_matl_rep_id := X_rep_id;
355: X_i := 0;
356: LOOP

Line 602: SELECT sysdate into X_date from dual;

598: THEN
599: G_c_ind := '**';
600: -- mr_insert_details(V_item_id,V_planning_class);
601: mr_cleanup_details;
602: SELECT sysdate into X_date from dual;
603: X_ret := G_doc_tab(X_i).trans_date - X_date;
604: IF (X_ret < 0) THEN
605: X_pastdue := '*';
606: ELSE

Line 656: SELECT sysdate into X_date from dual;

652: THEN
653: -- mr_insert_details(V_item_id,V_planning_class);
654:
655: mr_cleanup_details;
656: SELECT sysdate into X_date from dual;
657: X_ret := G_doc_tab(X_i).trans_date - X_date;
658: IF (X_ret < 0) THEN
659: X_pastdue := '*';
660: ELSE

Line 1200: from dual;

1196: ELSE
1197: G_doc_no:= NULL;
1198: G_cust_vend:=NULL;
1199: select gem5_mrp_doc_id_s.nextval into G_doc_id
1200: from dual;
1201: Raise NO_MATCH_DOC;
1202: END IF;
1203:
1204: IF G_doc_type <> 'OMSO' THEN