APPS.CHV_LOAD_ORDERS dependencies on CHV_ITEM_ORDERS

Line 396: insert into chv_item_orders(schedule_id,

392:
393: EXIT WHEN C1%notfound ;
394:
395: X_progress := '050';
396: insert into chv_item_orders(schedule_id,
397: schedule_item_id,
398: schedule_order_id,
399: supply_document_type,
400: order_quantity,

Line 412: CHV_ITEM_ORDERS_S.nextval,

408: created_by,
409: last_update_login)
410: values(x_schedule_id,
411: x_schedule_item_id,
412: CHV_ITEM_ORDERS_S.nextval,
413: 'PLANNED_ORDER',
414: nvl(x_ord_qty * x_conversion_rate,0),
415: nvl(x_ord_qty,0),
416: x_purchasing_unit_of_measure,

Line 538: insert into chv_item_orders(schedule_id,

534: X_progress := '050';
535:
536: --dbms_output.put_line('Get Approved Reqs: Before insert');
537:
538: insert into chv_item_orders(schedule_id,
539: schedule_item_id,
540: schedule_order_id,
541: supply_document_type,
542: order_quantity,

Line 557: CHV_ITEM_ORDERS_S.nextval,

553: document_line_id,
554: document_shipment_id)
555: values(x_schedule_id,
556: x_schedule_item_id,
557: CHV_ITEM_ORDERS_S.nextval,
558: 'REQUISITION',
559: nvl(X_to_org_purch_quantity,
560: X_to_org_primary_quantity),
561: X_to_org_primary_quantity,

Line 708: insert into chv_item_orders(schedule_id,

704: EXIT WHEN C1%notfound;
705:
706: X_progress := '040';
707:
708: insert into chv_item_orders(schedule_id,
709: schedule_item_id,
710: schedule_order_id,
711: supply_document_type,
712: order_quantity,

Line 727: CHV_ITEM_ORDERS_S.nextval,

723: document_line_id,
724: document_shipment_id)
725: values(x_schedule_id,
726: x_schedule_item_id,
727: CHV_ITEM_ORDERS_S.nextval,
728: 'RELEASE',
729: x_conversion_rate *
730: X_to_org_primary_quantity,
731: X_to_org_primary_quantity,