APPS.WSH_DELIVERY_TEMPLATE_ROWS dependencies on WSH_DELIVERY_TEMPLATES_S

Line 85: select wsh_delivery_templates_s.nextval

81:
82: X_dummy varchar2(18);
83:
84: cursor id_sequence is
85: select wsh_delivery_templates_s.nextval
86: from sys.dual;
87:
88: cursor row_id is
89: select rowid

Line 671: update wsh_delivery_templates set

667: where departure_template_id = X_planned_dep_template_id
668: for update nowait;
669: end if;
670:
671: update wsh_delivery_templates set
672:
673: delivery_template_id = X_delivery_template_id,
674: name = X_name,
675: organization_id = X_organization_id,